Since1953

We found someone local to do it for us. If anyone else out there needs a bridge from (Icode) Everest to Prestashop, message me.

As soon as we reduced our shipping options to "UPS Shipping Ground" and "Local Pickup" it sped ours up significantly, so I don't know if it's an issue with the UPS module or something else.

Experiencing the same bug when I try to edit some products, although if I find the right table/field in PHP My Admin it seems to bypass it. PrestaShop™ 1.6.0.8

I'm experiencing the "%5C" bug as well. Very annoying, but I found a workaround by going to the database and editing the "content" field in "xxx_cms_lang". Once you do it there, it seems to keep the url. By the way, it's in ALL my CMS pages, not just the block.

*Bump*

The problem I'm getting is that when it goes to the backup step I get the following error (and I haven't figured out a way around it): "Unable to create backup db file /home3/xxxxxxx/public_html/psadmin/autoupgrade/backup/V1.5.3.1_xxxxxxxxx.sql.bz2"

I even tried changing permissions of that folder to ALL (777) via FTP (as I read that fixed it for a few people on another forum post) but it didn't solve the problem.

I'm getting the same error while trying to upgrade a test prestashop installation from 1.5.3.1.

Did the documentation mention anything about a fix?

So how do I fix it? It's preventing some customers from registering...

There is a module called "Featured Products on the Homepage" and you have to configure it: "In order to add products to your homepage, just add them to the "home" category." We had to change all of our products into other categories and then only put the ones we want featured into the "home" category.

I have the same problem and I know what's causing it for us - $0 items. We provide seminars free of charge and when they add the item to their cart, even though payment is not required, it throws this error. Until this week I was under the impression that even though the error was generated the orders were going through, but a customer contacted me and let me know it wouldn't let him "register" (check out) because of the error. I've sent emails to Paypal, but I haven't seen any responses. Here is the error message I get: L_ERRORCODE0 -> 10525 L_SHORTMESSAGE0 -> Invalid Data L_LONGMESSAGE0 -> This transaction cannot be processed. The amount to be charged is zero. L_SEVERITYCODE0 -> Error

So were you able to do this in 1.5.3 without setting up discount pricing for everything? In other words, I would like everyone that goes to our website to be able to see a list price and our sell price (without having to login). It would be nice if this could be configured in the product page via the BO.

