YourWBB

Database error in WoltLab Burning Board (2.1.6): Invalid SQL: SELECT * FROM bb1_acpmenuitemgroups WHERE acpmode<='1' ORDER BY showorder ASC
mysql error: Table 'DNMail.bb1_acpmenuitemgroups' doesn't exist
mysql error number: 1146
mysql version: 5.0.30-Debian_1-log
php version: 5.2.0-7
Date: 30.12.2006 @ 15:02
Script: /srdn/wbb/acp/misc.php?action=menu&sid=
Referer: http://www.hybridtherory.de/srdn/wbb/acp/index.php?sid=&url=

CREATE TABLE bb1_acpmenuitemgroups (
  itemgroupid smallint(5) unsigned NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  condition text NOT NULL,
  conditiontype enum('OR','AND') NOT NULL default 'OR',
  showorder smallint(5) unsigned NOT NULL default '0',
  acpmode tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (itemgroupid)
) TYPE=MyISAM;

SQL-Befehl:

CREATE TABLE bb1_acpmenuitemgroups(
itemgroupid smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
title varchar( 255 ) NOT NULL default '',
condition text NOT NULL ,
conditiontype enum( 'OR', 'AND' ) NOT NULL default 'OR',
showorder smallint( 5 ) unsigned NOT NULL default '0',
acpmode tinyint( 3 ) unsigned NOT NULL default '0',
PRIMARY KEY ( itemgroupid )
) TYPE = MYISAM

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition text NOT NULL,
  conditiontype enum('OR','AND') NOT NULL default 'OR'' at line 4