Bug when gammu-smsd start if [sql] table not named as default

[m4ucoder]

Hello,
This is a bug : if you rename tables used by gammu-smsd, you must also have "duplicated" tables with the 'original' name, because when gammu-smsd service starts, it look for tables with the original name.

Because I am developing a joomla component wich is using gammu-smsd, I have added [sql] into gammu-smsdrc file.
I had modified table names, because joomla uses table names with prefix. For instance the "outbox" table is renamed "ghuo3_outbox".

When I start gammu-smsd service, logs shows me :

Error code 1146, Error Table 'mydbjoomla.outbox' doesn't exist
SQL failure 2
Table outbox not found, disconnecting !

But if I add tables "outbox", "inbox" tables etc, and I restart gammu-smsd service, the problem dissapears.
The problem is that when the service begins, gammu-smsd make SELECT on "outbox", "inbox" etc, and after when initialization is done, it takes all prefixed table : "ghuo3_outbox", "ghuo3_inbox" etc. and works as expected.

I hoê this help somebody

Philippe Lambotte

[nijel]

Indeed changing table names in custom SQL queries is not supported right now...