Upgraded to 2.6 - Error on Admin Index page

smokn28 · December 23rd, 2006, 04:24 PM

Getting the following error when I open the Admin link:

Code:

Content visible to verified customers only.

This is what I have on my Line 50 of my adm-misc.php:

Code:

Content visible to verified customers only.

Chuck S · December 23rd, 2006, 05:25 PM

Have you ran your upgrade script?

Try setting in admin the debug option to 2 to display the error. You can do this in phpmyadmin in the classifieds settings table

smokn28 · December 23rd, 2006, 08:08 PM

I don't know how to describe the fix...as it just worked itself out. Don't know how that would have happened. Yes, prior to the error I had already uploaded the files and ran the upgrade script.

Then I went to the Classifieds Admin link and that's when I saw the error however, I could still manipulate the settings in the Admin panel. I changed some of the new options and viewed the Classifieds....went back into the Admin link and the error was still there. I left for a couple hours and went back into the Admin link and the error was gone. I had refreshed a few times prior to my leaving as well.

So....I dunno....

Thanks though.

Chuck S · December 23rd, 2006, 09:07 PM

No problem enjoy

dendrob · December 26th, 2006, 11:40 PM

I have the same error after the update. Did anyone fix it, or should I wait the magical 2 hrs ?

smokn28 · December 27th, 2006, 12:37 AM

Quote:

Originally Posted by dendrob

I have the same error after the update. Did anyone fix it, or should I wait the magical 2 hrs ?

Ouch....

It was a weird fix. Maybe you'll need to do the same thing I did... I made some changes on my settings and closed out of the admin cp....then reopened it later and the error was gone.

I know it sounds corky....but it's what worked for me.

Good luck denrob.

gholsie · December 27th, 2006, 01:15 AM

I just searched for this error because I'm having the same problem. Did you make changes to all of the admin options? It may be difficult to find the exact portion you saved w/out going through all options and saving them.

Edit: I am using the integration with vbulletin/vbPortal.

Chuck S · December 27th, 2006, 07:59 AM

Look at the error and that query there is no reason why you should have the error if the noted upgrades are ran. That line is the auto delete all expired ads over 2 weeks old code.

Code:

Content visible to verified customers only.

smokn28 · December 27th, 2006, 08:00 AM

gholsie, all I remember doing is making some changes in the way the thumbnails were displayed (filmstrip, photo, etc).

oldengine · December 27th, 2006, 09:51 AM

I had the same error. Apparently there is some magic in running upgrade.php even for minor script uodates. It took care of my errors.

rcull · December 28th, 2006, 12:20 PM

I just did the upgrade and have this same error displaying in both admin frames!

I made a few changes in the admin and waited a couple of hours, but it's still there!

I do have the "Number of days to show sold/closed ads?" set to 30 if this could be related to the autodelete.

Any ideas?

Chuck S · December 28th, 2006, 02:17 PM

I dont think so all this would do is make the query return no results. You need to see why your getting an error. Maybe going in through phpmyadmin and setting the debug setting in settings table to 2

UPDATE cp_settings SET setting=2 WHERE id=184

That might tell you what your missing

rcull · December 28th, 2006, 05:02 PM

If I am reading it correctly, it is set to 2. This can also be changed in the admin panel Global options. It is changeing in the database when I change it in the admin panel.

It continues to show the same error on the admin page.

I notice that item 194 in my database is show out of order as if it were item 172...

I don't think there should be a line 172, maybe? but why does 194 stick itself in there?

Chuck S · December 28th, 2006, 09:21 PM

Debug setting is definately if viewing the settings table setting 184

Yes you can set it to display errors and you should get if it is set to that the true mysql error

rcull · December 28th, 2006, 09:43 PM

The error displayed in both window is the same as described by the previous poster:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/teambuic/public_html/classifieds/adm-misc.php on line 50

Is this the true error or should I be looking somewhere else?

Thanks

Chuck S · December 29th, 2006, 08:11 AM

Thats a generic error with debug display errors on you should see the true error but it you dont have the error anymore there is nothing more we can say since it is gone right.

rcull · December 29th, 2006, 09:24 AM

No, mine has not dissappeared like the other posters above...

Chuck S · December 29th, 2006, 09:30 AM

You sure you ran all your upgrades you needed to?

You can email me with link and sign in

diretur · December 29th, 2006, 09:49 AM

same problem

Chuck S · December 29th, 2006, 10:11 AM

Again this is an issue of what the error is? What your missing from the query. This is why I ask did you run all applicable upgrades. I have had this simple query running for along while to auto delete ads and it works fine.