server und warrules draufballern
doch allerdings bekomme ich diesen fehler
externer Link
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | MySQL Error: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 'TYPE = myisam' at line 1in Query:CREATE TABLE `ic1_serverrules` ( `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT , `zahl` SMALLINT(6) DEFAULT 0 NOT NULL , `titel` VARCHAR(200) NOT NULL , `text` TEXT NOT NULL , PRIMARY KEY ( `id` ) , FULLTEXT ( `titel` , `text` ) ) TYPE = myisamDebug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ installswrules.php:29 -- db_query(...) @ index.php:36 -- require_once(...)MySQL Error: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 'TYPE = myisam' at line 1in Query:CREATE TABLE `ic1_warrules` ( `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT , `zahl` SMALLINT(6) DEFAULT 0 NOT NULL , `titel` VARCHAR(200) NOT NULL , `text` TEXT NOT NULL , PRIMARY KEY ( `id` ) , FULLTEXT ( `titel` , `text` ) ) TYPE = myisamDebug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ installswrules.php:39 -- db_query(...) @ index.php:36 -- require_once(...)Die Server/War Rules wurde erfolgreich installiertDu solltest nun die /include/contents/installswrules.php löschen! |
in der datei steht drinne
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 | <?php defined ('main') or die ( 'no direct access' ); $design = new design ( 'Server/War Rules', 'Server/War Rules'); $design->header(); if ( empty ($_POST['step']) ) { ?> <form action="index.php?installswrules" method="POST"> <input type="hidden" name="step" value="2" /> <table width="100%" class="border" border="0" cellspacing="1" cellpadding="3" align="center"> <tr class="Chead"> <td colspan="2"><b>Willkommen zur Installation von Server/War Rules</b></td></tr> <td></td> <td><input type="submit" value="Weiter ->"></td> </tr> </table> </form> <?php} elseif ( $_POST['step'] == 2 ) { $sql = 'CREATE TABLE `prefix_serverrules` (' . ' `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT , ' . ' `zahl` SMALLINT(6) DEFAULT 0 NOT NULL , ' . ' `titel` VARCHAR(200) NOT NULL , ' . ' `text` TEXT NOT NULL , ' . ' PRIMARY KEY ( `id` ) , ' . ' FULLTEXT ( `titel` , `text` ) ' . ' )' . ' TYPE = myisam '; db_query($sql); $sql = 'CREATE TABLE `prefix_warrules` (' . ' `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT , ' . ' `zahl` SMALLINT(6) DEFAULT 0 NOT NULL , ' . ' `titel` VARCHAR(200) NOT NULL , ' . ' `text` TEXT NOT NULL , ' . ' PRIMARY KEY ( `id` ) , ' . ' FULLTEXT ( `titel` , `text` ) ' . ' )' . ' TYPE = myisam'; db_query($sql); db_query("INSERT INTO `prefix_modules`(`url`,`name`,`gshow`,`ashow`,`fright`) VALUES ('ruless','Serverrules', 0, 1, 0)"); db_query("INSERT INTO `prefix_modules`(`url`,`name`,`gshow`,`ashow`,`fright`) VALUES ('rulesw','Warrules', 0, 1, 0)"); ?> <table width="100%" class="border" border="0" cellspacing="1" cellpadding="3" align="center"> <tr class="Chead"> <td colspan="2"><b>Die Server/War Rules wurde erfolgreich installiert</b></td> </tr> <tr class="Cnorm"> <td colspan="2"><b>Du solltest nun die /include/contents/installswrules.php löschen!</b></td> </tr> </table><?php } $design->footer();?> |
betroffene Homepage: stshq.de
