5 users online. Create an account or sign in to join them.Users
[2.0.7] DatabaseException during installation
A for , submitted by rainerborene on 24 February 2010
Announcement
Symphony's issue tracker has been moved to Github.
Issues are displayed here for reference only and cannot be created or edited.
Browse
Closed#236: [2.0.7] DatabaseException during installation
-
-
- rainerborene
- Comment #1
- 24 Feb 10, 12:01 am
-
-
- alpacaaa
- Comment #2
- 26 Feb 10, 6:13 am
You’ re running mysql in strict mode, maybe? If you have enough permissions on the server, I’d try running the following query:
set global sql_mode=''
That is the default value on a common installation, so nothing dangerous is hidden behind it. Restart the server and cross your fingers :)
-
-
- rainerborene
- Comment #3
- 10 Mar 10, 10:50 pm
Unfortunately, I don’t have enough permissions to run that query.
-
-
- Alistair
- Comment #4
- 17 Mar 10, 4:26 pm
role_id should not be there. That must have snuck in to the install package after testing the Members extension. I’ve updated the install.sql so it wont be a problem. http://github.com/symphony/symphony-2/commit/3b73c6a1bef063d225626a10683c4d07feb3ae9b
This issue is closed.
I’ve just tried to make a clean installation and I have got this error.
Fatal error: Uncaught exception 'DatabaseException' with message 'MySQL Error (1364): Field 'role_id' doesn't have a default value in query "INSERT INTO `sym_authors` ( `id` , `username` , `password` , `first_name` , `last_name` , `email` , `last_seen` , `user_type` , `primary` , `default_section` , `auth_token_active` ) VALUES ( 1, 'dev', MD5('test'), 'Test', 'Example', 'test@example.com', NULL , 'developer', 'yes', '6', 'no' );"' in D:htdocssymphonysymphonylibtoolkitclass.mysql.php:390 Stack trace: #0 D:htdocssymphonysymphonylibtoolkitclass.mysql.php(275): MySQL->__error() #1 D:htdocssymphonysymphonylibtoolkitinclude.install.php(600): MySQL->query('INSERT INTO `t...') #2 [internal function]: Action::install(Object(Page), Array) #3 D:htdocssymphonysymphonylibtoolkitinclude.install.php(1329): call_user_func_array(Array, in D:htdocssymphonysymphonylibtoolkitclass.mysql.php on line 390