Bug #24150
closed
Can't create table sys_registry from install tool
0%
Description
I'm testing the 4.5.0-beta1 and the install tool fails on creating this statement:
CREATE TABLE sys_registry ( uid int(11) unsigned NOT NULL auto_increment, entry_namespace varchar(128) NOT NULL default '', entry_key varchar(128) NOT NULL default '', entry_value blob, PRIMARY KEY (uid), UNIQUE entry_identifier (entry_namespace,entry_key) );
Testing the dummy package and source.tgz on an empty database created by typo3.
mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using readline 6.1
on ubuntu 10.10 and Apache/2.2.14
php version 5.3.2-1ubuntu4.5 with Suhosin Patch 0.9.9.1
(issue imported from #M16494)
Updated by Rob Vonk about 14 years ago
I see now that there's a small message on top of the page:
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 'UNIQUE (Array) )' at line 7
And when i remove the dbal extension, all is fine.
Updated by Jigal van Hemert about 14 years ago
This happens when DBAL is active; it can't process the index on two columns which is present in the table definition of sys_registry.
Work around:
- uninstall DBAL if you only use MySQL
- use Install Tool > Database Analyzer > COMPARE to create the sys_registry table
The problem with DBAL is reported in issue #24156
Updated by Xavier Perseguers almost 14 years ago
Will be handled with bug entry in DBAL. Thanks.