• stangie924

    (@stangie924)


    Hi! I need help about the database problem in our WordPress website. I followed the instruction to repair it but some of the database could not be repaired.

    This is the following error:
    wp_prth_options: Number of rows changed from 467 to 466

    Thank you!

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    Without knowing the problem that was supposedly repaired, it’s difficult to speculate on how to fix this. I’m guessing there’s a mismatch between the next available ID and the number of records in your options table.

    If I’m right, here’s what to do to resolve this: Access the phpMyAdmin app, usually via your hosting account. Navigate to your WP database and its options table. Click on the option_id column heading until the IDs are listed in reverse order, largest to smallest. Note what the very largest ID is.

    Now go to the Operations tab. In the Table Options box, locate the AUTO_INCREMENT field and set it to one more than the largest option_id value you noted earlier. Then click the Go button for this same Table Options box to save the value.

    If I’m right, your database ought to now work correctly.

Viewing 1 replies (of 1 total)
  • The topic ‘Some database problems could not be repaired.’ is closed to new replies.