When I open the term that I would like to configure with new two term fields that I previously set up. Drupal send me this WARNING:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release FROM themask_term_fields_term WHERE tid = 4' at line 1 query: SELECT release FROM themask_term_fields_term WHERE tid = 4 in /home1/wrongdes/public_html/drupal/sites/all/modules/term_fields/term_fields.module on line 95.
When I save term with edited term fields. Drupal send me this two warnings (by two term fields).
# user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release, number_of_singles) VALUES (4, 'sdfsdf', 'sfsdf')' at line 1 query: INSERT INTO themask_term_fields_term (tid, release, number_of_singles) VALUES (4, 'sdfsdf', 'sfsdf') in /home1/wrongdes/public_html/drupal/sites/all/modules/term_fields/term_fields.module on line 442.
# user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release FROM themask_term_fields_term WHERE tid = 4' at line 1 query: SELECT release FROM themask_term_fields_term WHERE tid = 4 in /home1/wrongdes/public_html/drupal/sites/all/modules/term_fields/term_fields.module on line 342.
Thank you for help!
| Comment | File | Size | Author |
|---|---|---|---|
| #4 | term_fields_e_all_save-D6.patch | 772 bytes | hass |
Comments
Comment #1
discuss commentedComment #2
discuss commentedComment #3
hass commentedAre this really the warning messages or have you altered them? I cannot see anything wrong in the above statements...
Comment #4
hass commentedThe only notices I've found are these after saving a term:
And one minor in the admin file. Patch attached.
Comment #5
hass commentedComment #6
overbythere commentedI can confirm these errors happen, here is my log:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc,title FROM term_fields_term WHERE tid = 13' at line 1 query: SELECT desc,title FROM term_fields_term WHERE tid = 13 in /home/hens/public_html/att/sites/all/modules/term_fields/term_fields.module on line 357.
I have noticed that it is due to the fields not being contained in quotes, I have updated the module accordingly for myself, however when I create the diff file from the HEAD or 6.1 it seems a lot more has changed, so I have included my code changes:
Find where the function term_fields_get_fields starts, and amend:
Comment #7
b-prod commentedPorted in the 1.16 release
Comment #8
hass commentedThe standard should be
[date], [time]as I know.