GridConnector doesn't return data - error on line 1 at colu

Suite 7.0/6.0/5.0 and Optimus Suite 5.0
#1

I am trying to bind the Grid to a MySQL datasource using the GridConnector on a server-side PHP file. When I open the HTML file which contains the grid I get this popup:
Error type: LoadXML
Description: Incorrect XML

If I call the URL of the server-side php script directly I receive this error message:

This page contains the following errors:
error on line 1 at column 1: Document is empty
Below is a rendering of the page up to the first error.

Here is my server side php script which has been taken out of one of your samples:

<?php require_once("dhtml/codebase/grid_connector.php"); $res=mysql_connect("localhost","root",""); mysql_select_db("test"); $grid = new GridConnector($res); $grid->enable_log("temp.log",true); $grid->render_table("groups","id","name"); ?>

Here is my “temp.log” file:

Log started, 25/10/2010 09:10:51

SELECT id,name FROM groups
Done in 0.0009310245513916s

As a side note, my /var/log/httpd/error_log is clean.

My environment is:
Linux CentOS 5.5 2.6.35.4 x86_64
Apache/2.2.3
MySQL 5.0.77
PHP Version 5.1.6

Can you point me into the right direction? Is this an apache/mysql/php configuration issue?

Thank you!

#2

One more thing. When I do a “wget” on the getgroups.php file I can see the response… It’s only a small: Object id #7

Thanks again!

#3

Nevermind… updating to PHP 5.2 or higher apparently does the trick!

Thanks!