Database Error

[Gulf-Soul]

Hello

This is the error:-

Database error in vBulletin 3.8.0:
 
Invalid SQL:
 
                    SELECT title
                    FROM usertitle
                    WHERE minposts <= 0
                    ORDER BY minposts DESC
                    LIMIT 1;
 
MySQL Error   : Unknown column 'minposts' in 'where clause'
Error Number  : 1054
Request Date  : Wednesday, June 17th 2009 @ 03:17:55 PM
Error Date    : Wednesday, June 17th 2009 @ 03:17:55 PM
Script        : http://www.my-forum.com/vb/admincp/misc.php?do=updateuser
Referrer      : http://www.my-forum.com/vb/admincp/misc.php
IP Address    : 78.101.246.203
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.77-community 

Can anybody help me please

Regards,

[lyco]

need more information on the problem like when did it occur what were you doing when it happened etc.

[Gulf-Soul]

When I want to delete a post

[lyco]

hummm when did the issue start happening did you change anything about your forum or install an addon before it started

[Gulf-Soul]

no .. and i disabled all the hook

[lyco]

was your forum working before all this started

[Gulf-Soul]

Yes

[Steve Machol]

Run this query to add that field:

ALTER TABLE usertitle ADD minposts INT UNSIGNED NOT NULL DEFAULT '0'

You can run queries in the SQL tab in phpMyAdmin, or to run queries from the Admin CP:

Admin CP -> Maintenance -> Execute SQL Query -> Manual Query

Then enter your query in the Manual Query box and click on 'Continue'.

To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

$config['SpecialUsers']['canrunqueries'] = 'x';

...with x being your userid number.

[Gulf-Soul]

Thanks