|
Newbie |
Joined: Wed Jun 15, 2011 1:12 am Posts: 30
|
Trying to upgrade the beta 5 database to beta 6 and I am getting a Database Error:-
[quote]A Database Error Occurred Error Number: 1067
Invalid default value for 'system_id'
ALTER TABLE sys_sw_database_details ADD system_id int(10) unsigned NOT NULL default NULL
This appears to be setting a NOT NULL value to NULL. There is also another instance of this a few lines further down in the same file code_igniter/system/application/controllers/admin.php (lines 1278 and 1282 I think).
Should the values be empty, i.e. 2 single quotes?
I have restored the backup of my database and await your advices.
Thanks
Richard
|
|