Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderators: ArturoRobles, ArturoRobles

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
By MitraDeepak
#790659
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
By mishika
#790665
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
User avatar
By amosbatto
#790686
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.
By MitraDeepak
#790695
This is trigger code.
Code: Select all
@@requisition_submission_Date = getCurrentDate();
@@[email protected]@USER_LOGGED;

[email protected]@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;
By mishika
#790698
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
User avatar
By amosbatto
#790731
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();
@@[email protected]@USER_LOGGED;
[email protected]@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;
}

Maybe try increasing your thread stack size? Seems[…]

I use PM 3.4. Android push works while IOS push do[…]

[quote=ziadeh post_id=823031 time=1550759948 user_[…]

I have to support reports in processmaker 3.4. A s[…]