Database Error in search, New Post and Quick Links

Mikeyodesigns · 01-17-2007, 10:41 PM

Phpmyadmin is for managing the mysql database that all the vbulletin data is held on.
It usually can be found at your hosting site.
Go to whoever hosts your site and login to your account, most give you some kind of admin panel where you can add databases see site stats and so on...
There should be a link to phpmyadmin somewhere in there. All hosting company use different administration panels.If you are not sure how to find phpmyadmin then ask your hosting company.

ducksguts · 01-17-2007, 10:45 PM

yeah thats ok thanks mate, I know where it is, I'm stuck using Plesk for a cp but its still easy enough to get to php myadmin from there, I have just never really used it to change much thats all ;)

Mikeyodesigns · 01-17-2007, 10:53 PM

Quote:

Originally Posted by ducksguts

yeah thats ok thanks mate, I know where it is, I'm stuck using Plesk for a cp but its still easy enough to get to php myadmin from there, I have just never really used it to change much thats all ;)

Yep phpmyadmin is not overly user friendly looking he he he..
What i did was make another database for wordpress or something and then had a go at that database to see how phpmyadmin worked before i tried my vb database.:classic:

d09barf · 01-24-2007, 04:14 AM

Quote:

Originally Posted by cool999

I get database error everytime when someone search, Click on New Post, Quick links.
This is the error-
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 1 AND searchhash = 'fda6ebd683b75aabcd5157ba69dd5ace' AND orderedids = '97,109,108,107,106,105,104,103,102,101,100,99,98, 96,95,94' AND announceids = '' AND completed = 1;
MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054

Please tell me how to solve it, i need to solve this urgently.
Thanksss

===============================================

Cool999,

I have had the same error and researched solutions on 4 sites with no help anywhere. Queries and editing didnt help and those that replied were so vague it was a guessing game at best.
However.... I was able to find out that there were issues or a glitch with the "search.php" file in the latest release of vb3.6.4
Having tried everything else and going for broke, I deleted my search.php file from the forums root folder and uploaded an earlier version of "search.php" from vb3.6.2.
Once I did this I have no more errors and things work great.
Now maybe this isnt the technical answer (lol) that the coders here might offer, but it worked for me and it was a hell of alot easier than some of the advice I was given.
I attached the one that worked for me in a zip file below for you to download if you like.
It worked for me, maybe it will work for you.

LMK

Peace out,
DB :pirate:

Nick R · 01-25-2007, 03:38 PM

They have the solution on vbulletin.com. All you have to do is add a column to the table as whitemike said...

ducksguts · 03-04-2007, 05:29 PM

Ok I apoligise for reposting this error but I finally got my brain around this and the error is fixed, I thankyou whitemike for your patience ;)

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)