Jump to content

Problems Restoring DB

bugster

By bugster
in Using WHMCS

 Share

Recommended Posts

bugster Member

bugster

Posted
Posted

Hello,

I'm trying to move the whmcs db to a different server. I do a backup using whmcs and then try importing it using the mysql command. I keep getting an error:

ERROR 1292 <22007> at line 8764: Incorrect date value: ' ' for column 'duedate' at row 1

 

My backup file is over 11mb so finding the problem is a little tricky and I've searched for 'duedate' in the file and can't even find a mention of it.

 

Any help would be appreciated. I'm just glad I found the problem now and not when I needed to restore from a crash. I'm using ver 3.6.2

 

Thanks,

Brian

0
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated

  I accept