search

art1c0 / mooha

Automatically exported from code.google.com/p/mooha
0 stars 0 forks source link

Mysql query in _deleteItem only supports decimal client_item_id #22

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
The query in _deleteItem uses %5$d to store the client_item_id, which breaks 
client item ids that are not numeric. A quick grep shows that all other queries 
regarding client_item_id are ok. The attached patch fixes this.

Original issue reported on code.google.com by matthijskooijman@gmail.com on 1 Sep 2010 at 7:12

Attachments:

GoogleCodeExporter commented 9 years ago 
_addItem is also affected. My device sends luids that are numeric, but greater 
than will fit in a php integer, so all client_item_ids in my db are 2147483647.

Attached an updated path.

Original comment by d.de...@gmail.com on 28 Dec 2010 at 4:38

Attachments: