Skip to content

[4.0] Installer improvements#26399

Closed
brianteeman wants to merge 2 commits intojoomla:4.0-devfrom
brianteeman:todo3
Closed

[4.0] Installer improvements#26399
brianteeman wants to merge 2 commits intojoomla:4.0-devfrom
brianteeman:todo3

Conversation

@brianteeman
Copy link
Copy Markdown
Contributor

@brianteeman brianteeman commented Sep 24, 2019

Pull Request for Issue #26387 .

Summary of Changes

Don't perform update queries where they are not needed.
Make sure that the queries performed are correct

Testing Instructions

Perform a clean install
Check the db table and you will see that modules have no start publishing date

Export the database

apply the pr

Perform a clean install
Check the db table and you will see that modules have a start publishing date

Export the database

Compare the two database exports

The only differences between the two exports will be sessions, admin password and the timestamps.

There should be no difference for the userid
There should be a difference with the modules publish_up date which should be the time of the install and not 0000

Benefits

Less queries performed that are not needed reduces the installation time etc

@richard67
Copy link
Copy Markdown
Member

@brianteeman Is there maybe a step "Apply the changes of this PR" (or similar) missing in the testing instructions between the 1st export and the 2nd clean install?

@brianteeman
Copy link
Copy Markdown
Contributor Author

obviously - but as it wasn't that obvious I updated the instructions

@richard67
Copy link
Copy Markdown
Member

Code review looks good to me, can do real test tonight after work (if still necessary then).

@mbabker
Copy link
Copy Markdown
Contributor

mbabker commented Sep 24, 2019

Just as a fair warning, this change probably breaks “fixing” timestamps and user IDs in the localise.sql or custom.sql file if you use those to seed tables with data like the sample data SQL files did. The timestamps are less of an issue, but the user IDs potentially leaves you in a spot where things look broken in the backend.

@brianteeman
Copy link
Copy Markdown
Contributor Author

@mbabker - forgot that.

of course there would still be an issue with custom.sql being used for custom installations (with extensions) which could not be updated as this function would not be aware of those tables and fields

@brianteeman
Copy link
Copy Markdown
Contributor Author

also the script is still wrong in its existing format for the use cases you described

@wilsonge
Copy link
Copy Markdown
Contributor

Just got pointed at this by Richard. I'm happy to remove the date code like done here in favour of people using GET_DATE in their sql. but agree with michael the created by/modified by user needs to remain

@richard67
Copy link
Copy Markdown
Member

See PR #26825 .

@brianteeman brianteeman deleted the todo3 branch December 6, 2019 23:16
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