We were recently worked on what one would consider the easy job of installing Prosper 202 in a shared web hosting environment. Our client happened to be hosted with Hostgator, the same as many people are.
The files were uploaded, database and database user were created. The simple ’5 minute’ install didn’t turn out to be so easy. Around step three of the installation there was an issue with SQL and partitioning. Hostgator does not support SQL partitioning at least on their shared hosting environments. You can see here, several other people were having the same issue.
What we did to fix the issue and get the script installed was modify the functions_install.php file, removing references to SQL partitioning.
The end result? It worked flawlessly. The script was installed and functioned as it should.
So, if you happen to be hosted with Hostgator and are installing Prosper 202 and are having the same issue, we have a fix for you.
Download and extract the attached file and overwrite your original file before installing the script.
Deprecated. See other Prosper posts.
I am using Prosper202 on a Hostgator VPS server. I installed p202 ver 1.3.2 using your Hostgator “fix” install package and it worked perfectly.
My question is about updates to Prosper202. When I do periodic upodates to P202, such as from 1.3.2 to 1.5.1, do I need to be concerned with using a special version of function-install.php, or can I just follow the normal update instructions which will (most likely) overwrite the special function-install.php file which was used during my original installation.
Thank you,
Sam
Hi Sam,
You’ll be fine with upgrading.
Thanks,
Jason
Thanks so much for sharing this and making it available to everyone, this one file saved me from having to switch hosts, you rock!
You’re welcome!
Thanks for the fixes guys, superb.
Many thanks
Ian Hagerty
[...] off was an issue with HostGator shared accounts not supporting SQL partitioning. Found this fix for the issue. Just download the file they provide and replace it with the file contained in the [...]