ringo7 Posted January 26, 2012 Share Posted January 26, 2012 Hello everyone! I own a small business and i decided to built myself an online shop for it using prestashop after i read a bit online about diffrent cms solutions. But i got into troubles early on. As i started to install prestashop i passed the first two steppes(i even created an .htacces file with "php_flag magic_quotes_gpc Off" line in it so i pass the original requirements check) but i have no ideea how to pass step3: database configuration. I logged on cpanel on my hosting account and i created a new database with a new user; i gave the user full rights. But after i filled in required datebase credentials in "step3: database configuration" nothing happens. It does not show me any error even if i purpossely misspelled my login to see if i get any error but it just shows the rotating arros foor 2-3 seconds then it shows me the original screen without any message of error. If anyone got the same issues and knows how to get me pass this step i would really appreciate your help. Thank you, Chris Link to comment Share on other sites More sharing options...
Carl Favre Posted January 26, 2012 Share Posted January 26, 2012 Hi ringo7, Could you give me in PM your url + database login/password so I can check it? Link to comment Share on other sites More sharing options...
s@fsoft Posted January 26, 2012 Share Posted January 26, 2012 Hi ringo7, Before you need to check the spelling of your accounts names/passwords. In order to move this installation step, do not check the SMTP option when installing prestashop. Leave it later. Test and see the result. S@fsoft Link to comment Share on other sites More sharing options...
BorisAlexandre Posted January 26, 2012 Share Posted January 26, 2012 I've just had this problem when doing a clean install on my personal server to do some testing locally... Re-downloaded the software, unzipped and put it back in the directory fixed everything... there must have been some corrupted file that didn't let it go forward. Hope this help ! 1 Link to comment Share on other sites More sharing options...
ringo7 Posted January 27, 2012 Author Share Posted January 27, 2012 Checked and rechecked the spelling of the credentials and they seem fine. Tryed that already Boris. But thanks for the thought anyway. I am keep looking for a solution. Can it be a hosting problem? Link to comment Share on other sites More sharing options...
ringo7 Posted February 6, 2012 Author Share Posted February 6, 2012 Still no solution for my problem. Any new ideeas anyone? Link to comment Share on other sites More sharing options...
s@fsoft Posted February 6, 2012 Share Posted February 6, 2012 Hi Ringo, Try to put 127.0.0.1 instead of localhost and see. Otherwise, you need to check if the database name is created in your phpmyadmin interface. If the problem persists. Give me the logins/passwords and I'll check with you the prblem. Safwen 1 Link to comment Share on other sites More sharing options...
ringo7 Posted February 22, 2012 Author Share Posted February 22, 2012 Still not getting by step 3 - db configuration. Anything else i could do? Regards, Chris. Link to comment Share on other sites More sharing options...
Desynet Posted March 1, 2012 Share Posted March 1, 2012 SOLUCIÓN PARA PASO 3 de Instalación de PrestaShop Configuración de la Base de Datos: Antecedente: Si ya se aseguraron de que el nombre de la base de datos, el nombre de usuario y contraseña sean correctos, entonces nos queda solo asegurarnos qué valor debe de ponerse en el campo "Servidor". El problema puede ser en la mayoría de los casos este valor de acuerdo a cada web hosting. SOLUCIÓN: Desde tu cuenta de Cpanel de tu Web Hosting abre la herramienta MySQL Base de Datos y allí te aparece una leyenda que dice así: ------------------------------ Host de MySQL remoto La dirección del servidor de mysql es 1**.15*.129.130. Al conectar con el servidor de mysql debe especificar este host. ------------------------------ Como ves te dice la dirección IP del servidor de tu Base de Datos, esta dirección es la que debes especificar y no la de tu nombre de dominio "exampledomain.com". Esto porque el Web Hosting que aloja a tu dominio puede tener un servidor exclusivo para Base de datos. A mi me funcionó la solución. Espero les ayude, comenten. Saludos! Link to comment Share on other sites More sharing options...
ringo7 Posted March 7, 2012 Author Share Posted March 7, 2012 I finally have my shop online. Thanks everyone for their time and williness to help me and special thanks to Scotty501 who solved my problem. Cheers! Link to comment Share on other sites More sharing options...
Scotty501 Posted March 7, 2012 Share Posted March 7, 2012 You are welcome 1 Link to comment Share on other sites More sharing options...
KyGoogleGuy Posted March 15, 2012 Share Posted March 15, 2012 Scotty501 - Care to share what you did to solve the problem? I have similar issues... Link to comment Share on other sites More sharing options...
Scotty501 Posted March 15, 2012 Share Posted March 15, 2012 To be honest - I just did a clean install. It tends to be username and database names that cause the problems - unless the server is complete trash - it rarely fails. If you let me have your web and FTP details (via PM) - I would be happy to take a look for you. Link to comment Share on other sites More sharing options...
korallis Posted March 17, 2012 Share Posted March 17, 2012 To be honest - I just did a clean install. It tends to be username and database names that cause the problems - unless the server is complete trash - it rarely fails. If you let me have your web and FTP details (via PM) - I would be happy to take a look for you. hey scotty501 i have deleted the entire dir and re uploaded and installed again and still i get stuck at step 3 with the same issue, any chance you can tell me how to fix it? Link to comment Share on other sites More sharing options...
cliqadam Posted March 17, 2012 Share Posted March 17, 2012 I have an identical problem could it be that my username and database contains an underscore I don't think it should be a problem because when i hit test connection it passes the process stops with the next button at the bottom of the page If anyone can offer any solution I would appreciate it very much Link to comment Share on other sites More sharing options...
cliqadam Posted March 18, 2012 Share Posted March 18, 2012 problem got fixed with a huge help of scotty501 thanx Solution: turn off magic quotes. magic_quotes_gpc this can be done in PHP.ini Magic quotes for incoming GET/POST/Cookie data. magic_quotes_gpc = Off or in WHM MAIN >> Service Configuration >>PHP Configuration Editor >> Advanced Mode worked for me hope it will for you Link to comment Share on other sites More sharing options...
Scotty501 Posted March 18, 2012 Share Posted March 18, 2012 I have sent you a PM with all your logins - glad I could help Edit your first post to mark topic as solved - helps other user find the working answer Edit = I just realised you did not start the thread. Link to comment Share on other sites More sharing options...
korallis Posted March 18, 2012 Share Posted March 18, 2012 scotty i replied to your pm mate :-) Link to comment Share on other sites More sharing options...
korallis Posted March 19, 2012 Share Posted March 19, 2012 problem got fixed with a huge help of scotty501 thanx Solution: turn off magic quotes. magic_quotes_gpc this can be done in PHP.ini Magic quotes for incoming GET/POST/Cookie data. magic_quotes_gpc = Off or in WHM MAIN >> Service Configuration >>PHP Configuration Editor >> Advanced Mode worked for me hope it will for you This did not work for me, but thanks for the suggestion Link to comment Share on other sites More sharing options...
G-Trade Posted July 22, 2012 Share Posted July 22, 2012 I have exact the same probleme on my server. Everything seems nice in ok, but validation of servername replys an error. Scotty501 (or anybody else)...could you help me solving this one, pls? Link to comment Share on other sites More sharing options...
shahjhan Posted July 29, 2012 Share Posted July 29, 2012 hi there, my database has been verified but an error arises: 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 \'sunni\'@\'localhost\' for table \'ps_access\'(Error: : 1142) how to resolve it?presta.bmp Link to comment Share on other sites More sharing options...
shahjhan Posted July 29, 2012 Share Posted July 29, 2012 hi there, my database has been verified but an error arises: 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 \'sunni\'@\'localhost\' for table \'ps_access\'(Error: : 1142) how to resolve it?presta.bmp 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