Database error

[ayman83]

There is a problem in the control panel
If you search for the name of the message comes
Source

 Database error in vBulletin 3.8.3:Invalid SQL:    SELECT subscriptionid, usergroupid
    FROM subscriptionpermission;MySQL Error   : 
Error Number  : 1054
Request Date  : Tuesday, June 23rd 2009 @ 07:22:36 PM
Error Date    : Tuesday, June 23rd 2009 @ 07:22:36 PM
Script        : http://---.net/admincp/user.php?do=edit&u=5
Referrer      : http://---.net/admincp/index.php?do=home
IP Address    : 78.93.227.87
Username      : imtyaz
Classname     : vB_Database
MySQL Version : 5.0.81-community 

and thanks 4 help

[Steve Machol]

Any reason this in in Project Tools?

Invalid SQL errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any third-party hacks or plugins, then see if you still have this problem.

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?

[ayman83]

I'm sorry if I write in the subject line
Awaiting Expert

[ayman83]

The problem was resolved to enter into the control panel
But the rest of another problem
Browse any subject at the operating successfully
But upon entering the forum sections, show a line in the data
Source:

 Database error in vBulletin 3.8.3:Invalid SQL:  SELECT 

[LEFT]   announcement.announcementid, startdate, title, announcement.views,
   user.username, user.userid, user.usertitle, user.customtitle, user.usergroupid,
   IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
   , NOT ISNULL(announcementread.announcementid) AS readannounce
   
  FROM announcement AS announcement
  LEFT JOIN announcementread AS announcementread ON (announcementread.announcementid = announcement.announcementid AND announcementread.userid = 5)
  LEFT JOIN user AS user ON(user.userid = announcement.userid)
  
  WHERE startdate <= 1245914215
   AND enddate >= 1245914215
   AND forumid IN (939,566,-1)
   
  ORDER BY startdate DESC, announcement.announcementid DESC
  LIMIT 1;MySQL Error   : Unknown column 'announcementread.announcementid' in 'field list'
Error Number  : 1054
Request Date  : Thursday, June 25th 2009 @ 10:16:55 AM
Error Date    : Thursday, June 25th 2009 @ 10:16:56 AM
Script        : http://---/forumdisplay.php?f=939
Referrer      : http:---//
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.81-community[/LEFT] 

[Steve Machol]

You need to follow the instructions in post #2.