The dreaded [ERROR] TABLE IS CORRUPTED

  • Resolved harvoolio

    (@harvoolio)


    10 years, 11 months ago

    Tobias,

    I saw the dreaded [ERROR] TABLE IS CORRUPTED (JSON_ERROR_NONE)! DO NOT EDIT THIS TABLE NOW! Instead, please see https://tablepress.org/faq/corrupted-tables/ for instructions.

    Fortunately, I store all the data elsewhere on an XLS file and import it into the table.

    So, in troubleshooting, I tried creating a brand new table and importing my XLS file, but to no avail. So, I disabled all plugins but could still not import the XLS file. I then tried importing a CSV file and could do so with all plugins disabled and then re-enabled.

    So, I recreated a table with a different name, saved my XLS file as a CSV and then changed the shortcode in WordPress.

    The table still hangs, but presently saves. Could I have caused problems with Optimize Database after Deleting Revisions or WP-DBManager by deleting something I should not have while trying to optimize it?

    My website is still in development hosted on Flywheel so I will send you a collaborator password to your email address.

    Thanks as always,
    Michael

    https://wordpress.org/plugins/tablepress/

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    10 years, 11 months ago

    Hi Michael,

    thanks for your post, and sorry for the trouble.

    I have received your email with the extra information and account details and will take a look shortly!

    Regards,
    Tobias

    Ecovacs Robotics

    (@jmellin)

    10 years, 11 months ago

    I’m not trying to hi-jack harvoolio’s request for help but I have a similar problem. Just received the error:

    “Attention: The internal data of table “2” is corrupted!”

    It happens on my subdomains but main site is fine.
    I removed all double quotes but still have the error.
    Is that any info that can help or be diagnosed?

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    10 years, 11 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Just to be sure, can you please take a look at the ideas from http://tablepress.org/faq/corrupted-tables/ ?

    Regards,
    Tobias

    jmrtv

    (@jmrtv)

    10 years, 9 months ago

    sorry to jump in here but im new to posting here and didnt see any direct message option..
    TobiasBG,
    Hoping you can help.
    I creates a script to run a cron to update my table weekly. I am pretty sure (reviewed several times) that all of my [[“”,””],[“”,””]] formatting is correct when i run a mysql update but i am getting the ‘table is corrupted’ error. Can you help point me in what things to look for that trigger this error? Is there an entry in another table that I am missing? I cant see why it thinks that it is corrupted. HELP PLEASE

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    10 years, 9 months ago

    Hi jmrtv,

    thanks for your post, and sorry for the trouble.

    You will basically have to make sure that your created content is properly JSON-encoded.
    For example, all slashes / and quotation marks " have to be escaped with a backslash \.

    Regards,
    Tobias

    jmrtv

    (@jmrtv)

    10 years, 9 months ago

    it certainly seems to be. All slashes and quotes are escaped.
    would mysql_real_escape_string help or hurt in this case?
    do you have a direct email?

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    10 years, 9 months ago

    Hi,

    can you maybe pass your content through some JSON online validator? That might help in finding the cause. I’m not sure about mysql_real_escape_string(), but you will also have to take precautions to not accidentally escape things twice (which can e.g. happen if you use the WordPress API functions for updating the content in the database).

    My email is in the main plugin file of TablePress, but be warned that I might not be able to help as this is a custom modification of TablePress.

    Regards,
    Tobias

    jmrtv

    (@jmrtv)

    10 years, 9 months ago

    thanks. that helped to find the problem.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    10 years, 9 months ago

    Hi,

    great! That’s good to hear!

    Best wishes,
    Tobias

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

The topic ‘The dreaded [ERROR] TABLE IS CORRUPTED’ is closed to new replies.

Tags