Error while updating our database


(eisi123) #1

Hello,
when i try to update our piwik installation to 0.5.4 i get the following error:

Error trying to execute the query
’ALTER TABLE piwik_log_action CHANGE name name TEXT’. The error was:
SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column 'name’
used in key specification without a key length

We use mysql 5.0.51a

Are there any suggestions?
Regards,
Ingo


#2

Hi,
i had the same error here updating to 1.4. This helped me out:
drop index idx1 on piwik_dwds_log_action;

Not sure wether there this will have a performance impact though.

Best regards,
Kai