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)
Updated by Sebastian Kurfuerst almost 20 years ago
Your MYSQL database version is too new, and the bugfix is in CVS.
bug can be closed I think,
Sebastian
bearbeitet am: 10.01.05 16:52
Updated by old_GuBA almost 20 years ago
PHP version 4.3.10
MySQL version 4.0.22-standard
and the package the Typo3 is a Quickstart
Updated by Sebastian Kurfuerst almost 20 years ago
The bug I meant is explained here:
http://bugs.typo3.org/bug_view_page.php?bug_id=0000416
and is fixed already in CVS. I don't know if this solves your problem too...
Sebastian
bearbeitet am: 10.01.05 18:05
Updated by Karsten Dambekalns almost 20 years ago
No, the bug reported here is about the extra comma, and it does break creating the table in MySQL. This is not the same as #14354!
Updated by Ingmar Schlecht almost 20 years ago
Thanks!
The bug is now fixed in CVS.
Actions