Vtiger - MySQL error when exporting comments to a CSV

AWARDED
Bids
18
Avg Bid (AUD)
$115
Project Budget (AUD)
$30 - $250

Project Description:
In the comments section of Vtiger install, there is a mysql error when exporting to CSV. Need it fixed so we can export comments.

It is a heavily customised version of Vtiger.

See CSV for full error message.

Here is part of the error:

array (
0 =>
array (
'file' => '/home/sarahcrm/public_html/include/database/PearDatabase.php',
'line' => 474,
'function' => 'checkError',
),
1 =>
array (
'file' => '/home/sarahcrm/public_html/include/utils/export.php',
'line' => 192,
'function' => 'pquery',
),
2 =>
array (
'file' => '/home/sarahcrm/public_html/include/utils/export.php',
'line' => 248,
'function' => 'export',
),
3 =>
array (
'file' => '/home/sarahcrm/public_html/index.php',
'line' => 205,
'function' => 'include',
),
)Error exporting ModComments: SELECT vtiger_modcomments.commentcontent as 'Comment',case when (vtiger_users.user_name not like '') then vtiger_users.user_name else vtiger_groups.groupname end as 'Assigned To',vtiger_modcomments.related_to as 'Related To',vtiger_crmentity.smcreatorid as 'Creator',vtiger_crmentity.createdtime as 'Created Time',vtiger_crmentity.modifiedtime as 'Modified Time',vtiger_modcomments.parent_comments as 'Related To Comments', vtiger_users.user_name AS user_name
FROM vtiger_crmentity INNER JOIN vtiger_modcomments ON vtiger_crmentity.crmid=vtiger_modcomments.modcommentsid INNER JOIN vtiger_modcommentscf ON vtiger_modcommentscf.modcommentsid = vtiger_modcomments.modcommentsid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id and vtiger_users.status='Active' LEFT JOIN vtiger_leaddetails ON vtiger_leaddetails.leadid = vtiger_modcomments.related_to LEFT JOIN vtiger_account ON vtiger_account.accountid = vtiger_modcomments.related_to LEFT JOIN vtiger_modcomments ON vtiger_modcomments.modcommentsid = vtiger_modcomments.parent_comments LEFT JOIN vtiger_potential ON vtiger_potential.potentialid = vtiger_modcomments.related_to LEFT JOIN vtiger_projecttask ON vtiger_projecttask.projecttaskid = vtiger_modcomments.related_to LEFT JOIN vtiger_project ON vtiger_project.projectid = vtiger_modcomments.related_to LEFT JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_modcomments.related_to LEFT JOIN vtiger_activity ON vtiger_activity.activityid = vtiger_modcomments.related_to WHERE vtiger_crmentity.deleted=0 Query Failed:SELECT vtiger_modcomments.commentcontent as 'Comment',case when (vtiger_users.user_name not like '') then vtiger_users.user_name else vtiger_groups.groupname end as 'Assigned To',vtiger_modcomments.related_to as 'Related To',vtiger_crmentity.smcreatorid as 'Creator',vtiger_crmentity.createdtime as 'Created Time',vtiger_crmentity.modifiedtime as 'Modified Time',vtiger_modcomments.parent_comments as 'Related To Comments', vtiger_users.user_name AS user_name
FROM vtiger_crmentity INNER JOIN vtiger_modcomments ON vtiger_crmentity.crmid=vtiger_modcomments.modcommentsid INNER JOIN vtiger_modcommentscf ON vtiger_modcommentscf.modcommentsid = vtiger_modcomments.modcommentsid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id and vtiger_users.status='Active' LEFT JOIN vtiger_leaddetails ON vtiger_leaddetails.leadid = vtiger_modcomments.related_to LEFT JOIN vtiger_account ON vtiger_account.accountid = vtiger_modcomments.related_to LEFT JOIN vtiger_modcomments ON vtiger_modcomments.modcommentsid = vtiger_modcomments.parent_comments LEFT JOIN vtiger_potential ON vtiger_potential.potentialid = vtiger_modcomments.related_to LEFT JOIN vtiger_projecttask ON vtiger_projecttask.projecttaskid = vtiger_modcomments.related_to LEFT JOIN vtiger_project ON vtiger_project.projectid =

Additional Project Description:
06/29/2013 at 3:33 EDT
More directions and information will be supplied to the chosen freelancer with the login details...

Skills required:
MySQL, PHP, vTiger
Additional Files: Comments (2).csv
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 100
in 5 days
$ 38
in 1 days
$ 53
in 1 days
Hire powertech
$ 147
in 3 days
$ 103
in 2 days
Hire bigdognec
$ 55
in 3 days
$ 147
in 3 days
$ 30
in 15 days
Hire sat12
$ 105
in 3 days
$ 88
in 1 days