Jacek Es
Members-
Posts
64 -
Joined
-
Last visited
About Jacek Es
- Birthday 07/29/1975
Profile Information
-
Location
Portugal
-
Activity
Developer
Recent Profile Visitors
935 profile views
Jacek Es's Achievements
-
State field not showing in front end customer address editing
Jacek Es replied to Jacek Es's topic in General topics
It turns out that the State field can be added in the Address format under the Country settings. Everything works as expected -
State field not showing in front end customer address editing
Jacek Es replied to Jacek Es's topic in General topics
Thanks, again. I have submitted this to PrestaShop's official support team . I will update this here once available. -
State field not showing in front end customer address editing
Jacek Es replied to Jacek Es's topic in General topics
Hi, Thanks for the hints. I tested this on the brand new installation of PrestaShop 8.0.4 with the default theme to exclude custom theme issues. The same results. In the front end (address edit by the customer) the State field only shows for the countries that have States added by default - United States, Mexico, Canada, Argentina, Italy, Indonesia, Japan, Australia, India. For any other country if you add States to them and mark this option in the Country info (Contains states? Yes) the field State only shows in the backend address edit but not in the front end edited by the customer. Interesting part is that if you disable States option for one of Countries that have States added by default (Contains states? No), for example United States then the field State still shows in the front end but does not contain any options to select. This makes me think that Prestashop can only display State field for the countries that have States added by default. You cannot add this option ton other country. Is this a bug? Could be something to do with conditionals reducing this functionality to United States, Mexico, Canada, Argentina, Italy, Indonesia, Japan, Australia, India. Steps to reproduce: 1. Install PS 8.0.4 with the default theme 2. Edit country info for United Kingdom and mark as containing States - (Contains states? Yes) 3. Create sample States for United Kingdom 4. Via the front end create a customer account and add address - the field State is not visible 5. Try add a customer address via the back office - the field State is visible and contains created states (from step 3) I cleared cache after each change and the same results. Jacek -
Hello PrestaShop version: 8.0.4 I am using STATE field for United Kingdom country. I have set this in the country information (Contains states? Yes). In the admin, this field is visible when editing addresses but it's not visible when editing the address in the front end by the customer. When changing country to USA the State field shows up but it doesn't show for the United Kingdom. Any idea how to resolve this? Jacek
-
So many Abandoned Shopping carts HELP
Jacek Es replied to officialkeys's topic in Configuring and using PrestaShop
I know the issue happened long ago (2016) but maybe someone else will benefit from this solution. You can identify the bot responsible for shopping cart creation in Raw access file on your server. Once you identify the bot you can block it via .htaccess. More info: https://www.phpbb.com/community/viewtopic.php?t=2550501 It helped me but unfortunately some bots don't use a signature (bot name) and they change the IP quite often so blocking IP also doesn't work. Can anyone suggest alternative solution for bots that don't have signature? Is there a way to block access to anyone who add items to cart in a time span that is shorter than specified? Let's say to block access to the site for visitors who add product to cart more than once and in the time shorter than 3 sec? -
[sOLVED]Display lowest price on product list page
Jacek Es replied to floriqn's topic in General topics
Hello, With the arrival of PrestaShop 8 have anyone achieved this on PrestaShop 8. It's a very useful feature -
Hello, I tried to update the shop from 1.7.2.4 to 1.7.8.8 but after the process the back end displays the following error: Call to a member function getRequestUri() on null [Symfony\Component\Debug\Exception\FatalThrowableError 0] The front end just displays HTTP ERROR 500. I first tried to use the 1-click upgrade module and then tried manual update as described here: https://devdocs.prestashop-project.org/1.7/basics/keeping-up-to-date/upgrade/ but the result is the same with the above error message. Can anyone point me in the right direction? Thanks
-
Hi, This works great! Thank you. I would love to see a modification that instead of the Price a minimum price is displayed based on the quantity discounts. Would this be possible? PrestaShop 1.6 Jacek
-
Hi, Prestashop 1.6.0.8 Stripe 2.3.5 I just installed the Stripe module. It's working but on each transaction there is a note: "Warning: the secure key is empty, check your payment account before validation". I found this old post in the archive: Can anyone suggest how to resolve this? Thanks, Jacek
-
Jacek Es started following No products displayed , [Module] PrestaShop MultiShop Pro PS 1.6.x | 1.7.x by PrestaHeroes and Consulta SQL incorrecta Expression #13 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'base.pd.nb_downloadable' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_ful
-
[SOLVED] As I thought. It was related to MySQL server update to 5.7. I avoided full update. Instead my web hosting changed configuration on the server and it works again on MySQL 5.7. WEB HOSTING ANSWER: 'not in GROUP BY clause and contains nonaggregated column ' is a common issue when going from 5.6 to 5.7. It can be fixed with a config change to make it backwards compatible.
-
This is most likely related to update to MySQL on my server. It turns out my hosting did update to MySQL version from 5.5 to 5.7.26 last night. Any idea how to fix this without updating the core of PrestaShop. I am running PS 1.6.0.8
-
Consulta SQL incorrecta Expression #13 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'base.pd.nb_downloadable' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_ful
Jacek Es replied to feryseg's topic in PrestaShop Download: instalación, actualización y configuración
I have the same issue. PHP version on my server is 5.6.40. Anyone solved it? -
Hi, PS 1.6 Suddenly no products are displayed within the category, only product count (example: There are 5 products.). This is for all categories. In admin product list I have this error message: " Bad SQL query Expression #13 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'osl_prestashop.pd.nb_downloadable' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by" I brought files and database from backup when everything was fine but still the same error. I am clueless ...