logz05

It appears as though the incompatibility is because of having a Standard Registration Process (Preferences -> Customers -> Registration Process Type) instead of Address Only. It isn't very obvious but what this does is register the Delivery Address and allow and option to have a different Invoicing Address rather than the other way round. Hope this helps

Hi, +1 for exactly the same problem. The error log gives teh following: *ERROR* 2014/06/12 - 16:50:57: Invalid address at line 359 in file classes/Address.php My web is based in Spain with Spain, UK and Ireland as valid countries. I suspect that there maybe something to do with the address configuration. N

Hola Calamar, No era mi caso, pero puede ser algo más que he cambiado. Gracias

Hi, I have just found out that when a customer returns from having made a purchase in Paypal, they get to see a blank page. They get the message from PayPal confirming the transaction but they do not get the order confirmation email from PS. I would imagine that is because the order is not confirmed in the BO orders either! My error log is showing: [13-Nov-2013 17:11:25 Europe/Paris] PHP Fatal error: Undefined class constant 'FILTER_ACTION_ALL_NOCAP' in /home/xxx/public_html/classes/PaymentModule.php on line 403 Clearly this is the route cause. I have tried updating the PayPal module to the latest version in the Addons but without success - exactly the same problem. I am using 1.5.4.1 as the prestashop - this was upgraded from 1.4. Anyone any ideas about what is happening? Thanks

Tengo exactamente el mismo problema desde hace unos días Estoy usando PS1.5.4.1 Paypal 3.6.1 - actualizado pero da el mismo problema So lo resuelves postear la solución porfa - lo haré lo mismo!

Virtually all the products have attributes - that is not a tenable solution. What I don't understand is that this is standard Prestashop code - untouched by human hand - I guess it should work!! I have even tried the file on Github....and still no joy. Is there a limitation to the number of products and attributes that PS can handle, is that what we are seeing. Tonight I am upgrading the server to 4Gb RAM to see if that can cope.

10....per page

31 views and no-one with any similar situation?

Hi Viktor I have pretty much the same problem - I too have narrowed it down to the same query. Did you solve it?

Hi, There is a process in classes/Category.php that is killing my server. PS 1.5.4.1 VPS with 2GB 2361 products 100'2 of attributes but obviously not all used at the same time. I am getting major mySQL hangups (up to 450 seconds of process time) with the query in this file: $sql = 'SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL '.(Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY)) > 0 AS new, product_shop.price AS orderprice FROM `'._DB_PREFIX_.'category_product` cp LEFT JOIN `'._DB_PREFIX_.'product` p ON p.`id_product` = cp.`id_product` '.Shop::addSqlAssociation('product', 'p').' LEFT JOIN `'._DB_PREFIX_.'product_attribute` pa ON (p.`id_product` = pa.`id_product`) '.Shop::addSqlAssociation('product_attribute', 'pa', false, 'product_attribute_shop.`default_on` = 1').' '.Product::sqlStock('p', 'product_attribute_shop', false, $context->shop).' LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('cl').') LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').') LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product`)'. Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1').' LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$id_lang.') LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = '.(int)$context->shop->id.' AND cp.`id_category` = '.(int)$this->id .($active ? ' AND product_shop.`active` = 1' : '') .($front ? ' AND product_shop.`visibility` IN ("both", "catalog")' : '') .($id_supplier ? ' AND p.id_supplier = '.(int)$id_supplier : '') .' GROUP BY product_shop.id_product'; if ($random === true) { $sql .= ' ORDER BY RAND()'; $sql .= ' LIMIT 0, '.(int)$random_number_products; } else $sql .= ' ORDER BY '.(isset($order_by_prefix) ? $order_by_prefix.'.' : '').'`'.pSQL($order_by).'` '.pSQL($order_way).' LIMIT '.(((int)$p - 1) * (int)$n).','.(int)$n; $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql); if ($order_by == 'orderprice') Tools::orderbyPrice($result, $order_way); if (!$result) return array(); /* Modify SQL result */ return Product::getProductsProperties($id_lang, $result); It is a major query and is quite clearly killing the web..... There are others that are suffering from the same thing: http://www.prestashop.com/forums/topic/268962-possible-bug-prestasho-with-many-20000-products-kills-database/ http://www.prestashop.com/forums/topic/253715-fight-with-speed-now-sql-problem/ http://forge.prestashop.com/browse/PSCFV-10147page=com.atlassian.jira.plugin.system.issuetabpanels%3Achangehistory-tabpanel and a little googling finds a a lot off sites that are showing PrestashopDatabase Exceptions as well Has anyone come across this and is so have you found a solution?

Hi, When searching for a product in 1.5.4.1 the default url is: index.php?controller=search&orderby=position&orderway=desc&search_query=almohadas+de+plumas&submit_search=+ How can I change the orderby and orderway so the url becomes: index.php?controller=search&orderby=name&orderway=asc&search_query=almohadas+de+plumas&submit_search=+ I have changed everywhere I can think of including: classes/Search.php controllers/SearchController When you use the select box the URL changes to index.php?controller=search?search_query=almohadas+de+plumas&submit_search=+&orderby=name&orderway=asc I would be willing to take an htaccess redirect rule to act like this. Anyone got any ideas?

Hi I can exclude the category from the discount but if the customer puts in a product which is in a category that has the discount applied AND a product from the non discounted category, THEN the voucher discount is applied to everything. IS there no other solution? BIG EDIT! SOLVED (for me at least) In Actions mark the Apply discount to "Selected Products"

Gracias tío

You bet ... you receive orders from suppliers and you need to go through all open orders to find the one that requires fulfilling

Hola, Alguien sabe como buscar para pedidos abiertos (pendiente de envio) por producto en PS 1.5.4? Normalmente tenemos más de 100 pedidos pendientes de recibir productos desde nuestros proveedores. Cuando llega la mercancia necesitamos encontrar los pedidos que corresponden. No veo como hacerlo?