[sr-dev] [kamailio] quoted words reserved by mysql (#159)

[Oleksandr Dombrovskyi]

Guys, i have found another bug related to the **partition** column. Take a look at this log from kamailio:

```
May 13 16:22:01 localhost /usr/local/sbin/kamailio[24862]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: 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 'partition ) values ('1000','sip:1000 at 89.209.124.148:64403;transport=tcp','2015-0' at line 1
May 13 16:22:01 localhost /usr/local/sbin/kamailio[24862]: ERROR: <core> [db_query.c:233]: db_do_insert_cmd(): error while submitting query
May 13 16:22:01 localhost /usr/local/sbin/kamailio[24862]: ERROR: usrloc [ucontact.c:683]: db_insert_ucontact(): inserting contact in db failed
May 13 16:22:01 localhost /usr/local/sbin/kamailio[24862]: ERROR: usrloc [urecord.c:580]: insert_ucontact(): failed to insert in database
May 13 16:22:01 localhost /usr/local/sbin/kamailio[24862]: ERROR: registrar [save.c:507]: insert_contacts(): failed to insert contact
May 13 16:22:17 localhost /usr/local/sbin/kamailio[24861]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: 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 'partition ) values ('1000','sip:1000 at 89.209.124.148:64403;transport=tcp','2015-0' at line 1
May 13 16:22:17 localhost /usr/local/sbin/kamailio[24861]: ERROR: <core> [db_query.c:233]: db_do_insert_cmd(): error while submitting query
May 13 16:22:17 localhost /usr/local/sbin/kamailio[24861]: ERROR: usrloc [ucontact.c:683]: db_insert_ucontact(): inserting contact in db failed
May 13 16:22:17 localhost /usr/local/sbin/kamailio[24861]: ERROR: usrloc [urecord.c:580]: insert_ucontact(): failed to insert in database
May 13 16:22:17 localhost /usr/local/sbin/kamailio[24861]: ERROR: registrar [save.c:507]: insert_contacts(): failed to insert contact
May 13 16:22:23 localhost /usr/local/sbin/kamailio[24861]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: 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 'partition ) values ('1000','sip:1000 at 89.209.124.148:64403;transport=tcp','2015-0' at line 1
May 13 16:22:23 localhost /usr/local/sbin/kamailio[24861]: ERROR: <core> [db_query.c:233]: db_do_insert_cmd(): error while submitting query
May 13 16:22:23 localhost /usr/local/sbin/kamailio[24861]: ERROR: usrloc [ucontact.c:683]: db_insert_ucontact(): inserting contact in db failed
May 13 16:22:23 localhost /usr/local/sbin/kamailio[24861]: ERROR: usrloc [urecord.c:580]: insert_ucontact(): failed to insert in database
May 13 16:22:23 localhost /usr/local/sbin/kamailio[24861]: ERROR: registrar [save.c:507]: insert_contacts(): failed to insert contact
May 13 16:22:23 localhost /usr/local/sbin/kamailio[24861]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: 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 'partition ) values ('1000','sip:1000 at 89.209.124.148:64403;transport=tcp','2015-0' at line 1
May 13 16:22:23 localhost /usr/local/sbin/kamailio[24861]: ERROR: <core> [db_query.c:233]: db_do_insert_cmd(): error while submitting query
May 13 16:22:23 localhost /usr/local/sbin/kamailio[24861]: ERROR: usrloc [ucontact.c:683]: db_insert_ucontact(): inserting contact in db failed
May 13 16:22:23 localhost /usr/local/sbin/kamailio[24861]: ERROR: usrloc [urecord.c:580]: insert_ucontact(): failed to insert in database
May 13 16:22:23 localhost /usr/local/sbin/kamailio[24861]: ERROR: registrar [save.c:507]: insert_contacts(): failed to insert contact
May 13 16:22:24 localhost /usr/local/sbin/kamailio[24861]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: 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 'partition ) values ('1000','sip:1000 at 89.209.124.148:64403;transport=tcp','2015-0' at line 1
May 13 16:22:24 localhost /usr/local/sbin/kamailio[24861]: ERROR: <core> [db_query.c:233]: db_do_insert_cmd(): error while submitting query
May 13 16:22:24 localhost /usr/local/sbin/kamailio[24861]: ERROR: usrloc [ucontact.c:683]: db_insert_ucontact(): inserting contact in db failed
May 13 16:22:24 localhost /usr/local/sbin/kamailio[24861]: ERROR: usrloc [urecord.c:580]: insert_ucontact(): failed to insert in database
May 13 16:22:24 localhost /usr/local/sbin/kamailio[24861]: ERROR: registrar [save.c:507]: insert_contacts(): failed to insert contact
May 13 16:23:24 localhost /usr/local/sbin/kamailio[24862]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: 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 'partition ) values ('1000','sip:1000 at 89.209.124.148:64403;transport=tcp','2015-0' at line 1
May 13 16:23:24 localhost /usr/local/sbin/kamailio[24862]: ERROR: <core> [db_query.c:233]: db_do_insert_cmd(): error while submitting query
May 13 16:23:24 localhost /usr/local/sbin/kamailio[24862]: ERROR: usrloc [ucontact.c:683]: db_insert_ucontact(): inserting contact in db failed
May 13 16:23:24 localhost /usr/local/sbin/kamailio[24862]: ERROR: usrloc [urecord.c:580]: insert_ucontact(): failed to insert in database
May 13 16:23:24 localhost /usr/local/sbin/kamailio[24862]: ERROR: registrar [save.c:507]: insert_contacts(): failed to insert contact
```

---
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/pull/159#issuecomment-101736388
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20150513/6e71c853/attachment.html>