Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Equipment Plugin compatability when upgrading to OSTicket Version 1.10 from 1.9 #55

Open
Justproof opened this issue Nov 16, 2016 · 2 comments

Comments

@Justproof
Copy link

Hi! I hope all is well.
Is OSTicket Version 1.10 supported with this plugin?
I recently upgraded to version 1.10 and had to rollback due to a privileges error that could be related to the equipment plugin install. I'm going to try again by first removing the plugin prior to updating OSTicket to see if that fixes the issue.

Error:

Error
SQL query: Documentation

DELIMITER ; ;

/!50003 CREATE//!50017 DEFINER=ostdatac_ostdata@localhost//*!50003 TRIGGER ost_equipment_AINS AFTER INSERT ON ost_equipment FOR EACH ROW BEGIN SET @pk=NEW.equipment_id; SET @list_pk=(SELECT id FROM ost_list WHERE name='equipment'); INSERT INTO ost_list_items (list_id, value, properties) VALUES (@list_pk, CONCAT(' Asset_ID:', NEW.asset_id), CONCAT('',@pk)); END */ ; ;

MySQL said: Documentation

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

@poctob
Copy link
Owner

poctob commented Nov 21, 2016

This problem is a general MySQL privilege issue. The user need to have rights to create and execute triggers and stored procedures.

@zeHamish
Copy link

attempting a deployment on 1.10.4 and after changing some hard coded table prefixes have run afoul of the following two errors immediately after addin ENABLE

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP INDEX name' at line 5

which i'd probably be inclined to look at working with / around if not for the next one which indicates a serious structural change between versions?

Table 'bsdf1051_ostSupport.jd4_ticket_event' doesn't exist
Error parsing SQL schema! Get help from developers (#4)
Upgrade configuration error. Unable to upgrade database tables!

indeed...that table does not exist in my 1.10.4 osT deployment.

poooop

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants