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
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
> 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