Project

General

Profile

Actions

Bug #43470

closed

SQL engine parse ERROR: Still content in clause after parsing!: near "; "

Added by Stefan Neufeind almost 12 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2012-11-29
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.0
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

(this occured when using dbal - but problem is in the sql-parser in core)

How to reproduce:
  • dbal activated
  • installing "dam"

Fails with exception

SQL engine parse ERROR: Still content in clause after parsing!: near "; "

thrown in parseCREATEDATABASE() in
typo3/sysext/core/Classes/Database/SqlParser.php

Query leading to this:
string(308) "CREATE TABLE tx_dam_media_types (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
ext varchar(5) DEFAULT '' NOT NULL,
mime varchar(64) DEFAULT '' NOT NULL,
type int(11) DEFAULT '0' NOT NULL,
icon varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
"

Doing a trim() on the query beforehand it works without any problems. I expect there are newlines or maybe a tab at the end of that string.

Actions #1

Updated by Stefan Neufeind almost 12 years ago

  • Assignee set to Stefan Neufeind
Actions #2

Updated by Gerrit Code Review almost 12 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/16875

Actions #3

Updated by Stefan Neufeind almost 12 years ago

Problem lies/can be fixed in trimSql() of the SqlParser in core. It's just triggered by that "random" whitespace-char in create table of dam. See review for details.

Actions #4

Updated by Gerrit Code Review almost 12 years ago

Patch set 2 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/16875

Actions #5

Updated by Gerrit Code Review almost 12 years ago

Patch set 3 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/16875

Actions #6

Updated by Gerrit Code Review almost 12 years ago

Patch set 1 for branch TYPO3_6-0 has been pushed to the review server.
It is available at http://review.typo3.org/16912

Actions #7

Updated by Gerrit Code Review almost 12 years ago

Patch set 1 for branch TYPO3_4-7 has been pushed to the review server.
It is available at http://review.typo3.org/16913

Actions #8

Updated by Gerrit Code Review almost 12 years ago

Patch set 1 for branch TYPO3_4-6 has been pushed to the review server.
It is available at http://review.typo3.org/16914

Actions #9

Updated by Gerrit Code Review almost 12 years ago

Patch set 1 for branch TYPO3_4-5 has been pushed to the review server.
It is available at http://review.typo3.org/16915

Actions #10

Updated by Stefan Neufeind almost 12 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #11

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF