You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@roller.apache.org by Vincent <vi...@xaymaca.com> on 2006/03/04 06:55:23 UTC

some mysql errors on upgrading to 2.1

mysql> source 200-to-210-migration.sql

ERROR 1067 (42000): Invalid default value for 'approved'
ERROR 1067 (42000): Invalid default value for 'pending'
ERROR 1054 (42S22): Unknown column 'approved' in 'field list'
ERROR 1067 (42000): Invalid default value for 'commentmod'
ERROR 1067 (42000): Invalid default value for 'defaultallowcomments'
Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

ERROR 1054 (42S22): Unknown column 'commentmod' in 'field list'
ERROR 1061 (42000): Duplicate key name 'we_status_idx'
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> quit


I was running 2.01 under mysql 5 and tomcat 5.5.9

Ghetto Java is not looking to good right now:

http://www.ghetto.com/roller/page/gj


-- 
Kings are Earth's Gods: in vice their laws their will
And if Jove stray, who dares say Jove doth ill? -Shakespeare