#373 DB error - Bookmarked bugs - On upgrade to cvs-head

[Bryce Nesbitt]

Step 1) Upgrade to the current CVS, and rev 5 DB. Mysql DB.
Step 2) Bookmark a bug.
Step 3) Click on the bookmark:

DB Error: syntax error
select b.bug_id as bug_link_id, severity.severity_color, priority.priority_color, b.bug_id, title, , status.status_name, resolution_name, reporter.login as reporter, owner.login as owner, b.last_modified_date, project.project_name, component.component_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_auth_user lastmodifier on b.last_modified_by = lastmodifier.user_id left join phpbt_comment comment on b.bug_id = comment.bug_id left join phpbt_attachment attachment on b.bug_id = attachment.bug_id left join phpbt_bug_vote vote on b.bug_id = vote.bug_id left join TBL_BOOKMARK bookmark on b.bug_id = bookmark.bug_id left join phpbt_resolution resolution on b.resolution_id = resolution.resolution_id left join phpbt_database_server on b.database_id = phpbt_database_server.database_id left join phpbt_version version2 on b.to_be_closed_in_version_id = version2.version_id left join phpbt_version version3 on b.closed_in_version_id = version3.version_id, phpbt_severity severity, phpbt_status status, phpbt_os os, phpbt_site site, phpbt_version version, phpbt_component component, phpbt_project project, TBL_PRIORITY priority where b.severity_id = severity.severity_id and b.priority = priority.priority_id and b.status_id = status.status_id and b.os_id = os.os_id and b.site_id = site.site_id and b.version_id = version.version_id and b.component_id = component.component_id and b.project_id = project.project_id and b.status_id in (1, 2, 3, 4, 5) and b.bug_id = bookmark.bug_id AND bookmark.user_id = 3 group by b.bug_id order by b.bug_id asc, b.bug_id asc LIMIT 0, 20 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' status.status_name, resolution_name, reporter.login as reporter, owner.login as' at line 1]

--------------------------
Step 4) It appears you can clear the error by messing with the columns in the "Personal Page". Note the extra ", ," in the SQL above.

[Bryce Nesbitt]

Logged In: YES
user_id=122507
Originator: YES

Resolution: This happens if you are logged in to an old version of phpBugTracker, and a newer version, at the same time.

[Tom Diesel]

Logged In: YES
user_id=338267
Originator: NO

Just upgraded to the new version after I discovered heaps of spam in my bugtracker. Then I ran into this prob.

THX, Step 4 helped to fix it (just saving without changes)!

Deleting all cookies for the site didn't help though, so there is no logging issue afaics.

[Bryce Nesbitt]

Logged In: YES
user_id=122507
Originator: YES

Solution: visit your "personal page" and hit "save" (you don't have to change anything).