
Not sure if two of three issues impacted by install but wanted to post what happened to be complete. During upgrade step 8) Apply the database changes (part 1/2) I received two error messages. ***** Step 8 ***** [root@orca otrs]# cat scripts/DBUpdate-to-3.0.mysql.sql | mysql -p -f -u root otrs Enter password: ERROR 1061 (42000) at line 12: Duplicate key name 'ticket_until_time' ERROR 1101 (42000) at line 343: BLOB/TEXT column 'content_type' can't have a default value [root@orca otrs]# ***** Error 1061 steps: ***** mysql> alter table ticket -> drop index ticket_until_time; Query OK, 121 rows affected (0.01 sec) Records: 121 Duplicates: 0 Warnings: 0 mysql> CREATE INDEX ticket_until_time ON ticket (until_time); Query OK, 121 rows affected (0.02 sec) Records: 121 Duplicates: 0 Warnings: 0 ***** Error 1101 steps ***** Found this reference on mysql bug didn't know what to do next...any ideas? http://bugs.mysql.com/bug.php?id=19498 ***** Final known error ***** Posted pics and details http://forums.otrs.org/viewtopic.php?f=63&t=5512 I am unable to log in with customer users. Agent users appear to be working fine. When I attempt login with customer user I get a cute little picture saying "Panic! No UserData!!!" Don't know to do about this error someone suggested bug but I wanted to pass on to community first.
participants (1)
-
Paul Taylor