• Resolved peter achutha

    (@peter-achutha)


    My WordPress blog was abandoned before covid-19, before 2020, era as many people were copying my blog and claiming that they invented the idea. Now I am trying to reinstall the website and updated some of the tables in the database with older tables. I had used WP 5.7 then and now I keep getting errors in the PHP error log.

    [14-Jul-2025 11:25:00 UTC] WordPress database error Table ‘drpeters_wp498.wpo2_term_taxonomy’ doesn’t exist for query SELECT t.term_id FROM wpo2_terms AS t INNER JOIN wpo2_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘wp_theme’) AND t.name IN (‘twentytwentyfive’)

    What do I do now?

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator bcworkz

    (@bcworkz)

    A table doesn’t exist error is more than a version mismatch. Find out what your actual table name prefix is via the phpMyAdmin app. Ensure the same is assigned in your wp-config.php file. Ensure the DB user has adequate privileges to read, update, alter, etc. for all of the tables.

    I’m not sure what you did to get to this point, but if you need to start over for any reason, assuming you still have unmolested DB backups from v5.7, do the following:

    Install the DB tables from backup if they are not already in place. Move your /themes/ and /plugins/ directory contents to a safe place, leaving the directories empty. Download and install version 5.7. Install using the same procedure as for a manual update. Only install the themes that came with the download package . Verify the site works normally, even if it doesn’t look right due to a different theme and no plugins being used. You may need to revert your server’s PHP version to the earliest available. If you get deprecation warnings, that’s OK. Hopefully there are no fatal errors because of a PHP version more recent than 5.7 is.

    Once you have a working v5.7 site, use the Update WordPress button on the updates screen. WordPress will then properly update your DB tables along with updating all of the core files.

    Thread Starter peter achutha

    (@peter-achutha)

    Thanks bcworkz (@bcworkz).

    I am trying that out now. I have deleted my blog and changed it to WP 5.7 several times. This is because it lost my password and now, ever since I installed email by SMTP, it does not allow me to access /wp-admin webpage. I am still trying.

    Thread Starter peter achutha

    (@peter-achutha)

    Thanks I have got it to work without errors.

    What is this requirement of 2 step authentication? I dislike the 2 step authentication and found, a few years ago, that Chrome allows hackers to get in but Firefox blocks them by asking for a new password. I had reported this to Google and they had fixed Chrome. Eventually, many hackers will break the 2 step authentication. The banks in Malaysia are insisting on 2 step authentication even though you do not have a computer and just a phone. That is terrible and worst is that 2 step authentication gives you a false sense of security. Nothing like long passwords that take millions of years to break.

    Moderator bcworkz

    (@bcworkz)

    I’m glad it’s all working! FWIW, there are numerous ways to reset your password without needing to fuss with versions. In some cases, you don’t need WP at all, but access to phpMyAdmin and your hosting account. It’s also possible to disable malfunctioning plugins without back end access. Hopefully there’s no next time where this info would be useful.

    I’m pretty sure no one likes 2FA 😉 IMO it came about because some people are incapable of using secure passwords or phrases. Sadly, it is somewhat more security theater than real protection, but it is better than weak passwords alone. AFAIK 2FA in wp.org is optional. Additionally, there are a couple different 2FA options that are at least better than the customary code via SMS. All managed in the security tab of your wp.org profile.

    Thread Starter peter achutha

    (@peter-achutha)

    Hi bcworkz,

    Thanks for your response.

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

The topic ‘Upgrading WP 6.8 using old tables’ is closed to new replies.