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

wbTeamPro and wbTimeLog are actively being developed and supported.

We are working to update our tracker, changelogs, and documentation to convey this appropriately.
Thank you for your patience as we manage this period of growth.

View Issue Details [ Jump to Notes ] [

1 Vote

]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0010214

wbTeamPro

[All Projects] Bugs

public

2017-01-30 09:31

2015-01-25 00:00

Reporter

MaxOnTheHill

Assigned To

webuddha

Priority

high

Severity

major

Reproducibility

always

Status

Resolved

Resolution

fixed

Platform

OS Version

Product Version

v3.0.11

Target Version

Applied to Version

v3.0.12

Summary

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

Description

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

Tags

action, clientside

Attached Files

Relationships

Notes
(0010029) webuddha (administrator) 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.

Issue History
Date Modified	Username	Field	Change
2013-04-16 18:13	MaxOnTheHill	New Issue
2013-04-16 18:13	MaxOnTheHill
2013-04-16 20:52	webuddha	Note Added: 0010029
2013-04-16 20:52	webuddha	Status	New => Resolved
2013-04-16 20:52	webuddha	Applied to Version	=> v3.0.12
2013-04-16 20:52	webuddha	Resolution	open => fixed
2013-04-16 20:52	webuddha	Assigned To	=> webuddha
2013-04-16 20:53	webuddha	Tag Attached: action
2013-04-16 20:53	webuddha	Tag Attached: clientside