Author Topic: Issue Updating the QM Database to 1.4.7.1  (Read 2564 times)

rneubauer

  • Newbie
  • *
  • Posts: 11
  • Karma: 0
    • View Profile
    • Email
Issue Updating the QM Database to 1.4.7.1
« on: October 02, 2008, 04:59:14 »
I am trying to upgrade fom 1.4.4 to 1.4.7.1 and I am running into a DB update issue.

I copied the database back to the server, and started the dbtest, then chose to update my DB. Here is the error I get:

# 20 Checking database table: qa_data Error
 Problem encountered:
The required database table 'qa_data' is missing or unreadable. Please run the database update utility.
Java Error:
Problema DB: java.sql.SQLException: Table 'queuemetrics.qa_data' doesn't exist
 
So I go to the DB update tool and this is what I get:

Updating database
DB Version Description Result
1.4.4 Creating table 'qa_data' Err
1.4.4 Creating table 'qa_forms' Err
1.4.4 Preloading table 'qa_forms' Err
1.4.4 Creating table 'qa_forms_items' Err
1.4.4 Preloading table 'qa_forms_items' Err

The database was updated succesfully.
You are now ready to run QueueMetrics. Click here to start.

Any Ideas? I have a bit if data in there that I really cont lose. I would love to see the past year stats compared to the upcoming high volume season...

R

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Issue Updating the QM Database to 1.4.7.1
« Reply #1 on: October 03, 2008, 15:52:05 »
Try grabbing the tables "qa_*" right from the setup script. Maybe you do not have table creation grants on the QM database?

rneubauer

  • Newbie
  • *
  • Posts: 11
  • Karma: 0
    • View Profile
    • Email
Re: Issue Updating the QM Database to 1.4.7.1
« Reply #2 on: November 04, 2008, 15:32:24 »
I tried that, and even tried to change the DB level to the new version, but it caused a bunch of errors. I am just going to start it all overagain with a fresh database. It sucks, though, because my client wants all the historical data, and now I cant give it to him...

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Issue Updating the QM Database to 1.4.7.1
« Reply #3 on: November 04, 2008, 16:54:35 »
All historical data are either on flat-file or on the queue_log table -just create a new datanbase and import the queue_log table from the old one. This should not be such a major change.