search

bednee / cooluri

GIT repository for TYPO3 extension CoolUri
7 stars 12 forks source link

SQL errors on DB schema update #33

Open mbrodala opened 9 years ago

mbrodala commented 9 years ago

There are some issues with the SQL syntax used to set up the link_* tables. These are the changes suggested by the DB compare tool:

ALTER TABLE link_cache CHANGE url url char(255); Current value: char(255) default NULL

ALTER TABLE link_cache CHANGE tstamp tstamp TIMESTAMP default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP; Current value: timestamp NOT NULL default 'CURRENT_TIMESTAMP' on update CURRENT_TIMESTAMP

ALTER TABLE link_cache CHANGE sticky sticky tinyint(1) unsigned default 0; Current value: tinyint(1) unsigned default '0'

ALTER TABLE link_cache DROP KEY url;

ALTER TABLE link_cache ADD KEY url (url(255));

ALTER TABLE link_oldlinks CHANGE link_id link_id int(10) unsigned NOT NULL default 0; Current value: int(10) unsigned NOT NULL default '0'

ALTER TABLE link_oldlinks CHANGE url url char(255); Current value: char(255) default NULL

ALTER TABLE link_oldlinks CHANGE tstamp tstamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP; Current value: timestamp NOT NULL default 'CURRENT_TIMESTAMP' on update CURRENT_TIMESTAMP

ALTER TABLE link_oldlinks DROP KEY url;

ALTER TABLE link_oldlinks ADD KEY url (url(255));

Performing these yields the following errors:

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 'char(255) default NULL' at line 1
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 'timestamp NOT NULL default 'CURRENT_TIMESTAMP' on update CURRENT_TIMESTAMP' at line 1
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 'tinyint(1) unsigned default '0'' at line 1
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 'int(10) unsigned NOT NULL default '0'' at line 1
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 'char(255) default NULL' at line 1
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 'timestamp NOT NULL default 'CURRENT_TIMESTAMP' on update CURRENT_TIMESTAMP' at line 1

We are using TYPO3 6.2.15.