Project

General

Profile

Actions

Bug #14484

closed

Error in SQL syntax

Added by old_GuBA almost 20 years ago. Updated over 18 years ago.

Status:
Closed
Priority:
Should have
Category:
Install Tool
Target version:
-
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...
  1. 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 #1

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

Actions #2

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

Actions #3

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

Actions #4

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!

Actions #5

Updated by Ingmar Schlecht almost 20 years ago

Thanks!
The bug is now fixed in CVS.

Actions

Also available in: Atom PDF