We recently upgraded ttx to MSSQL 2000. The old tickets were successfully migrated to the new database. One can create a new ticket and add messages to it. And we can verify that in the backend. But no tickets are being listed in the tickets page. Even if we do not specify any criteria and hit the button SHOW ALL, it says "There are no tickets matching your query".
Attached is the DBI Trace log generated when you hit the button SHOW ALL records.
I would appreciate if somebody could help.
Ab
DBI 1.601-nothread default trace level set to 0x0/2 (pid 11877) at TTXMSSQLTickets.pm line 136 via TTXMSSQLTickets.pm line 103
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x836c7b8)~0x836c740 'SELECT COUNT(ID) FROM tickets WHERE (STATUS != 'CLS' OR CLOSED >= '1930-
11-13 18:44:54')')
SQLPrepare returned 0
dbd_st_prepare'd sql 837d000, SELECT COUNT(ID) FROM tickets WHERE (STATUS != 'CLS' OR CLOSED >= '1930-11-13 18:44:54')
<- prepare= DBI::st=HASH(0x8376a80) at TTXMSSQLTickets.pm line 510
-> execute for DBD::ODBC::st (DBI::st=HASH(0x8376a80)~0x8376a68)
dbd_describe SQLNumResultCols=0 (rows=1)
now using col 1: type = INTEGER (4), len = 4, display size = 12, prec = 4, scale = 0
dbd_execute: have 1 fields
<- execute= -1 at TTXMSSQLTickets.pm line 516
-> fetchrow_array for DBD::ODBC::st (DBI::st=HASH(0x8376a80)~0x8376a68)
<- fetchrow_array= ( '8' ) [1 items] row1 at TTXMSSQLTickets.pm line 523
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x836c7b8)~0x836c740 'SELECT ID FROM tickets WHERE (STATUS != 'CLS' OR CLOSED >= '1930-11-13 1
8:44:54') ORDER BY UPDATED DESC')
SQLPrepare returned -1
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x8376bb8)~INNER)
DESTROY for DBI::st=HASH(0x8376bb8) ignored - handle not initialised
<- DESTROY= undef at TTXMSSQLTickets.pm line 548
<- prepare= undef at TTXMSSQLTickets.pm line 548
-> errstr in DBD::_::common for DBD::ODBC::db (DBI::db=HASH(0x836c7b8)~0x836c740)
<- errstr= undef at TTXMSSQLTickets.pm line 555
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x8376a68)~INNER)
<- DESTROY= undef at TTXDesk.pm line 547
-> disconnect for DBD::ODBC::db (DBI::db=HASH(0x836c7b8)~0x836c740)
<- disconnect= 1 at TTXMSSQLTickets.pm line 110
-> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x836c740)~INNER)
<- DESTROY= undef at ttx.cgi line 615
-- DBI::END ($@: , $!: )
-> disconnect_all for DBD::ODBC::dr (DBI::dr=HASH(0x836c38c)~0x836c3e0)
<- disconnect_all= '' at DBI.pm line 718
! -> DESTROY in DBD::_::common for DBD::ODBC::dr (DBI::dr=HASH(0x836c3e0)~INNER)
! <- DESTROY= undef during global destruction
