Search error

[angkor408]

For some reason the search doesn't work if I want to find member photo. This is the error message I got. This problem happen when I upgraded to the newest photopost.

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /gallery/search.php on line 281

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /gallery/search.php on line 484

[Chuck S]

Looks to me like you upgraded and did not run your upgrade script and selected the upgrades you need to run to be honest. Run upgrade.php in your browser and run the upgrades from your last version to the latest.

[angkor408]

Hi, actually I did run the upgrade.php file. During the upgrade it also the previous version I have. It installed successfully and everything seem to be working fine like slideshow, etc.. Any other suggestion so I don't have to do the long way? Thank, Tim

Here my website link:

http://www.khmerclub.com

Originally Posted by Chuck S

Looks to me like you upgraded and did not run your upgrade script and selected the upgrades you need to run to be honest. Run upgrade.php in your browser and run the upgrades from your last version to the latest.

[Chuck S]

That error tells me you might have ran the 5.6 to 6.0 upgrade but you surely did not run the 5.5 to 5.6 upgrade where you needed to. Maybe you where unsure what version you where last running.

You can also set debug option in global options in admin to display errors and as admin you will see the true error and post here. That will confirm what i am saying.

[angkor408]

Hi Chuck, I will try again today. Can you tell me the main file I should backup so it doesn't screw up my setting like SQL path setting, Features block, category.etc Thank, Tim

[Chuck S]

No files hold that information. You can download the 6.01 distribution unzip it. Delete the data and uploads directories. Delete the install.php and config files. Delete the header and footer htm files if you are using personalized ones. Then upload that to your photopost site on the web and run the upgrade script. You will see if you look at the true error your missing something and if you post it here I can tell you the exact upgrade you missed but off hand with the error it looks like the 5.5-5.6 one.

[angkor408]

This is the error I got when I enable the display error:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT searchid,searchterms,name,date FROM pp_searchids WHERE userid=1 ORDER BY date DESC LIMIT 3

Result: Table 'khmerclu_photo53.pp_searchids' doesn't exist

Database handle: Resource id #24

[Chuck S]

Exactly that tells me the 5.5 to 5.6 upgrade has not been ran. You need to make sure your running all 6.01 files except the configs and upload the upgrade file and run the proper upgrades and you will be fine.

[angkor408]

You the man!! It work now. Actually didn't start upgrade from 5.5 to 5.6. I jump from 5.X to 6.0. Again, my search is working now.

http://www.khmerclub.com/gallery/search.php?searchid=2

[Chuck S]

Enjoy and have a good evening.