• Hi
    I am moving servers and trying to import a database on to the new server.
    I am getting an sql error :

    #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 ''s:1617:"a:48:{s:20:"enable-post-excerpts"' at line 22

    I open the sql file and this is the syntax currently (this is line 3423 though)

    (14683, 'bnc_iphone_pages', 's:1617:"a:48:{s:20:"enable-post-excerpts";i:1;s:27:"enable-twenty-eleven-footer";i:0;s:16:"enable-page-coms";i:0;s:11:"enable-zoom";i:0;s:18:"enable-cats-button";i:1;s:18:"enable-tags-button";i:0;s:20:"enable-search-button";i:1;s:19:"enable-login-button";i:0;s:22:"enable-gigpress-button";i:0;s:16:"enable-flat-icon";i:1;s:16:"enable-gravatars";i:0;s:16:"enable-main-home";i:1;s:15:"enable-main-rss";i:1;s:17:"enable-main-email";i:1;s:23:"enable-truncated-titles";i:1;s:16:"enable-main-name";i:0;s:16:"enable-main-tags";i:0;s:22:"enable-main-categories";i:0;s:9:"prowl-api";s:0:"";s:28:"enable-prowl-comments-button";i:0;s:25:"enable-prowl-users-button";i:0;s:27:"enable-prowl-message-button";i:0;s:9:"home-page";s:7:"Default";s:10:"statistics";s:0:"";s:10:"sort-order";s:4:"name";s:22:"enable-regular-default";i:0;s:20:"enable-show-comments";i:0;s:18:"enable-show-tweets";i:0;s:19:"enable-fixed-header";i:0;s:18:"custom-user-agents";a:0:{}s:16:"excluded-cat-ids";s:0:"";s:16:"excluded-tag-ids";s:0:"";s:10:"adsense-id";s:0:"";s:15:"adsense-channel";s:0:"";s:14:"post-cal-thumb";s:15:"post-thumbnails";s:7:"h2-font";s:14:"Helvetica Neue";s:18:"style-text-justify";s:14:"left-justified";s:16:"style-background";s:18:"classic-wptouch-bg";s:16:"enable-exclusive";i:0;s:16:"wptouch-language";s:4:"auto";s:10:"ad_service";s:7:"adsense";s:10:"main_title";s:11:"Default.png";s:12:"header-title";s:10:"GTO London";s:17:"custom-footer-msg";s:32:"All content Copyright GTO London";s:23:"header-background-color";s:6:"000000";s:19:"header-border-color";s:6:"333333";s:17:"header-text-color";s:6:"eeeeee";s:10:"link-color";s:6:"006bb3";}";', 'yes'),

    Thanks for help in advance!

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘sql database error’ is closed to new replies.