View Full Version : Search error messages
January 8th, 2007, 10:21 AM
I recently changed hosts and now my search feature is displaying the following error messages.
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /photopost/search.php on line 261
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /photopost/search.php on line 468
Keeping in mind that you are talking to someone with no php experience, can you tell me how I might solve the problem?
Thanks so very much!
January 8th, 2007, 12:41 PM
Did you transfer the correct database and files?
I looks like you transfered an older database and newer files. You can in admin turn on the debug setting to display errors and you will see the correct error when going to search and post that here and we can go from there. Most likely running the 5.5 and 5.6 upgrades will fix you but lets see.
January 8th, 2007, 12:59 PM
I am using version 5.61
Here is the error message that I am getting after setting the debug.
We're sorry, but the system experienced an unrecoverable error. Please try again later.
Query: DELETE FROM pp_searchids WHERE date < 1168279017
Result: Table 'stamkcom_forum.pp_searchids' doesn't exist
Database handle: Resource id #30
January 8th, 2007, 01:19 PM
Yep your search table does not exist. Redownload the build upload the files except the config and run upgrade.php and run the 5.5 and 5.6 upgrades
January 8th, 2007, 04:39 PM
This is most likely a very stupid question but where can I find a list of all of the builds? I checked in the member section and all I am able to find/download is version 5.6.2
January 8th, 2007, 05:30 PM
Yes that is what you want to download. Upload the files except the config files and run the upgrades noted in my post. Your searchid table does not exist which means you never ran your upgrade script.
January 10th, 2007, 05:49 AM
Thank you, Chuck! Worked like a charm :D
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.