Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: MySQL
Parašė robert· 2008 Spa. 13 21:10:34
#1
Kas blogai sitoje lenteleje
"CREATE TABLE " . TBL_ADMINSECTIONS . " (
\"sectionid\" int(10) unsigned auto_increment,
\"section\" varchar(250) default NULL,
\"displayorder\" int(11) default 0,
PRIMARY KEY (\"sectionid\"),
UNIQUE KEY \"section\" (\"section\")
) ENGINE=InnoDB";
Redagavo robert· 2008 Spa. 13 21:10:43
Parašė Žirklė· 2008 Spa. 13 21:10:12
#2
"CREATE TABLE " .TBL_ADMINSECTIONS." (
sectionid int(10) unsigned auto_increment,
section varchar(250) default NULL,
displayorder\" int(11) default 0,
PRIMARY KEY (sectionid),
UNIQUE KEY section (section)
) ENGINE=InnoDB";
Parašė robert· 2008 Spa. 13 21:10:28
#3
Error
SQL query:
"CREATE TABLE ".TBL_ADMINSECTIONS. " ( sectionid int(10) unsigned auto_increment, section varchar(250) default NULL, displayorder\" int(11) default 0, PRIMARY KEY (sectionid), UNIQUE KEY section (section) ) ENGINE=InnoDB"
MySQL said: Documentation
#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 '"CREATE TABLE " .TBL_ADMINSECTIONS." (
sectionid int(10) unsigned auto_incremen' at line 1
Parašė ramon· 2008 Spa. 13 22:10:02
#4
Žirklė parašė:
"CREATE TABLE " .TBL_ADMINSECTIONS." (
sectionid int(10) unsigned auto_increment,
section varchar(250) default NULL,
displayorder\" int(11) default 0,
PRIMARY KEY (sectionid),
UNIQUE KEY section (section)
) ENGINE=InnoDB";
Parašė robert· 2008 Spa. 13 22:10:54
#5
Vistiek tas pats :|
#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 '"CREATE TABLE " .TBL_ADMINSECTIONS." (
sectionid int(10) unsigned auto_incremen' at line 1
Parašė robert· 2008 Spa. 14 14:10:11
#6
update, gal kas nors žinos :|
Parašė MAnjack· 2008 Spa. 14 14:10:45
#7
Jeigu ką, tai ramon pažymėtą vietą reikia ištrint :D
Parašė robert· 2008 Spa. 14 14:10:13
#8
Tai buvau ištrynęs, bet visstiek ta error išmete, na bet dabar tai nesvarbu.
Yra nauja bėda, kai kuriu šitą lentelę :
CREATE TABLE `tvs_newsconfig` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`sectionid` int( 11 ) NOT NULL default '0',
`title` varchar( 150 ) NOT NULL default '',
`description` varchar( 200 ) NOT NULL default '',
`value` text NOT NULL ,
`var` varchar( 100 ) NOT NULL default '',
`option` varchar( 150 ) NOT NULL default '',
`displayorder` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `var` ( `var` ) ,
KEY `title` ( `title` , `description` , `var` )
);
Man išmetą tokį error'ą
#1071 - Specified key was too long; max key length is 1000 bytes
Be šitos lentelės neveikia TVS, ką daryti? :?
Parašė robert· 2008 Spa. 14 17:10:25
#9
update dar kartą, gal kas žinos :|
Parašė robert· 2008 Spa. 16 16:10:12
#10
Dar kartą update