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.