Error during database upgrade from 0.4.2 to 0.4.3


(wavesound) #1

Hi All,

I’m seeing the following when trying to upgrade Piwik:

Error trying to execute the query ‘ALTER TABLE piwik_log_visit
CHANGE visit_goal_converted visit_goal_converted TINYINT(1) NOT NULL’.
The error was: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘’ for column ‘visit_goal_converted’ at row 1

Thank you in advance for any assistance!

-Rob


(vipsoft) #2

Please try adding the IGNORE keyword, e.g.,

'ALTER IGNORE TABLE `'. Piwik::prefixTable('log_visit') .'`
    CHANGE `visit_goal_converted` `visit_goal_converted` TINYINT(1) NOT NULL' => false,

(wavesound) #3

[quote=vipsoft @ Aug 14 2009, 01:45 AM]Please try adding the IGNORE keyword, e.g.,

'ALTER IGNORE TABLE `'. Piwik::prefixTable('log_visit') .'`
    CHANGE `visit_goal_converted` `visit_goal_converted` TINYINT(1) NOT NULL' => false,

[/quote]

Thank you! That worked perfectly!

-Rob