In Piwik 0.5.4, log_action's name column is changed from "VARCHAR(255) NOT NULL" to simply "TEXT" (and allowing NULL).
Can you make the corresponding change to core/Piwik.php for new users?
(In [1738]) fixes #1089 - sync up with 0.5.4 update (schema change)