Hi, perhaps somebody can help me. I ve updated to the cvs version (from today). There have been some problems with the table group_user in my mysql. read and/or write as field name make errors when inserting in to the table. so I inserted them manualy. Now if I change the ro/rw value in the admin backend of otrs it is not possible to make this sql insert correctly. here is the error message: [Error][Kernel::System::Group::GroupMemberAdd][Line:87]: You have an error in your SQL syntax near 'read, write, create_time, create_by, change_time, change_by) VALUES ( 2, 1, 1,' at line 1, SQL: 'INSERT INTO group_user (user_id, group_id, read, write, create_time, create_by, change_time, change_by) VALUES ( 2, 1, 1, 0, current_timestamp, 1, current_timestamp, 1)' Can somebody please help me? THX. Cheers Marc
Hi Marc,
I ve updated to the cvs version (from today).
<snip>
[Error][Kernel::System::Group::GroupMemberAdd][Line:87]: You have an error in your SQL syntax near 'read, write, create_time, create_by, change_time, change_by) VALUES ( 2, 1, 1,' at line 1, SQL: 'INSERT INTO group_user (user_id, group_id, read, write, create_time, create_by, change_time, change_by) VALUES ( 2, 1, 1, 0, current_timestamp, 1, current_timestamp, 1)'
Had the same problems today. I was able to manually add the read/write fields to the table, but e-mails weren't being processed. I did see some promising changes in there, but not any of the changes I was looking forward to (like the ability to initiate a ticket with a user via e-mail). I suppose that's why they call it "developmental" code. ;) Best wishes, Paul
Hi Paul, On Sat, Mar 08, 2003 at 12:39:39PM -0500, Paul wrote:
I ve updated to the cvs version (from today). <snip> [Error][Kernel::System::Group::GroupMemberAdd][Line:87]: You have an error in your SQL syntax near 'read, write, create_time, create_by, change_time, change_by) VALUES ( 2, 1, 1,' at line 1, SQL: 'INSERT INTO group_user (user_id, group_id, read, write, create_time, create_by, change_time, change_by) VALUES ( 2, 1, 1, 0, current_timestamp, 1, current_timestamp, 1)'
Had the same problems today. I was able to manually add the read/write fields to the table, but e-mails weren't being processed. I did see some promising changes in there, but not any of the changes I was looking forward to (like the ability to initiate a ticket with a user via e-mail).
read/write are reserved SQL words. :-/ Remove the (read/write) fields, update to the current CVS version and use "cat $OTRS_HOME/scripts/DBUpdate-to-1.1.mysql.sql | mysql -p -f -u root otrs" -=> Then the fields are named permission_read and permission_write.
I suppose that's why they call it "developmental" code. ;)
Yes. ,)
Best wishes, Paul
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address.
Hi Marc, On Sat, Mar 08, 2003 at 06:25:52PM +0100, Marc Scheuffler wrote:
I ve updated to the cvs version (from today). There have been some problems with the table group_user in my mysql. read and/or write as field name make errors when inserting in to the table. so I inserted them manualy. [...] [Error][Kernel::System::Group::GroupMemberAdd][Line:87]: You have an error in your SQL syntax near 'read, write, create_time, create_by, change_time, change_by) VALUES ( 2, 1, 1,' at line 1, SQL: 'INSERT INTO group_user (user_id, group_id, read, write, create_time, create_by, change_time, change_by) VALUES ( 2, 1, 1, 0, current_timestamp, 1, current_timestamp, 1)'
Can somebody please help me?
Oppps. I used reserved SQL words! :-/ Update to the current CVS version and use "cat $OTRS_HOME/scripts/DBUpdate-to-1.1.mysql.sql | mysql -p -f -u root otrs" again. Then it should work again.
Cheers Marc
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- nohl: 6:32pm up 20 days, 4:54, 6 users, load average: 0.24, 0.34, 0.26
participants (3)
-
Marc Scheuffler -
Martin Edenhofer -
Paul