TOPIC:

Hi, JEM-friends,
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...

To get around use of reserved words in table column names one can surround the field names with back quotes:stackoverflow.com/questions/261455/using...s-around-field-names
And I have to agree with you - use of reserved names as column names is a bad practice.