The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

BUG: timestamp value must be quoted (4 posts)

  1. Gregory Karpinsky (@tivnet)
    Posted 3 years 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'


  2. fwchapman
    Posted 3 years 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
    Posted 3 years ago #


    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
    Posted 3 years ago #


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


Topic Closed

This topic has been closed to new replies.

About this Plugin

  • BackUpWordPress
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic