Bug #53750
closed
Scheduler extension sql file is invalid
100%
Description
The ext_tables.sql file of the scheduler extension is invalid.
On import into MySQL, an error is thrown and MySQL refuses to create the table:
ERROR 1067 (42000) at line 4: Invalid default value for 'uid'
This is due to the fact that a default value is being set for an auto_increment field.
This line:
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
Should read:
uid int(11) unsigned NOT NULL auto_increment,
Files
Updated by Michiel Roos about 11 years ago
- File bugfix_53750.diff bugfix_53750.diff added
Updated by Markus Klein about 11 years ago
- Status changed from New to Accepted
Hi Michiel!
Since this does work on all other installations, I suspect that you've some special MySQL settings (maybe some sort of strict mode).
Nevertheless the SQL does not look right. Can you push the patch to Gerrit?
Updated by Gerrit Code Review about 11 years ago
- Status changed from Accepted to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/25502
Updated by Gerrit Code Review about 11 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/25502
Updated by Gerrit Code Review about 11 years ago
Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/25502
Updated by Gerrit Code Review about 11 years ago
Patch set 1 for branch TYPO3_6-1 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/25505
Updated by Gerrit Code Review about 11 years ago
Patch set 1 for branch TYPO3_6-0 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/25506
Updated by Gerrit Code Review about 11 years ago
Patch set 1 for branch TYPO3_4-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/25507
Updated by Gerrit Code Review about 11 years ago
Patch set 1 for branch TYPO3_4-5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/25508
Updated by Michiel Roos about 11 years ago
In version 6.2 this issue has also spread too the tx_scheduler_task_group table definition in the same file.
Besides that, the core is clean:
for f in `find ./ -type f -name *.sql`; do echo $f; grep auto_increment $f | grep DEFAULT; done;
Updated by Michiel Roos about 11 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 3f2ed1dffa42fc6e675fe4f2fc8875d1d1117877.
Updated by