Hello James,

Can you please provide us with the phpmyadmin access?

In Site Details.

Hello James,

It looks like your database user doesn't have the privilege to create stored routines http://dev.mysql.com/doc/refman/5.0/en/stored-routines-privileges.html . Can you please check this with your host? After they fix this, you should be able to upgrade without any issues.

GoDaddy will not fix it.

What's the reason given by them? Not sure how to work around this because the database user needs to have stored routine access and it doesn't make sense to not allow this?

They simply said they will not do it on shared hosting.

In short, do not use GoDaddy, they are horrible at everything BUT taking your money. They do that well.

Hello James,

I'm really sorry that delayed of this reply,
Do you consider to switch to another webhosting provider? Because regarding this issues you have to request with your webhosting and set your database user have granted the SUPER privilege, then only have the SUPER privilege granted in order to execute create / alter function statement.

No need to be sorry, I am going to migrate over the weekend to SiteGround.

Thanks,
James

Hello James ,

Okay, keep us updated then.