caovillanueva

You need to look in your database using phpmyadmin, look for ps_order_state_lang  here are the details for all of the possible order states.
Mine had several missing including in_transit which is the name of the template in public_html/mails/en

caovillanueva

Meake an override here:

/override/classes/Mail.php
  
  
  <?php


class Mail extends MailCore
{

caovillanueva

SELECT 
p.id_product AS 'ID du produit',
p.active AS 'Actif (0/1)',
pl.name AS 'Nom',
GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ',') AS 'Catégories (x,y,z...)',
p.price AS 'Prix TTC ou HT à choix',
p.id_tax_rules_group AS 'ID règle de taxes',
p.wholesale_price AS 'Prix d_achat',
p.on_sale AS 'En soldes (0/1)',
IF(pr.reduction_type = 'amount', pr.reduction, '') AS 'Montant de la remise',

caovillanueva

ON LARAGON:

just put this line:

[mysqld]
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"


restart mysql and done.

caovillanueva

Note: This command was run via npm module 'win-node-env'
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] build: `NODE_ENV=production webpack --progress`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] build script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:

caovillanueva

xs (for phones - screens less than 768px wide)
sm (for tablets - screens equal to or greater than 768px wide)
md (for small laptops - screens equal to or greater than 992px wide)
lg (for laptops and desktops - screens equal to or greater than 1200px wide)


hidden-md-down
hidden-sm-down

caovillanueva

Es un problema de compatibilidad con Symfony. Busca "2G" en el fichero php.ini de tu hosting y sustituyelo por "2048M".

post_max_size = 2048M
upload_max_filesize = 2048M

caovillanueva

You can simply add a translation for the according text block. In the back office, go to Design -> E-Mail-Themes and click "Translate E-Mails" for your language. There, search for "(waiting for validation)" and add your translation. If you want to remove the message completely, simply type a single space character into the translation field. In my case, the message is gone from the order_conf e-mail then.

caovillanueva

EXPORT PRODUCTS PRESTASHOP 1.7

SELECT
    p.id_product AS 'Product ID',
    p.active AS 'Active',
    pl.name AS 'Name',
    GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") AS categories , 
    p.price AS 'Price tax excluded',
    p.id_tax_rules_group AS 'Tax rules ID',
    p.wholesale_price AS 'Wholesale price',

caovillanueva

UPDATE ps_product_shop c
JOIN table_test e ON c.id_product = e.id_product
SET c.id_category_default = e.id_category_default

note: tested.

------------------------------------------------
UPDATE TableB 
SET TableB.value = (
    SELECT TableA.value