Title: error 1048 when importing .sql1 file
Last modified: October 13, 2016

---

# error 1048 when importing .sql1 file

 *  [iep](https://wordpress.org/support/users/iep/)
 * (@iep)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/error-1048-when-importing-sql1-file/)
 * 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/&#8217](http://xxx.com/&#8217);, 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](https://gravatar.com).’,‘
   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](https://wordpress.org/support/users/iep/).

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

 *  [fredcbl](https://wordpress.org/support/users/fredcbl/)
 * (@fredcbl)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/error-1048-when-importing-sql1-file/#post-8323522)
 * 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](http://www.php.net/manual/en/mysqli.constants.php)
 * look into the file backup-scheduler.php : $wpdb->get_col_info(‘type’, $ii) ==“
   string”
 *  [fredcbl](https://wordpress.org/support/users/fredcbl/)
 * (@fredcbl)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/error-1048-when-importing-sql1-file/#post-8323592)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/backup-scheduler_f8f7f7.svg)
 * [Backup Scheduler](https://wordpress.org/plugins/backup-scheduler/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/backup-scheduler/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/backup-scheduler/)
 * [Active Topics](https://wordpress.org/support/plugin/backup-scheduler/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/backup-scheduler/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/backup-scheduler/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [fredcbl](https://wordpress.org/support/users/fredcbl/)
 * Last activity: [9 years, 7 months ago](https://wordpress.org/support/topic/error-1048-when-importing-sql1-file/#post-8323592)
 * Status: not resolved