wbTeamPro Feature Request & Bug Tracker - wbTeamPro
View Issue Details
0010214wbTeamPro[All Projects] Bugspublic2017-01-30 09:312015-01-25 00:00
MaxOnTheHill 
webuddha 
highmajoralways
Resolvedfixed 
v3.0.11 
v3.0.12 
0010214: Main Contact: wbDatabase fatal error errno: 1054 errmsg: Unknown column 'client.email' in 'field list'
When contact assigned to project or action, the main account email gets assigned to the contacts in wbTeamPro ... which gives:

Main Contact: wbDatabase fatal error
errno: 1054
errmsg: Unknown column 'client.email' in 'field list'

Thanks for fixing so that a contact can get assigned in the 3.0.11 release, as this didn't function previously; however, while can now assign contact, it gives the above error.

------
Detail from ticket reply:
------
Hi David,

Still seem to be having problems ... as email assigned to contact is coming through incorrectly ... it is bringing through the main client/account email through as the email address for the client contact assigned to the project/action ... then causing more errors on frontend.
I'm assuming it probably also sends to the incorrect email - or email may fail, haven't tested, as don't want to have clients confused and not wanting to use the system because not working quite right.

Error I get when viewing on frontend, when viewing an action, is:
Main Contact: wbDatabase fatal error
errno: 1054
errmsg: Unknown column 'client.email' in 'field list'

I also get the same error code, with totally broken display output, if I click on topic/discussion edit on frontend.

In administration, in action/project view and look to assign client contact it shows the contacts name, but with the main account email address (not the email address of the contact.


At the moment, this sort of breaks all functionality I need to be able to work with the client contacts (as main account email is the admin/billing department) .... only the guys as contacts should be involved with the projects.


>>> Would love a quick fix if possible.


Love what you're doing ... thx, Max
action, clientside
Issue History
2013-04-16 18:13MaxOnTheHillNew Issue
2013-04-16 18:13MaxOnTheHill
2013-04-16 20:52webuddhaNote Added: 0010029
2013-04-16 20:52webuddhaStatusNew => Resolved
2013-04-16 20:52webuddhaApplied to Version => v3.0.12
2013-04-16 20:52webuddhaResolutionopen => fixed
2013-04-16 20:52webuddhaAssigned To => webuddha
2013-04-16 20:53webuddhaTag Attached: action
2013-04-16 20:53webuddhaTag Attached: clientside

Notes
(0010029)
webuddha   
2013-04-16 20:52   
This issue was found when selecting options 3-6 from the contactName display format option. The contactName render was missing the necessary table joins resulting in the database error.