help to better help you:

Please: add always Joomla / JEM version and details to your posts, so we can try to reproduce your issue!

Feature requests for JEM 2.0 - initial public release

field "fulltext" in jem_events

field "fulltext" in jem_events

5 years 10 months ago
#25727
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...

Please Log in or Create an account to join the conversation.

Re: field "fulltext" in jem_events

5 years 7 months ago
#26148
To get around use of reserved words in table column names one can surround the field names with back quotes:
Code:
INSERT INTO jem_events (`fields`, .... , `fulltext`) VALUES(fieldvalues, .... ,'foo spam foo')
stackoverflow.com/questions/261455/using-backticks-around-field-names
And I have to agree with you - use of reserved names as column names is a bad practice.

Please Log in or Create an account to join the conversation.

Time to create page: 0.599 seconds