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

Need help upgrading your Joomla! website or converting to Joomla! 3.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Post Reply
nicedive4u
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sun Jul 03, 2022 4:06 pm

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

Post by nicedive4u » Sun Jul 03, 2022 4:17 pm

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sun Jul 03, 2022 4:06 pm

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

Post by nicedive4u » Mon Jul 04, 2022 8:55 am

nicedive4u wrote:
Sun Jul 03, 2022 4:17 pm
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
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4754
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK
Contact:

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

Post by gws » Mon Jul 04, 2022 9:01 am

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
Joomla! Explorer
Joomla! Explorer
Posts: 258
Joined: Fri Sep 16, 2011 6:13 pm
Location: Germany
Contact:

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

Post by Richard67 » Sat Jul 09, 2022 10:56 am

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.


Post Reply

Return to “Migrating and Upgrading to Joomla! 3.x”