GX-Bug #51628
Von Mirko Janssen vor fast 7 Jahren aktualisiert
Der CSV Export für Preisprotale kann nicht ausgeführt werden bzw. bricht mit einem Fehler ab, wenn zu viele Zusatzfelder existieren. Folgende Fehlermeldung wird geloggt: 2017-05-15 12:41:54 (b61b9acf3e79abdff139ee4b089cc50c) SQL ERROR(1116): "Too many tables; MySQL can only use 61 tables in a join" in /.../inc/xtc_db_error.inc.php:23 /www/htdocs/w0151827/petsworld-and-more.de/inc/xtc_db_error.inc.php:23 (Details) #11 File: /.../inc/xtc_db_error.inc.php:23 /www/htdocs/w0151827/petsworld-and-more.de/inc/xtc_db_error.inc.php:23 #10 File: /.../inc/xtc_db_query.inc.php:78 /www/htdocs/w0151827/petsworld-and-more.de/inc/xtc_db_query.inc.php:78 #9 File: /.../system/classes/csv/CSVSource.php:281 /www/htdocs/w0151827/petsworld-and-more.de/system/classes/csv/CSVSource.php:281 #8 File: /.../system/classes/csv/CSVSource.php:181 /www/htdocs/w0151827/petsworld-and-more.de/system/classes/csv/CSVSource.php:181 #7 File: /.../system/classes/csv/CSVControl.inc.php:442 /www/htdocs/w0151827/petsworld-and-more.de/system/classes/csv/CSVControl.inc.php:442 #6 File: /.../system/classes/csv/CSVContentView.inc.php:520 /www/htdocs/w0151827/petsworld-and-more.de/system/classes/csv/CSVContentView.inc.php:520 #5 File: /.../system/classes/csv/CSVContentView.inc.php:73 /www/htdocs/w0151827/petsworld-and-more.de/system/classes/csv/CSVContentView.inc.php:73 #4 File: /.../system/classes/lightbox/LightboxContentView.inc.php:145 /www/htdocs/w0151827/petsworld-and-more.de/system/classes/lightbox/LightboxContentView.inc.php:145 #3 File: /.../system/classes/csv/CSVAjaxHandler.inc.php:372 /www/htdocs/w0151827/petsworld-and-more.de/system/classes/csv/CSVAjaxHandler.inc.php:372 #2 File: /.../system/classes/csv/CSVAjaxHandler.inc.php:93 /www/htdocs/w0151827/petsworld-and-more.de/system/classes/csv/CSVAjaxHandler.inc.php:93 #1 File: /.../system/core/RequestRouter.inc.php:93 /www/htdocs/w0151827/petsworld-and-more.de/system/core/RequestRouter.inc.php:93 #0 File: /.../admin/request_port.php:115 /www/htdocs/w0151827/petsworld-and-more.de/admin/request_port.php:115 Request: GET /admin/request_port.php?module=CSV&action=get_template&scheme_id=24&template=export_scheme_fields.html (Details) Get: (Details) Information: Query: SELECT DISTINCT pic.*, pqu.*, s.*, p.*, pd.*, afvd1.value AS additional_field_value_1, afvd2.value AS additional_field_value_2, afvd3.value AS additional_field_value_3, afvd4.value AS additional_field_value_4, afvd5.value AS additional_field_value_5, afvd6.value AS additional_field_value_6, afvd7.value AS additional_field_value_7, afvd8.value AS additional_field_value_8, afvd9.value AS additional_field_value_9, afvd10.value AS additional_field_value_10, afvd11.value AS additional_field_value_11, afvd12.value AS additional_field_value_12, afvd13.value AS additional_field_value_13, afvd14.value AS additional_field_value_14, afvd15.value AS additional_field_value_15, afvd16.value AS additional_field_value_16, afvd17.value AS additional_field_value_17, afvd18.value AS additional_field_value_18, afvd19.value AS additional_field_value_19, afvd20.value AS additional_field_value_20, afvd21.value AS additional_field_value_21, afvd22.value AS additional_field_value_22, afvd23.value AS additional_field_value_23, afvd24.value AS additional_field_value_24, afvd25.value AS additional_field_value_25, afvd26.value AS additional_field_value_26, afvd27.value AS additional_field_value_27, afvd28.value AS additional_field_value_28 FROM products_to_categories ptc, export_scheme_categories esc, products p LEFT JOIN specials s ON (p.products_id = s.products_id) LEFT JOIN additional_field_values afv1 ON (afv1.item_id = p.products_id AND afv1.additional_field_id = 1) LEFT JOIN additional_field_value_descriptions afvd1 ON (afvd1.additional_field_value_id = afv1.additional_field_value_id AND (afvd1.language_id = 0 OR afvd1.language_id = 2)) LEFT JOIN additional_field_values afv2 ON (afv2.item_id = p.products_id AND afv2.additional_field_id = 2) LEFT JOIN additional_field_value_descriptions afvd2 ON (afvd2.additional_field_value_id = afv2.additional_field_value_id AND (afvd2.language_id = 0 OR afvd2.language_id = 2)) LEFT JOIN additional_field_values afv3 ON (afv3.item_id = p.products_id AND afv3.additional_field_id = 3) LEFT JOIN additional_field_value_descriptions afvd3 ON (afvd3.additional_field_value_id = afv3.additional_field_value_id AND (afvd3.language_id = 0 OR afvd3.language_id = 2)) LEFT JOIN additional_field_values afv4 ON (afv4.item_id = p.products_id AND afv4.additional_field_id = 4) LEFT JOIN additional_field_value_descriptions afvd4 ON (afvd4.additional_field_value_id = afv4.additional_field_value_id AND (afvd4.language_id = 0 OR afvd4.language_id = 2)) LEFT JOIN additional_field_values afv5 ON (afv5.item_id = p.products_id AND afv5.additional_field_id = 5) LEFT JOIN additional_field_value_descriptions afvd5 ON (afvd5.additional_field_value_id = afv5.additional_field_value_id AND (afvd5.language_id = 0 OR afvd5.language_id = 2)) LEFT JOIN additional_field_values afv6 ON (afv6.item_id = p.products_id AND afv6.additional_field_id = 6) LEFT JOIN additional_field_value_descriptions afvd6 ON (afvd6.additional_field_value_id = afv6.additional_field_value_id AND (afvd6.language_id = 0 OR afvd6.language_id = 2)) LEFT JOIN additional_field_values afv7 ON (afv7.item_id = p.products_id AND afv7.additional_field_id = 7) LEFT JOIN additional_field_value_descriptions afvd7 ON (afvd7.additional_field_value_id = afv7.additional_field_value_id AND (afvd7.language_id = 0 OR afvd7.language_id = 2)) LEFT JOIN additional_field_values afv8 ON (afv8.item_id = p.products_id AND afv8.additional_field_id = 8) LEFT JOIN additional_field_value_descriptions afvd8 ON (afvd8.additional_field_value_id = afv8.additional_field_value_id AND (afvd8.language_id = 0 OR afvd8.language_id = 2)) LEFT JOIN additional_field_values afv9 ON (afv9.item_id = p.products_id AND afv9.additional_field_id = 9) LEFT JOIN additional_field_value_descriptions afvd9 ON (afvd9.additional_field_value_id = afv9.additional_field_value_id AND (afvd9.language_id = 0 OR afvd9.language_id = 2)) LEFT JOIN additional_field_values afv10 ON (afv10.item_id = p.products_id AND afv10.additional_field_id = 10) LEFT JOIN additional_field_value_descriptions afvd10 ON (afvd10.additional_field_value_id = afv10.additional_field_value_id AND (afvd10.language_id = 0 OR afvd10.language_id = 2)) LEFT JOIN additional_field_values afv11 ON (afv11.item_id = p.products_id AND afv11.additional_field_id = 11) LEFT JOIN additional_field_value_descriptions afvd11 ON (afvd11.additional_field_value_id = afv11.additional_field_value_id AND (afvd11.language_id = 0 OR afvd11.language_id = 2)) LEFT JOIN additional_field_values afv12 ON (afv12.item_id = p.products_id AND afv12.additional_field_id = 12) LEFT JOIN additional_field_value_descriptions afvd12 ON (afvd12.additional_field_value_id = afv12.additional_field_value_id AND (afvd12.language_id = 0 OR afvd12.language_id = 2)) LEFT JOIN additional_field_values afv13 ON (afv13.item_id = p.products_id AND afv13.additional_field_id = 13) LEFT JOIN additional_field_value_descriptions afvd13 ON (afvd13.additional_field_value_id = afv13.additional_field_value_id AND (afvd13.language_id = 0 OR afvd13.language_id = 2)) LEFT JOIN additional_field_values afv14 ON (afv14.item_id = p.products_id AND afv14.additional_field_id = 14) LEFT JOIN additional_field_value_descriptions afvd14 ON (afvd14.additional_field_value_id = afv14.additional_field_value_id AND (afvd14.language_id = 0 OR afvd14.language_id = 2)) LEFT JOIN additional_field_values afv15 ON (afv15.item_id = p.products_id AND afv15.additional_field_id = 15) LEFT JOIN additional_field_value_descriptions afvd15 ON (afvd15.additional_field_value_id = afv15.additional_field_value_id AND (afvd15.language_id = 0 OR afvd15.language_id = 2)) LEFT JOIN additional_field_values afv16 ON (afv16.item_id = p.products_id AND afv16.additional_field_id = 16) LEFT JOIN additional_field_value_descriptions afvd16 ON (afvd16.additional_field_value_id = afv16.additional_field_value_id AND (afvd16.language_id = 0 OR afvd16.language_id = 2)) LEFT JOIN additional_field_values afv17 ON (afv17.item_id = p.products_id AND afv17.additional_field_id = 17) LEFT JOIN additional_field_value_descriptions afvd17 ON (afvd17.additional_field_value_id = afv17.additional_field_value_id AND (afvd17.language_id = 0 OR afvd17.language_id = 2)) LEFT JOIN additional_field_values afv18 ON (afv18.item_id = p.products_id AND afv18.additional_field_id = 18) LEFT JOIN additional_field_value_descriptions afvd18 ON (afvd18.additional_field_value_id = afv18.additional_field_value_id AND (afvd18.language_id = 0 OR afvd18.language_id = 2)) LEFT JOIN additional_field_values afv19 ON (afv19.item_id = p.products_id AND afv19.additional_field_id = 19) LEFT JOIN additional_field_value_descriptions afvd19 ON (afvd19.additional_field_value_id = afv19.additional_field_value_id AND (afvd19.language_id = 0 OR afvd19.language_id = 2)) LEFT JOIN additional_field_values afv20 ON (afv20.item_id = p.products_id AND afv20.additional_field_id = 20) LEFT JOIN additional_field_value_descriptions afvd20 ON (afvd20.additional_field_value_id = afv20.additional_field_value_id AND (afvd20.language_id = 0 OR afvd20.language_id = 2)) LEFT JOIN additional_field_values afv21 ON (afv21.item_id = p.products_id AND afv21.additional_field_id = 21) LEFT JOIN additional_field_value_descriptions afvd21 ON (afvd21.additional_field_value_id = afv21.additional_field_value_id AND (afvd21.language_id = 0 OR afvd21.language_id = 2)) LEFT JOIN additional_field_values afv22 ON (afv22.item_id = p.products_id AND afv22.additional_field_id = 22) LEFT JOIN additional_field_value_descriptions afvd22 ON (afvd22.additional_field_value_id = afv22.additional_field_value_id AND (afvd22.language_id = 0 OR afvd22.language_id = 2)) LEFT JOIN additional_field_values afv23 ON (afv23.item_id = p.products_id AND afv23.additional_field_id = 23) LEFT JOIN additional_field_value_descriptions afvd23 ON (afvd23.additional_field_value_id = afv23.additional_field_value_id AND (afvd23.language_id = 0 OR afvd23.language_id = 2)) LEFT JOIN additional_field_values afv24 ON (afv24.item_id = p.products_id AND afv24.additional_field_id = 24) LEFT JOIN additional_field_value_descriptions afvd24 ON (afvd24.additional_field_value_id = afv24.additional_field_value_id AND (afvd24.language_id = 0 OR afvd24.language_id = 2)) LEFT JOIN additional_field_values afv25 ON (afv25.item_id = p.products_id AND afv25.additional_field_id = 25) LEFT JOIN additional_field_value_descriptions afvd25 ON (afvd25.additional_field_value_id = afv25.additional_field_value_id AND (afvd25.language_id = 0 OR afvd25.language_id = 2)) LEFT JOIN additional_field_values afv26 ON (afv26.item_id = p.products_id AND afv26.additional_field_id = 26) LEFT JOIN additional_field_value_descriptions afvd26 ON (afvd26.additional_field_value_id = afv26.additional_field_value_id AND (afvd26.language_id = 0 OR afvd26.language_id = 2)) LEFT JOIN additional_field_values afv27 ON (afv27.item_id = p.products_id AND afv27.additional_field_id = 27) LEFT JOIN additional_field_value_descriptions afvd27 ON (afvd27.additional_field_value_id = afv27.additional_field_value_id AND (afvd27.language_id = 0 OR afvd27.language_id = 2)) LEFT JOIN additional_field_values afv28 ON (afv28.item_id = p.products_id AND afv28.additional_field_id = 28) LEFT JOIN additional_field_value_descriptions afvd28 ON (afvd28.additional_field_value_id = afv28.additional_field_value_id AND (afvd28.language_id = 0 OR afvd28.language_id = 2)) LEFT JOIN products_item_codes pic ON (p.products_id = pic.products_id) LEFT JOIN products_quantity_unit pqu ON (p.products_id = pqu.products_id) , products_description pd WHERE p.products_id = pd.products_id AND p.products_status = '1' AND ( (p.products_quantity >= '1.0000')) AND p.products_id = ptc.products_id AND ptc.categories_id IN ('1','2','9','10','11','12','13','14','16','17','18','20','28','34','133','135','138','139','140','141','142','143','145','146','163','164','167','169','171','172','209','210','211','213','214','219','222','225','226','228','233','234','235','236','254','255','262','263','265','267','276','283','285','289','290','292','294','295','297','299','301','303','304','305','308','309','310','311','312','320','321','324','325','337','338','339','340','341','342','343','344','345','346','347','348','350','353','355','356','357','360','362','368','370','372','373','374','375','376','377','379','381','382','383','385','386','387','389','390','391','392','393','394','395','397','398','401','402','403','414','415','416','417','419','457','464','465','466','470','471','472','473','474','475','476','480','481','482','484','485','486','488','490','491','497','498','499','500','505','512','514','517','518','519','520','521','523','525','526','531','537','538','539','540','541','542','543','548','549','557') AND esc.scheme_id = 24 AND esc.selection_state LIKE 'self_%' AND esc.categories_id = ptc.categories_id AND pd.language_id = '2' ORDER BY p.products_id LIMIT 0, 5