Insert error

Scheduler Javascript
#1

Hello,

I have a problem when i want insert a new event :

mysql_real_escape_string() expects parameter 2 to be resource, boolean given at F:\Developpement\Workspaces\web\data\db_common.php line 1008

When i check my connector i don’t see where is the error.

This my connector.php :

$res=mysql_connect("172.16.0.2","user","password");
mysql_select_db("sceduledb");
 
$conn = new SchedulerConnector($res);
$conn->enable_log("temp.log");
 
$conn->render_table("Calendar","id","event_start,event_end,event_text");

My table :

Column Type Null Default Comments
id int(11) No
event_start datetime No
event_end datetime No
event_text varchar(255) No

<script>

       scheduler.config.xml_date="%Y-%m-%d %H:%i";
       scheduler.init('scheduler_here',null,"month");
       scheduler.load("/data/connector.php");

       var dp = new dataProcessor("/data/connector.php");
       dp.init(scheduler);

    </script>

And the result of my log :


====================================
Log started, 16/05/2013 02:19:30
====================================

DataProcessor object initialized
1368706763942_start_date => 2013-05-10 00:00
1368706763942_end_date => 2013-05-10 00:05
1368706763942_text => New event
1368706763942_id => 1368706763942
1368706763942_!nativeeditor_status => inserted
ids => 1368706763942

Row data [1368706763942]
event_start => 2013-05-10 00:00
event_end => 2013-05-10 00:05
event_text => New event
id => 1368706763942
!nativeeditor_status => inserted

mysql_real_escape_string() expects parameter 2 to be resource, boolean given at F:\Developpement\Workspaces\web\data\db_common.php line 1008

mysql_real_escape_string() expects parameter 2 to be resource, boolean given at F:\Developpement\Workspaces\web\data\db_common.php line 1008

mysql_real_escape_string() expects parameter 2 to be resource, boolean given at F:\Developpement\Workspaces\web\data\db_common.php line 1008

INSERT INTO Calendar(`event_start`,`event_end`,`event_text`) VALUES ('','','')

mysql_query() expects parameter 2 to be resource, boolean given at F:\Developpement\Workspaces\web\data\db_common.php line 990

mysql_insert_id() expects parameter 1 to be resource, boolean given at F:\Developpement\Workspaces\web\data\db_common.php line 1004

Edit operation finished
0 => action:inserted; sid:1368706763942; tid:;

Done in 0.083801984786987s
#2

Such error can occur if you have provided wrong db credentials, $res variable didn’t get the valid db channel, and above error occurs.

#3

Hi,

The problem is solve thank you. The problem was the conndction mysql