Feeling Lucky
?
[#17651] - Fixed SQL update queries
- Fixed in Code Base
- 21 Aug 2017
- Medium
- Build: 4.0-dev
- # 17651
- Diff
- roland-d:4.0-dev
User tests: Successful: Unsuccessful:
Summary of Changes
The update SQL files have 2 issues:
- The file administrator/components/com_admin/sql/updates/mysql/4.0.0-2016-07-03.sql has duplicate single quotes making the SQL invalid
- The file administrator/components/com_admin/sql/updates/mysql/4.0.0-2017-04-25.sql is executed after the administrator/components/com_admin/sql/updates/mysql/4.0.0-2017-03-18.sql file. The 2017-03-18 file drops the columns custom_data and system_data so they cannot be altered in the 2017-04-25 file.
Testing Instructions
- Install a Joomla 3 website
- Execute the SQL queries in the mentioned files and the correct order. You will get database errors.
- Apply patch
- Install a Joomla 3 website
- Execute the SQL queries in the mentioned files and the correct order. There should be no errors
Expected result
Queries are executed as needed.
Actual result
Database errors occur
Documentation Changes Required
None
joomla-cms-bot
- | Category | ⇒ | SQL Administration com_admin |
| Status | New | ⇒ | Pending |
wilsonge
- | Status | Pending | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-08-21 11:52:00 |
| Closed_By | ⇒ | wilsonge | |
| Labels |
Added:
?
|
||