WordPress database error#1064

  • I am having some major database troubles. Trying to update changes I’ve made for saysyou.net from running out of a subdirectory to the main site.

    I have been following this tutorial for moving my site from a subdirectory to the main one (saysyou.net) as it is much more detailed than this guide. I have been able to do this process with my blog without a hitch before. But of course everything went wonky when I got to the part about changing the WordPress address URL from the subdir to saysyou.net which means something did not happen correctly.

    To explore the troubleshooting on this, I’ve loaded the backup of the site on my computer’s localhost, but when I try to import the database all I get is the 1064 syntax error. I have tried excluding tables from the export in phpMyAdmin, but it just says that each successive table has more syntax errors.
    Here’s what the syntax error looks like on my localhost.

    I have tried repairing the database using define(‘WP_ALLOW_REPAIR’, true); in the wp-config.php file, but it comes back that everything is fine, no repairs needed.

    The hosting platform is old school or something because the phpMyAdmin looks like it’s from the 90s or early 00s. Is there a possibility that the phpMyAdmin is exporting a database using old syntax?

    I seriously feel completely stuck, the site is down for now. If there is a way to restore the site back to the subdirectory just to get it working again so I can keep troubleshooting on my localhost — any help would be amazing. Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

  • Have you tried using phpMyAdmin on the production site and going in and looking at the wp-options table. There are two rows you are interested in – the first has the option name ‘siteurl’ and it should be one of the first rows. The second’s ‘option name’ is ‘home’ and is generally on page 2 of the options.

    siteurl equates to the general setting ‘WordPress Address (URL)’
    home equates to the general setting ‘SIte Address (URL)’

    so you could set them back to their original values and you should be able to get back in. So ‘siteurl’ will point to the subdirectory ‘saysyou.net/xxxxxxx’
    and ‘home’ will point at just the url ‘saysyou.net’

    BTY love the show – get the site back on line!

    Thread Starter LMMartens

    (@lmmartens)

    Yes, that is one of the first things I did, but I’m realizing now why that didn’t work the first time. I’ve got it back up in the subdirectory and will have things back to normal for the public by the morning. I’m glad you are a fan of the show. We’re going to be making a lot of great changes in the upcoming weeks, so keep a look out ??

    I’m still quite puzzled by this database error though as I want to be able to work out the site’s kinks on my localhost but can’t without the databases export/import happening properly. I’m going to contact our hosting support and see if there’s an issue there.

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