No Code Attached Yet Information Required
avatar dsimonse
dsimonse
23 Oct 2023

Steps to reproduce the issue

Just upgraded to Joomla4.4.0 from 4.3.4 and the DB-version/DB-updateversion don't match the new version.screen shot 2023-10-23 at 04 21 13

Expected result

That the DB-tables should reflect the new version

Actual result

System information (as much as possible)

Additional comments

Votes

# of Users Experiencing Issue
1/1
Average Importance Score
4.00

avatar dsimonse dsimonse - open - 23 Oct 2023
avatar dsimonse dsimonse - change - 23 Oct 2023
Labels Removed: ?
avatar joomla-cms-bot joomla-cms-bot - change - 23 Oct 2023
Labels Added: No Code Attached Yet
avatar joomla-cms-bot joomla-cms-bot - labeled - 23 Oct 2023
avatar richard67
richard67 - comment - 23 Oct 2023

@dsimonse How did you perform the update? Have you used the Joomla Update component?

avatar richard67 richard67 - change - 23 Oct 2023
Labels Added: Information Required
avatar richard67 richard67 - labeled - 23 Oct 2023
avatar dsimonse
dsimonse - comment - 23 Oct 2023

Hi Richard,

I didn’t use the Joomla update-component since it was not working.

I installed ”Joomla_4.4.0-Stable-Full_Package.zip”

//Dennis

Från: Richard Fath
Skickat: den 23 oktober 2023 11:26
Till: joomla/joomla-cms @.>
Kopia: dsimonse @.
>; Mention @.***>
Ämne: Re: [joomla/joomla-cms] DB-tables not updated whem upgrading to 4.4.0 (Issue #42205)

@dsimonse https://github.com/dsimonse How did you perform the update? Have you used the Joomla Update component?


Reply to this email directly, view it on GitHub #42205 (comment) , or unsubscribe https://github.com/notifications/unsubscribe-auth/AEDPNYWBKFI3OOGXJ5D5SJLYAYZZ7AVCNFSM6AAAAAA6LX7NISVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONZUG44DANRXGI .
You are receiving this because you were mentioned. https://github.com/notifications/beacon/AEDPNYQKSCLL7W5GRYCDHMLYAYZZ7A5CNFSM6AAAAAA6LX7NISWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTTJZEAQA.gif Message ID: @.*** @.***> >

avatar richard67 richard67 - change - 23 Oct 2023
Status New Closed
Closed_Date 0000-00-00 00:00:00 2023-10-23 09:42:05
Closed_By richard67
avatar richard67 richard67 - close - 23 Oct 2023
avatar richard67
richard67 - comment - 23 Oct 2023

@dsimonse What means the Joomla Update component was not working? Do you have any error message or the update log "administrator/logs/joomla_update.php" from the trial with the update component?

And what means I installed ”Joomla_4.4.0-Stable-Full_Package.zip”? You've just unpacked that package? This package is only for new installations and not for updates, and unpacking a zip without using the Update Component will for sure not start the database updates to run.

All I know up to now looks to me as expected behaviour. You cannot update without using the Joomla Update component or Joomla CLI. For how to correctly update using the Joomla Update component see https://docs.joomla.org/J4.x:Updating_from_an_existing_version .

Closing as expected behaviour.

For the "Joomla Update component was not working" please open a new issue if it doews not work as described in the referred document, with details like e.g. the content of the "administrator/logs/joomla_update.php" file. Thanks in advance.

avatar richard67
richard67 - comment - 23 Oct 2023

P.S.: I hope you have made a backup before you made the update. If so, please revert to that backup and proceed the update as described in the doc linked in my previous comment. Otherwise, if you do not have a backup,m you have to run the SQL statements from the update SQL scripts administrator/components/com_admin/sql/updates/mysql/4.4.0-2023-05-08.sql and administrator/components/com_admin/sql/updates/mysql/4.4.0-2023-09-13.sql in phpMyAdmin, replacing the #__ in the statements by your actual database prefix (including the underscore).

avatar dsimonse
dsimonse - comment - 23 Oct 2023

Hi Richard,

I was to fast and installed the updatepackage (and had no backup) without you sql-scrips.

It corrected the DB-warnings, but do I have to run them anyway?

//Dennis

Från: Richard Fath
Skickat: den 23 oktober 2023 12:02
Till: joomla/joomla-cms @.>
Kopia: dsimonse @.
>; Mention @.***>
Ämne: Re: [joomla/joomla-cms] DB-tables not updated whem upgrading to 4.4.0 (Issue #42205)

P.S.: I hope you have made a backup before you made the update. If so, please revert to that backup and proceed the update as described in the doc linked in my previous comment. Otherwise, if you do not have a backup,m you have to run the SQL statements from the update SQL scripts administrator/components/com_admin/sql/updates/mysql/4.4.0-2023-05-08.sql and administrator/components/com_admin/sql/updates/mysql/4.4.0-2023-09-13.sql in phpMyAdmin, replacing the #__ in the statements by your actual database prefix (including the underscore).


Reply to this email directly, view it on GitHub #42205 (comment) , or unsubscribe https://github.com/notifications/unsubscribe-auth/AEDPNYWNS7LWFITID65EDVTYAY6ANAVCNFSM6AAAAAA6LX7NISVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONZUHA2DGNRYGE .
You are receiving this because you were mentioned.Message ID: @.***>

avatar richard67
richard67 - comment - 23 Oct 2023

It corrected the DB-warnings, but do I have to run them anyway?

@dsimonse Yes, you have to run the 2 SQL scripts like I said. Correcting the warnings with the fix button only fixes the versions mismatch but does not run any update SQL script. Personal note: No backup, no mercy ?

avatar dsimonse
dsimonse - comment - 23 Oct 2023

Hi Richard,

I did find the scripts in the folder but have no idea how to run them – please advice!

Regards
Dennis

Från: Richard Fath
Skickat: den 23 oktober 2023 12:23
Till: joomla/joomla-cms @.>
Kopia: dsimonse @.
>; Mention @.***>
Ämne: Re: [joomla/joomla-cms] DB-tables not updated whem upgrading to 4.4.0 (Issue #42205)

It corrected the DB-warnings, but do I have to run them anyway?

@dsimonse https://github.com/dsimonse Yes, you have to run the 2 SQL scripts like I said. Correcting the warnings with the fix button only fixes the versions mismatch but does not run any update SQL script. Personal note: No backup, no mercy ?


Reply to this email directly, view it on GitHub #42205 (comment) , or unsubscribe https://github.com/notifications/unsubscribe-auth/AEDPNYRDGYIGGX3MNGQL2GLYAZAP5AVCNFSM6AAAAAA6LX7NISVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONZUHA4DKMJTGY .
You are receiving this because you were mentioned.Message ID: @.***>

avatar richard67
richard67 - comment - 23 Oct 2023

@dsimonse If you read the comment where I mentioned the scripts, you will see that I already have advised how to run them (in phpMyAdmin). If you don't know how to do that you should not try to run a website. For more questions pelase use the support forum https://forum.joomla.org/ . This here is an issue tracker to track bugs and issues but not a support forum for such questions. Thanks for you understanding.

Additional hint: When updating with the Joomla Update component, which is the only way to do updates, it does not need to run SQL scripts manually. It is only needed in such cases like here when a broken site with incomplete database updates needs to be fixed.

Add a Comment

Login with GitHub to post a comment