Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
Advanced search

2508 Posts in 651 Topics- by 1319 Members - Latest Member: jwalkerjr

eTicket CommunitySupportInstallation Help & Software Support (Moderators: jason, Hummdis)Topic: Predefined response not showing after upgrade?
« previous next »
Pages: [1]   Go Down
Print
Author Topic: Predefined response not showing after upgrade?  (Read 1915 times)
0 Members and 1 Guest are viewing this topic.
Ticknew
New Member
*

Karma: +0/-0
Offline 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 Offline

Posts: 558



WWW
« 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
Don't PM me directly for help.  Post to the forums, that's what they are for after all.  PM's to me that request help will be ignored.

Hummdis Communications - Freelance Website Design & IT Consulting
Ticknew
New Member
*

Karma: +0/-0
Offline 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 Offline

Posts: 804


WWW
« Reply #3 on: July 10, 2008, 09:16:26 AM »
You will have to manually execute this SQL statement.

Code:
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 Offline

Posts: 8
« Reply #4 on: August 03, 2008, 12:07:35 AM »
I'm also showing on all tables:

Quote
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 Offline

Posts: 804


WWW
« 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 Offline

Posts: 558



WWW
« Reply #6 on: August 13, 2008, 11:37:02 AM »
Ticketnew, did that work for you?
Logged
Don't PM me directly for help.  Post to the forums, that's what they are for after all.  PM's to me that request help will be ignored.

Hummdis Communications - Freelance Website Design & IT Consulting
ticogrande
New Member
*

Karma: +0/-0
Offline 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 Offline

Posts: 558



WWW
« 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
Don't PM me directly for help.  Post to the forums, that's what they are for after all.  PM's to me that request help will be ignored.

Hummdis Communications - Freelance Website Design & IT Consulting
beven
Project Manager/Developer
Global Moderator
Super Member
*****

Karma: +12/-4
Offline Offline

Posts: 804


WWW
« 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 Offline

Posts: 558



WWW
« 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. Smiley
Logged
Don't PM me directly for help.  Post to the forums, that's what they are for after all.  PM's to me that request help will be ignored.

Hummdis Communications - Freelance Website Design & IT Consulting
eTicket Community
   
 Logged
Pages: [1]   Go Up
Print
eTicket CommunitySupportInstallation Help & Software Support (Moderators: jason, Hummdis)Topic: Predefined response not showing after upgrade? « previous next »
Jump to: