Re: missing presence packet

2015-12-08 Thread Shawn Debnath
Typically, the hyphen is a special character and the string containing it has to be escaped correctly. Also evident from the way “object-sequence” or the column names are escaped in the debug log. Have you tried running the query on the database itself to check the results? Googling for mysql

Re: missing presence packet

2015-12-08 Thread Stepan Salenikovich
Hi, So I recompiled with --debug-enabled and ran with -D checking the sm debug log, it seems the issue is that when user A logs back on, it's roster appears empty (ie: the mysql query returns with 0 items)... however, when I perform that same query on the db myself, I get several items. Heres

Re: missing presence packet

2015-12-08 Thread Stepan Salenikovich
> Have you tried running the query on the database itself to check the results? Yes, running the query on the databae directly gives the correct result. Howver, I have just noticed that a minute earlier in the log, this query works as it should as well (returning several rows, including the