Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Unknown column 'blacklist_ip' in 'where clause'

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