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