upgrade/update-database.php: v2.3.5: DB Error
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Eventum |
Fix Released
|
Medium
|
Elan Ruusamäe |
Bug Description
I ran into the following while upgrading from 2.3.3 to 2.3.5
Turns out that "eventum_" was hard-coded instead of using %TABLE_PREFIX%
It's just two lines, easy enough to fix with sed, but diff is attached.
[root@eventum upgrade]# ./update-
* Applying patch: 12 (12_timetrackin
DB Error: no such table: -- select first project id - we keep this as default
select prj_id from eventum_project limit 1 into @prj_id [nativecode=1146 ** Table 'eventumdev.
[root@eventum upgrade]#
[root@eventum upgrade]# ./update-
* Applying patch: 12 (12_timetrackin
DB Error: unknown error: ALTER TABLE time_tracking_
ADD COLUMN ttc_prj_id int(10) unsigned NOT NULL default 0 after ttc_id,
DROP KEY ttc_title,
ADD KEY ttc_title (ttc_prj_id, ttc_title) [nativecode=1060 ** Duplicate column name 'ttc_prj_id']
[root@eventum upgrade]#
fix included in 2.3.6 release