[Bugreport?] Update from 3.2.3 to 3.3.3 On Windows

Moderator: crythias

Locked
eandrex
Znuny expert
Posts: 213
Joined: 04 Nov 2012, 23:58
Znuny Version: OTRS 4.x
Real Name: Esteban
Company: NORTON DE COLOMBIA

[Bugreport?] Update from 3.2.3 to 3.3.3 On Windows

Post by eandrex »

Hi, i have been running an otrs 3.2.3 system for testing purpose..so today i wanted to updated it to 3.3.3

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..

Image

Image

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'
after that, i tried to log in, but it didnt pass from login page...
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
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: [Bugreport?] Update from 3.2.3 to 3.3.3 On Windows

Post by crythias »

OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
eandrex
Znuny expert
Posts: 213
Joined: 04 Nov 2012, 23:58
Znuny Version: OTRS 4.x
Real Name: Esteban
Company: NORTON DE COLOMBIA

Re: [Bugreport?] Update from 3.2.3 to 3.3.3 On Windows

Post by eandrex »

yeh, i did ran that perl script.. but somehow otrs is running fine..(i guess i was reading an outdated log)


thank you.
Locked