New Posts Problem

[AlShammari]

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

[Marco van Herwaarden]

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

[AlShammari]

thank you for reply

I didn't upgrade my site

and don't know what happen :(

how I can solve this problem

[Marco van Herwaarden]

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:

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

[AlShammari]

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

--------------- Added 1198811604 at 1198811604 ---------------

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:

ALTER TABLE search ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1';
You are not authorized to execute SQL queries

I didn't know why :(

[Dismounted]

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

[Marco van Herwaarden]

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

[AlShammari]

Dismounted I write my id number in config file

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

[Marco van Herwaarden]

Upgrading vBulletin (http://www.vbulletin.com/docs/html/upgrade)

[AlShammari]

thanx alot