MantisBT - v2.0 Release (Closed) |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0000463 | v2.0 Release (Closed) | [All Projects] General | public | 2010-06-05 11:39 | 2010-06-21 21:08 |
|
| Reporter | opto | |
|---|
| Assigned To | caseydk | |
|---|
| Priority | normal | Severity | minor | Reproducibility | always |
|---|
| Status | closed | Resolution | fixed | |
|---|
| Platform | | OS | | OS Version | |
|---|
| Product Version | v2.0.0 | |
|---|
| Target Version | | Fixed in Version | v2.0.0 | |
|---|
|
| Summary | 0000463: Unknown column 'contact_email' in 'field list' |
|---|
| Description | for projects, tasks I get theis error after copying over the latest PHP (100605, 00:56) and running the upgrade script via system admin.
error message:
C:\xampp\htdocs\w2pd05\classes\w2p\Database\Query.class.php(1109): query failed(SELECT c.contact_id, contact_first_name, contact_last_name, contact_email, contact_order_by,contact_phone, dept_name FROM ((`contacts` AS c)) INNER JOIN `project_contacts` AS pc ON pc.contact_id = c.contact_id LEFT JOIN `departments` AS d ON d.dept_id = c.contact_department WHERE pc.project_id = 9 AND (contact_private=0 OR (contact_private=1 AND contact_owner=1) OR contact_owner IS NULL OR contact_owner = 0 )) - error was: Unknown column 'contact_email' in 'field list'
ERROR: C:\xampp\htdocs\w2pd05\classes\w2p\Database\Query.class.php(1109) : query failed(SELECT c.contact_id, contact_first_name, contact_last_name, contact_email, contact_order_by,contact_phone, dept_name FROM ((`contacts` AS c)) INNER JOIN `project_contacts` AS pc ON pc.contact_id = c.contact_id LEFT JOIN `departments` AS d ON d.dept_id = c.contact_department WHERE pc.project_id = 9 AND
(contact_private=0
OR (contact_private=1 AND contact_owner=1)
OR contact_owner IS NULL OR contact_owner = 0
)) - error was: Unknown column 'contact_email' in 'field list'
Backtrace:
0 C:\xampp\htdocs\w2pd05\classes\w2p\Database\Query.class.php:1109 dprint()
1 C:\xampp\htdocs\w2pd05\classes\w2p\Database\Query.class.php:1174 exec()
2 C:\xampp\htdocs\w2pd05\modules\projects\projects.class.php:722 loadHashList()
3 C:\xampp\htdocs\w2pd05\modules\projects\view.php:279 getContacts()
4 C:\xampp\htdocs\w2pd05\index.php:362 require()
Unknown column 'contact_email' in 'field list'
Klaus
|
|---|
| Tags | No tags attached. |
|---|
| Relationships | | related to | 0000466 | closed | caseydk | Reorg of contacts with contacts_methods broke smartsearch |
|
| Attached Files | |
|---|
|
Notes |
|
|
(0000962)
|
|
opto
|
|
2010-06-05 12:24
|
|
doublechecked: this field (contact_email) is definitely not there.
realised that sql update 21 drops this and other fields.
So maybe something else is unfinished or broken. |
|
|
|
|
|
There were a LOT of these, but I just tracked down and cleaned up all of them in commits up through r1164. |
|
|
|
(0000970)
|
|
opto
|
2010-06-06 01:23
(Last edited: 2010-06-06 01:25) |
|
searching for contact_email in all files still gives many occurrences.
login is broken, also view of a project or view of a task.
Maybe I have an incomplete version? Or caused by dP upgrade?
I downloaded the tarball offered at http://web2project.svn.sourceforge.net/viewvc/web2project/
because:
if I try tortoisesvn or svn (sliksvn) from http://web2project.svn.sourceforge.net/viewvc/web2project/trunk/, I get:
Error: Repository moved temporarily to '/viewvc/web2project/trunk/'; please relocate
as I haven't checked out any yet, how can I relocate?
I don't understand this message.
I can check out others (e.g. weberp)
As I did log out and can't login any more, unfortunately, I cannot post any error messages (other than the login message):
C:\xampp\htdocs\w2pd05\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, contact_email as user_email, user_type FROM ((`users` AS users)) INNER JOIN `contacts` AS con ON contact_id = user_contact WHERE user_id = 1 AND user_username = 'admin') - error was: Unknown column 'contact_email' in 'field list'
ERROR: C:\xampp\htdocs\w2pd05\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, contact_email as user_email, user_type FROM ((`users` AS users)) INNER JOIN `contacts` AS con ON contact_id = user_contact WHERE user_id = 1 AND user_username = 'admin') - error was: Unknown column 'contact_email' in 'field list'
Backtrace:
0 C:\xampp\htdocs\w2pd05\classes\w2p\Database\Query.class.php:1109 dprint()
1 C:\xampp\htdocs\w2pd05\classes\w2p\Database\Query.class.php:1256 exec()
2 C:\xampp\htdocs\w2pd05\classes\ui.class.php:757 loadObject()
3 C:\xampp\htdocs\w2pd05\index.php:126 login()
Unknown column 'contact_email' in 'field list'
my AppUI->login still has the contact_email in the sql, but maybe my PHP files are nt up to date?
Klaus
|
|
|
|
|
The contact_email field is used as an alias now. If you look for the occurances, it should say something like "method_value as contact_email". This allows the queries behind the scenes to change but the rendering/processing doesn't have to.
From a quick look at that package, I wouldn't suggest using it.. the resulting compressed file is 23MB+ when the actual trunk uncompressed is only less than 11MB. To get setup with an anonymous SVN checkout, follow these instructions: https://sourceforge.net/scm/?type=svn&group_id=208735
Finally, your actual problem.. it still looks like it was the thing that was patched a few days ago because line 757 in the latest ui.class.php - http://web2project.svn.sourceforge.net/viewvc/web2project/trunk/classes/ui.class.php?revision=1136&view=markup - does not include "loadObject". I think a clean checkout will get you straightened out. |
|
|
|
(0000976)
|
|
opto
|
|
2010-06-06 12:59
|
|
thanks - works fine now.
Should I put the 'svn how to' into the wiki? (That's where I searched but didn't find anything) - together with a warning: do only use if you know what you do? |
|
|
|
|
|
|
|
|
|