Sorry for my poor english
Hi OSticket team,
You have doing a big error on your script, it's not a security problem, no, you have just missed CLUSTERRING SERVER !!!!
I will remember you how they working when you have many SQL node :
For all auto_increment, if node_1 is used for record a query, ID will be xxx1
if it's node_2, ID will be xxx2, node_3 xxx3.
What is wrong on your script :
For checking a configuration, you doing a query for search a configuration, but you search with ID (in auto_increment).
You can change your SQL file to :
INSERT INTO %TABLE_PREFIX%config SET isonline=1, updated=NOW();
For
INSERT INTO %TABLE_PREFIX%config SET id=1, isonline=1, updated=NOW();
And remove auto_increment.
I hope you understand what i want mean, but atm for some clustered server, your script need be fixed.