Willy15

Hi @AquaPlanning, I had exactly the same problem. Fixed it adding this into /classes/db/DbPDO.php, in the getPDO function. define ('_PS_ALLOW_MULTI_STATEMENTS_QUERIES_', null); Don't forget to backup your file! Not sure what might have caused it, the backoffice was working fine after updating to 1.7.8.8. Hope it helps! ????

Hi @marketyellow3, did you find a solution for this? It only makes sense when payment is by bank transfer.

Hi I have a similar problem on 1.7.6.7. I have the City field disabled but for some reason is still marked as required, and I get 500 server error when a customer attempt to add a new address. I tried to override Address.php but it didn't work, so I ended up editing the core class similar to @rocky solution, of course I have a note to myself now: "don't forget to redo this change after updating PS". I'm not an expert, actually I'm not even sure you can override this. Am I missing something on the override? <?php class Address extends AddressCore { public static $definition = array( 'table' => 'address', 'primary' => 'id_address', 'fields' => array( 'id_customer' => array('type' => self::TYPE_INT, 'validate' => 'isNullOrUnsignedId', 'copy_post' => false), 'id_manufacturer' => array('type' => self::TYPE_INT, 'validate' => 'isNullOrUnsignedId', 'copy_post' => false), 'id_supplier' => array('type' => self::TYPE_INT, 'validate' => 'isNullOrUnsignedId', 'copy_post' => false), 'id_warehouse' => array('type' => self::TYPE_INT, 'validate' => 'isNullOrUnsignedId', 'copy_post' => false), 'id_country' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true), 'id_state' => array('type' => self::TYPE_INT, 'validate' => 'isNullOrUnsignedId'), 'alias' => array('type' => self::TYPE_STRING, 'validate' => 'isGenericName', 'required' => true, 'size' => 32), 'company' => array('type' => self::TYPE_STRING, 'validate' => 'isGenericName', 'size' => 255), 'lastname' => array('type' => self::TYPE_STRING, 'validate' => 'isName', 'required' => true, 'size' => 255), 'firstname' => array('type' => self::TYPE_STRING, 'validate' => 'isName', 'required' => true, 'size' => 255), 'vat_number' => array('type' => self::TYPE_STRING, 'validate' => 'isGenericName'), 'address1' => array('type' => self::TYPE_STRING, 'validate' => 'isAddress', 'required' => true, 'size' => 128), 'address2' => array('type' => self::TYPE_STRING, 'validate' => 'isAddress', 'size' => 128), 'postcode' => array('type' => self::TYPE_STRING, 'validate' => 'isPostCode', 'size' => 12), /* This was set to false for the override */ 'city' => array('type' => self::TYPE_STRING, 'validate' => 'isCityName', 'required' => false, 'size' => 64), 'other' => array('type' => self::TYPE_STRING, 'validate' => 'isMessage', 'size' => 300), 'phone' => array('type' => self::TYPE_STRING, 'validate' => 'isPhoneNumber', 'size' => 32), 'phone_mobile' => array('type' => self::TYPE_STRING, 'validate' => 'isPhoneNumber', 'size' => 32), 'dni' => array('type' => self::TYPE_STRING, 'validate' => 'isDniLite', 'size' => 16), 'deleted' => array('type' => self::TYPE_BOOL, 'validate' => 'isBool', 'copy_post' => false), 'date_add' => array('type' => self::TYPE_DATE, 'validate' => 'isDate', 'copy_post' => false), 'date_upd' => array('type' => self::TYPE_DATE, 'validate' => 'isDate', 'copy_post' => false), ), ); } EDIT: duuhhh, I will also make sure to write this note: "Clear your chache"... It is working now with the override.

Im sorry to hear you're having the same problem...! Not sure what is causing it, I even tried another webhost and it's not working either... Just curious... What version of PS are you running?

