I imported a script that created my database and indexes, but if I try to create stored procedures and functions I get this error.
Will I be unable to use stored procedures and functions? I have about 12 of them, and I need them for my application to work correctly.
You cannot create database functions and stored procedures on free hosting.
It’s recommended to place those logics in PHP instead.
Well, no. The procedures represent many, many hours of work. So now I can’t use your free plan?
wdym “my” free plan
I don’t work for InfinityFree
But yes they won’t work on free hosting.
OK, I thought you did. I probably wasted a whole day on this setup. If I upgraded plans, then there probably would be something else that doesn’t work.
Stored procedures are indeed not supported on free hosting.
As for what that means for your website, that’s up to you to decide. You can either find hosting that does support the stored procedures, or update your website to not use them anymore.
That would be true for any hosting, not just iFastNet’s premium hosting. If you build your website on one setup (a local setup) and the migrate it to a different setup, there is always a chance that something breaks due to a difference. With our hosting, it was the stored procedures. With any other hosting, it could be anything else.
If you want to try your luck with a different hosting provider, then you’re free to do so of course. But “I had problems with free hosting so their premium hosting probably also has problems, and I can avoid that by going to a different provider” is not fair I think.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.