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