Ok for some reason $displaylanguage wasn't working, so I simply replaced it with "es_ES" and problem solved now. File is widget_facebook.tpl located in /modules/pspagebuilder/views/templates/front/widgets. Edit, save and clear your cache {* * Pts Prestashop Theme Framework for Prestashop 1.6.x * * @package pspagebuilder * @version 5.0 * @author http://www.prestabrain.com * @copyright Copyright (C) October 2013 prestabrain.com <@emai:prestabrain@gmail.com> * <info@prestabrain.com>.All rights reserved. * @license GNU General Public License version 2 *} <div class="facebook-wrapper {$addition_cls|escape:'html':'UTF-8'}" style="width:{$width|escape:'html':'UTF-8'}" > {if isset($application_id)&&$application_id} <div id="fb-root"></div> <script>(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; {* js.src = "//connect.facebook.net/{$displaylanguage|escape:'html':'UTF-8'}/all.js#xfbml=1&appId={$application_id|escape:'html':'UTF-8'}"; *} js.src = "//connect.facebook.net/es_ES/all.js#xfbml=1&appId={$application_id|escape:'html':'UTF-8'}"; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk'));</script> {else} <script>(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; {* js.src = "//connect.facebook.net/{$displaylanguage|escape:'html':'UTF-8'}/all.js#xfbml=1"; *} js.src = "//connect.facebook.net/es_ES/all.js#xfbml=1&appId={$application_id|escape:'html':'UTF-8'}"; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk'));</script> {/if} <div class="fb-like-box" data-href="{$page_url|escape:'html':'UTF-8'}" data-colorscheme="{$color|escape:'html':'UTF-8'}" data-height="{$height|escape:'html':'UTF-8'}" data-width="{$width|escape:'html':'UTF-8'}" data-show-faces="{$show_faces|escape:'html':'UTF-8'}" data-stream="{$show_stream|escape:'html':'UTF-8'}" data-show-border="{$show_border|escape:'html':'UTF-8'}" data-header="{$show_header|escape:'html':'UTF-8'}"></div> </div>

Dear all, Quick question. How do I translate the (like) Facebook Widget from PS Page Builder? My store is in spanish, but Facebook widget is in english. I know I have to change en_US to es_ES somewhere, but I cannot find the correct file...! Thanks! PS 1.6.1.12 Server information: Linux #1 SMP Wed Jun 21 18:37:06 EDT 2017 x86_64 (Shared) Server software version: LiteSpeed PHP version: 7.0.21 MySQL version: 5.6.36-cll-lve MySQL engine: InnoDB MySQL driver: DbPDO Current theme in use: pf_basic

Me ocurrió con otra plataforma de pago que no lograba conectar porque mi tienda no estaba visible al público... Podrá ser eso? Saludos

Hola amigos, muchos comenzamos con tiendas pequeñas en las que no resulta conveniente hacer la integración directamente con Transbank por diversos motivos. En mi caso opté por FLOW, que tienen el módulo listo, se instala en un click y se puede comenzar a ocupar casi enseguida. Hasta el momento no he tenido problemas y sólo cobran comisión por transacción, sin costos fijos, lo que es ideal para quienes comenzamos con algún emprendimiento virtual. Opciones similares hay varias, arriba nombraron otra por ejemplo. Saludos,

Dear all, Happy new year! Im facing some issues configuring my store email Zoho + SMTP. My PrestaShop version is 1.6.1.12, but since I modified some core files, I'm manually updating every bug that has been reported and fixed until 1.6.1.17. I never touched an email file, though. Server information: Linux #1 SMP Wed Jun 21 18:37:06 EDT 2017 x86_64 (Shared) Server software version: LiteSpeed PHP version: 7.0.21 MySQL version: 5.6.36-cll-lve MySQL engine: InnoDB MySQL driver: DbPDO Current theme in use: pf_basic Everything was working perfect, but a few days ago, my store stopped sending emails to customers, and everytime I try to send a test email, I get this error message: Error: Please check your configuration Connection could not be established with host smtp.zoho.com [ #0] And I did not change anything before it stopped working...! I contacted Zoho support asking for help. After some traceroute and OpenSSL test results, they found that eveything was normal; no issues in connecting to their SMTP server. So it has to be a store problem somewhere... This is the guide I followed to configure emails: https://www.zoho.com/mail/help/zoho-smtp.html - Tried both, SSL and TLS (465 & 587) encryption. - The email address matches the Shop email. - Not using 2-step/factor verification. - Not using a password with special characters. - PS log and server error log not showing anything strange. - I added the recommended Zoho SPF record in my webhost. - Email address is the Zoho admin account. - Also tried using same email/pw for PS login and email. No luck. BUT........., I created exactly the same email account from my webhost Cpanel (and using webhost SMTP settings in PS) and it works!... This is clearly not a solution, but a quick fix until someone shows up with a solution for Zoho SMTP settings error in Prestashop. I've seen many similar threads, tried all solutions but they didn't work at all. Any ideas? Also, every email sent using the email templates from PS, has 1 attached file called "img" 0 KB... What is this and how can I remove it? Thanks