mhequipit
Full Member
Karma: 1
Posts: 117
|
 |
« on: January 18, 2007, 04:35:25 PM » |
|
I told the program to hide tickets that were solved after 1 day. I have now moved it to 999 days and the tickets aren't coming back in view, this is a non sql install. I need to get those tickets back, I even restored the .cgi files from last nights backup but they still aren't showing up in the web view even though they are in the /tickets/ folder. How do we get these back, and also if we upgrade this to the sql version will the tickets port over? All help is greatly appreciated as this is a time sensitive issue. Thanks!
Willie
|
|
|
|
|
Logged
|
|
|
|
|
Alex
|
|
« Reply #1 on: January 19, 2007, 06:04:55 AM » |
|
All tickets are preserved when upgrading to MySQL edition. The "hide old solved tickets" option does not delete any tickets. It is only a hidden filter for ticket browser. You may always access hidden old solved tickets by ticket ID.
|
|
|
|
|
Logged
|
|
|
|
mhequipit
Full Member
Karma: 1
Posts: 117
|
|
« Reply #2 on: January 19, 2007, 07:13:57 AM » |
|
Ok but I need them all unhidden, is there a way to do this?
|
|
|
|
|
Logged
|
|
|
|
mhequipit
Full Member
Karma: 1
Posts: 117
|
|
« Reply #3 on: January 19, 2007, 07:16:37 AM » |
|
When I put in a ticket number that is hidden it says nothing matched. Please help!!
|
|
|
|
|
Logged
|
|
|
|
mhequipit
Full Member
Karma: 1
Posts: 117
|
|
« Reply #4 on: January 19, 2007, 07:29:36 AM » |
|
When I put * in for ticket number it only shows 32 which are all open, when I look at the /tickets/ directory there are 72 tickets that should be showing up and aren't.
|
|
|
|
|
Logged
|
|
|
|
|
Alex
|
|
« Reply #5 on: January 19, 2007, 07:51:58 AM » |
|
Looks like you have either corrupt or wrong index file. Please check contents of the tickets.cgi, the file keeps the index. If the file is 32 lines long you have 32 tickets in the database. Make sure you did not overwrite the file with old copy. You may try retrieving a backup copy from the backup folder, the Trouble Ticket Express makes the weekly backups automatically.
|
|
|
|
|
Logged
|
|
|
|
mhequipit
Full Member
Karma: 1
Posts: 117
|
|
« Reply #6 on: January 19, 2007, 08:32:18 AM » |
|
I found the backup with all the tickets, copied it over, made sure the tickets were there but they still aren't showing up. I also upgraded to sql does that matter?
|
|
|
|
|
Logged
|
|
|
|
|
Alex
|
|
« Reply #7 on: January 19, 2007, 08:42:55 AM » |
|
As long as you upgraded to MySQL edition the tickets.cgi is not used any more. You may safely delete the file. You MySQL database contains only tickets that were in the tickets.cgi at the moment of import. To re-import run sqlsetup.cgi again (this will invalidate any tickets submitted while in MySQL mode).
|
|
|
|
|
Logged
|
|
|
|
mhequipit
Full Member
Karma: 1
Posts: 117
|
|
« Reply #8 on: January 19, 2007, 09:38:22 AM » |
|
Did that and the tickets still aren't there, maybe faster for me to reenter the tickets by hand at this point?
|
|
|
|
|
Logged
|
|
|
|
mhequipit
Full Member
Karma: 1
Posts: 117
|
|
« Reply #9 on: January 19, 2007, 09:38:51 AM » |
|
Do I need to blow out the database or use a different db name for this to work?
|
|
|
|
|
Logged
|
|
|
|
mhequipit
Full Member
Karma: 1
Posts: 117
|
|
« Reply #10 on: January 23, 2007, 10:09:20 AM » |
|
Any ideas?
|
|
|
|
|
Logged
|
|
|
|
|
