[MitraDeepak]

Hi, Friends! Could you help me?

I get this error message when I try to create a new case:

System Exception.

RuntimeException:
[wrapped: It is not possible to execute the query. Please contact your system administrator]
At BasePeer::doSelect()
in /opt/processmaker/shared/sites/workflow/classes/om/BasePmtVehiclefacilitytrackerreportPeer.php line 458
At BasePmtVehiclefacilitytrackerreportPeer::doSelectRS()
in /opt/processmaker/shared/sites/workflow/classes/om/BasePmtVehiclefacilitytrackerreportPeer.php line 426
At BasePmtVehiclefacilitytrackerreportPeer::doSelect()
in /opt/processmaker/workflow/engine/classes/model/AdditionalTables.php(829) : eval()'d code line 1
At eval() in /opt/processmaker/workflow/engine/classes/model/AdditionalTables.php line 829
At AdditionalTables->updateReportTables()
in /opt/processmaker/workflow/engine/classes/class.case.php line 2145
At Cases->updateCase()
in /opt/processmaker/workflow/engine/methods/cases/cases_Step.php line 238
At require_once() in /opt/processmaker/workflow/public_html/sysGeneric.php line 2027
At include() in /opt/processmaker/workflow/public_html/app.php line 61

[mishika]

Hello,

Have you applied a trigger which is executing a SQL query when you start a case, i.e. before the first step?
If so, please check the SQL query. There is a problem with some SQL query being fired on your PM table(PmtVehiclefacilitytrackerreport).

If there is a trigger or another mode of SQL query you have added, please share it here, as it will help better debug the problem.

Hope this helps

Best Regards
Mishika

[amosbatto]

What versions of PHP and MySQL are you using? ProcessMaker is only compatible with PHP 5.5 and 5.6. Those look like the kinds of errors that occur with PHP 7.

[MitraDeepak]

This is trigger code.

Code: Select all

@@requisition_submission_Date = getCurrentDate();
@@requisitor_id=@@USER_LOGGED;

$requisitor_id=@@requisitor_id;


$db = "773267866581206092d62d8023724286";

  $select_data= "select count(vrlf_APP_STATUS) as not_filled_id from vr_local_tour_passengers_feedback where vrldf_passenger_feedback_author_id='$requisitor_id' and vrlf_APP_STATUS='TO_DO'";
	
	$result=executeQuery($select_data,$db);
	
		if (is_array($result) and count($result) > 0)
		$not_filled_id= $result[1]['not_filled_id'];

@@local_feedback_status=$not_filled_id;

 $select_data1="select count(vropf_APP_STATUS) as not_filled_id from vr_outstation_passengers_feedback where vropf_passenger_feedback_author_id='$requisitor_id' and vropf_APP_STATUS='TO_DO'";
	

	$result1=executeQuery($select_data1,$db);
	
		if (is_array($result1) and count($result1) > 0)
		$not_filled_id1= $result1[1]['not_filled_id'];

@@outstation_feedback_status=$not_filled_id1;

[mishika]

Hello,

Please provide the PHP and MYSQL version you are working on as Amos is correct about the error when working with ProcessMaker on PHP 7.
Also, what operating system are you using?

Best Regards
Mishika

[amosbatto]

Your problem might be that you are trying to reference variables which aren't being defined or one of your queries has an error such as a misspelled database field. Do it this way:

Code: Select all

@@requisition_submission_Date = getCurrentDate();
@@requisitor_id=@@USER_LOGGED;
$requisitor_id=@@requisitor_id;
$db = "773267866581206092d62d8023724286";

$select_data= "select count(vrlf_APP_STATUS) as not_filled_id from vr_local_tour_passengers_feedback 
      where vrldf_passenger_feedback_author_id='$requisitor_id' and vrlf_APP_STATUS='TO_DO'";
   
$result=executeQuery($select_data,$db);
   
if (is_array($result) and count($result) > 0) {
      $not_filled_id= $result[1]['not_filled_id'];
      @@local_feedback_status=$not_filled_id;
}

$select_data1="select count(vropf_APP_STATUS) as not_filled_id from vr_outstation_passengers_feedback 
    where vropf_passenger_feedback_author_id='$requisitor_id' and vropf_APP_STATUS='TO_DO'";

$result1=executeQuery($select_data1,$db);
   
if (is_array($result1) and count($result1) > 0) {
   $not_filled_id1= $result1[1]['not_filled_id'];
   @@outstation_feedback_status=$not_filled_id1;
}