Blog Seperator
September 8th, 2009

Installing Magento on a Go Daddy Server

There are tons of people, just like me and you, who have had problems installing Magento on any server, let alone a Go Daddy one. Among the horrible errors I received, these were the most common:

  • The server encountered an internal error or misconfiguration and was unable to complete your request.
  • Base table or view already exists
  • Column already exists, or Column already exists: magento_eav_attribute

After hours of trial and error, I’ve finally figured out how to get it done right.  Unfortunately a lot of the blogs and forums I read along the way had it figured out at some point too–but between Go Daddy changes and updates from Magento every fix requires tweaking along the way. I think the key is to find a version that works for someone, and stick with that. Lucky for us Magento keeps archived copies of all their installs.

Here are 11 straight-forward steps to installing Magento 1.3.2.1.

  • Sign up with a GoDaddy Linux account. I’ve read that any account will work, or that you have to at least have a Deluxe account. For this example I used the Deluxe account.
  • Create a new MySQL database using the Go Daddy Hosting Control Center. Be sure to make a note of your server name, username (which is also your database name), and password.
  • Download the latest release of Magento (1.3.2.3 worked great for me)
  • Download the sample data that goes with that release (also on that same page)
  • Add the custom php5.ini file (below) to your web root, or just create a new one and add these three lines:
    • register_globals = on
      allow_url_fopen = on
      cgi.fix_pathinfo =1
  • Copy both Magento zip files (the main application release and the sample data) you downloaded to your server root. It’s quicker to copy them there, then unarchive them using the Go Daddy File Manager. Unarchive both sets using the default path of “/”.
  • It may take a few minutes, but once everything is unarchived, you’ll want to copy any folders under “media” in the sample data to the main “/magento/media” folder.
  • Take the SQL file in the sample data, and paste it (or import it) into the database you created in step 2. It’ll take a while, and it will create over 200 tables.
  • In the “/magento” folder we’ll need to make a change to the .htaccess file (or you can download the custom one below)
    • Change “# Options -MultiViews” to “Options -MultiViews” (remove the “#”)
  • Now we need to change the permissions on a few of the folders in the main /magento directory. I used an FTP manager to do this, leave a comment if you need help. Change “/var”, “/app/etc”, and “/media” to 777, and make it recursive so that it does all child folders as well.
  • Browse to your site, http://www.yoursite.com/magento, and fill in the form. I chose my timezone and currency, and did not append the table names with anything. On the three checkboxes at the bottom, the only one I checked was the “rewrite” box. Click the button, and the installation will begin. It takes a few minutes, and you will probably get an error at some point in the install. Just ignore it by going back to your magento site (ie http://www.yoursite.com/magento). If you get to the point where you can create a Magento store username and password, you’re at the finish line.

Even after the install finished, the first time I went to the front side of my store, I received an error. I just refreshed the page and it went away. This happened to me on every install attempt. I think people get stuck because they immediately try to reinstall. Don’t. Just fight through it and refresh, or go back to the /magento directory and refresh your browser. I hope this tutorial saves you hours of headaches!

