Table '...#__history' doesn't exist /Update from 3.10.9 to 3.10.10

[nicedive4u]

Hi,

I need help, it is worse!

I have two websites with Joomla 3.10.9 running and did to today the update to 3.10.10.
Unfortunetly my backup from yesterday was wrong, only saved the DB, but not the Home files.

So after the update Joomla showed on BOTH sides not any png or jpg pictures anymore?! Couldn't find any mistake.

So I restore my DB from yesterday from the 3.10.9 and Update the Package 3.x to 3.10.9 to Joomla.
And now my one site is showing the main site but no content anymore.
https://www.nicedive4u.de

Joomla shows me in the database area: Table 'web22_db5.#__history' doesn't exist

And below it shows:

The database schema version (3.10.7-2022-03-18) does not match the CMS version (4.1.3-2022-04-08).
Table 't01u8_contact_details' has wrong type or attributes for column 'xreference' with type varchar(50). (From file: "3.7.0-2017-02-17.sql".)
Table 't01u8_content' has wrong type or attributes for column 'xreference' with type varchar(50). (From file: "3.7.0-2017-03-03.sql".)
Table 't01u8_newsfeeds' has wrong type or attributes for column 'xreference' with type varchar(50). (From file: "3.7.0-2017-03-03.sql".)
Table 't01u8_menu' has wrong type or attributes for column 'checked_out_time' with type datetime. (From file: "3.7.3-2017-06-03.sql".)
Table 't01u8_ucm_content' has wrong type or attributes for column 'core_publish_up' with type datetime. (From file: "4.0.0-2018-08-29.sql".)
Table 't01u8_ucm_content' has wrong type or attributes for column 'core_publish_down' with type datetime. (From file: "4.0.0-2018-08-29.sql".)
Table 't01u8_ucm_content' has wrong type or attributes for column 'core_checked_out_time' with type datetime. (From file: "4.0.0-2018-08-29.sql".)
Table 't01u8_history' has wrong type or attributes for column 'item_id' with type VARCHAR(50). (From file: "4.0.0-2020-05-29.sql".)
The 't01u8_history' table should not have the 'ucm_type_id' column. (From file: "4.0.0-2020-05-29.sql".)
Table 't01u8_history' has wrong type or attributes for column 'save_date' with type datetime. (From file: "4.0.0-2020-05-29.sql".)
Table 't01u8_workflows' has wrong type or attributes for column 'checked_out' with type int unsigned. (From file: "4.0.0-2020-05-29.sql".)
Table 't01u8_workflow_stages' has wrong type or attributes for column 'checked_out' with type int unsigned. (From file: "4.0.0-2020-05-29.sql".)
Table 't01u8_workflow_transitions' has wrong type or attributes for column 'checked_out' with type int unsigned. (From file: "4.0.0-2020-05-29.sql".)
Table 't01u8_fields' has wrong type or attributes for column 'checked_out' with type int unsigned. (From file: "4.0.0-2020-05-29.sql".)
Table 't01u8_fields_groups' has wrong type or attributes for column 'checked_out' with type int unsigned. (From file: "4.0.0-2020-05-29.sql".)
Column 'only_use_in_subform' is not included in table 't01u8_fields'. (From file: "4.0.0-2021-04-22.sql".)
Column 'extension' is not in table 't01u8_mail_templates'. (From file: "4.0.0-2021-04-22.sql".)
Index 'idx_level' is not included in table 't01u8_finder_taxonomy'. (From file: "4.0.0-2021-05-30.sql".)
The table 't01u8_scheduler_tasks' does not exist. (From file: "4.1.0-2021-11-20.sql".)
Index 'idx_link_modified' is not included in table 't01u8_redirect_links'. (From file: "4.1.0-2022-01-24.sql".)
Index 'idx_link_modified' is not included in table 't01u8_redirect_links'. (From file: "4.1.0-2022-01-24.sql".)

It was so much work because the site is in german and english.

Please help me.

[nicedive4u]

So I restore my DB from yesterday from the 3.10.9 and Update the Package 3.x to 3.10.9 to Joomla.
And now my one site is showing the main site but no content anymore.
https://www.nicedive4u.de

When I restore my DB from yesterday, I see again content, but when I press the DB fix button in Joomla it destroys it and there is no content anymore.

I made a fresh new installation from Joomla 3.10.9.
I export the above last working DB from my backup.
I import this DB in the fresh installation on a fresh DB.
This DB works perfect, I tested it with using it for my old broken installation.
So now which of the files in Joomla I have to copy/overwrite from my fresh installation to my broken system to have again a good running system?

In my broken system I can not administrate any modules, articles, configuration etc.

Thanks

[gws]

Install Akeeba and make a backup of the working site then use akeebas kickstart to populate your live site.
https://www.akeeba.com/documentation/ak ... ation.html

[Richard67]

So it seems that on your broken site you had tried to update to Joomla 4 in past, because the rename of the table "#__ucm_history" to just "#__history" happens when updating to Joomla 4, and the SQL update script file names like "4.0.0-2018-08-29.sql" and so on being reported by the database checker show that there are these update SQL scripts present, which also can only result from a previous attempt to update to Joomla 4.

But your error report does not tell anything about a previous attempt to update to Joomla 4, it only tells about update from 3.10.9 to 3.10.10.

You wrote something about having restored the database from a backup.

You should know 2 things:

1. Always restore a complete database backup into an empty database, i.e. delete all database tables before restoring the backup, otherwise especially after attempts to update to J4 you have a mix of old a new tables and data.

2. Files and database (structure and data) belong together. I.e. you should have a backup of the Joomla files and the database together, and restore both together.

The best way to do that is to use Akeeba kickstart for restoring the backup.