Reply
Please help i have database problem on my vbulletin 3.6.4.
Old 07-19-2007, 06:00 AM Please help i have database problem on my vbulletin 3.6.4.
Average Talker

Posts: 18
Name: Oscar
I dontknow what kin of problem is this, im total dummie in this whole database error and stuff.
But please can anyone help me. I have this error message whem I'm and anybody else trying to search on my forum:
Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT * FROM search AS search
WHERE searchhash = 'f811323ed990aaf7fcfd2d0488a98e53'
AND userid = 1
AND completed = 1;

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Thursday, July 19th 2007 @ 01:11:04 AM
Script : http://onlinemovieforum.com/search.php?do=process
Referrer : http://onlinemovieforum.com/index.php
IP Address : 212.7.31.96
Username : Loonm
Classname : vB_Database
or check by yourself, here is the link : http://onlinemovieforum.com
try search enything.
Thanks !!!
__________________
Watch Movies Online, search for links on Online Movie Forum
Loonm is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
Old 07-19-2007, 10:41 AM Re: Please help i have database problem on my vbulletin 3.6.4.
Novice Talker

Posts: 9
Obviously, the issue you are experiencing is due to the fact that there is no such row completed in your search table of the vBulletin database.

Have you made any changes to your database recently? If you have a recent backup of that particular table, you might want to try and import it to restore the missing rows.
nh-val is offline
Reply With Quote
View Public Profile
 
Old 07-19-2007, 11:09 AM Re: Please help i have database problem on my vbulletin 3.6.4.
Skilled Talker

Posts: 72
I was able to do a search but it seems your quick search ain't working. You may want to disable captcha verification for quick search
J-G-Ju is offline
Reply With Quote
View Public Profile
 
Old 07-19-2007, 02:25 PM Re: Please help i have database problem on my vbulletin 3.6.4.
chrishirst's Avatar
Super Moderator

Latest Blog Post:
Javascript alert
Posts: 13,688
Location: Blackpool. UK
Quote:
is no such row completed in your search table
No such column
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Indifference will be the downfall of mankind, but who cares?
Code Samples | People Counting System
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 07-19-2007, 03:02 PM Re: Please help i have database problem on my vbulletin 3.6.4.
Average Talker

Posts: 18
Name: Oscar
im really dumb in this guys, can you give me some idiotproof guide how to solve this? i didn't change anything in my database
__________________
Watch Movies Online, search for links on Online Movie Forum
Loonm is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Please help i have database problem on my vbulletin 3.6.4.
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.15328 seconds with 12 queries