The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
mysql issue with search feature
please let me know why im getting this error please i just upgraded a forum and now cant see why its coming up
Database error in vBulletin 3.6.5: Invalid SQL: SELECT searchid FROM vBsearch AS search WHERE userid = 23 AND searchhash = '64534ee4c81dd3739dc498192013c091' AND orderedids = '32,30' AND announceids = '' AND completed = 1; MySQL Error : Unknown column 'completed' in 'where clause' Error Number : 1054 Date : Wednesday, March 21st 2007 @ 03:18:53 AM Script : http://www.prosportsnow.com/search.php?do=getnew Referrer : http://www.prosportsnow.com/ IP Address : 0000000000 Username : Steve Classname : vB_Database |
#2
|
|||
|
|||
To fix this please run the following query:
[sql]ALTER TABLE vBsearch ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1';[/sql] |
#3
|
||||
|
||||
Quote:
thank you worked like a charm. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|