Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Florida
    Posts
    62

    Error Message At DB Restore...

    I received the following error message when I performed a db restore this evening. I had to modify and manually run the query to add this table. Running SS 4.1.7.

    -----------

    Database Error In SunShop 4.0: Invalid SQL: CREATE TABLE ss_users_saved_carts ( `id` int(10) auto_increment, `sessid` varchar(40), `userid` int(10), `cart` longtext, `stamp` timestamp DEFAULT 'CURRENT_TIMESTAMP', PRIMARY KEY (id), KEY userid (userid) )

    MySQL Error: Invalid default value for 'stamp'

    MySQL Error Number: 1067

    Date: Thursday 08th 2009f January 2009 01:36:12 AM

    Script: /***/adminindex.php?action=settings⊂=restore&do=restore

    Referer: http://www.lighterfly.com/***/admini...#8834;=restore

    ------------

    I changed:
    DEFAULT 'CURRENT_TIMESTAMP'

    to:
    DEFAULT CURRENT_TIMESTAMP

    and it worked fine. I'm currently hosting with HostRocket. Here are some MySQL version details that might help you put a fix into future SS versions.

    version 5.0.67-community-log
    version comment MySQL Community Edition (GPL)
    version compile machine x86_64
    version compile os redhat-linux-gnu
    Vic DeVore
    Zippo Lighters

  2. #2
    Join Date
    Aug 2006
    Location
    San Diego, CA
    Posts
    4,333
    Your issue is your MySQL version and the statement "DEFAULT 'CURRENT_TIMESTAMP". Remove that and it should fix the import.

  3. #3
    Join Date
    Aug 2006
    Location
    San Diego, CA
    Posts
    4,333
    Didn't realize you found the solution to but yeah, you can remove it or change it.

Similar Threads

  1. Pop Up Error Message
    By microdaq in forum Troubleshooting and Problems
    Replies: 1
    Last Post: 05-31-2011, 12:59 PM
  2. Paypal Error Message
    By kierang in forum Troubleshooting and Problems
    Replies: 1
    Last Post: 07-27-2009, 01:01 PM
  3. Database backup error message
    By Kraken in forum Troubleshooting and Problems
    Replies: 5
    Last Post: 01-15-2009, 03:25 PM
  4. Error message when selecting Register
    By JenniC in forum Troubleshooting and Problems
    Replies: 1
    Last Post: 01-04-2009, 08:13 PM
  5. Database Error message after upgrading to 1.7RC
    By Go2Networks in forum Troubleshooting and Problems
    Replies: 5
    Last Post: 12-03-2003, 05:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •