Thank you, I have successfully optimized my database.
Seeking to use Phpmyadmin to purge all attachments from the database.
Current Version 1.10.4
Past threads say to truncate 4 tables:
"TRUNCATE TABLE ost_file"
"TRUNCATE TABLE ost_file_chunk"
"TRUNCATE TABLE ost_attachment"
"TRUNCATE TABLE ost_ticket_attachment" <---I cant find this one???Are these 4 correct in the current version? Why am I missing the last of the 4... "ost_ticket_attachment" is not present in my database.
Thank you, I will look into that...
Is there a delete command I can run via SQL my admin that will allow me to reduce the database size, and then optimize the database...
I can delete all tickets over 1 year old, If I can delete everything over a year old it would reduce the size by about 75%... The issue is currently the UI crash when I try to delete the old tickets.
- Edited
Current Version 1.10.4
The DB is over 1.8 Gigs in size with ticket count well over 100K....
The system is running very slow, even when doing an operation that does not require an email. Just the act of deleting an old ticket can cause it to hang for 2 minutes, bulk deleting causes it to hang for 10+ minutes.
How can I bulk delete old tickets and clean up my database?
***I tried using two of these auto ticket closer and deleters but after clicking install plugin I had an error 500 until I deleted the plugin.
Update a highlight 50 and delete all at once in the UI has seized it up for over an hour... I am considering rebooting the server as it still have not recovered yet.
- Edited
When an unclaimed ticket is in an open queue.... My users would claim tickets (before they work them) that are part of an issue they are working.With Osticket 10 it appears that only users with the Assign permission are able to claim tickets for themselves. Is this correct? or have I missed some setting in v10?
- Edited
I had a similar issue... Just remove old cron job on server and add it back....Basically same thing you did....
- In Avatars
- Edited
I finally got it working, but not because I had actually done anything wrong the first try... But rather because it takes time for the avatar to populate over.....
- Edited
Admin Panel / Agents / RolesCreate New Role give it ONE permission for testingDisable this roleAdmin Panel / Agents / DepartmentsPick DepartmentSelect access tabGive agent disabled Role permissions (Should not even be choice)***Further testingThe Agent should have the disabled role and be working with it.gotoAdmin Panel / Agents / RolesNotice you can't enable the disabled role even though it is actually enabled????
- In Avatars
- Edited
A general description of how these avatars work would be helpful.. Yes, we use Gravitar but how does that work?
- Edited
Then it is not set in the php.ini file...Edit the file Php.ini put the correct setting in and reboot the server.
- Edited
Be advised I tried this same thing on godaddy and their Cron job creation tool.... WOULD NOT WORKI ended up having by web team add it in the console, and now it is up and going. (I do not know the syntax they used)
- Edited
I had this issue a few weeks ago....You have two places to configure timezone..**Admin Panel (I am assuming you have this correct)**Agent Panel (I am assuming you have this correct)Both were correct but there is also a PHP time setting on your PHP installation. Based on that setting is how it determines your regional DST rules.Admin/Dashboard/Informationdate.timezone America/ChicagoWhat is that set to? ^******Please note that the server time setting is separate from the PHP installs time setting.
- Edited
I just worked from this and got it workinghttp://osticket.com/wiki/POP3/IMAP_Setting_Guide
- Edited
1.9.13 is out at github...I wonder why it was not announced here.
- Edited
Well my web team pushed out the change late last night,but I did not check it until just now....Which means we are after march 29th...... So I can't know for sure if that was the issue, but I do know the time stamp is right now.We will need to check it again at the end of the year when the time changes back.
- Edited
****Now that you asked that I am thinking the root set to UTC is looking at the UK DST which doesn't start until March 29th.....I am going to edit the php.ini file and reboot the server and see what is comes up as.
- Edited
PHP Version 5.4.45date.timezone UTCWeb Server Software Apache/2.2.31 (Unix) mod_ssl/2.2.31 OpenSSL/1.0.1e-fips mod_bwlimited/1.4Q When you go to "My Preferences" (Upper right) as an Agent and scroll down to Daylight Saving... and tick or untick and click on Save Changes it doesn't change the time in the display?A No, time remains the same staying on CST -6 the entire time.
- Edited
DST is not being observed.....Current settings show observe DST both in admin system and in the user my preference... Time zone is set to CT which is currently CDT -5 as opposed to CST -6Checking or un-checking the DST box has NO EFFECT
- Edited
Please explain exactly the issue your having... What email to the end user is missing?No Notification EmailNo Response EmailBoth are missingFor the department in question, is the email address the same or different than the system email? (Have you tested outgoing email on both of them?)
- Edited
Assuming you don't have any of those auto assign to functions enabled....Most likely it is claim on response. So if the agent replies they get assigned. Q -Once he opens the ticket?NO this will not assign the ticketQ -Once he replies to the ticket? Yes, IF, claim on response is enabled.Otherwise the ticket is being assigned via auto assignment under Help Topic or Ticket Filters