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:

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

[AlShammari]

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] ---------------

Originally Posted by 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:

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

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

[AlShammari]

thanx alot