You have an error in your SQL syntax

  • This is NOT a error with BackWPup itself but an error that it causes when activating other plugins. That’s what I’ve seen reported by others online.

    What happens when you activate ANOTHER plugin is that it actually activates but this error is first reported:

    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 ‘TYPE=MyISAM’ at line 9 on line: 1471

    Then you have to click back arrow a couple of times on your browser to get back to a place on your dashboard to continue working. The plugin you activated works, but this error is always there and apparently caused by BackWPup. Why? What’s the solution? Thanks!

    https://www.ads-software.com/plugins/backwpup/

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

  • Hello,

    see the first answer of https://stackoverflow.com/questions/12428755/1064-error-in-create-table-type-myisam .

    This happends if you backup an older mysql version and you will restore it on a newer one.
    You can resolve it by editing the .sql file and replace TYPE=MyISAM by ENGINE=MyISAM .

    Thread Starter karunaray

    (@karunaray)

    Thanks. I’m not a database person at all, so just to make sure I understand… I’ve used the plugin to make backups but have ONLY saved those files to my computer. I’ve never actually used any backups from this plugin to reboot/restore my blog or upload any backup files to the server.

    Are you saying this only happens if you use a backup made with the plugin from an older version of MySQL is used on a newer version of MySQL?

    Or it happens because my host upgraded MySQL (I believe) and it doesn’t matter if a backup made by the plugin was used or not?

    I can ask my host to edit the .sql file but I’d like to approach them with clear information Thanks again.

    Hello,
    that is not a problem of BackWPup! BAckWPup will only use the informations the MYSQL server will provide. You have the same Problem if you do database backups with PHPMyAdmin or the mysqldump command.

    That happends because your hoster use an older MySQL Version is think version 4.x and ther server where you would restore the sql file is a version 5.x.
    IF you use the same sql version on both you don’t have the Problem.

    The editing of the database.sql file can you do self.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘You have an error in your SQL syntax’ is closed to new replies.