Question

Photo of Ronald Flores

0

500MB Sql server size

6

I know -- Godaddy is not "supported". However, earlier today I installed Rock on a godaddy shared platform and went through with install. I made the mistake of putting the same URL on both the external and internal URLs, tried to look for a way to change it but couldn't. Ended up re installing everything from scratch, now its giving me an error that MS SQL server needs to be bigger than 200MB. Well godaddy doesn't let any SQL databases bigger than 200MB.

Is there a way to override this limitation? I just need to install it we are a small church. Any help appreciated.


Capture.JPG

  • Photo of Daniel Hazelbaker

    0

    If you post an image of the exact error screen we might be able to give more help.

    But if GoDaddy limits you to 200MB then you may hit that limit REAL quick. 200MB is nothing when it comes to databases. What you may be able to do to "override" the error is to make sure you fully delete the database before re-installing. But again, 200MB will be chewed through really quick. My essentially clean install dev Rock database is 125MB. That only leaves 75MB for you to actually do anything.

  • Photo of Shawn Ross

    1

    Ronald, is your church a 501c3?

    If so, you could run your system using Microsoft's Philanthropies Azure credit. It's more than enough for Rock with a church of your size. There is even a guide to using Azure: Rock Solid Azure Hosting.

    I have successfully used 3Essentials to host Rock using their 'Shared' product. It works. It's nowhere near as fast as a VM + Azure SQL with MS Azure, and Azure costs less if you're a 501c3.


    Shawn

  • Photo of Ronald Flores

    1

    Ok everybody, I was able to do what Daniel suggested and simply reinstall everything, this allowed the installation to proceed. 

    Regarding the 200MB limitation, Godaddy gives a fixed limitation of 200MB per database, even with their dedicated servers. With the dedicated service, you get unlimited SQL server databases, but at a max of 200MB per database. 

    I did not meant to imply that godaddy was not supported at all; what I meant was that godaddy should not figure as a recommended hosting provider for Rock. 

    At least, I couldn't find anywhere in the Rock pre-install documentation the indication that it needed a minimum 500MB database file. It wasn't on the pre-requirements list, as far as I could find. Please correct me if it is. 

    Anyhow, I got it running on the economy account and it works MARVELOUS. This software is indeed a jewel. Thank you everybody!!!

    • Daniel Hazelbaker

      Daniel Hazelbaker

      We are having a side discussion on another forum about the documentation. GoDaddy is no longer listed as a recommended hosting provider - BUT - a google search of "rockrms godaddy" brings up the old content page so we are looking at best ways to somehow flag those older pages as outdated to help people find the up to date information instead.


      Be sure to keep on eye on the size of the database. Any database driven software, Rock included, will absolutely freak out if it suddenly runs out of space in the database. There are a few ways to keep database space down, such as setting up the document types to use file system storage instead of database storage. But that is a discussion for another thread. But glad to hear you got it working. I know you said you are stuck with GoDaddy, but do keep an mind the Azure credits that Shawn mentioned. If you do qualify for the credit it's something like $5,000/yr, which is more than enough to cover the costs you would have for hosting.

      • Jim Michael

        Jim Michael

        I'll add that unless something has changed recently, you can install SQL Express in a dedicated server and run any DB size you want up to the 10GB limit. All of the 200MB limitation have to do with using Godaddy's instances of SQL server you run via Plesk or CPanel... but with a dedicated server you have full access to Windows and just install what you want.

      • Photo of Ronald Flores

        0

        I understand that completely. But then that would mean that ROCK is NOT SUPPORTED on godaddy on the simple limit of 200MB for the SQL server size. 

        • Daniel Hazelbaker

          Daniel Hazelbaker

          The screen shot is a little small, but it looks like it should let you re-install if you delete the existing database first. If it still doesn't then it is possible GoDaddy has set some flag on the database saying it is limited to 200MB that wasn't there initially.


          But you are correct. Godaddy doesn't tell you anywhere on their "hosting details" page that they limit the database to 200MB. You have to dig around in their knowledge base to find it (or run into it as you did). I will submit a ticket to request that godaddy be removed completely from the documentation as that limit really does make them a non-option.


          Sorry you ran into that problem. If you already paid them you might see about asking for a refund stating that this limitation was not indicated anywhere on their "server details" page.

          • Jim Michael

            Jim Michael

            GoDaddy also sells "Dedicated Servers" which let you install SQL express or any other version, so it's wrong to make a blanket statement that Rock "won't run on Godaddy". That said, in my experience they seriously over provisions hosts and it will probably perform poorly regardless.

          • Photo of Ronald Flores

            0

            Capture.JPG

          • Photo of Ronald Flores

            0

            Daniel, it is very understandable. I guess most people would use godaddy for its ease of use in many fronts -- not necessarily its performance. But I'd say, taking this into consideration, maybe the installer should give a warning about the SQL server size, not just stop the whole installation thing. Maybe let the install pass with a warning? I would really like to use Rock for our church management, but we are kind of stuck with godaddy, for several unmentionable reasons. 

            • Michael Roth

              Michael Roth

              Ronald, there are a couple of other options for you if you need.



              1. Myasp.net is pretty cheap and could work for a small church if you need it to. It won't be the fastest option and had its limits.

              2. Call godaddy and they can bump you up in db size as they do this to keep the customer happy. I did this for a customer once but the page load times fro godaddy drove us to leave there shared hosting plan quickly.

              3. Email me at Mike@DTSChurch.com and I'm sure we can work something out so you can get something to work.


              Regards,
              Mike