SuiteCRM Error

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

I get this error repeated in the logs over and over.
The ID in the query structure is blank.
Not sure How to correct this.

Mon Jul 9 14:42:06 2018 [7100][73099ce5-4960-cab0-ba39-4612737fcd9f][FATAL] Error running count query for Meeting List: Query Failed: SELECT count(*) c FROM meetings LEFT JOIN meetings_cstm ON meetings.id = meetings_cstm.id_c LEFT JOIN users jt0 ON meetings.modified_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 LEFT JOIN users jt1 ON meetings.created_by=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 LEFT JOIN users jt2 ON meetings.assigned_user_id=jt2.id AND jt2.deleted=0

AND jt2.deleted=0 where (id = ) AND meetings.deleted=0

#2

You’re not telling us your SuiteCRM version, but I am pretty sure you’re not using the latest, since this error was coming up a lot in some version a while ago, and then it was fixed.

Can you upgrade?

#3

I apologize.

Version is 7.10.7
Mysql 5.7
IIS 8.5
PHP 7.2

This PHP Error seems to be associated

Stack trace:
#0 C:\Sugarcrm\include\database\DBManager.php(353): sugar_die(‘Database failur…’)
#1 C:\Sugarcrm\include\database\DBManager.php(328): DBManager->registerError(‘Error running c…’, ‘Error running c…’, true)
#2 C:\Sugarcrm\include\database\MysqliManager.php(177): DBManager->checkError(‘Error running c…’, true)
#3 C:\Sugarcrm\data\SugarBean.php(4202): MysqliManager->query(’ SELECT count(*…’, true, ‘Error running c…’)
#4 C:\Sugarcrm\service\v4\SugarWebServiceUtilv4.php(109): SugarBean->process_list_query(’ SELECT meetin…’, 0, -1, ‘20’, 'id = ')
#5 C:\Sugarcrm\service\v4\SugarWebServiceImplv4.php(306): SugarWebServiceUtilv4->get_data_list(Object(Meeting), ‘date_entered DE…’, 'id = ', 0, -1, -1, false, false)
#6 C:\Sugarcrm\service\core\REST\SugarRestJSON.php(91): SugarWebServiceImplv4->get_entry_list(‘s4a2k30hhatbmtv…’, ‘Meetings’, 'id = ', ‘date_entered DE…’, 0, Ar in C:\Sugarcrm\include\utils.php on line 1772
[10-Jul-2018 07:57:43 America/Tegucigalpa] PHP Notice: Undefined variable: module_sub_panels in C:\Sugarcrm\include\SubPanel\SubPanelTiles.php on line 377
[10-Jul-2018 07:57:43 America/Tegucigalpa] PHP Warning: array_map(): Argument #2 should be an array in C:\Sugarcrm\include\SubPanel\SubPanelTiles.php on line 377
[10-Jul-2018 07:57:45 America/Tegucigalpa] PHP Fatal error: Uncaught Error: Call to undefined function mime_content_type() in C:\Sugarcrm\download.php:183

#4

Hi KingMonkey,

For the PHP fatal I believe this issue has the solution: https://github.com/salesagility/SuiteCRM/issues/1863. It should be as simple as enabling the extension in your php.ini.

#5

I wasn’t expecting this on 7.10.7 :frowning:

Exactly which screen do you go to, to produce this error? Please give me a list of “steps to reproduce”.

Also, what is the line immediately before this stack trace that you gave me? That is where the actual error is.

The structure of log entries is

ERROR MSG
0 STACK TRACE
1 STACK TRACE
2 STACK TRACE
3 STACK TRACE
etc

Thanks for reporting