Actions
Bug #14484
closedError in SQL syntax
Start date:
2005-01-10
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
3.7.0
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
At the end of sentence SQL of the table 'pages' there is one comma that exceeds...
- Table structure for table 'pages'
#
CREATE TABLE pages(
uid int( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
pid int( 11 ) DEFAULT '0' NOT NULL ,
t3ver_oid int( 11 ) unsigned DEFAULT '0' NOT NULL ,
t3ver_id int( 11 ) unsigned DEFAULT '0' NOT NULL ,
t3ver_label varchar( 30 ) DEFAULT '' NOT NULL ,
tstamp int( 11 ) unsigned DEFAULT '0' NOT NULL ,
sorting int( 11 ) unsigned DEFAULT '0' NOT NULL ,
deleted tinyint( 4 ) unsigned DEFAULT '0' NOT NULL ,
perms_userid int( 11 ) unsigned DEFAULT '0' NOT NULL ,
perms_groupid int( 11 ) unsigned DEFAULT '0' NOT NULL ,
perms_user tinyint( 4 ) unsigned DEFAULT '0' NOT NULL ,
perms_group tinyint( 4 ) unsigned DEFAULT '0' NOT NULL ,
perms_everybody tinyint( 4 ) unsigned DEFAULT '0' NOT NULL ,
editlock tinyint( 4 ) unsigned DEFAULT '0' NOT NULL ,
crdate int( 11 ) unsigned DEFAULT '0' NOT NULL ,
cruser_id int( 11 ) unsigned DEFAULT '0' NOT NULL ,
title tinytext NOT NULL ,
doktype tinyint( 3 ) unsigned DEFAULT '0' NOT NULL ,
TSconfig blob NOT NULL ,
storage_pid int( 11 ) DEFAULT '0' NOT NULL ,
is_siteroot tinyint( 4 ) DEFAULT '0' NOT NULL ,
php_tree_stop tinyint( 4 ) DEFAULT '0' NOT NULL ,
tx_impexp_origuid int( 11 ) DEFAULT '0' NOT NULL ,
PRIMARY KEY ( uid ) ,
KEY t3ver_oid( t3ver_oid ) ,
KEY parent( pid ) , -------->> is here....
)
MySQL ha dicho: Documentación
#14723 - 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 ')' at line 31
(issue imported from #M668)
Actions