• 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 EXISTS wp_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=utf8

    MySQL 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

Viewing 2 replies - 1 through 2 (of 2 total)
  • So I see that you’re importing it into MariaDB… what database server was it exported from? Oracle, MySQL, MSSql, all have slightly different syntaxes here and there which could be causing an issue.

    Thread Starter travelaar

    (@travelaar)

    The server it was downloaded from uses MySQL. Xampp comes with MariaDB.
    I didn’t know what the difference was, but is it an idea to try and install xampp with MySQL?

    <edit>

    In Xampp, the modules “Apache” and “MySQL” are running.
    Where do I specify where to upload the database to?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Importing database error’ is closed to new replies.