Parašė kesiukas· 2010 Lie. 14 10:07:10
#7
romaxi ziurek koki error ismeta:
Klaida SQL užklausoje. Žemiau išvestas
MySQL serverio pranešimas (jeigu toks yra), turėtų padėti Jums nustatyti klaidos priežastį
ERROR: Klaidinga skyryba @ 1
STR: <?
SQL: <?php
$result = dbquery("CREATE TABLE ".$db_prefix."blacklist (
blacklist_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
blacklist_ip VARCHAR(20) NOT NULL DEFAULT '',
blacklist_email VARCHAR(100) NOT NULL DEFAULT '',
blacklist_reason TEXT NOT NULL,
PRIMARY KEY (blacklist_id)
) TYPE=MyISAM;");<?php
$result = dbquery("CREATE TABLE ".$db_prefix."blacklist (
blacklist_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
blacklist_ip VARCHAR(20) NOT NULL DEFAULT '',
blacklist_email VARCHAR(100) NOT NULL DEFAULT '',
blacklist_reason TEXT NOT NULL,
PRIMARY KEY (blacklist_id)
) TYPE=MyISAM;");<?php
$result = dbquery("CREATE TABLE ".$db_prefix."blacklist (
blacklist_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
blacklist_ip VARCHAR(20) NOT NULL DEFAULT '',
blacklist_email VARCHAR(100) NOT NULL DEFAULT '',
blacklist_reason TEXT NOT NULL,
PRIMARY KEY (blacklist_id)
) TYPE=MyISAM;");
SQL užklausa:
<?php $result = dbquery("CREATE TABLE ".$db_prefix."blacklist ( blacklist_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT, blacklist_ip VARCHAR(20) NOT NULL DEFAULT '', blacklist_email VARCHAR(100) NOT NULL DEFAULT '', blacklist_reason TEXT NOT NULL, PRIMARY KEY (blacklist_id) ) TYPE=MyISAM;");
MySQL atsakymas: ?
#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 '<?php
$result = dbquery("CREATE TABLE ".$db_prefix."blacklist (
blacklist_id S' at line 1
Redagavo kesiukas· 2010 Lie. 14 10:07:38