Setting up log table

Classic Servoy
1

I created a MySQL database named log_data and in there created a log table. Then I configured the log_server database server to connect to the log_data DB in MySQL. I enabled tracking for one of my tables, but no entries are inserted into the log table. Is there something missing? I did not create the log table in Servoy, but with a MySQL tool.
Would Servoy automatically fill all fields or do user_name and event_time have to be set to autoentry?

[attachment=0]log.png[/attachment]

Using:
Servoy version 4.1.3 -build 672
java.version=1.5.0_19-b02-304
Mac OS X, 10.5.7

log.png
log.png1060×456 50.9 KB

2

Is solution login required?

3

Yes, solution login is required.

4

I would try it by creating the table from the Servoy security screen.

5

Servoy security screen? Under security I don’t see where I can create a table…
I did, however, create the table in Servoy (Database Servers - log_server). Still it doesn’t work. What are the exact colum definitions of the table? Maybe not all fields are correct…

6

Sorry, I was thinking in terms of Servoy 3.5. In Servoy 4.x, right click on “Database Servers” and “Create Log Table” is the 2nd option.

Picture 1.png
Picture 1.png563×298 19.2 KB

7

Thanks! That’s exactly what I was looking for. And now it works :)

8

I even knew it was there and it took me a bit to find it. This is great candidate for an Eclipse cheat sheet.