error 1048 when importing .sql1 file

  • iep

    (@iep)


    9 years, 7 months ago

    When I try importing the sql1 file, I get a 1048 error:

    INSERT INTO phSI07qcT_2_comments VALUES(‘1’, ‘1’, ‘A WordPress Commenter’, ‘wapuu@wordpress.example’, ‘http://xxx.com/’, NULL, ‘2016-09-12 05:02:09’, ‘2016-09-12 05:02:09’, ‘Hi, this is a comment.
    To get started with moderating, editing, and deleting comments, please visit the Comments screen in the dashboard.
    Commenter avatars come from Gravatar.’, ‘0’, ‘1’, NULL, NULL, ‘0’, ‘0’)
    MySQL meldt: Documentatie

    #1048 – Column ‘comment_author_IP’ cannot be null

    • This topic was modified 9 years, 7 months ago by iep.
Viewing 2 replies - 1 through 2 (of 2 total)
  • fredcbl

    (@fredcbl)

    9 years, 7 months ago

    It seems that slbackup generates NULL for some types.
    In fact, it expects that get_col_info returns a string for type like ‘string’, ‘blob’, ‘datetime’ but with the mysqli driver it returns a constant like 252, 253… according to this page : http://www.php.net/manual/en/mysqli.constants.php

    look into the file backup-scheduler.php : $wpdb->get_col_info(‘type’, $ii) == “string”

    fredcbl

    (@fredcbl)

    9 years, 7 months ago

    sorry database.class.php not backup-scheduler.php

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘error 1048 when importing .sql1 file’ is closed to new replies.