[TYPO3-english] SQL Problem in Update wizard
Tomas Norre Mikkelsen
tomasnorre at gmail.com
Thu Feb 10 13:03:33 CET 2011
Hi,
I have a problem SQL queries and Update Wizard. I'm upgrading a solution
to typo3lts, and got follow 3 queries, that need to be done in "compare"
databases.
-- SQL
ALTER TABLE tx_tcdirectmail_sentlog DROP KEY authcode;
ALTER TABLE tx_tcdirectmail_sentlog ADD KEY authcode (authcode(9));
ALTER TABLE tx_skcalendar_event CHANGE cost cost tinytext default 0;
-- Result:
BLOB/TEXT column 'cost' can't have a default value
Why is it trying to change to values not allowed?
any hints and problem solving?
/Tomas
More information about the TYPO3-english
mailing list