Category limit on submitted tickets

[zippytheclown]

Script URL: N/A, internal webserver
Version of script: 0.93.1
Hosting company: N/A, internal webserver
URL of phpinfo.php: N/A, internal webserver
URL of session_test.php: N/A, internal webserver
What terms did you try when SEARCHING for a solution: category

Write your message below:
I am having a problem with the category that is being recorded for certain new tickets. The symptom is very specific. We have over 100 categories, 106 to be exact. When a new ticket is submitted using a category above the 100th one, the ticket is recorded using the 100th category, rather than the higher one it was submitted with. This ONLY happens with the categories above the 100th one. All other behaviors are normal and correct, including all category functions. I can create/modify categories over the 100 mark, and they show up everywhere in the admin and submit screens, they just don't make it through to the final listing. My first thought was database, but because the categories are functional and can be created/modified, I have eliminated that as an possibility. I don't see anything in any of the configuration that suggests a functional limit, but my php knowledge is limited to what I have learned by using this script and reading this forum.

I know that not having the operational script available online can be a significant hurdle for troubleshooting, but I can provide any or all of the files for review if it will help. Any input would be helpful and greatly appreciated.

MySQL version 4.1
PHP version 5.1.1
Apache 2.0.55

[Klemen]

Hi,

I never though someone would use 100+ categories for Hesk

I think I know what the problem is, do you know how to manually edit MySQL tables?

If YES: MAKE BACKUP FIRST. Then in table hesk_tickets try changing field category from type TINYINT(4) to SMALLINT(5), this SQL should do the trick:

Code: Select all

ALTER TABLE `hesk_tickets` CHANGE `category` `category` SMALLINT NOT NULL DEFAULT '1'

If you don't know how to do it manually, let me know and I will write you a script to mke the above change.

Let me know how it goes.

[zippytheclown]

Klemen,
Thank you very much for the reply. We love the package and you should be very proud of the work you have done here!

I checked the hesk_categories table this morning, and the datatype is already SMALLINT(5) for the id column, and VARCHAR(20) for the name column, or am I looking at the wrong thing? I am using the MySQL graphic admin interface, but I don't think that will make a difference here...

Nick

[Klemen]

Nick,

If you look at my post carefully it's table hesk_tickets you should be editing, not hesk_categories

You need to change type of FIELD "category" in TABLE "hesk_tickets"

Regards,

[zippytheclown]

Klemen,
Sorry, you're right, I read it too fast. Fix worked like a charm, all is well. I'll go read up on the difference between the two datatypes, and thanks so much for the help. If I can ever do anything for you in the DFW, Texas area drop me a line, and I'm headed over to Amazon to check out your wish list. Thanks again.

Nick

[Klemen]

Glad to hear it works now. The difference between the two types is the maximum value that can be assigned to it. The "tinyint" has a limit of 128 and I left it like that as I didn't expect one would actually add 100+ categories to Hesk. But will have it changed to smallint by default in the next release.
http://dev.mysql.com/doc/refman/5.0/en/ ... types.html

Oh, haven't look at my Amazon wish list for a long time, gotta update it a little Just kidding, not that I would mind having something from the wish list, but don't feel like you have to buy me anything for the simple help I provided.

[zippytheclown]

Good help is hard to find, and good help that is free is golden. Thanks again!

Nick