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_endtime
datetime 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_count
int(10) unsigned NOT NULL,es_sent_preview
text ) 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_id
int(10) unsigned NOT NULL,es_sent_guid
varchar(255) NOT NULL,es_sent_qstring
varchar(255) NOT NULL,es_sent_source
varchar(255) NOT NULL,es_sent_starttime
datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,es_sent_endtime
datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,es_sent_count
int(10) unsigned NOT NULL,es_sent_preview
text ) 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_endtime
datetime NOT NULL DEFAULT ‘0000-00-00 ‘ at line 2
- The topic ‘Importing database error’ is closed to new replies.