Exception storing schema updates


#1

Hello,

I’m new to this & just trying to set up a DreamFactory instance on a CentOS 7.1 server.

I’ve gone through the following installation guide:
https://github.com/dreamfactorysoftware/dsp-core/wiki/Install-CentOS-RedHat

The PHP timezone has been set to address the error in the log file below:
http://stackoverflow.com/questions/16765158/date-it-is-not-safe-to-rely-on-the-systems-timezone-settings

However, as soon as I enter the Administrator’s details on the DF start page, the error at the end occurs & the website is unusable.

Any ideas?

root@localhost log]# cat web.10.log
[2015-10-09 23:26:17][app][ERROR    ]   * System error querying admin activated state.
[2015-10-09 23:26:18][app][ERROR    ] CDbCommand::execute() failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dreamfactory.df_sys_cache' doesn't exist. The SQL statement executed was: DELETE FROM df_sys_cache WHERE expire>0 AND expire<1444433177.
[2015-10-09 23:26:18][app][ERROR    ] date_default_timezone_get(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. (/opt/dreamfactory/platform/vendor/monolog/monolog/src/Monolog/Logger.php:248)
Stack trace:
#0 /opt/dreamfactory/platform/vendor/kisma/kisma/src/Kisma/Core/Utility/Log.php(208): log()
#1 /opt/dreamfactory/platform/vendor/dreamfactory/lib-php-common-platform/src/Services/SystemManager.php(977): error()
#2 /opt/dreamfactory/platform/app/controllers/WebController.php(95): activated()
#3 /opt/dreamfactory/platform/vendor/dreamfactory/yii/framework/yiilite.php(1744): WebController->init()
#4 /opt/dreamfactory/platform/vendor/dreamfactory/yii/framework/yiilite.php(1665): DreamFactory\Platform\Yii\Components\PlatformWebApplication->runController()
#5 /opt/dreamfactory/platform/vendor/dreamfactory/yii/framework/yiilite.php(1190): DreamFactory\Platform\Yii\Components\PlatformWebApplication->processRequest()
#6 /opt/dreamfactory/platform/vendor/dreamfactory/lib-php-common-yii/src/Utility/Pii.php(219): DreamFactory\Platform\Yii\Components\PlatformWebApplication->run()
#7 /opt/dreamfactory/platform/web/index.php(69): run()
REQUEST_URI=/
[2015-10-09 23:26:21][app][ERROR    ]   * System error querying admin activated state.
[2015-10-09 23:26:21][app][ERROR    ] date_default_timezone_get(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. (/opt/dreamfactory/platform/vendor/monolog/monolog/src/Monolog/Logger.php:248)
Stack trace:
#0 /opt/dreamfactory/platform/vendor/kisma/kisma/src/Kisma/Core/Utility/Log.php(208): log()
#1 /opt/dreamfactory/platform/vendor/dreamfactory/lib-php-common-platform/src/Services/SystemManager.php(977): error()
#2 /opt/dreamfactory/platform/app/controllers/WebController.php(95): activated()
#3 /opt/dreamfactory/platform/vendor/dreamfactory/yii/framework/yiilite.php(1744): WebController->init()
#4 /opt/dreamfactory/platform/vendor/dreamfactory/yii/framework/yiilite.php(1665): DreamFactory\Platform\Yii\Components\PlatformWebApplication->runController()
#5 /opt/dreamfactory/platform/vendor/dreamfactory/yii/framework/yiilite.php(1190): DreamFactory\Platform\Yii\Components\PlatformWebApplication->processRequest()
#6 /opt/dreamfactory/platform/vendor/dreamfactory/lib-php-common-yii/src/Utility/Pii.php(219): DreamFactory\Platform\Yii\Components\PlatformWebApplication->run()
#7 /opt/dreamfactory/platform/web/index.php(69): run()
REQUEST_URI=/
[2015-10-10 10:33:55][app][ERROR    ]   * System error querying admin activated state.
[2015-10-10 10:33:55][app][DEBUG    ] Database required
[2015-10-10 10:33:55][app][DEBUG    ] Checking database schema
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_config
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_user
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_role
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_service
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_app
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_app_group
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_app_to_app_group
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_app_to_role
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_app_to_service
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_role_service_access
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_role_system_access
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_lookup_key
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_schema_extras
[2015-10-10 10:33:55][app][DEBUG    ] Creating table: df_sys_email_template
[2015-10-10 10:33:56][app][DEBUG    ] Creating table: df_sys_stat
[2015-10-10 10:33:56][app][DEBUG    ] Creating table: df_sys_provider
[2015-10-10 10:33:56][app][DEBUG    ] Creating table: df_sys_provider_user
[2015-10-10 10:33:56][app][DEBUG    ] Creating table: df_sys_device
[2015-10-10 10:33:56][app][DEBUG    ] Creating table: df_sys_event
[2015-10-10 10:33:56][app][DEBUG    ] Creating table: df_sys_service_doc
[2015-10-10 10:34:00][app][ERROR    ] Exception storing schema updates: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'timestamp_on_update' at row 1
[2015-10-10 10:34:00][app][ERROR    ] CDbCommand::execute() failed: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'timestamp_on_update' at row 1. The SQL statement executed was: INSERT INTO `df_sys_schema_extras` (`timestamp_on_update`, `validation`, `table`, `field`, `service_id`) VALUES (:timestamp_on_update, :validation, :table, :field, :service_id). Bound with :timestamp_on_update=false, :validation='{"api_read_only":{"on_fail":"ignore_field"}}', :table='df_sys_config', :field='created_date', :service_id=NULL.
[2015-10-10 10:34:00][app][DEBUG    ] System administrator required.
[2015-10-10 10:34:25][app][DEBUG    ] System administrator required.
[2015-10-10 10:34:26][app][DEBUG    ] Database data (default services) required.
[2015-10-10 10:34:29][app][DEBUG    ] Database data (default services) required.

#2

Are you having this same issue in DreamFactory 2.0 or is this an issue only on legacy versions?