Concerning field "fulltext" in jem_events:
I tried to fill jem_events using a python-script. But .... field "fulltext" doesn't have a default value, and adding a value with INSERT INTO jem_events (fields, .... , fulltext) VALUES(fieldvalues, .... ,'foo spam foo') fails.
Of course it fails: "fulltext" is a reserved word in MySQL for creating a fulltext-index.
So, what can I do to insert events in that table?
I suppose, the JEM-developers should think about renaming that...