You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
[Exception]
Failed to execute LOAD DATA LOCAL INFILE '/var/www/html/shopware/output/articles.csv' IGNORE INTO TABLE s_articles
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'
(id, supplierID, name, description, description_long, shippingtime, datum, active, taxID, pseudosales, topseller, keywords, changetime, pricegroupID, pricegroupActive, filtergro upID, laststock, crossbundlelook, notification, template, mode, main_detail_id, available_from, available_to, configurator_set_id);
Code: 42000,1148,The used command is not allowed with this MySQL version
The text was updated successfully, but these errors were encountered:
MySQL 8 seems to be stricter with local data. local_infile must be enabled in my.cnf and can't be overwritten anymore using mysql client.
We need here a check that local-inifile is enabled
Exception:
[Exception]
Failed to execute LOAD DATA LOCAL INFILE '/var/www/html/shopware/output/articles.csv' IGNORE INTO TABLE s_articles
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'
(
id
,supplierID
,name
,description
,description_long
,shippingtime
,datum
,active
,taxID
,pseudosales
,topseller
,keywords
,changetime
,pricegroupID
,pricegroupActive
,filtergro upID
,laststock
,crossbundlelook
,notification
,template
,mode
,main_detail_id
,available_from
,available_to
,configurator_set_id
);Code: 42000,1148,The used command is not allowed with this MySQL version
The text was updated successfully, but these errors were encountered: