Form Log Plugin question (Solved)

[jmoises]

Hello, i just found out about this great plugin, i start testing, work great without the template custome message, but if i set a template i get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

this is the template i am using:

User {$my->username} {Add/Edit} a record entitled {sy2j8_hot_empresa___nombre}, on {DATE}. His IP is {$_SERVER->REMOTE_ADDR}

View attachment 17410

Thanks for any help

 

[troester]

Puh, I just tried, it's pretty complicated

If you are setting a table suffix you are creating a new log table.
If you don't have a template message this log table has a fixed structure, so all is ok.

IF you have a template message Fabrik is expecting also the table structure in this message
http://fabrikar.com/forums/index.php?wiki/logs-form-plugin/
http://fabrikar.com/forums/index.php?threads/doc-logs-plugin.12308/

So set a new suffix (to force a new table with the new structure) and change your message to e.g.
++message==varchar++ "User {$my->username} {Add/Edit} a record entitled {sy2j8_hot_empresa___nombre}, on {DATE}. His IP is {$_SERVER->REMOTE_ADDR}"

 

[jmoises]

Great Thanks, did you not get the error?

 

[troester]

Without defining a table column (++message==varchar++ ) and the quotes "xyz" around the text I got the error, too.

 

[jmoises]

Thank you so much!