id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,mlocked 3319,SVN 13265 - error upgrading database schema from [1186] to [1188],anonymous,Isaac Richards,"I believe some mysql4 code crept back into svn recently and that is breaking the db upgrade script. mysql version 3.23 errors during mythfrontend run: 2007-04-16 21:01:33.370 Current Schema Version: 1186 2007-04-16 21:01:33.371 Newest Schema Version : 1188 2007-04-16 21:01:33.372 Connected to database 'mythconverg' at host: localhost 2007-04-16 21:01:33.372 Setting Lock for Database Schema upgrade. If you see a long pause here it means the Schema is already locked and is being upgraded by another Myth process. 2007-04-16 21:01:33.373 Connected to database 'mythconverg' at host: localhost 2007-04-16 21:01:33.375 Upgrading to schema version 1187 2007-04-16 21:01:33.375 DB Error (Performing database upgrade): Query was: ALTER TABLE eit_cache MODIFY eventid INT UNSIGNED default 0; Error was: Driver error was [2/1171]: QMYSQL3: Unable to execute query Database error was: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead new version: 1187 2007-04-16 21:01:33.376 Database Schema upgrade FAILED, unlocking. 2007-04-16 21:01:33.376 Couldn't upgrade database to new schema, exiting. ",defect,closed,major,0.21,mythtv,head,medium,fixed,,,0