mysql error 1153 google sitemaps plugin

  • asamuels

    (@asamuels)


    18 years, 5 months ago

    I am currently moving servers and have created a database backup of my current mysql database.

    When I come to import it on the new server I get the following error:

    #1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

    I have found the offending database entry in the myphpadmin in the wp-options table at line 92.

    The “option name” is sm_log, which i assume is something to do with the google sitemaps plugin?

    I have disabled the google sitemaps plugin as I no longer want to use it and even upgraded it to latest version for 2.3.

    So my question is can I drop this table will it screw up the blog?

    Also if you no longer use a plugin, how do you get rid of all the table entries that related to the plugin?

    Thanks in advance

Viewing 1 replies (of 1 total)
  • MichaelH

    (@michaelh)

    18 years, 5 months ago

    You can’t drop the ‘wp_options’ table.

    You might delete that particular record though.

    Of course, if you follow WordPress Backups, you have a current copy of your database so if something bad were to happen you would have a fallback position.

    Table entries in wp_options for unused plugins need to be manually delete unless the good author does that for you as part of the deactivation process.

Viewing 1 replies (of 1 total)

The topic ‘mysql error 1153 google sitemaps plugin’ is closed to new replies.

Tags