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.
Ian Hagerty says:
Josh says:
Erik Karey says:
April 25, 2010 at 5:06 pm
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
April 26, 2010 at 2:55 am
Hi Sam,
You’ll be fine with upgrading.
Thanks,
Jason