Hello:
I inherited our OSTicket system from a former employee. When I came on, we started running OST in a test and a Production environment. Over the past weekend, we had a upgrade to our network that forced us to update OST to a newer version ( we were running 1.10.1 ).
I was able to upgrade our Test system from 1.10.1 to 1.15.2, but when I went to our Production version for the upgrade, I got the following error:
[core]: Upgrader Error
[/** * @version v1.11 * @signature 934b8db8f97d6859d013b6219957724f * @title Custom Queues, Columns * * Add custom queues, custom columns, and quick filter capabilities to the * system. */ ALTER TABLE ost_queue ADD columns_id int(11) unsigned AFTER parent_id, ADD filter varchar(64) AFTER config, ADD root varchar(32) DEFAULT NULL AFTER filter, ADD path varchar(80) NOT NULL DEFAULT '/' AFTER root] ALTER command denied to user 'rseliteauth'@'louappwqs1060.rsc.humad.com' for table 'ost_queue'
Now, I know that this error is happening because my company denies the main account that accesses our MySQL DB the ability to alter the DB, but my question is this...
If I get the permissions updated to allow that account to modify the DB structure, how do I kick off this upgrade again? I was hoping that once I restored the previous version to the iis folder, and then started an upgrade again, it would bring be back to the upgrade button, but when I re-update now, I get an error that the upgrade failed and gives the same error.... so how do I resume the upgrade?
Does the system just know that there is a pending DB change and when the access is granted, it proceeds?
Thanks
