Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



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

Posts: 18
Name: Oscar
Trades: 0
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 !!!
__________________

Please login or register to view this content. Registration is FREE
, search for links on Online Movie Forum
Loonm is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 07-19-2007, 11:41 AM Re: Please help i have database problem on my vbulletin 3.6.4.
Novice Talker

Posts: 9
Trades: 0
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, 12:09 PM Re: Please help i have database problem on my vbulletin 3.6.4.
Skilled Talker

Posts: 72
Trades: 0
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
__________________

Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE

J-G-Ju is offline
Reply With Quote
View Public Profile
 
Old 07-19-2007, 03:25 PM Re: Please help i have database problem on my vbulletin 3.6.4.
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Quote:
is no such row completed in your search table
No such column
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 07-19-2007, 04:02 PM Re: Please help i have database problem on my vbulletin 3.6.4.
Average Talker

Posts: 18
Name: Oscar
Trades: 0
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
__________________

Please login or register to view this content. Registration is FREE
, 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 Search this Thread
Search this Thread:

Advanced Search

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

BB 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.22310 seconds with 12 queries