WordPress.org

Ready to get started?Download WordPress

Forums

BackUpWordPress
BUG: timestamp value must be quoted (4 posts)

  1. Gregory Karpinsky (@tivnet)
    Member
    Posted 1 year ago #

    CREATE TABLE mytable (
      date_updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    );
    INSERT INTO mytable VALUES (2013-04-19 23:11:42);

    Must be '2013-04-19 23:11:42'

    http://wordpress.org/extend/plugins/backupwordpress/

  2. fwchapman
    Member
    Posted 1 year ago #

    This bug has created a serious problem for me. Because DATETIME values in general are not quoted in database backups created by BackUpWordPress, I cannot import my database from a backup using phpMyAdmin. I get an error message that complains of bad syntax (i.e., missing delimiters).

    The MySQL database dumps I created using cPanel on my hosting account, the Duplicator plugin on my live site, and the DesktopServer Premium development environment on my local machine all enclose DATETIME values in delimiters. I've had no trouble importing my database when DATETIME values are quoted.

    Lack of delimiters around DATETIME values renders the database backup useless to me. I may now have to find a new backup plugin, which would be a shame, because I really like BackUpWordPress!

    Fred Chapman

  3. fwchapman
    Member
    Posted 1 year ago #

    CORRECTION

    I mistakenly assumed that datetime and timestamp values were treated the same way by this plugin, but that's not the case. I just double-checked a database backup which I created with this plugin, and datetime values are enclosed in quotes. It's timestamp values which are not enclosed in quotes, like the original post said.

  4. fwchapman
    Member
    Posted 1 year ago #

    WORKAROUND

    I developed a workaround for the unquoted timestamp problem and posted it here:

    http://wordpress.org/support/topic/workaround-importing-unquoted-timestamp-values

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic