[Mr_Devlin]

The db-changes wil not happen, tables will not being created, check your SQL-syntax, seems to be outdated

Datenbankfehler in vBulletin 4.1.9:

Invalid SQL:
SELECT * FROM adventcalendar_days ORDER BY adventcalendar_daysid ASC;

Referrer : https://xxx/login.php?do=login
lendar_days ORDER BY adventcalendar_daysid ASC;

MySQL-Fehler : Table 'XXX.adventcalendar_days' doesn't exist
Fehler-Nr. : 1146
Fehler-Zeit : Saturday, 21.11.2015 @ 13:13:30
Datum : Saturday, 21.11.2015 @ 13:13:30
Skript : http://xxx/admincp/adventcalendar_admin.php
IP-Adresse : xxxx
Benutzername : xxx
Klassenname : vB_Database_MySQLi
MySQL-Version : 6.0.11-alpha-community

PHP Code:

$db->hide_errors();

                $db->query("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `adventpermissions` INT(10) UNSIGNED NOT NULL DEFAULT '0'");

                $db->query("DROP TABLE IF EXISTS `" . TABLE_PREFIX . "adventcalendar_days`;");
                $db->query("CREATE TABLE `" . TABLE_PREFIX . "adventcalendar_days` (
                  `adventcalendar_daysid` int(11) NOT NULL auto_increment,
                  `active` smallint(1) NOT NULL default '0',
                  `image` text NOT NULL,
                  `data` text NOT NULL,
                  `bitfield` int(4) NOT NULL default '0',
                  `pwidth` int(4) NOT NULL default '0',
                  `pheight` int(4) NOT NULL default '0',
                  PRIMARY KEY  (`adventcalendar_daysid`)
                ) TYPE=MyISAM;"); 


Any help about this issue?