Hi,
I upgraded from MySQL 4.1 to 5.0 on my localhost where I installed
eventum 1.6.1.
To move the eventum db I made a mysqldump and then used the 'source'
command to load the dump file as I do usually.
Eventum seemed to work correctly apart from the issue lists, where I
couldn't see any issues (there were more than 100 issue)
The error log gives this error:
[Tue Oct 25 15:40:27 2005] An error was found on line '67' of script
'D:\servers\http\eventum\include\class.pager.php'.
The error message passed to us was:
'DB Error: no such field'
A more detailed error message follows:
'SELECT COUNT(iss_id) AS total_rows FROM
eventum.eventum_issue,
eventum.eventum_user LEFT JOIN
eventum.`eventum_group` ON
iss_grp_id=grp_id LEFT JOIN
eventum.eventum_project_category ON
iss_prc_id=prc_id LEFT JOIN
eventum.eventum_project_release ON
iss_pre_id = pre_id LEFT JOIN
eventum.eventum_status ON
iss_sta_id=sta_id LEFT JOIN
eventum.eventum_project_priority ON
iss_pri_id=pri_id LEFT JOIN
eventum.eventum_issue_quarantine ON
iss_id=iqu_iss_id AND (iqu_expiration > '2005-10-25
13:40:27' OR iqu_expiration IS NULL)
WHERE iss_prj_id= 4 AND iss_usr_id = usr_id AND
sta_is_closed=0 GROUP BY
iss_id [nativecode=1054 ** Unknown column 'iss_grp_id'
in 'on clause']'
A backtrace is available:
Array
(
[0] => Array
(
[file] => D:\servers\http\eventum\include\class.issue.php
[line] => 2278
[function] => gettotalrows
[class] => pager
[type] => ::
[args] => Array
(
[0] => SELECT
iss_id,
iss_grp_id,
iss_prj_id,
iss_sta_id,
iss_customer_id,
iss_created_date,
iss_updated_date,
iss_last_response_date,
iss_closed_date,
iss_last_customer_action_date,
iss_usr_id,
iss_summary,
pri_title,
prc_title,
sta_title,
sta_color status_color,
sta_id,
iqu_status,
grp_name `group`,
pre_title,
iss_last_public_action_date,
iss_last_public_action_type,
iss_last_internal_action_date,
iss_last_internal_action_type,
GREATEST(iss_last_public_action_date,
iss_last_internal_action_date) AS last_action_date,
IF(iss_last_internal_action_date >
iss_last_public_action_date, 'internal', 'public') AS action_type,
iss_private,
usr_full_name,
iss_percent_complete,
iss_dev_time,
iss_expected_resolution_date
FROM
eventum.eventum_issue,
eventum.eventum_user
LEFT JOIN
eventum.`eventum_group`
ON
iss_grp_id=grp_id
LEFT JOIN
eventum.eventum_project_category
ON
iss_prc_id=prc_id
LEFT JOIN
eventum.eventum_project_release
ON
iss_pre_id = pre_id
LEFT JOIN
eventum.eventum_status
ON
iss_sta_id=sta_id
LEFT JOIN
eventum.eventum_project_priority
ON
iss_pri_id=pri_id
LEFT JOIN
eventum.eventum_issue_quarantine
ON
iss_id=iqu_iss_id AND
(iqu_expiration > '2005-10-25 13:40:27' OR
iqu_expiration IS NULL)
WHERE
iss_prj_id= 4 AND iss_usr_id = usr_id AND
sta_is_closed=0
GROUP BY
iss_id
ORDER BY
last_action_date desc,
iss_id DESC
)
)
Which made me think that on version 5.0 the table before LEFT JOIN
clause must be eventum_issue or , in general, the first table interested
by the join (I didn't have the time to look at the manual).
So I swapped lines 2203 and 2204 in
'path_to_eventum/include/class.issue.php' and everything looked fine,
the issue list did show. I then received the same error when trying to
show an issue, so I swapped lines 2929 and 2930 and the error was gone.
I haven't tried other functions, but for now everything seems to work.
Thanks,
Frank
