You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

Pages: 1

#1 2012-06-19 16:52:47

pyueshd
Member
Registered: 2011-05-24
Posts: 50

Errors in sql-errors.log

Hi

I am running glpi version 0.83.1, with php 5.2.17 on Freebsd 7.0.  I have the following errors popping up :

19-06-2012 16:09
*** MySQL query error :
***
SQL: INSERT
                   INTO `glpi_tickets` (`content`,`name`,`urgency`,`itemtype`,`requesttypes_id`,`entities_id`,`impact`,`priority`,`users_id_recipient`,`status`,`date`,`suppliers_id_assign`,`itilcategories_id`,`global_validation`,`items_id`,`type`,`date_mod`) VALUES (\'Willem to phone Megan from Crawford- 011 883 5711 \\n \\n Kind Regards \\n \\n Thandeka Nxumalo \\n Beginning 2 End Technologies (PTY) Ltd \\n \\n \\n Networking | Professional Services | Broadband | Hosting and Internet Services \\n \\n Oxford Manor | 2 nd Floor | Unit 208 | 196 Oxford Road | Illovo | Johannesburg | 2196 \\n Tel: 0861 223 223 | Fax: 0865 009 240 | Cell: 082 389 1244 \\n Email: thandekan@b2e.co.za | Support: support@b2e.co.za | Sales: sales@b2e.co.za \\n Web: http://www.b2e.co.za | http://www.b2einternet.co.za \\n Disclaimer: http://www.b2e.co.za/disclaimer.html','Willem to phone Megan from Crawford- 011 883 5711 \\n \\n Kind Regards \\\',\'3\',\'\',\'2\',\'23\',\'3\',\'3\',\'185\',\'new\',\'2012-06-19 16:09:01\',0,\'5\',\'none\',0,\'1\',\'2012-06-19 16:09:01\')
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3','','2','23','3','3','185','new','2012-06-19 16:09:01',0,'5','none',0,'1','201' at line 2
Backtrace :
/usr/local/www/apache22/data/inc/commondbtm.class.php :368         DBmysql->query()
/usr/local/www/apache22/data/inc/commondbtm.class.php :695         CommonDBTM->addToDB()
/usr/local/www/apache22/data/inc/mailcollector.class.php :461              CommonDBTM->add()
/usr/local/www/apache22/data/inc/mailcollector.class.php :1291             MailCollector->collect()
 :         MailCollector::cronMailgate()
/usr/local/www/apache22/data/inc/crontask.class.php :758           call_user_func()
/usr/local/www/apache22/data/front/cron.php :83            CronTask::launch()
/usr/local/www/apache22/data/front/cron.php

19-06-2012 16:09
*** MySQL query error :
***
SQL: INSERT
                   INTO `glpi_tickets` (`content`,`name`,`urgency`,`itemtype`,`requesttypes_id`,`entities_id`,`impact`,`priority`,`users_id_recipient`,`status`,`date`,`suppliers_id_assign`,`itilcategories_id`,`global_validation`,`items_id`,`type`,`date_mod`) VALUES (\'Please phone Pat from Assa \\n \\n Kind Regards \\n \\n Thandeka Nxumalo \\n Beginning 2 End Technologies (PTY) Ltd \\n \\n \\n Networking | Professional Services | Broadband | Hosting and Internet Services \\n \\n Oxford Manor | 2 nd Floor | Unit 208 | 196 Oxford Road | Illovo | Johannesburg | 2196 \\n Tel: 0861 223 223 | Fax: 0865 009 240 | Cell: 082 389 1244 \\n Email: thandekan@b2e.co.za | Support: support@b2e.co.za | Sales: sales@b2e.co.za \\n Web: http://www.b2e.co.za | http://www.b2einternet.co.za \\n Disclaimer: http://www.b2e.co.za/disclaimer.html','Please phone Pat from Assa \\n \\n Kind Regards \\n \\n Thandeka Nxumalo \\\',\'3\',\'\',\'2\',\'23\',\'3\',\'3\',\'185\',\'new\',\'2012-06-19 16:09:01\',0,\'5\',\'none\',0,\'1\',\'2012-06-19 16:09:01\')
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3','','2','23','3','3','185','new','2012-06-19 16:09:01',0,'5','none',0,'1','201' at line 2
Backtrace :
/usr/local/www/apache22/data/inc/commondbtm.class.php :368         DBmysql->query()
/usr/local/www/apache22/data/inc/commondbtm.class.php :695         CommonDBTM->addToDB()
/usr/local/www/apache22/data/inc/mailcollector.class.php :461              CommonDBTM->add()
/usr/local/www/apache22/data/inc/mailcollector.class.php :1291             MailCollector->collect()
 :         MailCollector::cronMailgate()
/usr/local/www/apache22/data/inc/crontask.class.php :758           call_user_func()
/usr/local/www/apache22/data/front/cron.php :83            CronTask::launch()
/usr/local/www/apache22/data/front/cron.php

19-06-2012 16:09
*** MySQL query error :
***
SQL: INSERT
                   INTO `glpi_tickets` (`content`,`name`,`urgency`,`itemtype`,`requesttypes_id`,`entities_id`,`impact`,`priority`,`users_id_recipient`,`status`,`date`,`suppliers_id_assign`,`itilcategories_id`,`global_validation`,`items_id`,`type`,`date_mod`) VALUES (\'Please phone Jonathan on 082 654 7992, he needs technical support \\n \\n Kind Regards \\n \\n Thandeka Nxumalo \\n Beginning 2 End Technologies (PTY) Ltd \\n \\n \\n Networking | Professional Services | Broadband | Hosting and Internet Services \\n \\n Oxford Manor | 2 nd Floor | Unit 208 | 196 Oxford Road | Illovo | Johannesburg | 2196 \\n Tel: 0861 223 223 | Fax: 0865 009 240 | Cell: 082 389 1244 \\n Email: thandekan@b2e.co.za | Support: support@b2e.co.za | Sales: sales@b2e.co.za \\n Web: http://www.b2e.co.za | http://www.b2einternet.co.za \\n Disclaimer: http://www.b2e.co.za/disclaimer.html','Please phone Jonathan on 082 654 7992, he needs technical support \\n \\\',\'3\',\'\',\'2\',\'23\',\'3\',\'3\',\'185\',\'new\',\'2012-06-19 16:09:01\',0,\'5\',\'none\',0,\'1\',\'2012-06-19 16:09:01\')
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3','','2','23','3','3','185','new','2012-06-19 16:09:01',0,'5','none',0,'1','201' at line 2
Backtrace :
/usr/local/www/apache22/data/inc/commondbtm.class.php :368         DBmysql->query()
/usr/local/www/apache22/data/inc/commondbtm.class.php :695         CommonDBTM->addToDB()
/usr/local/www/apache22/data/inc/mailcollector.class.php :461              CommonDBTM->add()
/usr/local/www/apache22/data/inc/mailcollector.class.php :1291             MailCollector->collect()
 :         MailCollector::cronMailgate()
/usr/local/www/apache22/data/inc/crontask.class.php :758           call_user_func()
/usr/local/www/apache22/data/front/cron.php :83            CronTask::launch()
/usr/local/www/apache22/data/front/cron.php

19-06-2012 16:09
*** MySQL query error :
***
SQL: INSERT
                   INTO `glpi_tickets` (`content`,`name`,`urgency`,`itemtype`,`requesttypes_id`,`entities_id`,`impact`,`priority`,`users_id_recipient`,`status`,`date`,`suppliers_id_assign`,`itilcategories_id`,`global_validation`,`items_id`,`type`,`date_mod`) VALUES (\'Please phone Denys back- Issues with his Graph \\n \\n Kind Regards \\n \\n Thandeka Nxumalo \\n Beginning 2 End Technologies (PTY) Ltd \\n \\n \\n Networking | Professional Services | Broadband | Hosting and Internet Services \\n \\n Oxford Manor | 2 nd Floor | Unit 208 | 196 Oxford Road | Illovo | Johannesburg | 2196 \\n Tel: 0861 223 223 | Fax: 0865 009 240 | Cell: 082 389 1244 \\n Email: thandekan@b2e.co.za | Support: support@b2e.co.za | Sales: sales@b2e.co.za \\n Web: http://www.b2e.co.za | http://www.b2einternet.co.za \\n Disclaimer: http://www.b2e.co.za/disclaimer.html','Please phone Denys back- Issues with his Graph \\n \\n Kind Regards \\n \\\',\'3\',\'\',\'2\',\'23\',\'3\',\'3\',\'185\',\'new\',\'2012-06-19 16:09:01\',0,\'5\',\'none\',0,\'1\',\'2012-06-19 16:09:01\')
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3','','2','23','3','3','185','new','2012-06-19 16:09:01',0,'5','none',0,'1','201' at line 2
Backtrace :
/usr/local/www/apache22/data/inc/commondbtm.class.php :368         DBmysql->query()
/usr/local/www/apache22/data/inc/commondbtm.class.php :695         CommonDBTM->addToDB()
/usr/local/www/apache22/data/inc/mailcollector.class.php :461              CommonDBTM->add()
/usr/local/www/apache22/data/inc/mailcollector.class.php :1291             MailCollector->collect()
 :         MailCollector::cronMailgate()
/usr/local/www/apache22/data/inc/crontask.class.php :758           call_user_func()
/usr/local/www/apache22/data/front/cron.php :83            CronTask::launch()
/usr/local/www/apache22/data/front/cron.php

19-06-2012 16:09
*** MySQL query error :
***
SQL: INSERT
                   INTO `glpi_tickets` (`content`,`name`,`urgency`,`itemtype`,`requesttypes_id`,`entities_id`,`impact`,`priority`,`users_id_recipient`,`status`,`date`,`suppliers_id_assign`,`itilcategories_id`,`global_validation`,`items_id`,`type`,`date_mod`) VALUES (\'Please phone Lenore back- Issues with the printer \\n \\n Kind Regards \\n \\n Thandeka Nxumalo \\n Beginning 2 End Technologies (PTY) Ltd \\n \\n \\n Networking | Professional Services | Broadband | Hosting and Internet Services \\n \\n Oxford Manor | 2 nd Floor | Unit 208 | 196 Oxford Road | Illovo | Johannesburg | 2196 \\n Tel: 0861 223 223 | Fax: 0865 009 240 | Cell: 082 389 1244 \\n Email: thandekan@b2e.co.za | Support: support@b2e.co.za | Sales: sales@b2e.co.za \\n Web: http://www.b2e.co.za | http://www.b2einternet.co.za \\n Disclaimer: http://www.b2e.co.za/disclaimer.html','Please phone Lenore back- Issues with the printer \\n \\n Kind Regards \\\',\'3\',\'\',\'2\',\'23\',\'3\',\'3\',\'185\',\'new\',\'2012-06-19 16:09:01\',0,\'5\',\'none\',0,\'1\',\'2012-06-19 16:09:01\')
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3','','2','23','3','3','185','new','2012-06-19 16:09:01',0,'5','none',0,'1','201' at line 2
Backtrace :
/usr/local/www/apache22/data/inc/commondbtm.class.php :368         DBmysql->query()
/usr/local/www/apache22/data/inc/commondbtm.class.php :695         CommonDBTM->addToDB()
/usr/local/www/apache22/data/inc/mailcollector.class.php :461              CommonDBTM->add()
/usr/local/www/apache22/data/inc/mailcollector.class.php :1291             MailCollector->collect()
 :         MailCollector::cronMailgate()
/usr/local/www/apache22/data/inc/crontask.class.php :758           call_user_func()
/usr/local/www/apache22/data/front/cron.php :83            CronTask::launch()
/usr/local/www/apache22/data/front/cron.php

***
SQL: INSERT
                   INTO `glpi_tickets` (`content`,`name`,`urgency`,`itemtype`,`requesttypes_id`,`entities_id`,`impact`,`priority`,`users_id_recipient`,`status`,`date`,`suppliers_id_assign`,`itilcategories_id`,`global_validation`,`items_id`,`type`,`date_mod`) VALUES (\'Please phone Leoni from Crawford Fourways, issues with her laptop \\n \\n Kind Regards \\n \\n Thandeka Nxumalo \\n Beginning 2 End Technologies (PTY) Ltd \\n \\n \\n Networking | Professional Services | Broadband | Hosting and Internet Services \\n \\n Oxford Manor | 2 nd Floor | Unit 208 | 196 Oxford Road | Illovo | Johannesburg | 2196 \\n Tel: 0861 223 223 | Fax: 0865 009 240 | Cell: 082 389 1244 \\n Email: thandekan@b2e.co.za | Support: support@b2e.co.za | Sales: sales@b2e.co.za \\n Web: http://www.b2e.co.za | http://www.b2einternet.co.za \\n Disclaimer: http://www.b2e.co.za/disclaimer.html','Please phone Leoni from Crawford Fourways, issues with her laptop \\n \\\',\'3\',\'\',\'2\',\'23\',\'3\',\'3\',\'185\',\'new\',\'2012-06-19 16:09:01\',0,\'5\',\'none\',0,\'1\',\'2012-06-19 16:09:01\')
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3','','2','23','3','3','185','new','2012-06-19 16:09:01',0,'5','none',0,'1','201' at line 2
Backtrace :
/usr/local/www/apache22/data/inc/commondbtm.class.php :368         DBmysql->query()
/usr/local/www/apache22/data/inc/commondbtm.class.php :695         CommonDBTM->addToDB()
/usr/local/www/apache22/data/inc/mailcollector.class.php :461              CommonDBTM->add()
/usr/local/www/apache22/data/inc/mailcollector.class.php :1291             MailCollector->collect()
 :         MailCollector::cronMailgate()
/usr/local/www/apache22/data/inc/crontask.class.php :758           call_user_func()
/usr/local/www/apache22/data/front/cron.php :83            CronTask::launch()
/usr/local/www/apache22/data/front/cron.php

19-06-2012 16:09
*** MySQL query error :
***
SQL: INSERT
                   INTO `glpi_tickets` (`content`,`name`,`urgency`,`itemtype`,`requesttypes_id`,`entities_id`,`impact`,`priority`,`users_id_recipient`,`status`,`date`,`suppliers_id_assign`,`itilcategories_id`,`global_validation`,`items_id`,`type`,`date_mod`) VALUES (\'Please phone Mark from Argus Motors- 011 747 5224 \\n \\n Kind Regards \\n \\n Thandeka Nxumalo \\n Beginning 2 End Technologies (PTY) Ltd \\n \\n \\n Networking | Professional Services | Broadband | Hosting and Internet Services \\n \\n Oxford Manor | 2 nd Floor | Unit 208 | 196 Oxford Road | Illovo | Johannesburg | 2196 \\n Tel: 0861 223 223 | Fax: 0865 009 240 | Cell: 082 389 1244 \\n Email: thandekan@b2e.co.za | Support: support@b2e.co.za | Sales: sales@b2e.co.za \\n Web: http://www.b2e.co.za | http://www.b2einternet.co.za \\n Disclaimer: http://www.b2e.co.za/disclaimer.html','Please phone Mark from Argus Motors- 011 747 5224 \\n \\n Kind Regards \\\',\'3\',\'\',\'2\',\'23\',\'3\',\'3\',\'185\',\'new\',\'2012-06-19 16:09:01\',0,\'5\',\'none\',0,\'1\',\'2012-06-19 16:09:01\')
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3','','2','23','3','3','185','new','2012-06-19 16:09:01',0,'5','none',0,'1','201' at line 2
Backtrace :
/usr/local/www/apache22/data/inc/commondbtm.class.php :368         DBmysql->query()
/usr/local/www/apache22/data/inc/commondbtm.class.php :695         CommonDBTM->addToDB()
/usr/local/www/apache22/data/inc/mailcollector.class.php :461              CommonDBTM->add()
/usr/local/www/apache22/data/inc/mailcollector.class.php :1291             MailCollector->collect()
 :         MailCollector::cronMailgate()
/usr/local/www/apache22/data/inc/crontask.class.php :758           call_user_func()
/usr/local/www/apache22/data/front/cron.php :83            CronTask::launch()
/usr/local/www/apache22/data/front/cron.php

The errors continually pop up in the sql error log file.  Can someone assist ?

Regards

Offline

Pages: 1

Board footer

Powered by FluxBB