I have a simple php file with render_complex_sql that was working on the previous version of the DHTMLX suite. After upgrading to version 4.2 I can’t get even a very basic sql statement to work with render_complex_sql. Every request returns a PHP error 500.
I found an updated version of the php connector from stanislav in this forum but it is quite old and made no difference.
Here is the code I have right now.
require_once("codebase/grid_connector.php"); $gridConn= new GridConnector($res); $sql = "select deviceID,displayName"; $sql .= " from_unixtime(lastTotalConnectTime) as lastContact, from_unixtime(expirationTime) as expirationTime, licensePlate"; $sql .= " from Device where accountID = '$acc' order by accountID, deviceID asc"; $gridConn->render_complex_sql($sql,"deviceID","displayName,lastContact,expirationTime,licensePlate");
help please. I need this to work.