Hi Cory,
I am not using PHP mode or mysqldump. I followed the instructions from the video tutorials in the Duplication website.
But I did some more sleuthing and found the following error messages in the installer-log.txt that point to invalid values for dates and also NULL values for dates. So some of the main tables like 041_users and 041_posts are not created because of these errors. Here is the section of the installer-log.text with these errors.
Any idea what for example this error is referring to:
**ERROR** database error write ‘Invalid default value for ‘created”
thank you
-Malena
DATABASE ENVIRONMENT
————————————–
MYSQL VERSION: This Server: 5.7.15 — Build Server: 5.6.32
FILE SIZE: database.sql (6.23MB) – installer-data.sql (6.23MB)
TIMEOUT: 5000
MAXPACK: 4194304
SQLMODE: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
NEW SQL FILE: [/Users/malena/Sites/stellarpeers/installer-data.sql]
————————————–
DATABASE RESULTS
————————————–
**ERROR** database error write ‘Invalid default value for ‘comment_date” – [sql=
CREATE TABLE 041_comments (
comment_ID bigint(20) unsigned NOT NULL …]
**ERROR** database error write ‘Invalid default value for ‘created” – [sql=
CREATE TABLE 041_duplicator_packages (
id bigint(20) unsigned NOT NU…]
**ERROR** database error write ‘Invalid default value for ‘link_updated” – [sql=
CREATE TABLE 041_links (
link_id bigint(20) unsigned NOT NULL AUTO_I…]
**ERROR** database error write ‘Invalid default value for ‘timestamp” – [sql=
CREATE TABLE 041_pmpro_membership_orders (
id int(11) unsigned NOT N…]
**ERROR** database error write ‘Invalid default value for ‘post_date” – [sql=
CREATE TABLE 041_posts (
ID bigint(20) unsigned NOT NULL AUTO_INCREM…]
**ERROR** database error write ‘Invalid default value for ‘upload_date” – [sql=
CREATE TABLE 041_rt_rtm_media (
id bigint(20) NOT NULL AUTO_INCREMEN…]
**ERROR** database error write ‘Invalid default value for ‘registered” – [sql=
CREATE TABLE 041_signups (
signup_id bigint(20) NOT NULL AUTO_INCREM…]
**ERROR** database error write ‘Invalid default value for ‘member_since” – [sql=
CREATE TABLE 041_swpm_members_tbl (
member_id int(12) NOT NULL AUTO_…]
**ERROR** database error write ‘Invalid default value for ‘txn_date” – [sql=
CREATE TABLE 041_swpm_payments_tbl (
id int(12) NOT NULL AUTO_INCREM…]
**ERROR** database error write ‘Invalid default value for ‘created” – [sql=
CREATE TABLE 041_teambooking_promotions (
id int(11) NOT NULL AUTO_I…]
**ERROR** database error write ‘Invalid default value for ‘created” – [sql=
CREATE TABLE 041_teambooking_reservations (
id int(11) NOT NULL AUTO…]
**ERROR** database error write ‘Invalid default value for ‘date” – [sql=
CREATE TABLE 041_tg_item_elements (
id mediumint(9) NOT NULL AUTO_IN…]
**ERROR** database error write ‘Invalid default value for ‘date” – [sql=
CREATE TABLE 041_tg_item_skins (
id mediumint(9) NOT NULL AUTO_INCRE…]
**ERROR** database error write ‘Invalid default value for ‘user_registered” – [sql=
CREATE TABLE 041_users (
ID bigint(20) unsigned NOT NULL AUTO_INCREM…]
**ERROR** database error write ‘Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘date_notified’ at row 1′ – [sql=
/* INSERT TABLE DATA: 041_bp_notifications */
INSERT INTO `041_bp_notifica…]
**ERROR** database error write ‘Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘date_notified’ at row 1′ – [sql=INSERT INTO 041_bp_notifications VALUES(“2”, “3”, “8172”, “-1”, “social_a…]
**ERROR** database error write ‘Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘date_notified’ at row 1′ – [sql=INSERT INTO 041_bp_notifications VALUES(“3”, “3”, “8177”, “-1”, “social_a…]
**ERROR** database error write ‘Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘date_notified’ at row 1′ – [sql=INSERT INTO 041_bp_notifications VALUES(“4”, “3”, “8206”, “-1”, “social_a…]
**ERROR** database error write ‘Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘date_notified’ at row 1′ – [sql=INSERT INTO 041_bp_notifications VALUES(“5”, “3”, “8240”, “-1”, “social_a…]
**ERROR** database error write ‘Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘date_notified’ at row 1′ – [sql=INSERT INTO 041_bp_notifications VALUES(“6”, “3”, “8251”, “-1”, “social_a…]
**ERROR** database error write ‘Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘date_notified’ at row 1′ – [sql=INSERT INTO 041_bp_notifications VALUES(“7”, “3”, “8271”, “-1”, “social_a…]
**ERROR** database error write ‘Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘date_notified’ at row 1′ – [sql=INSERT INTO 041_bp_notifications VALUES(“8”, “3”, “8281”, “-1”, “social_a…]
