Help Desk Software & Beyond
May 21, 2012, 10:01:36 PM *
Welcome, Guest. Please login or register.
To post messages you need to register. We apologize for inconvenience, but this is to prevent spam.
Registration is instant (no email verification) and we do not ask for any personal information.

Login with username, password and session length
News: Welcome to Help Desk Software forum!
 
   Home   Help Search Login Register  
Help Desk Software & Beyond > Forum > Trouble Ticket Express > Troubleshooting/Setup (Moderator: Sparky) > [Solved] - TTX with MySQL Db - Missing data
Pages: [1]
« previous next »
  Print  
Author Topic: [Solved] - TTX with MySQL Db - Missing data  (Read 311 times)
arvin
Sr. Member
****

Karma: 10
Posts: 400


Yeah thats right !


View Profile
« on: December 01, 2011, 11:15:44 AM »
This is a weird one ....

When I view some of the tickets via the application, I can see the form data and on other tickets there is no data displayed...

Yet.. when I view the tables via my MS Access app ... I see the data on tickets that don't display any data via the application/browser....

Um ...why  Huh
« Last Edit: December 02, 2011, 04:04:48 PM by arvin » Logged
Sparky
Moderator
Hero Member
*****

Karma: 83
Posts: 2,228


stop pushing all those buttons


View Profile
« Reply #1 on: December 01, 2011, 11:19:14 AM »
Which data exactly?

Are there some weird characters in there causing TTX to skip over those?

Is it always the same data from the same tickets that's missing?
Logged
Did you update the paths in ttxcfg.cgi after moving TTX to your new location?   Undecided
To those seeking help.... please report back when you figure it out.  Cheesy
arvin
Sr. Member
****

Karma: 10
Posts: 400


Yeah thats right !


View Profile
« Reply #2 on: December 01, 2011, 11:25:27 AM »

Quote
Which data exactly?

Its the form/template data ...

Quote
Are there some weird characters in there causing TTX to skip over those?

Nope

Quote
Is it always the same data from the same tickets that's missing?

Yes ....but ..lets say that I have 2 billing inquiries .. in TTX I can the data of one but not the other ... yet in my MS Access app I can see the data for both ....
Logged
arvin
Sr. Member
****

Karma: 10
Posts: 400


Yeah thats right !


View Profile
« Reply #3 on: December 01, 2011, 11:43:33 AM »
Me thinks this is a MYSQL server issue ....

the provider we use did upgrade the MySQL version recently ... and now I'm wondering if the upgrade issues have now propagated to the physical server where our site resides on ....

Logged
Sparky
Moderator
Hero Member
*****

Karma: 83
Posts: 2,228


stop pushing all those buttons


View Profile
« Reply #4 on: December 01, 2011, 11:45:19 AM »
time for a new host...
Logged
Did you update the paths in ttxcfg.cgi after moving TTX to your new location?   Undecided
To those seeking help.... please report back when you figure it out.  Cheesy
arvin
Sr. Member
****

Karma: 10
Posts: 400


Yeah thats right !


View Profile
« Reply #5 on: December 01, 2011, 11:54:24 AM »
LMAO !....

Could you have used a smaller font!
Logged
arvin
Sr. Member
****

Karma: 10
Posts: 400


Yeah thats right !


View Profile
« Reply #6 on: December 02, 2011, 03:54:57 PM »
SOLVED ! ! ! ! !

nothing wrong with TTX  Grin....

Data within the "messages" table was corrupted ... restored it with backups ...

Rock on !  Cheesy
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1 RC3 | SMF © 2001-2006, Lewis Media Valid XHTML 1.0! Valid CSS!
Page created in 0.022 seconds with 20 queries.