Welcome, Guest
Username: Password: Remember me
Feature requests for JEM 2.0 - initial public release
  • Page:
  • 1

TOPIC: field "fulltext" in jem_events

field "fulltext" in jem_events 9 months 2 weeks ago #25727

  • fmartin
  • fmartin's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Martin Schimmels
  • Posts: 9
  • Thank you received: 0
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.

field "fulltext" in jem_events 6 months 4 weeks ago #26148

To get around use of reserved words in table column names one can surround the field names with back quotes:
INSERT INTO jem_events (`fields`, .... , `fulltext`) VALUES(fieldvalues, .... ,'foo spam foo')
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.

  • Page:
  • 1
Time to create page: 0.166 seconds


If you find JEM useful and if you use it on your site, please consider a donation to the project.

Private Messages

You are not logged in.

Follow us......