Bug #24315
closedDBAL: Error creating database table while trying to install openid extension
0%
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)
Updated by Adrian Dymorz almost 14 years ago
This happened in the old extension manager.
Updated by Steffen Kamper almost 14 years ago
does this only happen when dbal is installed?
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.
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)?
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").
Updated by Alexander Opitz over 10 years ago
- Status changed from Needs Feedback to Closed
- Assignee deleted (
Xavier Perseguers)