Ticknew
New Member
Karma: +0/-0
 Offline
Posts: 6
|
 |
« on: July 09, 2008, 12:03:18 AM » |
|
Ok, I finally got my install upgraded to the latest version and everything seemed to go smoothly. All tickets/responses migrated fine and the desk is working as it should.
However, all of my predefined responses are no longer showing.
In addition, going to the database tab shows all databases as "out of date" even though they are listed as 1.7.0.
Any idea why this would happen? I had quite a few predefined responses in there.
|
|
|
|
|
Logged
|
|
|
|
Hummdis
Moderator
Super Member
Karma: +13/-0
Offline
Posts: 601
In a world without fences, who needs Gates?
|
|
« Reply #1 on: July 09, 2008, 02:03:11 AM » |
|
The latest version of eTicket is 1.7.2, so if you installed 1.7.2 and not 1.7.0, then that would be why they are out of date. Do you know for sure what version of eTicket you installed? Did you perform the "update.sql" on the MySQL database?
|
|
|
|
|
Logged
|
|
|
|
Ticknew
New Member
Karma: +0/-0
Offline
Posts: 6
|
|
« Reply #2 on: July 09, 2008, 04:00:59 AM » |
|
Ok, I just download the latest build 1.7.2 the database page is showing 1.7.2 but is still saying that it's out of date...
All that really matters is that my predefined responses are still not appearing since the upgrade.
|
|
|
|
|
Logged
|
|
|
|
beven
Project Manager/Developer
Global Moderator
Super Member
Karma: +12/-4
Offline
Posts: 804
|
|
« Reply #3 on: July 10, 2008, 09:16:26 AM » |
|
You will have to manually execute this SQL statement. UPDATE ticket_settings SET `group` = 'predef_answers' WHERE `group` ='answers';
This state is run when you upgrade from 1.5.9 to any of the 1.7.x series but it seems it never got ran on your install. |
|
|
|
|
Logged
|
Not to be confused with Bob Evans.
Ask not what eTicket community can do for you - ask what you can do for eTicket community.
Version 2 coming out shortly.
|
|
|
vince
New Member
Karma: +0/-0
Offline
Posts: 8
|
|
« Reply #4 on: August 03, 2008, 12:07:35 AM » |
|
I'm also showing on all tables: Database Status Database out of date.
Table version 1.7.2 Any SQL we can run to fix? Thanks, - Vince |
|
|
|
|
Logged
|
|
|
|
beven
Project Manager/Developer
Global Moderator
Super Member
Karma: +12/-4
Offline
Posts: 804
|
|
« Reply #5 on: August 04, 2008, 10:25:42 AM » |
|
Run this code
replace the tables and prefix with yours.
ALTER TABLE `%TICKET_TABLE%` COMMENT = '1.7.2';
ALTER TABLE `%TICKET_PREFIX%answers` COMMENT = '1.7.2';
ALTER TABLE `%TICKET_PREFIX%attachments` COMMENT = '1.7.2';
ALTER TABLE `%TICKET_PREFIX%banlist` COMMENT = '1.7.2';
ALTER TABLE `%TICKET_PREFIX%categories` COMMENT = '1.7.2';
ALTER TABLE `%TICKET_PREFIX%groups` COMMENT = '1.7.2';
ALTER TABLE `%TICKET_PREFIX%messages` COMMENT = '1.7.2';
ALTER TABLE `%TICKET_PREFIX%privmsg` COMMENT = '1.7.2';
ALTER TABLE `%TICKET_PREFIX%reps` COMMENT = '1.7.2';
ALTER TABLE `%TICKET_PREFIX%settings` COMMENT = '1.7.2';
|
|
|
|
|
Logged
|
Not to be confused with Bob Evans.
Ask not what eTicket community can do for you - ask what you can do for eTicket community.
Version 2 coming out shortly.
|
|
|
Hummdis
Moderator
Super Member
Karma: +13/-0
Offline
Posts: 601
In a world without fences, who needs Gates?
|
|
« Reply #6 on: August 13, 2008, 11:37:02 AM » |
|
Ticketnew, did that work for you?
|
|
|
|
|
Logged
|
|
|
|
ticogrande
New Member
Karma: +0/-0
Offline
Posts: 3
|
|
« Reply #7 on: November 14, 2008, 06:27:50 AM » |
|
Hi
I am getting the same type error after upgrading today to 1.7.3
I did run the upgrade.php program but still get this:
Database Status Database out of date.
Table version 1.7.3
Is there a command(s) I should run to upgrade this? Same as the one given above?
Thanks
|
|
|
|
|
Logged
|
San Jose, Costa Rica
|
|
|
Hummdis
Moderator
Super Member
Karma: +13/-0
Offline
Posts: 601
In a world without fences, who needs Gates?
|
|
« Reply #8 on: November 17, 2008, 05:21:15 AM » |
|
Yes. Run the MySQL commands given by beven above. That fixed it for me.
|
|
|
|
|
Logged
|
|
|
|
beven
Project Manager/Developer
Global Moderator
Super Member
Karma: +12/-4
Offline
Posts: 804
|
|
« Reply #9 on: November 21, 2008, 09:36:03 PM » |
|
Humm thats weird. I'm looking at the source and it shows 1.7.3. I'll have to look into the distros to see if it was left out when packaged.
|
|
|
|
|
Logged
|
Not to be confused with Bob Evans.
Ask not what eTicket community can do for you - ask what you can do for eTicket community.
Version 2 coming out shortly.
|
|
|
Hummdis
Moderator
Super Member
Karma: +13/-0
Offline
Posts: 601
In a world without fences, who needs Gates?
|
|
« Reply #10 on: November 24, 2008, 05:22:48 AM » |
|
I upgraded from 1.5.9 to 1.7.3, if that helps to solve the problem at all.  |
|
|
|
|
Logged
|
|
|
|
|
eTicket Community
|
|
|
|
|
|
Logged
|
|
|
|
|
