bkreinhart Posted June 28, 2012 Share Posted June 28, 2012 Hey-- Just got done dropping all of the files onto my GoDaddy server, and started installation. The system configuration check went just swimmingly, and when I configure and verify the database it says my database is connected. I also managed to receive an e-mail so I know that that is working correctly. HOWEVER! Upon clicking NEXT I get the following error message: Error while inserting data in the database: 'CREATE TABLE `ps_access` ( `id_profile` int(10) unsigned NOT NULL, `id_tab` int(10) unsigned NOT NULL, `view` int(11) NOT NULL, `add` int(11) NOT NULL, `edit` int(11) NOT NULL, `delete` int(11) NOT NULL, PRIMARY KEY (`id_profile`,`id_tab`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8' CREATE command denied to user \'iconicadmin2\'@\'184.168.152.208\' for table \'ps_access\'(Error: : 1142) Zoom, over my head. I THINK it looks like a permissions error? Can anyone provide any insight toward what may be going on here? Link to comment Share on other sites More sharing options...
Mike_GoDaddy Posted June 28, 2012 Share Posted June 28, 2012 When you create a database with Go Daddy you setup the database name/user and then have the option to setup a second "read only" user. In your configuration you must use the database name/user and not the secondary "read only" user or you will get errors like you shared. The primary database user will be the same as the database name. Link to comment Share on other sites More sharing options...
bkreinhart Posted June 28, 2012 Author Share Posted June 28, 2012 Alright, so new error: Database server is available but database was not found Link to comment Share on other sites More sharing options...
Mike_GoDaddy Posted June 28, 2012 Share Posted June 28, 2012 Can you provide the connection string information you supplied in the previous step? Link to comment Share on other sites More sharing options...
bkreinhart Posted June 28, 2012 Author Share Posted June 28, 2012 Forgive me, but I am not sure what you are looking for. That is all the information the error gives me. I have simply taken the database server name and used it as my database name as well, doing this is what has given me this error. Hope that helps.. Link to comment Share on other sites More sharing options...
Mike_GoDaddy Posted June 28, 2012 Share Posted June 28, 2012 In the Database Configuration step what do you have for the server name, database name and database login. Do not provide the password. Link to comment Share on other sites More sharing options...
bkreinhart Posted July 3, 2012 Author Share Posted July 3, 2012 Forgive my late reply, was a long weekend up here-- Server Name: mgd0001.db.8203475.hostedresource.com Database Name: mgd0001.db.8203475.hostedresource.com Database Login: iconicadmin Maybe should have mentioned this earlier, but it is being installed under a subdomain to my main account. Link to comment Share on other sites More sharing options...
Mike_GoDaddy Posted July 3, 2012 Share Posted July 3, 2012 Forgive my late reply, was a long weekend up here-- Server Name: mgd0001.db.8203475.hostedresource.com Database Name: mgd0001.db.8203475.hostedresource.com Database Login: iconicadmin Maybe should have mentioned this earlier, but it is being installed under a subdomain to my main account. The database name and login should be the same as the first part of the server name. So it would be: Server Name: mgd0001.db.8203475.hostedresource.com Database Name: mgd0001 Database Login: mgd0001 The user you have may be a secondary read only user you are able to create at the time you setup the database but that will not work for database use for your application. Link to comment Share on other sites More sharing options...
bkreinhart Posted July 3, 2012 Author Share Posted July 3, 2012 You know, I read tonnes and tonnes of tutorials, and other people's issues and I think I read this soultion at least half of those times but never implemented it properly due to my lack of understanding. Thank you SO much for your help. As of now it is working! Brock Link to comment Share on other sites More sharing options...
Mike_GoDaddy Posted July 3, 2012 Share Posted July 3, 2012 You know, I read tonnes and tonnes of tutorials, and other people's issues and I think I read this soultion at least half of those times but never implemented it properly due to my lack of understanding. Thank you SO much for your help. As of now it is working! Brock Brock, I am super happy you got it working now! Mike Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 3, 2012 Share Posted July 3, 2012 Thanks Mike! I'll go ahead and mark this thread as solved. -Mike Link to comment Share on other sites More sharing options...
bkreinhart Posted July 3, 2012 Author Share Posted July 3, 2012 Installed at working nicely. Thanks again! Excited to get started with PrestaShop! Link to comment Share on other sites More sharing options...
erickhelena Posted July 25, 2012 Share Posted July 25, 2012 dude best solution , i ran into the same problem didnt realized the database server name was the one above when u use phpmyadmin, thnx a lot Link to comment Share on other sites More sharing options...
Mike_GoDaddy Posted July 25, 2012 Share Posted July 25, 2012 dude best solution , i ran into the same problem didnt realized the database server name was the one above when u use phpmyadmin, thnx a lot I am glad you were able to get your installation working with the help of this information! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now