[TYPO3-core] FYI #13504: Cannot parse TRUNCATE TABLE in install tool
Xavier Perseguers
typo3 at perseguers.ch
Wed Feb 10 22:12:11 CET 2010
Hi,
FYI, following patches were committed to Core trunk (rev. 6895) and DBAL trunk (rev. 29911).
Type: Bugfix / Feature
Bugtracker reference:
http://bugs.typo3.org/view.php?id=13504
Branch: trunk
Problem:
When using Typo3 (4.3.1) with a MS-SQL DB the Database Analyser can not update the tables in the "COMPARE" section and results in an error message like this:
ERROR: Query could not be parsed: "SQL engine parse ERROR: "" is not a keyword: near "TRUNCATE TABLE be_groups "". Query: "TRUNCATE TABLE be_groups;"
Additional Information:
This is/should be well known that many if not "all" (99%) suggestions made by the Install Tool when dealing with non-MySQL databases -- once the tables have been created -- are just nothing to worry
about. Anyway, this was not great that Install Tool suggests to truncate tables while not being able to perform the operation.
Type is bugfix and feature at the same time because it enhances the t3lib_db API with truncate methods. As such and even if it fixes a "bug", I decided only to commit it to trunk as it is only a "nice
to have".
Cheers
--
Xavier Perseguers
http://xavier.perseguers.ch/en
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 13504_core.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100210/65767e6c/attachment.txt>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 13504_dbal.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100210/65767e6c/attachment.asc>
More information about the TYPO3-team-core
mailing list