Feeling Lucky
?
[#4256] - Create postinstall_messages table if not exists
- Closed
- 10 Sep 2014
- Low
- Build: master
- Easy Test
- # 4256
Steps to reproduce the issue:
https://github.com/joomla/joomla-cms/blob/master/installation/sql/mysql/joomla.sql#L1501
Expected result:
CREATE TABLE IF NOT EXISTS `#__postinstall_messages` (
Actual result:
CREATE TABLE `#__postinstall_messages` (
Additional comments:
postgresql and sqlazure don't have any checks for "if not exists".
Also, for MySQL, the "INSERT INTO" can be changed to "INSERT IGNORE INTO" so that the installation script can be used as a recovery script if core extensions are uninstalled via the admin. What the ignore will do is ignore entries that are already there and only insert when an entry doesn't exist. I'm not sure what the equivalents are in postgresql and sqlazure.
| Priority | Medium | ⇒ | Low |
| Status | New | ⇒ | Pending |
| Easy | No | ⇒ | Yes |
zero-24
- | Status | Pending | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2014-09-10 14:58:44 |
| Labels |
Added:
?
|
||
Pull request:
#4257
This comment was created with the J!Tracker Application at http://issues.joomla.org/.