Auto close after X amount of days of in activity as defined in the ACP? This would then generate a PM to the user...


Title: Your Support Ticket XXX is Now Closed
Body: AUTOMATED NOTICE: Your support ticket has been closed due to X days of inactivity. However, if you require any further assistance, please:

• Open a "link to new ticket", OR
• "Link to Re-open" your ticket.

Your Support Team:
Link to Profiles of Admin | Link to Profiles of Admin | And so on...

Links support team could also be a new user group "support team" or one defined in the ACP

Better ;)
In usergroep manger the name of the table is still missing.

And when i submit a new ticket i get a database error.

-----------------------

Database error in vBulletin 3.7.0 Release Candidate 4:

Invalid SQL:
INSERT INTO helpcenter_ticket(departmentid, tickettitle, message, priority, ownerid, ownerusername, lastreplyusername, lastreplyuserid, datelogged, datelastupdate, ipaddress, threadnum) VALUES ('1','test','test test test','3','1','Mike','Mike','1','1209449977','1209 449977','0.0.0.0','0');

MySQL Error : Unknown column 'threadnum' in 'field list'
Error Number : 1054
Request Date : Tuesday, April 29th 2008 @ 08:19:37 AM
Error Date : Tuesday, April 29th 2008 @ 08:19:38 AM
Script : http://www.xxxxxxxnl/helpcenter.php?do=newticket
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.45-enterprise-gpl

i just upgraded to beta 5 due to a error, so i uninstalled and reinstalled the mod, and looking in the usergroup under admin, there is no title on the help center area of options, its blank. but the radio buttons and options are there.

i had this same error. i uninstalled the mod, and reinstalled it and the error is gone. i think if u upgrade to the current version you will get the error...

as far as the title bar in the usergroup missing, mine is missing also.

I will sort the HelpCenter table phrase when I get home, with regards to the "MySQL Error : Unknown column 'threadnum' in 'field list'" I think there is something wrong within the product file for altering the table.

I will update the product so that it creates the table with the new field name, but it may mean everyone has to uninstall and re-install to get it working correctly.

If anyone could have a look at the product file and check the SQL Query (version 0.5) then i'd be grateful.

Thanks, Paul.

paul that error is only duplicating itself on upgrade. i tested it on 2 forums. must uninstall and reinstall mod to not have errory.

ah right I understand now GoTTi and thanks for letting me know, I will fix the Usergroup phrase now.

Thanks, Paul.

I figured out the DB error. The problem occurred with reading the table, rather than creating it, so the problem wasn't in the product file. Once I realised that I stopped looking in the wrong place and had a quick look in helpcenter.php. I figured out the error, and managed to fix it myself :D. If anyone else has prefixes on their SQL tables then do the following in helpcenter.php

SEARCH FOR;
REPLACE WITH;
...or just wait for Paul to update the zip :).

Thanks Irish I have fixed this for the next release.

Thanks, Paul.

Well done, works well... Mike.