MantisBT - v2.0 Release (Closed)
View Issue Details
0000455v2.0 Release (Closed)[All Projects] Generalpublic2010-05-31 20:172010-06-21 21:12
Reporterzbyszek 
Assigned Tocaseydk 
PrioritynormalSeveritycrashReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Versionv2.0.0 
Summary0000455: Task error
DescriptionAfter installing SVN to 1124, you can log on to a system error moves to ProjectDesigner-normal view project-task

/var/www/webdotproject3/classes/w2p/Database/Query.class.php(1109): query failed(SELECT DISTINCT(user_id), user_username, contact_last_name, contact_first_name, contact_email, company_name, contact_company, dept_id, dept_name, CONCAT(contact_first_name,' ',contact_last_name) contact_name, user_type FROM ((`users` AS users)) INNER JOIN `contacts` AS con ON contact_id = user_contact LEFT JOIN `companies` AS com ON company_id = contact_company LEFT JOIN `departments` AS dep ON dept_id = contact_department GROUP BY user_id ORDER BY contact_first_name, contact_last_name) - error was: Unknown column 'contact_email' in 'field list'
ERROR: /var/www/webdotproject3/classes/w2p/Database/Query.class.php(1109) : query failed(SELECT DISTINCT(user_id), user_username, contact_last_name, contact_first_name,
         contact_email, company_name, contact_company, dept_id, dept_name, CONCAT(contact_first_name,' ',contact_last_name) contact_name, user_type FROM ((`users` AS users)) INNER JOIN `contacts` AS con ON contact_id = user_contact LEFT JOIN `companies` AS com ON company_id = contact_company LEFT JOIN `departments` AS dep ON dept_id = contact_department GROUP BY user_id ORDER BY contact_first_name, contact_last_name) - error was: Unknown column 'contact_email' in 'field list'
Backtrace:
0 /var/www/webdotproject3/classes/w2p/Database/Query.class.php:1109 dprint()
1 /var/www/webdotproject3/classes/w2p/Database/Query.class.php:1174 exec()
2 /var/www/webdotproject3/includes/main_functions.php:378 loadHashList()
3 /var/www/webdotproject3/modules/tasks/tasks.class.php:1740 w2PgetUsersHashList()
4 /var/www/webdotproject3/modules/tasks/tasks.php:495 getAllocation()
5 /var/www/webdotproject3/style/web2project/overrides.php:101 require()
6 /var/www/webdotproject3/modules/projects/view.php:339 show()
7 /var/www/webdotproject3/index.php:362 require()
Unknown column 'contact_email' in 'field list'
TagsNo tags attached.
Attached Files

Notes
(0000926)
caseydk   
2010-05-31 20:34   
Please update again. This appears to have been fixed around the r1120-1124 timeframe.
(0000928)
zbyszek   
2010-05-31 22:20   
I installed SVN 1129 problem solved thanks.
(0000929)
caseydk   
2010-05-31 22:50   
Resolved as noted.

Issue History
2010-05-31 20:17zbyszekNew Issue
2010-05-31 20:34caseydkNote Added: 0000926
2010-05-31 20:34caseydkStatusnew => resolved
2010-05-31 20:34caseydkResolutionopen => fixed
2010-05-31 20:34caseydkAssigned To => caseydk
2010-05-31 22:20zbyszekNote Added: 0000928
2010-05-31 22:20zbyszekStatusresolved => feedback
2010-05-31 22:20zbyszekResolutionfixed => reopened
2010-05-31 22:50caseydkNote Added: 0000929
2010-05-31 22:50caseydkStatusfeedback => resolved
2010-05-31 22:50caseydkResolutionreopened => fixed
2010-06-21 21:12caseydkStatusresolved => closed
2010-06-21 21:12caseydkFixed in Version => v2.0