upgrade/update-database.php: v2.3.5: DB Error

[Brian LaVallee]

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-database.php
* Applying patch: 12 (12_timetracking_project.sql)
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.eventum_project' doesn't exist]
[root@eventum upgrade]#

[root@eventum upgrade]# ./update-database.php
* Applying patch: 12 (12_timetracking_project.sql)
DB Error: unknown error: ALTER TABLE time_tracking_category
 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]#

[Elan Ruusamäe (glen666)]

fix included in 2.3.6 release