Author Topic: problem with import database  (Read 1151 times)

jeamesl

  • Newbie
  • *
  • Posts: 1
    • View Profile
    • Email
problem with import database
« on: October 02, 2016, 06:46:42 PM »
hi
I have install new feng office xlykyon step 4 find error.

Step 4: Finish
Installation process:
Database connection has been established successfully
InnoDB storage engine is supported
Failed to import database construction. MySQL said: Invalid default value for 'archived_on'

Please someone can help solve this problem

Thank you very much!

eliewaked

  • Newbie
  • *
  • Posts: 2
    • View Profile
    • Email
Re: problem with import database
« Reply #1 on: January 02, 2017, 06:53:01 PM »
well I m facing the same issue installing the package on local server with Mysql57 php56 and phpMyAdmin

I have made the setup several time on fresh server and getting the same error,

hope getting the solution fast
thanks

eliewaked

  • Newbie
  • *
  • Posts: 2
    • View Profile
    • Email
Re: problem with import database
« Reply #2 on: January 05, 2017, 05:31:12 PM »
SOLVED

go to phpmyadmin, SQL and set the following

set global innodb_large_prefix=on;
set global innodb_file_format=barracuda;
set global innodb_file_per_table=true;
set global sql_mode=NO_ENGINE_SUBSTITUTION;
set global sql_mode=NO_ZERO_IN_DATE;
set global sql_mode=ERROR_FOR_DIVISION_BY_ZERO;
set global sql_mode=NO_AUTO_CREATE_USER;

done