SQL error?! Completely baffled. Won't upload

  • Samnorth88

    (@samnorth88)


    10 years, 7 months ago

    I’ve uploaded a few sites an never had a problem.

    Then today I tried to upload a site… And I’ve got this? No idea how to fix it?! Can anybody help?

    Much appreciated

    SQL query: Documentation

    INSERT INTO wp_options (option_id, option_name, option_value, autoload) VALUES (147, ‘woo_custom_template’, ‘a:5:{i:0;a:4:{s:4:”name”;s:14:”_timthumb-info”;s:5:”label”;s:5:”Image”;s:4:”type”;s:4:”info”;s:4:”desc”;s:149:”TimThumb is disabled. Use the Featured Image panel in the sidebar instead, or enable TimThumb in the options panel.”;}i:1;a:5:{s:4:”name”;s:5:”embed”;s:3:”std”;s:0:””;s:5:”label”;s:10:”Embed Code”;s:4:”type”;s:8:”textarea”;s:4:”desc”;s:69:”Enter the video embed code for your video (YouTube, Vimeo or similar)”;}i:2;a:6:{s:4:”name”;s:7:”_layout”;s:3:”std”;s:6:”normal”;s:5:”label”;s:6:”Layout”;s:4:”type”;s:6:”images”;s:4:”desc”;s:54:”Select the layout you want on this specific post/page.”;s:7:”options”;a:4:{s:14:”layout-default”;s:79:”http://localhost:8888/wp-content/themes/peddlar/functions/images/layout-off.png”;s:11:”layout-full”;s:71:”http://localhost:8888/wp-content/themes/peddlar/functions/images/1c.png”;s:19:”layout-left-[…]

    MySQL said: Documentation

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘?’ at line 6

Viewing 1 replies (of 1 total)
  • Thread Starter Samnorth88

    (@samnorth88)

    10 years, 7 months ago

    UPDATE:

    I changed the compression from g-zipped to zipped And that seemed to temporarily solve the problem with no issues uploading the SQL and no errors appearing.

    However now the only page that works is the homepage

    Any other pages return:

    404 Error File Not Found

    The page you are looking for might have been removed,
    had its name changed, or is temporarily unavailable.

    I thought I’d try to use SQL to change any broken URLS

    But… to no avail.

    Completley bizzare? Even when I create a new page…. It still returns that error. Why can’t it see any other page than the home page?

Viewing 1 replies (of 1 total)

The topic ‘SQL error?! Completely baffled. Won't upload’ is closed to new replies.

Tags