Skip to content

[4.0] Fix extension SQL check for generic components, modules and plugins#30626

Merged
wilsonge merged 7 commits intojoomla:4.0-devfrom
wilsonge:fix/extension-sql-check
Sep 15, 2020
Merged

[4.0] Fix extension SQL check for generic components, modules and plugins#30626
wilsonge merged 7 commits intojoomla:4.0-devfrom
wilsonge:fix/extension-sql-check

Conversation

@wilsonge
Copy link
Copy Markdown
Contributor

@wilsonge wilsonge commented Sep 12, 2020

This code should work as it is but it's in draft as I need to create some dummy plugins and modules for people to test with.

Summary of Changes

Fixes Joomla database checker for 3rd party modules and plugins

Testing Instructions

Install the following 4 sample extensions:

test_module_admin_update_files.zip
test_module_site_update_files.zip
test_plugin_update_files.zip
test_plugin_wrong_files.zip

there's two plugins, a backend module and a frontend module. Before patch the database checker page will give an exception:

Screenshot 2020-09-14 at 21 52 18

After the patch the checker will show 3 of the extensions (one plugin and two modules) and won't list a plugin that is in an 'unexpected location' (see note on doc required change below if you're interested as to why)

Screenshot 2020-09-14 at 21 52 45

Documentation Changes Required

We need to document that for database fixer to work updates must exist in the format updates/mysql or updates/postgresql (at any level) - if you have mysql/updates as a folder structure the extension will be ignored by the schema checker.

@wilsonge wilsonge changed the title Fix extension SQL check for generic components, modules and plugins [4.0] Fix extension SQL check for generic components, modules and plugins Sep 12, 2020
@wilsonge
Copy link
Copy Markdown
Contributor Author

Marking as release blocker as this stops the database fixer from working completely when any plugin or module that has a SQL update file is installed

@wilsonge wilsonge force-pushed the fix/extension-sql-check branch from 76fbc2e to 0ea61fa Compare September 14, 2020 19:52
@wilsonge wilsonge marked this pull request as ready for review September 14, 2020 20:53
@wilsonge
Copy link
Copy Markdown
Contributor Author

Examples uploaded. Ready to rumble I hope

@N6REJ
Copy link
Copy Markdown
Contributor

N6REJ commented Sep 15, 2020

I have tested this item ✅ successfully on ede7746


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/30626.

1 similar comment
@richard67
Copy link
Copy Markdown
Member

I have tested this item ✅ successfully on ede7746


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/30626.

@richard67
Copy link
Copy Markdown
Member

RTC


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/30626.

@joomla-cms-bot joomla-cms-bot added the RTC This Pull Request is Ready To Commit label Sep 15, 2020
@wilsonge wilsonge merged commit 49401d9 into joomla:4.0-dev Sep 15, 2020
@wilsonge
Copy link
Copy Markdown
Contributor Author

Thanks guys!

@joomla-cms-bot joomla-cms-bot removed the RTC This Pull Request is Ready To Commit label Sep 15, 2020
@wilsonge wilsonge deleted the fix/extension-sql-check branch September 15, 2020 10:44
@wilsonge wilsonge added this to the Joomla 4.0 milestone Sep 15, 2020
sakiss pushed a commit to sakiss/joomla-cms that referenced this pull request Oct 16, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

5 participants