Search Problems

[Underlab]

I just upgraded to photopost, but now that I recall i had some trouble using the search feature before the install. This is the error I get - when i do a search for my friend "Pilot Rai"

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

Script:

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

Result: Unknown column 'name' in 'field list'

Database handle: Resource id #22

This is the error I get when I ust hit the search link -

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

Script:

Query: DELETE FROM searchids WHERE date < 1165523901

Result: Unknown column 'date' in 'where clause'

Database handle: Resource id #22

[Chuck S]

Have you ran the upgrades needed both 5.5 and 5.6?

If your searchid table exists those fields definately exist.

Maybe mistakenly the search table was renamed in vbulletin to searchid cause of having no prefix on your photopost tables?

I would suggest renaming the searchid table back to search so vbulletin will work

Follow this thread and rerun the upgrades meantioned. Its the only way off the top of my head I can think that your search table would not have the fields noted.

Adding a prefix to your PhotoPost tables

[Underlab]

Yes i ran the upgrades to the latest photopost available - Photopost 5.62.

I had some error at first but it still allowed me to complete teh upgrade. Everything else seems to work fine although when i log-in to the admin section it takes abit of time to load and it timed out a couple of times on me.

And then there is this search thing that doesnt seem to work.

[Underlab]

Ok before I do that. Earlier I had issues with my v-bulletin search as well. VBulletin had me Re-Add the search table along with some other additions to make their search table work again. I got it to work. I just checked teh database and i noticed that under "searchid" these are the tables i have

searchid
userid
ipaddress
personal
query
searchuser
forumchoice
sortby
sortorder
searchtime
showposts
orderedids
dateline
searchterms
displayterms
searchhash
titleonly
announceids

Can i just the neccessary table to make it work? pre-fixing seems like a lot of work that could result in messing up my vb again no? what do you suggest?

[Chuck S]

exactly searchid table is your vb search table not our search table

If you dont want to redo the table prefix just delete that searchid table and make this one

Content visible to verified customers only.

[Underlab]

You are the man Chuck. You always come through. That worked perfectly