Project

General

Profile

Actions

Bug #24315

closed

DBAL: Error creating database table while trying to install openid extension

Added by Adrian Fischer almost 14 years ago. Updated over 10 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2010-12-09
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.5
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

While trying to install openid extension in current trunk of TYPO3 (9766) I get the following error:

ERROR: Query could not be parsed: "SQL engine parse ERROR: No ) parenthesis in list: near "(255),tstamp,salt), KEY crdate (crdate) ) ENGINE=I"". Query: "CREATE TABLE tx_openid_nonce_store ( uid int(11) unsigned NOT NULL auto_increment, pid int(11) unsigned NOT NULL default '0', crdate int(11) unsigned NOT NULL default '0', tstamp int(11) unsigned NOT NULL default '0', server_url varchar(2047) NOT NULL default '', salt char(40) NOT NULL default '', PRIMARY KEY (uid), UNIQUE nonce (server_url(255),tstamp,salt), KEY crdate (crdate) ) ENGINE=InnoDB;"

The SQL definition causing this error seems to be:

CREATE TABLE tx_openid_nonce_store (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
server_url varchar(2047) NOT NULL default '',
salt char(40) NOT NULL default '',
PRIMARY KEY (uid),
UNIQUE nonce (server_url(255),tstamp,salt),
KEY crdate (crdate)
) ENGINE=InnoDB;

Apache: 2.2.16
PHP Versionen: 5.2.14
mySQL Version: 5.0.91-community-log
(issue imported from #M16710)

Actions #1

Updated by Adrian Dymorz almost 14 years ago

This happened in the old extension manager.

Actions #2

Updated by Steffen Kamper almost 14 years ago

does this only happen when dbal is installed?

Actions #3

Updated by Steffen Kamper almost 14 years ago

i can confirm that with DBAL this throws the error. Without dbal all is fine. So this is a DBAL related error only.

Actions #4

Updated by Alexander Opitz over 10 years ago

  • Status changed from Accepted to Needs Feedback
  • Target version deleted (0)
  • Is Regression set to No

Hi,

as this issue is very old. Does the problem still exists within newer versions of TYPO3 CMS (6.1.7)?

Actions #5

Updated by Adrian Dymorz over 10 years ago

Hi Alexander,

I do not remember exactly what the problem was there.

I agree to close this issue.

Best regards
Adrian

PS: I changed my name in 2010 and thus created a new account (old "Adrian Fischer", new "Adrian Dymorz").

Actions #6

Updated by Alexander Opitz over 10 years ago

  • Status changed from Needs Feedback to Closed
  • Assignee deleted (Xavier Perseguers)
Actions

Also available in: Atom PDF