While using the "Find Bug" facility on the front page.
DB Error: unknown error
select b.*, reporter.login as reporter, owner.login as owner, status_name, resolution_name from phpbt_bug b left join phpbt_auth_user owner on b.assigned_to = owner.user_id left join phpbt_auth_user reporter on b.created_by = reporter.user_id left join phpbt_bookmark bookmark on b.bug_id = bookmark.bug_id left join phpbt_resolution r on b.resolution_id = r.resolution_id, phpbt_severity sv, phpbt_status st, phpbt_site site, phpbt_priority prio where b.bug_id = 1 and b.project_id not in (0) and b.site_id = site.site_id and b.severity_id = sv.severity_id and b.status_id = st.status_idand b.priority = prio.priority_id [nativecode=ERROR: syntax error at or near "b" at character 593 ]
Looks like a simple space missing on the last line of the query:
= sv.severity_id and b.status_id = st.status_idand b.priority = prio.priority_id
should read
= sv.severity_id and b.status_id = st.status_id and b.priority = prio.priority_id
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
bug.php?op=show&bugid=1
While using the "Find Bug" facility on the front page.
DB Error: unknown error
select b.*, reporter.login as reporter, owner.login as owner, status_name, resolution_name from phpbt_bug b left join phpbt_auth_user owner on b.assigned_to = owner.user_id left join phpbt_auth_user reporter on b.created_by = reporter.user_id left join phpbt_bookmark bookmark on b.bug_id = bookmark.bug_id left join phpbt_resolution r on b.resolution_id = r.resolution_id, phpbt_severity sv, phpbt_status st, phpbt_site site, phpbt_priority prio where b.bug_id = 1 and b.project_id not in (0) and b.site_id = site.site_id and b.severity_id = sv.severity_id and b.status_id = st.status_idand b.priority = prio.priority_id [nativecode=ERROR: syntax error at or near "b" at character 593 ]
Looks like a simple space missing on the last line of the query:
= sv.severity_id and b.status_id = st.status_idand b.priority = prio.priority_id
should read
= sv.severity_id and b.status_id = st.status_id and b.priority = prio.priority_id