⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Search Tree view Error



fachrianlr
  • profile picture
  • Member

Posted 28 November 2018 - 09:40 AM

Hello,

 

Environment:

- php 5.6

- postgresql 9.6

- grocerycrud Enterprise 2.6.9

 

action:

- when searching in tree view of integer column and date column

 

error:

 

<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">
 
<h4>An uncaught Exception was encountered</h4>
 
<p>Type: PDOException</p>
<p>Message: SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: integer ~~ unknown
LINE 1: ..._date" FROM "res_order" WHERE res_order.sub_total LIKE '%12%...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.</p>
<p>Filename: /var/www/html/bpmks/application/libraries/GroceryCrudEnterprise/zendframework/zend-db/src/Adapter/Driver/Pdo/Connection.php</p>
<p>Line Number: 360</p>
 
 
<p>Backtrace:</p>
 
 
<p style="margin-left:10px">
File: /var/www/html/bpmks/application/libraries/GroceryCrudEnterprise/zendframework/zend-db/src/Adapter/Driver/Pdo/Connection.php<br />
Line: 360<br />
Function: query </p>
 
 
 
<p style="margin-left:10px">
File: /var/www/html/bpmks/application/libraries/GroceryCrudEnterprise/zendframework/zend-db/src/Adapter/Adapter.php<br />
Line: 190<br />
Function: execute </p>
 
 
 
<p style="margin-left:10px">
File: /var/www/html/bpmks/application/libraries/GroceryCrudEnterprise/grocerycrud/enterprise/src/GroceryCrud/Core/Model.php<br />
Line: 998<br />
Function: query </p>
 
 
 
<p style="margin-left:10px">
File: /var/www/html/bpmks/application/libraries/GroceryCrudEnterprise/grocerycrud/enterprise/src/GroceryCrud/Core/Model.php<br />
Line: 1244<br />
Function: getResultsFromSelect </p>
 
 
 
<p style="margin-left:10px">
File: /var/www/html/bpmks/application/libraries/GroceryCrudEnterprise/grocerycrud/enterprise/src/GroceryCrud/Core/State/DatagridState.php<br />
Line: 305<br />
Function: getList </p>
 
 
 
<p style="margin-left:10px">
File: /var/www/html/bpmks/application/libraries/GroceryCrudEnterprise/grocerycrud/enterprise/src/GroceryCrud/Core/State/DatagridState.php<br />
Line: 316<br />
Function: getData </p>
 
 
 
<p style="margin-left:10px">
File: /var/www/html/bpmks/application/libraries/GroceryCrudEnterprise/grocerycrud/enterprise/src/GroceryCrud/Core/GroceryCrud.php<br />
Line: 2174<br />
Function: render </p>
 
 
 
<p style="margin-left:10px">
File: /var/www/html/bpmks/application/controllers/dinas/Menu.php<br />
Line: 413<br />
Function: render </p>
 
 
 
 
 
 
 
<p style="margin-left:10px">
File: /var/www/html/bpmks/index.php<br />
Line: 315<br />
Function: require_once </p>
 
 
 
</div>