[Vtigercrm-developers] visibility of calendar entries
Tim Mohrbach
preexo at googlemail.com
Tue Dec 22 03:34:47 GMT 2015
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 at 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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20151222/7f4e063c/attachment-0001.html>
-------------- next part --------------
(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
More information about the vtigercrm-developers
mailing list