Connection error to sql db

Scheduler Javascript
#1

Hi,

I get problems connecting properly to sql db. Error is posted bellow. I can see entries being made to db, but empty as no data is passed along.
Any suggestions?

I have tried different ways for the connection. DB is populated with samplefile from downloadfile.

Config is currently set up like this:

//require_once(dirname(FILE).’/connector/scheduler_connector.php’);
$dbtype = “MySQL”;

$res=mysql_connect(“xxxxxxxxx”, “xxxxx”, “xxxxxxx”);
mysql_select_db(“schedulertest”);

$conn = new SchedulerConnector($res);
$conn->render_table(“events”,“event_id”,“start_date,end_date,event_name,details”);

==============================
Fatal error: Uncaught exception ‘Exception’ with message ‘MySQL operation failed
Unknown column ‘dhx_auto_id’ in ‘field list’’ in /hermes/waloraweb003/b2232/pow.cornelius/htdocs/planner/dmx/samples/common/connector/db_common.php:1011
Stack trace:
#0 /hermes/waloraweb003/b2232/pow.cornelius/htdocs/planner/dmx/samples/common/connector/db_common.php(670): MySQLDBDataWrapper->query(‘SELECT `dhx_aut…’)
#1 /hermes/waloraweb003/b2232/pow.cornelius/htdocs/planner/dmx/samples/common/connector/base_connector.php(531): DBDataWrapper->select(Object(DataRequestConfig))
#2 /hermes/waloraweb003/b2232/pow.cornelius/htdocs/planner/dmx/samples/common/connector/base_connector.php(512): Connector->get_resource()
#3 /hermes/waloraweb003/b2232/pow.cornelius/htdocs/planner/dmx/samples/common/connector/base_connector.php(409): Connector->render()
#4 /hermes/waloraweb003/b2232/pow.cornelius/htdocs/planner/dmx/samples/01_initialization_loading/data/types.php(10): Connector->render_table(‘tevents’, ‘event_id’, ‘start_date,end_…’)
#5 {main}
th in /hermes/waloraweb003/b2232/pow.cornelius/htdocs/planner/dmx/samples/common/connector/db_common.php on line 1011<br /

#2

Do anyone have a successful sql connection they can paste here for me to compare?

#3

Your code looks correct, the error similar to the above one can appear if you have not specified id parameter in the render_table command. Or has specified the incorrect one

The common connection code will look like next

[code]$res=mysql_connect(“localhost”, “root”, “”);
mysql_select_db(“schedulertest”);

$scheduler = new schedulerConnector($res);
$scheduler->render_table(“events”,“event_id”,“start_date,end_date,event_name,details”);[/code]

#4

Hi,
After some trails the error disappered. Another emerged about cloned results in common.php. This was related to zend settings in php.ini.

I suspect that was the root to all problems.

But thx for answers.

Jim