Setup: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

[Daanvs84]

I'm trying to host Sentrifugo on a webserver hosted by Godaddy. I've set up a database and database user that has every privilege available. Godaddy doesn't allow for a superuser as it's a shared hosting plan. In step 2 of the setup process this results in this error being shown:

Some error occured. SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Is there any way to disable the requirement for a super privileged user?

[greenlanegreb]

Think the project is totally banjaxed. I was amazed (at first) to discover it will only run on massively outdated PHP 7.4. But, then, when I logged in here I realised that the code hasn't been updated for getting on for 8 years. I suspect people are customising it to their own ends quite separately and not re-uploading the code.

You'll need to ask Go Daddy to import the SQL dump from your website home directory for you (will need root access) - but please bear in mind it'll only run on PHP 7.4 anyway, so, if you don't have PHP 7.4 patched through, for example, Cloud Linux, it's hardly ideal or secure. Plenty of hosters out there use Cloud Linux and do offer PHP Multi-version so that you can run it in 7.4 patched in isolation and everything else on a more modern PHP version.

There's nothing else out there for free as far as I know other than CiviCRM which goes some way to managing volunteer resources and there's nothing against using it for business as well as not for profits. It's just not really geared towards businesses - there is no native ability to port anything across so it would require some re-imagining of your HR management.

Happy new year.