Discover fails on external database table

ckacoroski

Hi,

I created a mysql database for testing and created an accounts table. This worked find and discover found it. I then added a second table (groups) and when I tried to discover it I got the following error:

Aware IM server encounterd the following error. You have an error in your SQL syntax; check the manual that corresponds to your MYSQL server version for the right syntax to user near 'group WHERE 1 = 0' at line 1.

Any ideas on how to fix this.

cheers,

ski

ckacoroski

ok, figured it out. I cannot use group as a table name.