Author: JNunn
September 8th, 2009 in Web Development | Trackback
Blog Seperator
Share this!
Comments
Hey, glad to see you've provided a tutorial for the newer versions! We've added a link to this page from our blog, since our tutorial is a bit outdated now. Cheers, Stefan
Posted by: Stefan Sizzle | September 8th, 2009 at 12:09 PM
Thanks man!
Posted by: Riley | September 16th, 2009 at 1:51 PM
Great Tutorial, except that you .htaccess files you say is available below is not available.
Posted by: Daniel Romney | September 24th, 2009 at 2:04 PM
Hi, When you said you used the deluxe account on godaddy which server did you use meaning on their website they have a deluxe plan under 3 different categories: website hosting, virtual dedicated, or dedicated? Do I have to use a Linux account to follow your Instructions or can I use Windows account as I have never worked with linux before? I want to build a video game ecommerce online store and have been searching the web for free ecommerce online store services and ran into Magento so I download the user guide and figured I'd give a shot. But godaddy seems pretty expensive, if i sign up i have to pay for 2 months up front and that yoursite you mention is $19.95 per month which is not to bad. Is it possible to just build a ecommerce site offline then sign up for domain and hosting site when the sites done? As paying all the money while your just developing your website which you don't know how long it will take to do sounds like a waste of money.
Posted by: Chris | September 24th, 2009 at 4:35 PM
Appreciate your effort Could you please help me understand how to do this step in Godaddy Take the SQL file in the sample data, and paste it (or import it) into the database you created in step 2. It’ll take a while, and it will create over 200 tables. Much appreciated your feeback NK
Posted by: NK | September 24th, 2009 at 11:13 PM
Daniel, sorry I didn't post that .htaccess. Just changing the one line mentioned should be all you need to do.
Posted by: JNunn | September 25th, 2009 at 9:09 AM
Chris, I used website hosting on the Linux account, so those instructions are for a Linux setup. But if you want to try it before you spend the money hosting, I would suggest downloading the Windows version from Magento, installing it locally, and using that. I do that now--I have XAMPP running on Windows XP with the latest Magento running. I'm able to do all my development that way and then copy up to the Go Daddy server whenever I want.
Posted by: JNunn | September 25th, 2009 at 9:13 AM
NK - For the SQL paste, you should have two things in their Sample Data download--a folder of Media files and an SQL file. After you copy their Media file to your installation, open the SQL file in Wordpad or something similar, and copy it to your clipboard. Use Go Daddy's control panel to find your databases. It should open phpMyAdmin and you'll be able to go to the SQL tab and paste in their statement.
Posted by: JNunn | September 25th, 2009 at 9:18 AM
Ok, Thanks for the info and appreciate the quick response.
Posted by: Chris | September 25th, 2009 at 9:03 PM
Ok, Thanks for the info and appericate the quick response.
Posted by: Chris | September 25th, 2009 at 9:03 PM
Thanks for you help, I made it through sql, now on changing attributes to 777 but unable to find app/etc directory any where in magneto folder. Where should I look or trying to think i missed something. rgrds ~nk~
Posted by: NK | September 26th, 2009 at 8:32 PM
Jnunn, I wasn't getting the installation pack running tso i went long way to install the magento, unzipped the zip file and ftped to website root and then did all the attribute changes for 777 and started working on installation screen, i passed the first 3 step and in configuration i had connection error with mysql which was resolved by removing base url "http" and then re-started again but now I am getting this error and cannot find a resolution I cannot change mysql password as it has to have one upper case and magento doesn't allow alpha numeric ....etc based on error Illegal scheme supplied, only alphanumeric characters are permitted any thoughts I am not a techie person but want to develop a store to see how it works
Posted by: NK | September 27th, 2009 at 10:14 PM
Hi Jnunn, I followed every step and it still appears the illegal scheme.... bla bla... I agree that the hole thing is about the upper case letter in the database password...
Posted by: Sam | October 6th, 2009 at 8:54 PM
Hi Jnunn: I am trying to install Magento on Godaddy server (delux Linux sharing hosting) and I followed your note above step by step but I am still getting "The server encountered an internal error or misconfiguration and was unable to complete your request" error. Is there anything else I need to do? Please help..
Posted by: Eleni | October 25th, 2009 at 1:14 PM
this made my week been trying to install this for a week no luck but this one is the bomb
Posted by: kitt | October 30th, 2009 at 6:35 PM
Eleni, what's your .htaccess file look like?
Posted by: J. Nunn | November 2nd, 2009 at 9:04 AM
I ran through this tutorial once, and it worked perfectly. Magento on affordable Go Daddy Deluxe hosting. Very nice, and thanks.
Posted by: Van | November 5th, 2009 at 10:58 PM
I followed all of these steps to download and install magento on godaddy and when i get to the installation screen i get this error mesage: * o SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) o Database connection error I changed my permissions to 777 as you stated. What am I missing??
Posted by: Denice | November 17th, 2009 at 7:50 PM
Denicee, are you on GoDaddy with a Linux system? That error typically happens because MySQL isn't found, isn't running, or isn't where the system expects it. If you are on GoDaddy with Linux (you should be), then you'll probably need to contact GoDaddy support and give them the error message.
Posted by: JNunn | November 18th, 2009 at 9:27 AM
JNunn Thanks for your response. yes I am on godaddy with a Linux system. I actually called them tonight and they said they weren't able to help me after having me on hold for ten minutes. They said they don't have a support for that I would have to contact Magento themselves for help. ...I think i'm going to change my hosting service provider within the next few months. I think that was ridiculous that they couldn't help, yet they allow the ecomerce program to run on their server. I just uninstalled it and am now trying to reinstall it again.
Posted by: Denice | November 18th, 2009 at 8:23 PM
I had one heck of a time installing the store on the economy Linux GoDaddy account. This was my second attempt to try to install Magento on a GoDaddy hosted account. Finally got it to work following the instructions above, but on the database setup I was getting the error: * o SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) o Database connection error I I changed host to: usernamexxx.db.xxxxxxx.hostedresource.com and it worked!!! To find out your host name in godaddy, go to databases --> MySql click on the pencil icon, and use the host name listed there. Don't forget to change the username from "root" to your db name
Posted by: CParker | January 2nd, 2010 at 8:45 PM
excellent post and thank you. i've tried following about 3 other how to install on godaddy accounts and this was my first successful attempt. the last paragraph about refreshing error messages was my Achilles kneel. anyway, thanks again for the info.
Posted by: Quincy | January 10th, 2010 at 1:39 AM
I can't tell you how incredibly grateful we are for your posting and directions for installation. It worked perfectly all the way through. THANK YOU again, you saved us a headache a million times over.
Posted by: Nicholas Gonzales | January 19th, 2010 at 9:57 AM
Post a Comment
Name:
Email Address:
URL:
Comments: