Importing database error
-
Hello,
I want to import my WordPress site into Xampp for offline editing. However, when I want to import the sql file into my local database it generate the following errors:
Using Duplicator plugin doesn’t work as my host doesn’t allow it.
I have looked everywhere, but its pretty hard when not familiar any of the problems.
Anyone a clue?
Thanks!Error
Static analysis:23 errors were found during analysis.
Unexpected character. (near “:” at position 1335)
Unexpected character. (near “:” at position 1338)
Unexpected character. (near “:” at position 1404)
Unexpected character. (near “:” at position 1407)
Ending quote ‘ was expected. (near “” at position 1537)
A comma or a closing bracket was expected (near “0000” at position 1322)
Unexpected token. (near “-00” at position 1326)
Unexpected token. (near “-00” at position 1329)
Unexpected token. (near “00” at position 1333)
Unexpected token. (near “:” at position 1335)
Unexpected token. (near “00” at position 1336)
Unexpected token. (near “:” at position 1338)
Unexpected token. (near “00” at position 1339)
Unexpected token. (near “‘,es_sent_endtimedatetime NOT NULL DEFAULT ‘” at position 1341)
Unexpected token. (near “0000” at position 1391)
Unexpected token. (near “-00” at position 1395)
Unexpected token. (near “-00” at position 1398)
Unexpected token. (near “00” at position 1402)
Unexpected token. (near “:” at position 1404)
Unexpected token. (near “00” at position 1405)
Unexpected token. (near “:” at position 1407)
Unexpected token. (near “00” at position 1408)
Unexpected token. (near “‘,es_sent_countint(10) unsigned NOT NULL,es_sent_previewtext ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8″ at position 1410)
SQL query:INSERT INTO
wp_es_pluginconfig(es_c_id,es_c_fromname,es_c_fromemail,es_c_mailtype,es_c_adminmailoption,es_c_adminemail,es_c_adminmailsubject,es_c_adminmailcontant,es_c_usermailoption,es_c_usermailsubject,es_c_usermailcontant,es_c_optinoption,es_c_optinsubject,es_c_optincontent,es_c_optinlink,es_c_unsublink,es_c_unsubtext,es_c_unsubhtml,es_c_subhtml,es_c_message1,es_c_message2) VALUES (1, ‘Travelaar.nl’, ‘<<email adress>>’, ‘WP HTML MAIL’, ‘YES’, ‘<<email adress>>’, ‘ New email subscription’, ‘Hi Admin, \r\n\r\nWe have received a request to subscribe new email address to receive emails from our website. \r\n\r\nEmail: ###EMAIL### \r\nName : ###NAME### \r\n\r\nThank You\r\n’, ‘YES’, ‘ Welkom bij travelaar.nl!’, ‘Hallo ###NAME###!\r\n\r\nVanaf nu zal je de nieuwsbrief van travelaar.nl in je inbox krijgen..\r\n\r\nBedankt en tot snel!’, ‘Double Opt In’, ‘ Bevestig je email..’, ‘Hallo ###NAME###! \r\n\r\nVia onderstaande link kun je je emailadres bevestigen.\r\n\r\n<a href=\\” CREATE TABLE IF NOT EXISTSwp_es_sentdetails(es_sent_idint(10) unsigned NOT NULL,es_sent_guidvarchar(255) NOT NULL,es_sent_qstringvarchar(255) NOT NULL,es_sent_sourcevarchar(255) NOT NULL,es_sent_starttimedatetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,es_sent_endtimedatetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,es_sent_countint(10) unsigned NOT NULL,es_sent_previewtext ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8MySQL said: Documentation
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘0000-00-00 00:00:00’,
es_sent_endtimedatetime NOT NULL DEFAULT ‘0000-00-00 ‘ at line 2
The topic ‘Importing database error’ is closed to new replies.