Leizu Silk Posted April 5, 2018 Share Posted April 5, 2018 (edited) Hi Anytime i try to change something on my front-office translations page I get the following error: Any assistance is greatly appreciated! Edit: If i disable SSL i no longer get this error, instead clicking save in the translations page takes directly to my shop home page without saving my changes. 0 - Invalid controller: name='shop', format='' You may not be able to visit this page because of: an out-of-date bookmark/favourite a search engine that has an out-of-date listing for this site a mistyped address you have no access to this page The requested resource was not found. An error has occurred while processing your request. Please try one of the following pages: Home Page If difficulties persist, please contact the System Administrator of this site and report the error below. Invalid controller: name='shop', format='' Edited April 6, 2018 by Leizu Silk (see edit history) Link to comment Share on other sites More sharing options...
Leizu Silk Posted April 5, 2018 Author Share Posted April 5, 2018 Also getting this when trying to delete a picture from the theme configurator [PrestaShopDatabaseException] Table 'boutiqu1_pres768.ps6m_ps6m_themeconfigurator' doesn't exist DELETE FROM `ps6m_ps6m_themeconfigurator` WHERE id_item = 8 at line 791 in file classes/db/Db.php 786. if ($webservice_call && $errno) { 787. $dbg = debug_backtrace(); 788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 790. if ($sql) { 791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 792. } 793. 794. throw new PrestaShopDatabaseException($this->getMsgError()); 795. } 796. } DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 580 - classes/db/Db.php] - [1 Arguments] DbCore->delete - [line 397 - modules/themeconfigurator/themeconfigurator.php] - [2 Arguments] ThemeConfigurator->removeItem - [line 532 - modules/themeconfigurator/themeconfigurator.php] ThemeConfigurator->getContent - [line 868 - controllers/admin/AdminModulesController.php] AdminModulesControllerCore->postProcessCallback - [line 1117 - controllers/admin/AdminModulesController.php] AdminModulesControllerCore->postProcess - [line 178 - classes/controller/Controller.php] ControllerCore->run - [line 367 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 58 - admin/index.php] I recently migrated to php 7.1.5. Could this be the culprit? I am running prestashop 1.6.1.18 Link to comment Share on other sites More sharing options...
Leizu Silk Posted April 6, 2018 Author Share Posted April 6, 2018 My config info: Server information Linux #1 SMP Fri Nov 3 04:25:16 EDT 2017 x86_64 Server software version Apache PHP version 7.1.15 Memory limit 256M Max execution time 600 DATABASE INFORMATION MySQL version 10.2.13-MariaDB MySQL server localhost MySQL name boutiqu1_pres768 MySQL user boutiqu1_pres768 Tables prefix ps6m_ MySQL engine InnoDB MySQL driver DbPDO STORE INFORMATION PrestaShop version 1.6.1.18 Shop URL http://www.boutiquesleep.co.za/shop/ Current theme in use default-bootstrap MAIL CONFIGURATION Mail method You are using the PHP mail() function. YOUR INFORMATION Your web browser Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36 CHECK YOUR CONFIGURATION Required parameters OK Optional parameters OK Link to comment Share on other sites More sharing options...
selectshop.at Posted April 6, 2018 Share Posted April 6, 2018 @Leizu Silk- the answer to your database exception error is still treated here: https://www.prestashop.com/forums/topic/694326-prestashop-fatal-error-in-module-file-xxxxxclassesdbdbpdophp-call-to-a-member-function-rowcount-on-boolean-cannot-delete-images-themeconfigurator/# For the first problem with SSL, you should contact your provider. Read server error logs. Seems that something is going wrong with redirection from non-SSL to SSL. Link to comment Share on other sites More sharing options...
Leizu Silk Posted April 6, 2018 Author Share Posted April 6, 2018 7 minutes ago, selectshop.at said: @Leizu Silk- the answer to your database exception error is still treated here: https://www.prestashop.com/forums/topic/694326-prestashop-fatal-error-in-module-file-xxxxxclassesdbdbpdophp-call-to-a-member-function-rowcount-on-boolean-cannot-delete-images-themeconfigurator/# For the first problem with SSL, you should contact your provider. Read server error logs. Seems that something is going wrong with redirection from non-SSL to SSL. @selectshop.atThanks so much for your help! With regards to the SSL, turning off SSL and/or enabling/disabling "Enable SSL on all pages" doesnt resolve the issue. Is it still SSL related? I just want to make sure before contacting my host. Link to comment Share on other sites More sharing options...
selectshop.at Posted April 6, 2018 Share Posted April 6, 2018 It could be a wrong redirect of your browser as well. Delete browser cache if you are using SSL. Access your site with https: and not http: If this does not solve your problem, than it could be related to mod_rewrite and probably wrong set rights on your server. Ask you provider, if you need to make port change on your .htaccess, this means if you need to add to shop .htaccess the SSL port. Link to comment Share on other sites More sharing options...
Leizu Silk Posted April 6, 2018 Author Share Posted April 6, 2018 1 hour ago, selectshop.at said: It could be a wrong redirect of your browser as well. Delete browser cache if you are using SSL. Access your site with https: and not http: If this does not solve your problem, than it could be related to mod_rewrite and probably wrong set rights on your server. Ask you provider, if you need to make port change on your .htaccess, this means if you need to add to shop .htaccess the SSL port. I just spoke with my host and they said the following: We have been trying to apply the https:// redirect within your .htaccess of the Prestashop that is installed within the shop directory. Unfortunately the website runs into a "Too many Redirects" loop. We added the following to the .htaccess file: RewriteEngine On RewriteCond %{HTTPS} !=on RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] As well as the following solution: RewriteEngine on RewriteCond %{SERVER_PORT} 80 RewriteRule . - [E=REWRITEBASE:/] RewriteRule ^(.*)$ https://store.yoursite.com.my/$1 [R,L] (we did replace the "store.yoursite.com.my" with www.boutiquesleep.co.za/store and boutiquesleep.co.za/store Could you please request Prestashop if there is any other way to implement to avoid the 404 Missing pages or even the redirect loop? Is there an alternative method for example via the back-end of Prestashop or even via the database? Kindly confirm. Link to comment Share on other sites More sharing options...
selectshop.at Posted April 9, 2018 Share Posted April 9, 2018 There is no other way. Your provider should configure the server better for to serve for all events, this means to server for all software. The problem you are having is a server specific problem, not a Prestashop problem. Your provider should solve this. On well configured servers you only need to add two lines which are: rewriting http to https the new port The best way is that your provider configures https directly on the hosts-ini of your webspace on his server, than there is no need to add any line to the shop .htaccess. Link to comment Share on other sites More sharing options...
Leizu Silk Posted April 12, 2018 Author Share Posted April 12, 2018 Would upgrading to Prestashop 1.7 solve this? 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