Live site install to localhost via Duplicator didn't install some tables

  • Resolved elchopin

    (@elchopin)


    8 years, 2 months ago

    Hi there,

    I’ve hit a brick wall with this & would greatly appreciate some help/guidance. I have recently tried to transfer my small live site (on DreamHost) to my localhost to continue working on it. I successfully installed WAMP and have phpmyadmin running fine. I used the Duplicator plugin to download the package & installer without issue. It seems to have the correct files and tables in the package. I created the database in phpmyadmin and at some point added a user with privileges.

    The trouble began after running through the installer phase on localhost/mydomain/installer.php. In step 2 the Duplicator seems not to have been creating all the required database tables. At stage 3 the Deploy error count was reading 268 (ish) and when clicking on permalinks I couldn’t login to the local install of WordPress.

    Eventually I got around this by adding a wp_user table which was absent, but then when viewing my site, all the pages and navigation bars are missing. From what I can tell there are suppose to be 11 default tables in the database, I am missing 3 still – wp_comments, wp_links & wp_posts hence why no pages will load… These three tables are definitely not in the phpmyadmin database. Step two of the duplicator seems to have not extracted them??

    Anyways, I am at a loss as to how to proceed to load these three tables individually from the package. Any help or suggestions would be appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter elchopin

    (@elchopin)

    8 years, 2 months ago

    The installer log is getting these errors relating to the tables not being created during the duplicator installer process –

    DATABASE RESULTS
    ————————————–
    **ERROR** database error write ‘Invalid default value for ‘comment_date” – [sql=
    CREATE TABLE wp_993px5_comments (
    comment_ID bigint(20) unsigned NOT…]
    **ERROR** database error write ‘Invalid default value for ‘created” – [sql=
    CREATE TABLE wp_993px5_duplicator_packages (
    id bigint(20) unsigned …]
    **ERROR** database error write ‘Invalid default value for ‘link_updated” – [sql=
    CREATE TABLE wp_993px5_links (
    link_id bigint(20) unsigned NOT NULL …]
    **ERROR** database error write ‘Invalid default value for ‘post_date” – [sql=
    CREATE TABLE wp_993px5_posts (
    ID bigint(20) unsigned NOT NULL AUTO_…]
    **ERROR** database error write ‘Invalid default value for ‘user_registered” – [sql=
    CREATE TABLE wp_993px5_users (
    ID bigint(20) unsigned NOT NULL AUTO_…]
    **ERROR** database error write ‘Table ‘database.wp_993px5_comments’ doesn’t exist’ – [sql=

    Any body seen this before? Any ideas what the problem is & what the solution could be?

    Thread Starter elchopin

    (@elchopin)

    8 years, 2 months ago

    Nevermind, I solved this.

    For some reason WordPress or the duplicator package was putting default time values of 0000-00-00 00:00:00 which the SQL didn’t like when creating the tables for the phpmyadmin database therefore it didn’t create tables with 0000-00-00 00:00:00 dates in it.

    Solution, I ended up manually importing the .zip file into phpmyadmin and copied across the 4 tables to the database that the duplicator created that were missing. When copying them across I encountered the SQL errors, telling you what was wrong – that it was that the ‘default dates’ i.e. 0000-00-00 00:00:00 were invalid. I then edited the dates or deleted the draft posts in the wp_post table that had that date & the tables were created and the data copied across. So that seems to have fixed things after checking the user data & saving permalinks. AM GLAD THAT’S OVER!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Live site install to localhost via Duplicator didn't install some tables’ is closed to new replies.