[#41] - Move adding columns into the script. Fixes #40.
- Closed
- 19 May 2015
- Medium
- Build: master
- # 41
- Diff
- joomla-extensions:fixAddColumns
User tests: Successful: Unsuccessful:
This fixes issue #40:
Duplicate column name 'version' SQL=ALTER TABLEp52jk_weblinksADD COLUMNversionint(10) unsigned NOT NULL DEFAULT '1';
This message shows when updating Joomla 3.3.6 to 3.4.1 upload and install the weblinks RC package.
| Milestone |
Added: 3.4.1 |
||
Why is this not using the query builder?
IIRC the database code in general doesn't have support for queries that change table schemas.
That should be remedied, but probably not in this PR, obv.
If we could deal with adding and removing columns 99% of extension update SQL files could be killed in one swift chop
Also successful tested by @infograf768 #44 (comment)
With my package and #41 (comment) included.
Thanks!
Works!
@test successful with the changes above and in combination with #42 Great work!