so i followed http://doc.otrs.org/3.3/en/html/upgrading.html
and according to UPDdate-to-3.3.pl, the migration script finishes with no erros..


after that i went to watch otrs.log and found this
Code: Select all
[Sat Dec 28 14:21:14 2013][Error][main::_AddTemplateTypeColumn][419] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'template_type'. (SQL-42S22) [state was 42S22 now 42000]
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000), SQL: 'SELECT TOP 1 template_type FROM standard_template WHERE 1=0'
[Sat Dec 28 14:21:14 2013][Error][main::_AddACLTables][307] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'acl'. (SQL-42S02) [state was 42S02 now 42000]
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000), SQL: 'SELECT TOP 1 * FROM acl WHERE 1=0'
i had to use index.pl?Action=Login&User=XXX&Password=YYYY&RequestedURL=Action%3DAgentDashboard and it worked
i have cleaned cache and rebuilded config many times, and still seems to not work the login page(and i have no logs)
same issue for customer.pl (login button stays disable)
i did run and they all were ok
Windows server 2008
sql server
otrs 3.2 clean install to otrs 3.3