New Posts Problem
 

Hello there

how r u all

I have problem whene I press on new posts

Database error in vBulletin 3.6.5:

Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 1 AND searchhash = '2b2e6abf9ab8facedf86094401e31988' AND orderedids = '212,243,226,240,220' AND announceids = '' AND completed = 1;

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Sunday, December 23rd 2007 @ 12:25:52 PM
Script : /vb/search.php?do=getnew
Referrer :
IP Address :
Username : Admin
Classname : vB_Database

Did you recently upgrade? If so did the upgrade script run without any errors? If not, what has been done to your site lately?

thank you for reply

I didn't upgrade my site

and don't know what happen :(

how I can solve this problem

Strange, such an error does not just start out of the blue, you must have done something.

You can solve the symptoms by running the following query:

[sql]ALTER TABLE search ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1';[/sql]

yes
I think I did something
maybe before 3 or 4 month I try to upgrade forum
but i didn't complete
:$

--------------- Added [DATE]1198811604[/DATE] at [TIME]1198811604[/TIME] ---------------

I didn't know why :(

In your /includes/config.php, under where it says "Permission to run SQL queries", you must have your user id filled in.

Once you start an upgrade, you should either finish it (without errors) or restore the full backup (database & files).

Dismounted I write my id number in config file

Marco van Herwaarden
do u have any post about how i can upgrade it?

thanx alot