View Full Version : Search not working
September 25th, 2010, 11:04 AM
RP5 w/ vb4
When I do a simple search from the main Reviews page it takes me to the Advanced search page. Then when I try the search from there I get some MySql errors.
After digging around in here, I turned on debug messages. Now when I do the simple search I get:
Query: DELETE FROM rp_searchids WHERE date < 1285430335
Result: Table 'msrrpdb.rp_searchids' doesn't exist
Database handle: Resource id #25
I've never run any sql scripts or opened my rp db w/ any kind of tool or utility, so I guess it never got created? or do i have to do something in the admin panel to enable search?
September 25th, 2010, 11:11 AM
If you upgraded did you run your upgrade script?
It appears you have not done so.
September 25th, 2010, 12:54 PM
I didn't know there was an upgrade, although I just went and looked and saw the 5.1 release, but I am pretty sure I didn't download (or upload for that matter). I don't see it anywhere on my computer.
Is that something that has to be run after a basic install of the latest version? I followed the normal installation instructions for the 5.0 version I downloaded - don't remember if that included running an upgrade at the end (guess I'll go look).
How do I have new code looking for things that the upgrade would do to the db?
After an upgrade I assume I have to re-apply any mods i've made ? Is there somewhere that documents best practices for making tweaks and then re-applying as needed after an upgrade?
For sure, I'll make a copy of the existing files, but other than tracking a list of files and what was changed, any suggestions?
September 25th, 2010, 02:42 PM
Your running reviewpost 5.1 not 5.0
The announcement on 5.1 is in our announcements forum with a list of changed files and there is an upgrade to run if you recently upgraded your files.
September 25th, 2010, 04:18 PM
Dunno how I missed having to run the upgrade.php -- I had not seen that.
After running, I don't get that error, but I still also don't get any results from the simple "Search Reviews" at the top of the reviews list on the main page. It just goes to the advanced search page. Then the query works.
I'm just searching on "propen"...
At least I got 1 step forward and not 2 forward and 1 back :)
September 25th, 2010, 06:38 PM
Search - Reeftalk Reviews (http://www.reeftalk.com/reviews/search.php?searchid=10)
I entered euroreef on my site and the proper results come back
September 27th, 2010, 01:43 PM
Main Index - My Product Gallery (http://www.mySurgReview.com/reviews)
September 27th, 2010, 01:45 PM
Not working at all now -- simple search from home page goes to the advanced search page. but searching from there doesn't find anything either.
September 27th, 2010, 04:45 PM
Your templates look like they are not current please redownload the build and upload the vb4enhanced templates folder.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.