web2project: web-based project management

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000457 [v2.0 Release (Current)] Core Infrastructure block always 2010-06-01 04:28 2010-06-21 23:10
Reporter laussetdelon View Status public  
Assigned To caseydk
Priority immediate Resolution fixed  
Status closed   Product Version v2.0.0
Summary 0000457: Problem upgrading from V1.3
Description I tried to install trunk 1129 today. I got after entering admin authentification information

ERROR: /var/www/project/classes/w2p/Database/Query.class.php(1109) : query failed(SELECT user_id, contact_first_name as user_first_name, contact_last_name as user_last_name, contact_company as user_company, contact_department as user_department, user_type,cm.method_value AS user_email FROM ((`users` AS users)) INNER JOIN `contacts` AS con ON contact_id = user_contact LEFT JOIN `contacts_methods` AS cm ON cm.contact_id = con.contact_id WHERE cm.method_name = 'email_primary' AND user_id = 1 AND user_username = 'admin') - error was: Table 'project.contacts_methods' doesn't exist
Backtrace:
0 /var/www/project/classes/w2p/Database/Query.class.php:1109 dprint()
1 /var/www/project/classes/w2p/Database/Query.class.php:1256 exec()
2 /var/www/project/classes/ui.class.php:763 loadObject()
3 /var/www/project/index.php:126 login()
Table 'project.contacts_methods' doesn't exist
Additional Information
Tags No tags attached.
Attached Files

- Relationships

-  Notes
(0000937)
caseydk (administrator)
2010-06-02 20:50

Resolved in r1130;
(0000943)
laussetdelon (reporter)
2010-06-03 07:57

Still the message below (upgrading to trunk 1130 or 1133

ERROR: /var/www/project/classes/w2p/Database/Query.class.php(1109) : query failed(SELECT user_id, contact_first_name as user_first_name, contact_last_name as user_last_name, contact_company as user_company, contact_department as user_department, user_type,cm.method_value AS user_email FROM ((`users` AS users)) INNER JOIN `contacts` AS con ON contact_id = user_contact LEFT JOIN `contacts_methods` AS cm ON cm.contact_id = con.contact_id WHERE cm.method_name = 'email_primary' AND user_id = 1 AND user_username = 'admin') - error was: Table 'project.contacts_methods' doesn't exist
Backtrace:
0 /var/www/project/classes/w2p/Database/Query.class.php:1109 dprint()
1 /var/www/project/classes/w2p/Database/Query.class.php:1256 exec()
2 /var/www/project/classes/ui.class.php:779 loadObject()
3 /var/www/project/index.php:126 login()
Table 'project.contacts_methods' doesn't exist
(0000949)
caseydk (administrator)
2010-06-04 20:44

I tracked down this one and beat it up in a back alley. It's not the most efficient way but it consistently works reliably.

Resolved in r1136.

- Issue History
Date Modified Username Field Change
2010-06-01 04:28 laussetdelon New Issue
2010-06-01 07:03 caseydk Status new => assigned
2010-06-01 07:03 caseydk Assigned To => caseydk
2010-06-01 07:12 caseydk Priority normal => immediate
2010-06-01 07:12 caseydk Severity crash => block
2010-06-02 20:50 caseydk Note Added: 0000937
2010-06-02 20:50 caseydk Status assigned => resolved
2010-06-02 20:50 caseydk Resolution open => fixed
2010-06-03 07:57 laussetdelon Note Added: 0000943
2010-06-03 07:57 laussetdelon Status resolved => feedback
2010-06-03 07:57 laussetdelon Resolution fixed => reopened
2010-06-04 20:44 caseydk Note Added: 0000949
2010-06-04 20:44 caseydk Status feedback => resolved
2010-06-04 20:44 caseydk Resolution reopened => fixed
2010-06-21 23:10 caseydk Status resolved => closed
2010-06-21 23:10 caseydk Fixed in Version => v2.0


Mantis 1.1.8[^]
Copyright © 2000 - 2009 Mantis Group
Powered by Mantis Bugtracker