wxanl

Hi and thanx for your reply! I updated prestashop and enabled debug mode. Prestashop is now 1.7.8.10 When i click on VIEW INVOICE i get this error message Table 'xxxx.ps_mol_order_payment_fee' doesn't exist<br /><br /><pre>SELECT * FROM `ps_mol_order_payment_fee` a0 WHERE (a0.`id_order` = 569) </pre> I did not make any custom modifiations .

Hi there, when i try to print an invoice, all of a sudden i get this error message. I understand that it may be related to the payment module (Mollie) but i don't seem to be able to figure out what is actually going wrong. Any one has some insight in this ? Prestashop version 1.7.7.1 Mollie version 6.0.3 Unknown offset 0 for collection MolOrderPaymentFee [PrestaShopException 0] Deprecated: array_key_exists(): Using array_key_exists() on objects is deprecated. Use isset() or property_exists() instead in /home/....../public_html/src/Adapter/EntityMapper.php on line 99

Hi and thanx for your reply. First , mails do not end up in de spam folder. Ofcourse i did some test orders myself with a personal account to make sure that this isnt the case. I also never received the order confirmation mail (client). I did receive all the following mails. Hosting company checked the server queues and logs. They clearly show that the order confirmation mail is nog showing up (Thus not been sent by prestashop as it seems). However, the notification to the seller and the change order status change mails are actually sent and received. This is consistent and can be reproduced with every new order. To me it looks like smtp mail is actually working correctly. All other mails sent from prestashop are also received. I checked the logfile but cant find any entries about mail errors.

Hi there, It seems that a clients prestashop (1.7.7.1) is no longer sending order confirmation mails to clients. This worked until a couple of days ago. All other mails are sent just fine like status changes etc. Just not the initial order confirmation. Mails are also not showing up in the email server logs as being sent (all other mails do). I am not sure where to look for this problem since everything seems to be just fine as far as i can tell. Anyone has an idea where to look ?

Update: since could not get it to work, i enabled legacy smtp on that account. Now working

We have the situation that mail delivery from prestashop 1.7.7.1 mail alerts suddenly stopped with a error message (connection refused). We are using the smtp option with the right credentials for an office35 account. That used to work. According to the techs at the hosting the problem may be caused because Office 365 now requires TLS 1.2 minimum to connect. Can anyone tell me what TLS version prestashop is using or how to fix this problem ? Error: Please check your configuration Connection could not be established with host smtp.office365.com :stream_socket_client(): unable to connect to tcp://smtp.office365.com:587 (Connection refused)

Anyone who can help with this ? It is really starting to be a problem now and i have no idea how to fix it.

Hi, Unfortunately this is a recurring problem. As you can see in the images, i actually enter the right price into the tax excluded field (193,95). The tax including field automatically calculates the right price (234,68). However, when saved, it shows the wrong prices on the product page. The total price is correct but i don't understand where the tax excluded / included prices are comming from? I dont use any special prices or something. So i really don't understand why those amounts appear ? Anyone got a clue ?

Ahhh now i see where i went wrong. Thank you so much for explaining it ! 🙂

Thank a lot. I added those to the query but the output was empty. So i am not sure about the position. SELECT p.id_product, pa.reference, pl.name, GROUP_CONCAT(DISTINCT(pal.name) SEPARATOR ", ") as combination, p.price, pq.quantity pm.manufacturer_lang as manufacturer_name, pa.id_manufacturer as id_manufacturer FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_stock_available pq ON (p.id_product = pq.id_product AND pa.id_product_attribute = pq.id_product_attribute) LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_attribute_lang pal ON (pac.id_attribute = pal.id_attribute) LEFT JOIN ps_manufacturer_lang AS pm ON (p.id_manufacturer = pm.id_manufacturer) WHERE pl.id_lang = 1 AND pal.id_lang = 1 GROUP BY pa.reference ORDER BY p.id_product, pac.id_attribute

Anyone got a clue ? I did try to add a left join to ps_manufacturer but that did not work. So any help would be welcome.

Solved it by cleaning out server cache.

Hi, is it possible to build a query that generates a list of product by manufacturer? I am using PS 1.7.x I want a list that shows basically information like: Manufacturer 1 - Product ID - Product name - Product Category - Price excl. vat - Price incl. vat Manufacturer 1 - Product ID - Product name - Product Category - Price excl. vat - Price incl. vat Manufacturer 2 - Product ID - Product name - Product Category - Price excl. vat - Price incl. vat Manufacturer 2 - Product ID - Product name - Product Category - Price excl. vat - Price incl. vat So i tried this: SELECT p.id_product, pa.reference, pl.name, GROUP_CONCAT(DISTINCT(pal.name) SEPARATOR ", ") as combination, p.price, pq.quantity FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_stock_available pq ON (p.id_product = pq.id_product AND pa.id_product_attribute = pq.id_product_attribute) LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_attribute_lang pal ON (pac.id_attribute = pal.id_attribute) WHERE pl.id_lang = 1 AND pal.id_lang = 1 GROUP BY pa.reference ORDER BY p.id_product, pac.id_attribute Which shows me basically most of the information i need but i am missing - Category - Price incl. Vat - Manufacturer Can someone point me in the right direction please ?

The thin is that this is happening on all products. I checked but there is no discount or variation price set that comes close to the price displayed. I am really not sure where to look now.

Thanx for your reply. The url to this product is: https://quiterightsafetywear.com/regenbroeken/81-2104-vlamvertragende-antistatische-regenbroek.html#/2-maat-medium/105-kleur-blauw I checked combinations, tax settings, groups and discounts but could not find anything strange. Not sure about other modules though. Need to check that first.