This is the log from mysql_slow_queries: # Wed Apr 24 10:17:28 2013 # Query_time: 3.512260 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use tvspecia_pre2; SET timestamp=1366820248; SET NAMES 'utf8' # Wed Apr 24 10:23:13 2013 # Query_time: 1.987945 Lock_time: 0.000186 Rows_sent: 1 Rows_examined: 18 use tvspecia_pre2; SET timestamp=1366820593; SELECT COUNT(DISTINCT nl.`id_prestablog_news`) AS `value` FROM `bhb_prestablog_news_lang` As nl LEFT JOIN `bhb_prestablog_correspondancecategorie` As co ON (co.news = nl.id_prestablog_news) LEFT JOIN `bhb_prestablog_categorie` As c ON (co.categorie = c.id_prestablog_categorie) LEFT JOIN `bhb_prestablog_news` As n ON (nl.id_prestablog_news = n.id_prestablog_news) WHERE n.`actif` = 1 AND nl.`id_lang` = 1 AND nl.`actif_langue` = 1 AND TIMESTAMP(n.`date`) <= '2013/04/24 12:23:11' AND c.`actif` = 1 AND c.id_prestablog_categorie = 2 LIMIT 1 # Wed Apr 24 10:23:17 2013 # Query_time: 1.271403 Lock_time: 0.000916 Rows_sent: 1 Rows_examined: 1 use tvspecia_pre2; SET timestamp=1366820597; SELECT `name`, `meta_title`, `meta_description`, `meta_keywords` FROM `bhb_manufacturer_lang` ml LEFT JOIN `bhb_manufacturer` m ON (ml.`id_manufacturer` = m.`id_manufacturer`) WHERE ml.id_lang = 1 AND ml.id_manufacturer = 7 LIMIT 1 # Wed Apr 24 10:23:17 2013 # Query_time: 3.795317 Lock_time: 0.002723 Rows_sent: 10 Rows_examined: 2143 use tvspecia_pre2; SET timestamp=1366820597; SELECT p.*, product_shop.*, product_shop.id_category_default, pl.*, i.id_image, il.legend, m.name manufacturer_name, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 0 DAY)) > 0 AS new FROM `bhb_category_product` cp LEFT JOIN bhb_category c ON (c.id_category = cp.id_category) LEFT JOIN `bhb_product` p ON p.`id_product` = cp.`id_product` INNER JOIN bhb_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN bhb_product_lang pl ON (pl.id_product = p.id_product) LEFT JOIN bhb_image i ON (i.id_product = p.id_product AND i.cover = 1) LEFT JOIN bhb_image_lang il ON (i.id_image = il.id_image AND il.id_lang = 1) LEFT JOIN bhb_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) WHERE product_shop.`active` = 1 AND c.nleft >= 7 AND c.nright <= 24 AND c.active = 1 AND pl.id_lang = 1 AND p.id_product IN (12,22,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,78,79,80,81,82,83,85,86,87,88,89,90,91,184,192,1348,1349,1350,1351,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1427,1428,1429,1430,1431,1432,1433,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490) GROUP BY p.id_product ORDER BY pl.name asc LIMIT 20,10 # Wed Apr 24 10:25:57 2013 # Query_time: 1.495897 Lock_time: 0.000213 Rows_sent: 1 Rows_examined: 18 use tvspecia_pre2; SET timestamp=1366820757; SELECT COUNT(DISTINCT nl.`id_prestablog_news`) AS `value` FROM `bhb_prestablog_news_lang` As nl LEFT JOIN `bhb_prestablog_correspondancecategorie` As co ON (co.news = nl.id_prestablog_news) LEFT JOIN `bhb_prestablog_categorie` As c ON (co.categorie = c.id_prestablog_categorie) LEFT JOIN `bhb_prestablog_news` As n ON (nl.id_prestablog_news = n.id_prestablog_news) WHERE n.`actif` = 1 AND nl.`id_lang` = 1 AND nl.`actif_langue` = 1 AND TIMESTAMP(n.`date`) <= '2013/04/24 12:25:56' AND c.`actif` = 1 AND c.id_prestablog_categorie = 2 LIMIT 1 # Wed Apr 24 10:26:46 2013 # Query_time: 2.179915 Lock_time: 0.000137 Rows_sent: 1 Rows_examined: 1 use tvspecia_pre2; SET timestamp=1366820806; SELECT * FROM `bhb_carrier` a LEFT JOIN `bhb_carrier_shop` `c` ON a.id_carrier = c.id_carrier AND c.id_shop = 1 WHERE (a.id_carrier = 24) LIMIT 1 # Wed Apr 24 10:27:02 2013 # Query_time: 1.455544 Lock_time: 0.000220 Rows_sent: 0 Rows_examined: 1 use tvspecia_pre2; SET timestamp=1366820822; UPDATE `bhb_configuration` SET `value` = '4',`date_upd` = '2013-04-24 12:27:00' WHERE `name` = 'PS_SHIPPING_HANDLING' AND id_shop_group IS NULL AND id_shop IS NULL LIMIT 1 # Wed Apr 24 10:30:24 2013 # Query_time: 1.728818 Lock_time: 0.000241 Rows_sent: 1 Rows_examined: 18 use tvspecia_pre2; SET timestamp=1366821024; SELECT COUNT(DISTINCT nl.`id_prestablog_news`) AS `value` FROM `bhb_prestablog_news_lang` As nl LEFT JOIN `bhb_prestablog_correspondancecategorie` As co ON (co.news = nl.id_prestablog_news) LEFT JOIN `bhb_prestablog_categorie` As c ON (co.categorie = c.id_prestablog_categorie) LEFT JOIN `bhb_prestablog_news` As n ON (nl.id_prestablog_news = n.id_prestablog_news) WHERE n.`actif` = 1 AND nl.`id_lang` = 1 AND nl.`actif_langue` = 1 AND TIMESTAMP(n.`date`) <= '2013/04/24 12:30:23' AND c.`actif` = 1 AND c.id_prestablog_categorie = 2 LIMIT 1

I have tried it on a few different installations of 1.5.X with similar results. I am currently running 1.5.3. Consistently, when you click "add to cart" it takes about 5 seconds for the product to be added to the cart. I've used firebug to determine that the delay is happening during the POST function. The GET function takes under 100ms, which is acceptable. Is there a way to speed this up?