[prev in list] [next in list] [prev in thread] [next in thread]
List: vtigercrm-developers
Subject: Re: [Vtigercrm-developers] visibility of calendar entries
From: Tim Mohrbach <preexo () googlemail ! com>
Date: 2015-12-22 3:34:47
Message-ID: CABz+p0U2kpELmxvKEOrXzAoFtQpuRKDDUUMvAVBS06Bv2JM4hw () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
The function getNonAdminAccessControlQuery in the
modules/Calendar/Activity.php seems to be the one creating the table
beforehand, I attached the whole mysql log, it shows that a previous query
on this temp table was actually successfull. Just the query before it
failed... I'll have a closer look, but wanted to share the whole log first,
see attachment.
On 22 December 2015 at 11:07, Preexo <preexo@googlemail.com> wrote:
> I started digging into this, after switching on the debug logs, I get a
> failed query, see the output below:
>
> Query: SELECT vtiger_activity.status, CASE WHEN (vtiger_activity.status not like \
> '') THEN vtiger_activity.status ELSE vtiger_activity.eventstatus END AS status, \
> vtiger_activity.activitytype, vtiger_activity.subject, vtiger_seactivityrel.crmid, \
> vtiger_activity.date_start, vtiger_activity.time_start, vtiger_activity.due_date, \
> vtiger_activity.time_end, vtiger_crmentity.smownerid, vtiger_activity.activityid, \
> vtiger_activity.visibility FROM vtiger_activity INNER JOIN vtiger_crmentity ON \
> vtiger_activity.activityid = vtiger_crmentity.crmid LEFT JOIN vtiger_seactivityrel \
> ON vtiger_activity.activityid = vtiger_seactivityrel.activityid LEFT JOIN \
> vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN \
> vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid INNER JOIN \
> vt_tmp_u1_t9 vt_tmp_u1_t9 ON (vt_tmp_u1_t9.id = vtiger_crmentity.smownerid and \
> vt_tmp_u1_t9.shared=0 and vt_tmp_u1_t9.id IN \
> (5,6,6,6,6,6,6,6,6,6,6,6,6,7,7,7,7,7,7,7,7,7,8,9,10,11,12,13,13,13,13,13,13,13,13,13,13,13,13,13,18,21,22,22,22,22,22,22,22,22,22,22,22,22,22,25,27,28,1,3,14,4)) \
> WHERE vtiger_crmentity.deleted=0 AND ( vtiger_activity.activitytype <> 'Emails') \
> AND vtiger_activity.activityid > 0 ORDER BY modifiedtime DESC LIMIT 0, 1015 failed. \
> Table 'vtiger_dev.vt_tmp_u1_t9' doesn't exist
> 1146: Table 'vtiger_dev.vt_tmp_u1_t9' doesn't exist
> ADOConnection._Execute(SELECT vtiger_activity.status, CASE WHEN \
> (vtiger_activity.status not like '') THEN vtiger_activity.status ELSE \
> vtiger_activity.e..., false) % line 1046, file: adodb.inc.php \
> ADOConnection.Execute(SELECT vtiger_activity.status, CASE WHEN \
> (vtiger_activity.status not like '') THEN vtiger_activity.status ELSE \
> vtiger_activity.e..., false) % line 72, file: adodb-perf.inc.php \
> adodb_log_sql(Object:ADODB_mysqli, SELECT vtiger_activity.status, CASE WHEN \
> (vtiger_activity.status not like '') THEN vtiger_activity.status ELSE \
> vtiger_activity.e..., false) % line 977, file: adodb.inc.php \
> ADOConnection.Execute(SELECT vtiger_activity.status, CASE WHEN \
> (vtiger_activity.status not like '') THEN vtiger_activity.status ELSE \
> vtiger_activity.e...) % line 357, file: PearDatabase.php \
> PearDatabase.pquery(SELECT vtiger_activity.status, CASE WHEN \
> (vtiger_activity.status not like '') THEN vtiger_activity.status ELSE \
> vtiger_activity.e..., Array[0]) % line 144, file: ListViewSession.php
> Fatal error: Call to a member function FetchRow() on a non-object in \
> /var/lib/shared/websites/custom/www/crmdev/include/database/PearDatabase.php on \
> line 532
> I have never seen those tables before and tried to look where they are
> actually being used and where they are being created. I could not find
> where they are being created, the usage can be seen in the screenshot
> below: The code of the function *getNonAdminAccessControlQuery* in the
> three classes seems quite identical to me btw, maybe we can think about
> merging this somewhere and inheriting it somehow instead of code
> redundancy, but this is not as important right now, I'll save that for
> later. Anyone got an idea where those user temp right tables are actually
> supposed to be created? Thanks for any help on this
> ------------------------------
> View this message in context: Re: visibility of calendar entries
> <http://vtiger-crm.2324883.n4.nabble.com/visibility-of-calendar-entries-tp17990p18019.html>
>
> Sent from the vtigercrm-developers mailing list archive
> <http://vtiger-crm.2324883.n4.nabble.com/vtigercrm-developers-f4.html> at
> Nabble.com.
>
> _______________________________________________
> http://www.vtiger.com/
>
[Attachment #5 (text/html)]
<div dir="ltr">The function getNonAdminAccessControlQuery in the \
modules/Calendar/Activity.php seems to be the one creating the table beforehand, I \
attached the whole mysql log, it shows that a previous query on this temp table was \
actually successfull. Just the query before it failed... I'll have a closer look, \
but wanted to share the whole log first, see attachment.</div><div \
class="gmail_extra"><br><div class="gmail_quote">On 22 December 2015 at 11:07, Preexo \
<span dir="ltr"><<a href="mailto:preexo@googlemail.com" \
target="_blank">preexo@googlemail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">I started digging into this, after switching on the debug \
logs, I get a failed query, see the output below: <pre>Query: SELECT \
vtiger_activity.status, CASE WHEN (vtiger_activity.status not like '') THEN \
vtiger_activity.status ELSE vtiger_activity.eventstatus END AS status, \
vtiger_activity.activitytype, vtiger_activity.subject, vtiger_seactivityrel.crmid, \
vtiger_activity.date_start, vtiger_activity.time_start, vtiger_activity.due_date, \
vtiger_activity.time_end, vtiger_crmentity.smownerid, vtiger_activity.activityid, \
vtiger_activity.visibility FROM vtiger_activity INNER JOIN vtiger_crmentity ON \
vtiger_activity.activityid = vtiger_crmentity.crmid LEFT JOIN vtiger_seactivityrel ON \
vtiger_activity.activityid = vtiger_seactivityrel.activityid LEFT JOIN vtiger_users \
ON vtiger_crmentity.smownerid = <a href="http://vtiger_users.id" \
target="_blank">vtiger_users.id</a> LEFT JOIN vtiger_groups ON \
vtiger_crmentity.smownerid = vtiger_groups.groupid INNER JOIN vt_tmp_u1_t9 \
vt_tmp_u1_t9 ON (<a href="http://vt_tmp_u1_t9.id" target="_blank">vt_tmp_u1_t9.id</a> \
= vtiger_crmentity.smownerid and vt_tmp_u1_t9.shared=0 and <a \
href="http://vt_tmp_u1_t9.id" target="_blank">vt_tmp_u1_t9.id</a> IN \
(5,6,6,6,6,6,6,6,6,6,6,6,6,7,7,7,7,7,7,7,7,7,8,9,10,11,12,13,13,13,13,13,13,13,13,13,13,13,13,13,18,21,22,22,22,22,22,22,22,22,22,22,22,22,22,25,27,28,1,3,14,4)) \
WHERE vtiger_crmentity.deleted=0 AND ( vtiger_activity.activitytype <> \
'Emails') AND vtiger_activity.activityid > 0 ORDER BY modifiedtime DESC \
LIMIT 0, 1015 failed. Table 'vtiger_dev.vt_tmp_u1_t9' \
doesn't exist
1146: Table 'vtiger_dev.vt_tmp_u1_t9' doesn't exist
ADOConnection._Execute(SELECT vtiger_activity.status, CASE \
WHEN (vtiger_activity.status not like '') THEN vtiger_activity.status ELSE \
vtiger_activity.e..., false) % line 1046, file: adodb.inc.php \
ADOConnection.Execute(SELECT vtiger_activity.status, CASE WHEN \
(vtiger_activity.status not like '') THEN vtiger_activity.status ELSE \
vtiger_activity.e..., false) % line 72, file: adodb-perf.inc.php \
adodb_log_sql(Object:ADODB_mysqli, SELECT vtiger_activity.status, CASE WHEN \
(vtiger_activity.status not like '') THEN vtiger_activity.status ELSE \
vtiger_activity.e..., false) % line 977, file: adodb.inc.php \
ADOConnection.Execute(SELECT vtiger_activity.status, CASE WHEN \
(vtiger_activity.status not like '') THEN vtiger_activity.status ELSE \
vtiger_activity.e...) % line 357, file: PearDatabase.php PearDatabase.pquery(SELECT \
vtiger_activity.status, CASE WHEN (vtiger_activity.status not like '') THEN \
vtiger_activity.status ELSE vtiger_activity.e..., Array[0]) % line 144, file: \
ListViewSession.php
Fatal error: Call to a member function FetchRow() on a non-object in \
/var/lib/shared/websites/custom/www/crmdev/include/database/PearDatabase.php on line \
532</pre>
I have never seen those tables before and tried to look where they are actually being \
used and where they are being created. I could not find where they are being created, \
the usage can be seen in the screenshot below: <img border="0">
The code of the function <i>getNonAdminAccessControlQuery</i> in the three classes \
seems quite identical to me btw, maybe we can think about merging this somewhere and \
inheriting it somehow instead of code redundancy, but this is not as important right \
now, I'll save that for later.
Anyone got an idea where those user temp right tables are actually supposed to be \
created?
Thanks for any help on this
<br><hr align="left" width="300">
View this message in context: <a \
href="http://vtiger-crm.2324883.n4.nabble.com/visibility-of-calendar-entries-tp17990p18019.html" \
target="_blank">Re: visibility of calendar entries</a><div class="HOEnZb"><div \
class="h5"><br> Sent from the <a \
href="http://vtiger-crm.2324883.n4.nabble.com/vtigercrm-developers-f4.html" \
target="_blank">vtigercrm-developers mailing list archive</a> at \
Nabble.com.<br></div></div><br>_______________________________________________<br> <a \
href="http://www.vtiger.com/" rel="noreferrer" \
target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>
--001a11355014999afa05277449c0--
["vtiger_mysql_debug.txt" (text/plain)]
(mysqli): SELECT tabid, name, ownedby FROM vtiger_tab
(mysqli): SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, \
uitype, typeofdata, presence FROM vtiger_field WHERE tabid in ('29') (mysqli): \
SELECT * FROM vtiger_tab (mysqli): SELECT \
fieldname,modulename,tablename,entityidfield,entityidcolumn from vtiger_entityname \
(mysqli): SELECT * FROM vtiger_links WHERE linktype IN ('HEADERSCRIPT') and tabid IN \
(1,2,3,4,6,7,8,9,10,13,14,15,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,0) \
(mysqli): SELECT * FROM vtiger_links WHERE linktype IN ('HEADERCSS') and tabid IN \
(1,2,3,4,6,7,8,9,10,13,14,15,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,0) \
(mysqli): SELECT modulename,tablename,entityidfield,fieldname FROM vtiger_entityname \
(mysqli): SELECT * FROM vtiger_tab WHERE presence IN ('0','2')
(mysqli): SELECT fieldname,modulename,tablename,entityidfield,entityidcolumn from \
vtiger_entityname (mysqli): SELECT \
fieldname,modulename,tablename,entityidfield,entityidcolumn from vtiger_entityname \
(mysqli): SELECT * FROM vtiger_organizationdetails WHERE organization_id=1 \
(mysqli): SELECT * FROM vtiger_links WHERE linktype IN ('HEADERLINK') and tabid IN \
(1,2,3,4,6,7,8,9,10,13,14,15,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,0) \
(mysqli): select * from vtiger_announcement inner join vtiger_users on \
vtiger_announcement.creatorid=vtiger_users.id AND vtiger_users.is_admin='on' AND \
vtiger_users.status='Active' AND vtiger_users.deleted = 0 (mysqli): SELECT * FROM \
vtiger_tab WHERE presence IN (0,2) (mysqli): SELECT \
fieldname,modulename,tablename,entityidfield,entityidcolumn from vtiger_entityname \
(mysqli): SELECT fieldname,modulename,tablename,entityidfield,entityidcolumn from \
vtiger_entityname (mysqli): SELECT * FROM vtiger_actionmapping
(mysqli): SELECT * FROM vtiger_links WHERE (tabid='9' OR tabid=0) AND linktype IN \
('SIDEBARLINK','SIDEBARWIDGET') (mysqli): SELECT tabid, fieldname, fieldid, \
fieldlabel, columnname, tablename, uitype, typeofdata, presence FROM vtiger_field \
WHERE tabid in ('9','16') (mysqli): SELECT vtiger_activity.subject AS \
vtiger_activitysubject,vtiger_crmentity.smownerid AS \
vtiger_crmentityassigned_user_id,vtiger_activity.date_start AS \
vtiger_activitydate_start,vtiger_activity.time_start AS \
vtiger_activitytime_start,vtiger_activity.due_date AS \
vtiger_activitydue_date,vtiger_activity.time_end AS \
vtiger_activitytime_end,vtiger_activity.recurringtype AS \
vtiger_activityrecurringtype,vtiger_activity.duration_hours AS \
vtiger_activityduration_hours,vtiger_activity.duration_minutes AS \
vtiger_activityduration_minutes,vtiger_seactivityrel.crmid AS \
vtiger_seactivityrelparent_id,vtiger_activity.eventstatus AS \
vtiger_activityeventstatus,vtiger_activity.sendnotification AS \
vtiger_activitysendnotification,vtiger_activity.activitytype AS \
vtiger_activityactivitytype,vtiger_activity.location AS \
vtiger_activitylocation,vtiger_crmentity.createdtime AS \
vtiger_crmentitycreatedtime,vtiger_crmentity.modifiedtime AS \
vtiger_crmentitymodifiedtime,vtiger_activity.priority AS \
vtiger_activitytaskpriority,vtiger_activity.notime AS \
vtiger_activitynotime,vtiger_activity.visibility AS \
vtiger_activityvisibility,vtiger_crmentity.modifiedby AS \
vtiger_crmentitymodifiedby,vtiger_crmentity.description AS \
vtiger_crmentitydescription,vtiger_activity_reminder.reminder_time AS \
vtiger_activity_reminderreminder_time,vtiger_cntactivityrel.contactid AS \
vtiger_cntactivityrelcontact_id,vtiger_activity.mssystem_id AS \
vtiger_activitymssystem_id,vtiger_activitycf.cf_agcwys_events_1124 AS \
vtiger_activitycfcf_agcwys_events_1124,vtiger_activity.subject AS \
vtiger_activitysubject,vtiger_crmentity.smownerid AS \
vtiger_crmentityassigned_user_id,vtiger_activity.date_start AS \
vtiger_activitydate_start,vtiger_activity.time_start AS \
vtiger_activitytime_start,vtiger_activity.time_end AS \
vtiger_activitytime_end,vtiger_activity.due_date AS \
vtiger_activitydue_date,vtiger_seactivityrel.crmid AS \
vtiger_seactivityrelparent_id,vtiger_cntactivityrel.contactid AS \
vtiger_cntactivityrelcontact_id,vtiger_activity.status AS \
vtiger_activitytaskstatus,vtiger_activity.eventstatus AS \
vtiger_activityeventstatus,vtiger_activity.priority AS \
vtiger_activitytaskpriority,vtiger_activity.sendnotification AS \
vtiger_activitysendnotification,vtiger_crmentity.createdtime AS \
vtiger_crmentitycreatedtime,vtiger_crmentity.modifiedtime AS \
vtiger_crmentitymodifiedtime,vtiger_activity.activitytype AS \
vtiger_activityactivitytype,vtiger_activity.visibility AS \
vtiger_activityvisibility,vtiger_crmentity.description AS \
vtiger_crmentitydescription,vtiger_activity.duration_hours AS \
vtiger_activityduration_hours,vtiger_activity.duration_minutes AS \
vtiger_activityduration_minutes,vtiger_activity.location AS \
vtiger_activitylocation,vtiger_activity_reminder.reminder_time AS \
vtiger_activity_reminderreminder_time,vtiger_activity.recurringtype AS \
vtiger_activityrecurringtype,vtiger_activity.notime AS \
vtiger_activitynotime,vtiger_crmentity.modifiedby AS \
vtiger_crmentitymodifiedby,vtiger_crmentity.smcreatorid AS \
vtiger_crmentitycreated_user_id,vtiger_activitycf.cf_964 AS \
vtiger_activitycfcf_964,vtiger_crmentity.deleted FROM vtiger_crmentity LEFT JOIN \
vtiger_activity ON vtiger_activity.activityid=vtiger_crmentity.crmid LEFT JOIN \
vtiger_seactivityrel ON vtiger_seactivityrel.activityid=vtiger_crmentity.crmid LEFT \
JOIN vtiger_cntactivityrel ON vtiger_cntactivityrel.activityid=vtiger_crmentity.crmid \
LEFT JOIN vtiger_salesmanactivityrel ON \
vtiger_salesmanactivityrel.activityid=vtiger_crmentity.crmid LEFT JOIN \
vtiger_activity_reminder ON \
vtiger_activity_reminder.activity_id=vtiger_crmentity.crmid LEFT JOIN \
vtiger_recurringevents ON vtiger_recurringevents.activityid=vtiger_crmentity.crmid \
LEFT JOIN vtiger_activitycf ON vtiger_activitycf.activityid=vtiger_crmentity.crmid \
WHERE vtiger_crmentity.crmid='58958' LIMIT 1 (mysqli): SELECT * FROM vtiger_blocks \
WHERE tabid='9' ORDER BY sequence (mysqli): SELECT * FROM vtiger_field WHERE \
tabid='9' ORDER BY sequence (mysqli): SELECT * FROM vtiger_blocks WHERE \
blockid='86' (mysqli): SELECT * FROM vtiger_blocks WHERE blockid='19'
(mysqli): SELECT * FROM vtiger_blocks WHERE blockid='20'
(mysqli): SELECT * FROM vtiger_links WHERE (tabid='9' OR tabid=0) AND linktype IN \
('DETAILVIEWBASIC','DETAILVIEW') (mysqli): select smownerid from vtiger_crmentity \
where crmid = '58958' (mysqli): select count(*) as count from vtiger_users where id \
= '20' (mysqli): SELECT * FROM vtiger_modtracker_tabs WHERE \
vtiger_modtracker_tabs.visible = 1 AND vtiger_modtracker_tabs.tabid='9' (mysqli): \
SELECT fieldid FROM vtiger_field WHERE fieldname = 'related_to' AND tabid = '43' \
(mysqli): SELECT relmodule FROM vtiger_fieldmodulerel WHERE fieldid = '606' \
(mysqli): SELECT * FROM vtiger_modtracker_tabs WHERE vtiger_modtracker_tabs.visible = \
1 AND vtiger_modtracker_tabs.tabid='9' (mysqli): SELECT status, userid FROM \
vtiger_customview WHERE cvid='19' (mysqli): select cvid from vtiger_customview \
where viewname='All' and entitytype='Calendar' (mysqli): SELECT \
vtiger_activity.status, CASE WHEN (vtiger_activity.status not like '') THEN \
vtiger_activity.status ELSE vtiger_activity.eventstatus END AS status, \
vtiger_activity.activitytype, vtiger_activity.subject, vtiger_seactivityrel.crmid, \
vtiger_activity.date_start, vtiger_activity.time_start, vtiger_activity.due_date, \
vtiger_activity.time_end, vtiger_crmentity.smownerid, vtiger_activity.activityid, \
vtiger_activity.visibility FROM vtiger_activity INNER JOIN vtiger_crmentity ON \
vtiger_activity.activityid = vtiger_crmentity.crmid LEFT JOIN vtiger_seactivityrel ON \
vtiger_activity.activityid = vtiger_seactivityrel.activityid LEFT JOIN vtiger_users \
ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON \
vtiger_crmentity.smownerid = vtiger_groups.groupid INNER JOIN vt_tmp_u1_t9 \
vt_tmp_u1_t9 ON (vt_tmp_u1_t9.id = vtiger_crmentity.smownerid and \
vt_tmp_u1_t9.shared=0 and vt_tmp_u1_t9.id IN \
(5,6,6,6,6,6,6,6,6,6,6,6,6,7,7,7,7,7,7,7,7,7,8,9,10,11,12,13,13,13,13,13,13,13,13,13,13,13,13,13,18,21,22,22,22,22,22,22,22,22,22,22,22,22,22,25,27,28,1,3,14,4)) \
WHERE vtiger_crmentity.deleted=0 AND ( vtiger_activity.activitytype <> 'Emails') AND \
vtiger_activity.activityid > 0 ORDER BY modifiedtime DESC LIMIT 0, \
1015
Query: SELECT vtiger_activity.status, CASE WHEN (vtiger_activity.status not like '') \
THEN vtiger_activity.status ELSE vtiger_activity.eventstatus END AS status, \
vtiger_activity.activitytype, vtiger_activity.subject, vtiger_seactivityrel.crmid, \
vtiger_activity.date_start, vtiger_activity.time_start, vtiger_activity.due_date, \
vtiger_activity.time_end, vtiger_crmentity.smownerid, vtiger_activity.activityid, \
vtiger_activity.visibility FROM vtiger_activity INNER JOIN vtiger_crmentity ON \
vtiger_activity.activityid = vtiger_crmentity.crmid LEFT JOIN vtiger_seactivityrel ON \
vtiger_activity.activityid = vtiger_seactivityrel.activityid LEFT JOIN vtiger_users \
ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON \
vtiger_crmentity.smownerid = vtiger_groups.groupid INNER JOIN vt_tmp_u1_t9 \
vt_tmp_u1_t9 ON (vt_tmp_u1_t9.id = vtiger_crmentity.smownerid and \
vt_tmp_u1_t9.shared=0 and vt_tmp_u1_t9.id IN \
(5,6,6,6,6,6,6,6,6,6,6,6,6,7,7,7,7,7,7,7,7,7,8,9,10,11,12,13,13,13,13,13,13,13,13,13,13,13,13,13,18,21,22,22,22,22,22,22,22,22,22,22,22,22,22,25,27,28,1,3,14,4)) \
WHERE vtiger_crmentity.deleted=0 AND ( vtiger_activity.activitytype <> 'Emails') AND \
vtiger_activity.activityid > 0 ORDER BY modifiedtime DESC LIMIT 0, 1015 failed. Table \
'vtiger_dev.vt_tmp_u1_t9' doesn't exist
1146: Table 'vtiger_dev.vt_tmp_u1_t9' doesn't exist
ADOConnection._Execute(SELECT vtiger_activity.status, CASE \
WHEN (vtiger_activity.status not like '') THEN vtiger_activity.status ELSE \
vtiger_activity.e..., false) % line 1046, file: adodb.inc.php \
ADOConnection.Execute(SELECT vtiger_activity.status, CASE WHEN \
(vtiger_activity.status not like '') THEN vtiger_activity.status ELSE \
vtiger_activity.e..., false) % line 72, file: adodb-perf.inc.php \
adodb_log_sql(Object:ADODB_mysqli, SELECT vtiger_activity.status, CASE WHEN \
(vtiger_activity.status not like '') THEN vtiger_activity.status ELSE \
vtiger_activity.e..., false) % line 977, file: adodb.inc.php \
ADOConnection.Execute(SELECT vtiger_activity.status, CASE WHEN \
(vtiger_activity.status not like '') THEN vtiger_activity.status ELSE \
vtiger_activity.e...) % line 357, file: PearDatabase.php PearDatabase.pquery(SELECT \
vtiger_activity.status, CASE WHEN (vtiger_activity.status not like '') THEN \
vtiger_activity.status ELSE vtiger_activity.e..., Array[0]) % line 144, file: \
ListViewSession.php
Fatal error: Call to a member function FetchRow() on a non-object in \
/var/lib/shared/websites/custom/www/crmdev/include/database/PearDatabase.php on line \
532
_______________________________________________
http://www.vtiger.com/
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic