Maurizio Fabbri Posted March 14, 2014 Share Posted March 14, 2014 (edited) Hello. My Prestashop version is 1.4.11.0. I finished the site and I want to remove the password protected directory. I have public_html folder protected. I need to remove it. I tried deleting the user in Cpanel and some tutorials but nothing happens. The prompt/pop up continues appearing when I type the website name www.celma.com.ve. My hosting provider said me: add this to your htaccess file: <Directory /var/www/protected/> AuthType Basic AuthName "Production" AuthUserFile /path/to/.htpasswd Require valid-user </Directory> <Directory /var/www/protected/unprotected> Satisfy Any </Directory> But when exactly I have to add that? This is my htaccess file: # .htaccess automaticaly generated by PrestaShop e-commerce open-source solution # WARNING: PLEASE DO NOT MODIFY THIS FILE MANUALLY. IF NECESSARY, ADD YOUR SPECIFIC CONFIGURATION WITH THE HTACCESS GENERATOR IN BACK OFFICE # http://www.prestashop.com - http://www.prestashop.com/forums <IfModule mod_rewrite.c> # URL rewriting module activation RewriteEngine on # URL rewriting rules RewriteRule ^api/?(.*)$ /webservice/dispatcher.php?url=$1 [QSA,L] </IfModule> # Catch 404 errors ErrorDocument 404 /404.php PLEASE HELP ME. Edited March 24, 2014 by Maurizio Fabbri (see edit history) Link to comment Share on other sites More sharing options...
Bill Dalton Posted March 14, 2014 Share Posted March 14, 2014 You need to put it above this, # .htaccess automaticaly generated by PrestaShop e-commerce open-source solution# WARNING: PLEASE DO NOT MODIFY THIS FILE MANUALLY. IF NECESSARY, ADD YOUR SPECIFIC CONFIGURATION WITH THE HTACCESS GENERATOR IN BACK OFFICE# http://www.prestashop.com - http://www.prestashop.com/forums Anything you add to your htaccess file must go above the warning, everything you add below that we be overwritten as you make changes to your web site. Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 14, 2014 Author Share Posted March 14, 2014 Thank you for your answer Bill. So, it would be this: <Directory /var/www/protected/> AuthType Basic AuthName "Production" AuthUserFile /path/to/.htpasswd Require valid-user </Directory> <Directory /var/www/protected/unprotected> Satisfy Any </Directory> # .htaccess automaticaly generated by PrestaShop e-commerce open-source solution # WARNING: PLEASE DO NOT MODIFY THIS FILE MANUALLY. IF NECESSARY, ADD YOUR SPECIFIC CONFIGURATION WITH THE HTACCESS GENERATOR IN BACK OFFICE # http://www.prestashop.com - http://www.prestashop.com/forums <IfModule mod_rewrite.c> # URL rewriting module activation RewriteEngine on # URL rewriting rules RewriteRule ^api/?(.*)$ /webservice/dispatcher.php?url=$1 [QSA,L] </IfModule> # Catch 404 errors ErrorDocument 404 /404.php Won't this cause any damage? sure I can click on save changes? 1 Link to comment Share on other sites More sharing options...
Bill Dalton Posted March 14, 2014 Share Posted March 14, 2014 Good! Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 14, 2014 Author Share Posted March 14, 2014 (edited) Nothing happens. It continues. See picture please. Edited March 14, 2014 by mauriziofabbri (see edit history) Link to comment Share on other sites More sharing options...
Bill Dalton Posted March 14, 2014 Share Posted March 14, 2014 For that you need to talk to your host and ask why. You did do what they told you do correctly. Link to comment Share on other sites More sharing options...
tuk66 Posted March 14, 2014 Share Posted March 14, 2014 You must remove AuthType Basic AuthName "Production" AuthUserFile /path/to/.htpasswd Require valid-user to remove folder protection. not add. Just regenerate your .htaccess file. 1 Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 15, 2014 Author Share Posted March 15, 2014 (edited) My Hosting Provider said me: "if that does not work, try deleting the account completely (all the website), and create it again and upload all the files to the public_html again and upload the database. So, I did it. I made a backup, deleted the account in the WHM and created it again. www.celma.com.ve. I uploaded all the website files and folders to public_html in Cpanel and uploaded the database to phpmyadmin, after "create the database" in MySql databases with the same name. I couldn't import the database because when I tried it showed a red message saying something related with time, "execution time passed..." or something like that and just 29 tables of it were imported. And the database has more than 100 tables. The database is really small, only 1 Mb. My Hosting Provider helped me to import it, but when I opened the phpmyadmin I saw the same I had seen when I tried (just 29 tables of the database). Now we see this when trying to access to the site: Bad SubDomain SQL query. So, Why? What happened? You can see the error message here --> www.celma.com.ve. How can I solve this? Where is my site? cooperate with me, help me please. Edited March 15, 2014 by Maurizio Fabbri (see edit history) Link to comment Share on other sites More sharing options...
Bill Dalton Posted March 15, 2014 Share Posted March 15, 2014 First, you should not need to delete everything it turn off your login problem. If your host told you to delete everything that was CRAZY. It sounds like you were getting an error message related to PHP script execution time. Your host had your PHP permissions set to low. My advise is to get a new host. Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 15, 2014 Author Share Posted March 15, 2014 Do you know if we can solve the problem with this? http://www.reboot.ro/tutorials/how-to-solve-bad-subdomain-sql-query-on-prestashop-update-from-1-4-x-to-1-5-x/ Link to comment Share on other sites More sharing options...
El Patron Posted March 15, 2014 Share Posted March 15, 2014 I get Bad SubDomain SQL query. I think it might be simpler to just (back up first) the .htaccess and then re-generate the .htaccess from back office. back office-->tools-->generators-->regenerate .htaccess suerte! Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 15, 2014 Author Share Posted March 15, 2014 Thank you Patron, but I can't access to the Prestashop Admin Panel! Link to comment Share on other sites More sharing options...
El Patron Posted March 15, 2014 Share Posted March 15, 2014 Thank you Patron, but I can't access to the Prestashop Admin Panel! doh! what did you do? I suppose, just blowing ideas into the wind...not knowing what you 'might' have done is to back up the .htaccess via ftp and then delete the remote...see if that gets you anywhere... Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 15, 2014 Author Share Posted March 15, 2014 (edited) Patron thank you very much for your concern. Did you read the paragraph (the big paragraph) which begins: "My Hosting Provider said me: "if that does not work, try..."... up here in this topic, answering to Bill Dalton and tuk66? Edited March 15, 2014 by Maurizio Fabbri (see edit history) Link to comment Share on other sites More sharing options...
El Patron Posted March 15, 2014 Share Posted March 15, 2014 Patron thank you very much for your concern. Did you read the paragraph (the big paragraph) which begins: "My Hosting Provider said me: "if that does not work, try..."... up here in this topic, answering to Bill Dalton and tuk66? I do agree with Mr. Dalton, i.e. crazy of hosting to suggest deleting and re-uploading. You will need to resolve importing the db to resolve that issue before proceeding (sorry I did not read the original longer post more carefully). If you are not able to upload via phpmyadmin, I suggest contacting your hosting company to help...as that is beyond what can be accomplished here by us. Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 16, 2014 Author Share Posted March 16, 2014 (edited) Patron. What do you think about this? http://www.reboot.ro/tutorials/how-to-solve-bad-subdomain-sql-query-on-prestashop-update-from-1-4-x-to-1-5-x/ Zeepshop sent me that. He said me to try it, to solve the issue. What's your opinion? I know I have to solve phpmyadmin problem first. Because the database is not complete. Edited March 16, 2014 by Maurizio Fabbri (see edit history) Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 16, 2014 Author Share Posted March 16, 2014 (edited) I changed config/config.inc.php /* Debug only */ @ini_set('display_errors', 'on'); define('_PS_DEBUG_SQL_', true); And I get this: Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 130968 bytes) in /home/fecelma/public_html/classes/Db.php on line 611 NOTE: The database is not complete, I tried to upload it several times and nothing. It should be 165 tables more or less. And just uploades 29, 39 or 65 tables. I don't know what is happening with phpmyadmin. RED ERROR MESSAGE in phpmyadmin when trying to upload the database: something like.... "It has timed script execution, if you want to finish import resubmit same file and import will resume." I changed again /* Debug only */ @ini_set('display_errors', 'on'); define('_PS_DEBUG_SQL_', true); and still the message: Bad SubDomain SQL query. Edited March 16, 2014 by Maurizio Fabbri (see edit history) Link to comment Share on other sites More sharing options...
El Patron Posted March 16, 2014 Share Posted March 16, 2014 Hi, darn loads of problems but don't give up. ask your hosting provider to increase you memory to 256mb. (you now have 128mb) as for the phpmyadmin, did you resubmit as instructed in the message above. Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 16, 2014 Author Share Posted March 16, 2014 (edited) sorry, I changed it again to /* Debug only */ @ini_set('display_errors', 'off'); define('_PS_DEBUG_SQL_', false); and still the message: Bad SubDomain SQL query. Can I increase that value to 256 mb? (memory) Edited March 16, 2014 by Maurizio Fabbri (see edit history) Link to comment Share on other sites More sharing options...
El Patron Posted March 16, 2014 Share Posted March 16, 2014 have you successfully uploaded you db? Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 16, 2014 Author Share Posted March 16, 2014 have you successfully uploaded you db? Still not. I am trying right now. I changed this file: I added memory_limit=256M; register_globals=off max_input_vars = 10000; suhosin.get.max_vars = 10000; suhosin.post.max_vars = 10000 memory_limit=256M; Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 16, 2014 Author Share Posted March 16, 2014 Still not. I am trying right now. I changed this file: I added memory_limit=256M; register_globals=off max_input_vars = 10000; suhosin.get.max_vars = 10000; suhosin.post.max_vars = 10000 memory_limit=256M; Nothing, it uploaded just 39 tables. Error Message: "Se ha agotado el tiempo de ejecución del script; si desea completar la importación reenvíe el mismo archivo y la importación continuará." Link to comment Share on other sites More sharing options...
El Patron Posted March 16, 2014 Share Posted March 16, 2014 Nothing, it uploaded just 39 tables. Error Message: "Se ha agotado el tiempo de ejecución del script; si desea completar la importación reenvíe el mismo archivo y la importación continuará." please contact your hosting company to help with getting db loaded. They should have never told you to delete and start over...ave maria pues Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 16, 2014 Author Share Posted March 16, 2014 (edited) please contact your hosting company to help with getting db loaded. They should have never told you to delete and start over...ave maria pues I am driving me crazy. They take too long, too long to respond. I tried again uploading the database, and now it uploaded 75 tables. 10 more. 90 missing.... more or less. Edited March 16, 2014 by Maurizio Fabbri (see edit history) Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 17, 2014 Author Share Posted March 17, 2014 SOLVED!!!!!!!!! , I finally restored the database!!!!!!!!!! after 100 attempts more or less!! thank you very much El Patron, thank you Bill Dalton, thank you tuk66, thank you to Zeepshop, thank you to all for your help and concern!. Thank you so much! Now I just would like to know how to accelerate/speed up the site. 1 Link to comment Share on other sites More sharing options...
El Patron Posted March 17, 2014 Share Posted March 17, 2014 SOLVED!!!!!!!!! , I finally restored the database!!!!!!!!!! after 100 attempts more or less!! thank you very much El Patron, thank you Bill Dalton, thank you tuk66, thank you to Zeepshop, thank you to all for your help and concern!. Thank you so much! Now I just would like to know how to accelerate/speed up the site. that's great news!...and you learned thing that will serve you well in the future. Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 17, 2014 Author Share Posted March 17, 2014 Yes, how can I edit the title and put [sOLVED] ? Link to comment Share on other sites More sharing options...
El Patron Posted March 17, 2014 Share Posted March 17, 2014 Yes, how can I edit the title and put [sOLVED] ? edit the original post, then select more reply options, then you can edit the subject. Link to comment Share on other sites More sharing options...
Maurizio Fabbri Posted March 18, 2014 Author Share Posted March 18, 2014 Hello. My Prestashop version is 1.4.11.0. I finished the site and I want to remove the password protected directory. I have public_html folder protected. I need to remove it. I tried deleting the user in Cpanel and some tutorials but nothing happens. The prompt/pop up continues appearing when I type the website name www.celma.com.ve. My hosting provider said me: add this to your htaccess file: <Directory /var/www/protected/> AuthType Basic AuthName "Production" AuthUserFile /path/to/.htpasswd Require valid-user </Directory> <Directory /var/www/protected/unprotected> Satisfy Any </Directory> But when exactly I have to add that? This is my htaccess file: # .htaccess automaticaly generated by PrestaShop e-commerce open-source solution # WARNING: PLEASE DO NOT MODIFY THIS FILE MANUALLY. IF NECESSARY, ADD YOUR SPECIFIC CONFIGURATION WITH THE HTACCESS GENERATOR IN BACK OFFICE # http://www.prestashop.com - http://www.prestashop.com/forums <IfModule mod_rewrite.c> # URL rewriting module activation RewriteEngine on # URL rewriting rules RewriteRule ^api/?(.*)$ /webservice/dispatcher.php?url=$1 [QSA,L] </IfModule> # Catch 404 errors ErrorDocument 404 /404.php PLEASE HELP ME. [sOLVED] 1 Link to comment Share on other sites More sharing options...
webadherhone Posted August 26, 2016 Share Posted August 26, 2016 Hello , i have accidentaly erased my htaccess file, so i can't access to anything anymore. How can i generate an htaccess file or make my own to recover everything ? Thanks for support. Link to comment Share on other sites More sharing options...
Bill Dalton Posted August 26, 2016 Share Posted August 26, 2016 Go to Preferences > SEO & URLs Turn off Friendly URL Save Turn On Friendly URL Save That should do it. 1 Link to comment Share on other sites More sharing options...
Recommended Posts