error in creating company initial signup - centos 6 - mysql 5.6

[cs yeow]

hi hope some one can help on this error : error in create company

env: centos 6.6 64bit
mysql : MySQL-server-5.6.21-1.el6.x86_64
httpd: httpd-2.2.15-47.el6.centos.4.x86_64
orangescrum: 1.5.9

new to orangescrum , and try to setup but error prompt out hope some one manage to help

install follow the step http://www.orangescrum.org/how-to-install-orangescrum-on-centos

open browser http:192.168.2.11  and enter company name , email and password, click signup error prompt out : Error in Creating Company


mysql setting

mysql> select user,host from mysql.user;
+-------------+-----------+
| user        | host      |
+-------------+-----------+
| orangescrum | %         |
| root        | 127.0.0.1 |
| root        | ::1       |
| orangescrum | localhost |
| root        | localhost |
+-------------+-----------+

mysql> show grants for orangescrum@localhost;
+--------------------------------------------------------------------------------------------------------------------+
| Grants for orangescrum@localhost                                                                                   |
+--------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'orangescrum'@'localhost' IDENTIFIED BY PASSWORD '*6C362347EBEAA7DF44F6D34884615A35095E80EB' |
| GRANT ALL PRIVILEGES ON `orangescrum`.* TO 'orangescrum'@'localhost'                                               |
+--------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

mysql> show variables like 'sql_mode';
+---------------+--------------------------------------------+
| Variable_name | Value                                      |
+---------------+--------------------------------------------+
| sql_mode      | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+---------------+--------------------------------------------+
1 row in set (0.00 sec)

mysql> use orangescrum;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

mysql> show tables;

+--------------------------------+
| Tables_in_orangescrum          |
+--------------------------------+
| archives                       |
| case_actions                   |
| case_activities                |
| case_file_drives               |
| case_files                     |
| case_filters                   |
| case_recents                   |
| case_settings                  |
| case_templates                 |
| case_user_emails               |
| case_user_views                |
| companies                      |
| company_users                  |
| custom_filters                 |
| daily_updates                  |
| dailyupdate_notifications      |
| default_project_template_cases |
| default_project_templates      |
| default_templates              |
| easycase_milestones            |
| easycases                      |
| email_reminders                |
| log_activities                 |
| log_types                      |
| mail_tbls                      |
| milestones                     |
| project_technologies           |
| project_template_cases         |
| project_templates              |
| project_users                  |
| projects                       |
| save_reports                   |
| subscriptions                  |
| template_module_cases          |
| timezone_names                 |
| timezones                      |
| transactions                   |
| type_companies                 |
| types                          |
| user_infos                     |
| user_invitations               |
| user_logins                    |
| user_notifications             |
| user_subscriptions             |
| users                          |
+--------------------------------+
45 rows in set (0.00 sec)


# cat /var/www/html/orangescrum/app/Config/database.php

class DATABASE_CONFIG {

        public $default = array(
                'datasource' => 'Database/Mysql',
                'persistent' => false,
                'host' => 'localhost',
                'login' => 'orangescrum',
                'password' => 'xxxxxxxx',
                'database' => 'orangescrum',
                'prefix' => '',
                'encoding' => 'utf8',
        );
}


---end-------------
httpd config

cat /etc/httpd/conf.d/orangescrum.conf
<VirtualHost *:80>
ServerName localhost
DocumentRoot /var/www/html/orangescrum
<Directory /var/www/html/orangescrum>
Options Indexes FollowSymLinks MultiViews
AllowOverride All
Order allow,deny
allow from all
</Directory>
</VirtualHost>

cat /etc/httpd/conf/httpd.conf
DocumentRoot "/var/www/html"
<Directory />
    Options FollowSymLinks
    AllowOverride All
</Directory>
<Directory "/var/www/html">

---end---

note:
i also try to setup another centos 6.6 with default mysql pkg, i manage successfully signup and create project in orangescrum, the mysql version as below:
mysql:  mysql mysql-server-5.1.73-5.el6_7.1.x86_64 ( default mysql pkg on centos 6)


refer to snap2.jpg for working orangescrum

[Stéphane Wetterwald]

I think i found a solution :

edit /etc/my.cnf

change the line sql_mod = " XXXXX "

to sql_mod = ""

leave it blank and it worked for me.

[cs yeow]

On Friday, April 22, 2016 at 4:02:57 PM UTC+8, Stéphane Wetterwald wrote:

I think i found a solution :

edit /etc/my.cnf

change the line sql_mod = " XXXXX "

to sql_mod = ""

leave it blank and it worked for me.

hi Stéphane Wetterwald

i try the suggestion provided by you , but not work for me. thanks for your help. currently i use mysql 5.1 (default pkg from centos 6.x) i swork for me..

thanks a lot ..

[Firas Abd Alrahman]

Finally I got the error : 

Integrity constraint violation: 1048 Column 'subscription_id' cannot be null

by temporary editing the file : app/Controller/UsersController.php line: 3361

            } catch (Exception $e) {

                var_dump($e);

                $this->Company->delete($company_id);

                $message = 'Error in Creating Company';

var_dump displayed the error, the problem is the Exception not being logged any where and it is hard to guess the sql error.

[Team Orangescrum]

Hi Firas,

Thank you for letting us know. We will verify the same and update here.

Regards

Team Orangescrum