mysql> DELIMITER ;;
CREATE DEFINER=`altisage`@`localhost` PROCEDURE `resetLifeVehicles`()
BEGIN
UPDATE `vehicles` SET `active`= 0;
END
;;
1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
mysql>
any ideas? - I have verified that i am logged in to the database (able to create tables)
We do not currently support user-defined functions through our shared hosting. The second error that you saw just means that they aren't allowed (which is confusing; I don't know why they do not use a better one).
We hope to support user-defined functions at some point, but right now our systems are just not set up to keep track of them. Adding one manually would break things in many ways.
The main reason that user-defined functions present a problem is that they use the shared global namespace, as databases do. There are also some permissions concerns that will need to be addressed. Support will entail adding new features to the control panel to allow them to be created and tracked there.
They have to be installed as a root user's permissions.
And as mentioned, not something that's available.
It looks like your using these for a dayz version mod.
If your using a VDS, your can install something like Xampp and have the ability to do everything yourself.
Or if you have a website and access to cPanel, you can try to install a database with your webhosting. But you could find a similar issue depending on the hosting company.
Visit gspreviews.com And Rate & Review Your Old & Current GSP's Find Your GSP Coupons at gspreviews.com/coupons/
Be very careful if you choose XAMPP, as we've had countless customers have their default installations exploited by attackers. Know what you're doing and lock it down properly.
Thanks for the replies, I've decided to just run the delete and update commands regularly - there is a security risk with this, but nothing a regular offsite backup can avert in the case of a disaster.