Upgraded to 2.6 - Error on Admin Index page
 

Getting the following error when I open the Admin link:

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

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

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.

No problem enjoy

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. :confused:

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

Good luck denrob.

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.

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.

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

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.

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?

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

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?

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

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

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.

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

You sure you ran all your upgrades you needed to?

You can email me with link and sign in

same problem

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.