Project

General

Profile

Actions
Copy link

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
Copy link

Also available in: Atom PDF