INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: SELECT count(*) as cnt FROM cache_categories AS CC INNER JOIN xcart_categories AS XC1 ON (CC.c1_id = XC1.categoryid) WHERE user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' AND XC1.avail='Y'
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: DELETE FROM cache_categories WHERE user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0'
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: INSERT INTO cache_categories (sessionid, user_id, hersteller, c1_id, c2_id, c3_id, c4_id, c5_id, c6_id, c1_text, c2_text, c3_text, c4_text, c5_text, c6_text, c1_order, c2_order, c3_order, c4_order, c5_order, c6_order) SELECT DISTINCT '0d21d5d06690063d6d9218bb9e75cdb0' as sessionid, '' AS user_id, xp.emax_hersteller, (SELECT cat_1.categoryid FROM xcart_categories AS cat_1 WHERE cat_1.category = substring_index( concat( xc.category , '/' ) , '/', 1) LIMIT 1) AS c1_id, (SELECT cat_2.categoryid FROM xcart_categories AS cat_2 WHERE cat_2.category = substring_index( concat( xc.category , '/' ) , '/', 2) LIMIT 1) AS c2_id, (SELECT cat_3.categoryid FROM xcart_categories AS cat_3 WHERE cat_3.category = substring_index( concat( xc.category , '/' ) , '/', 3) LIMIT 1) AS c3_id, (SELECT cat_4.categoryid FROM xcart_categories AS cat_4 WHERE cat_4.category = substring_index( concat( xc.category , '/' ) , '/', 4) LIMIT 1) AS c4_id, (SELECT cat_5.categoryid FROM xcart_categories AS cat_5 WHERE cat_5.category = substring_index( concat( xc.category , '/' ) , '/', 5) LIMIT 1) AS c5_id, (SELECT cat_6.categoryid FROM xcart_categories AS cat_6 WHERE cat_6.category = substring_index( concat( xc.category , '/' ) , '/', 6) LIMIT 1) AS c6_id, (SELECT cat_1.category FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_text, substring_index( (SELECT cat_2.category FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1), '/', -1) AS c2_text, substring_index( (SELECT cat_3.category FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1), '/', -1) AS c3_text, substring_index( (SELECT cat_4.category FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1), '/', -1) AS c4_text, substring_index( (SELECT cat_5.category FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1), '/', -1) AS c5_text, substring_index( (SELECT cat_6.category FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1), '/', -1) AS c6_text, (SELECT cat_1.order_by FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_order, (SELECT cat_2.order_by FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1) AS c2_order, (SELECT cat_3.order_by FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1) AS c3_order, (SELECT cat_4.order_by FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1) AS c4_order, (SELECT cat_5.order_by FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1) AS c5_order, (SELECT cat_6.order_by FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1) AS c6_order FROM xcart_categories AS xc INNER JOIN xcart_products AS xp ON (xc.categoryid = xp.categoryid) INNER JOIN emax_artikel_preisliste AS eap ON (eap.artikel_nr = xp.productcode) WHERE xc.avail='Y' AND xc.order_by>=0 AND eap.preisliste='5' AND eap.vater_artikel_nr IS NULL AND eap.IstMinMenge=-1 AND eap.auspraegung_id=0
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: INSERT INTO cache_categories (sessionid, user_id, hersteller, c1_id, c2_id, c3_id, c4_id, c5_id, c6_id, c1_text, c2_text, c3_text, c4_text, c5_text, c6_text, c1_order, c2_order, c3_order, c4_order, c5_order, c6_order) SELECT DISTINCT '0d21d5d06690063d6d9218bb9e75cdb0' as sessionid, '' AS user_id, xp.emax_hersteller, (SELECT cat_1.categoryid FROM xcart_categories AS cat_1 WHERE cat_1.category = substring_index( concat( xc.category , '/' ) , '/', 1) LIMIT 1) AS c1_id, (SELECT cat_2.categoryid FROM xcart_categories AS cat_2 WHERE cat_2.category = substring_index( concat( xc.category , '/' ) , '/', 2) LIMIT 1) AS c2_id, (SELECT cat_3.categoryid FROM xcart_categories AS cat_3 WHERE cat_3.category = substring_index( concat( xc.category , '/' ) , '/', 3) LIMIT 1) AS c3_id, (SELECT cat_4.categoryid FROM xcart_categories AS cat_4 WHERE cat_4.category = substring_index( concat( xc.category , '/' ) , '/', 4) LIMIT 1) AS c4_id, (SELECT cat_5.categoryid FROM xcart_categories AS cat_5 WHERE cat_5.category = substring_index( concat( xc.category , '/' ) , '/', 5) LIMIT 1) AS c5_id, (SELECT cat_6.categoryid FROM xcart_categories AS cat_6 WHERE cat_6.category = substring_index( concat( xc.category , '/' ) , '/', 6) LIMIT 1) AS c6_id, (SELECT cat_1.category FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_text, substring_index( (SELECT cat_2.category FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1), '/', -1) AS c2_text, substring_index( (SELECT cat_3.category FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1), '/', -1) AS c3_text, substring_index( (SELECT cat_4.category FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1), '/', -1) AS c4_text, substring_index( (SELECT cat_5.category FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1), '/', -1) AS c5_text, substring_index( (SELECT cat_6.category FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1), '/', -1) AS c6_text, (SELECT cat_1.order_by FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_order, (SELECT cat_2.order_by FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1) AS c2_order, (SELECT cat_3.order_by FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1) AS c3_order, (SELECT cat_4.order_by FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1) AS c4_order, (SELECT cat_5.order_by FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1) AS c5_order, (SELECT cat_6.order_by FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1) AS c6_order FROM xcart_categories AS xc INNER JOIN xcart_products AS xp ON (xc.categoryid = xp.categoryid1) INNER JOIN emax_artikel_preisliste AS eap ON (eap.artikel_nr = xp.productcode) WHERE xc.avail='Y' AND xc.order_by>=0 AND eap.preisliste='5' AND eap.vater_artikel_nr IS NULL AND eap.IstMinMenge=-1 AND eap.auspraegung_id=0
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: INSERT INTO cache_categories (sessionid, user_id, hersteller, c1_id, c2_id, c3_id, c4_id, c5_id, c6_id, c1_text, c2_text, c3_text, c4_text, c5_text, c6_text, c1_order, c2_order, c3_order, c4_order, c5_order, c6_order) SELECT DISTINCT '0d21d5d06690063d6d9218bb9e75cdb0' as sessionid, '' AS user_id, xp.emax_hersteller, (SELECT cat_1.categoryid FROM xcart_categories AS cat_1 WHERE cat_1.category = substring_index( concat( xc.category , '/' ) , '/', 1) LIMIT 1) AS c1_id, (SELECT cat_2.categoryid FROM xcart_categories AS cat_2 WHERE cat_2.category = substring_index( concat( xc.category , '/' ) , '/', 2) LIMIT 1) AS c2_id, (SELECT cat_3.categoryid FROM xcart_categories AS cat_3 WHERE cat_3.category = substring_index( concat( xc.category , '/' ) , '/', 3) LIMIT 1) AS c3_id, (SELECT cat_4.categoryid FROM xcart_categories AS cat_4 WHERE cat_4.category = substring_index( concat( xc.category , '/' ) , '/', 4) LIMIT 1) AS c4_id, (SELECT cat_5.categoryid FROM xcart_categories AS cat_5 WHERE cat_5.category = substring_index( concat( xc.category , '/' ) , '/', 5) LIMIT 1) AS c5_id, (SELECT cat_6.categoryid FROM xcart_categories AS cat_6 WHERE cat_6.category = substring_index( concat( xc.category , '/' ) , '/', 6) LIMIT 1) AS c6_id, (SELECT cat_1.category FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_text, substring_index( (SELECT cat_2.category FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1), '/', -1) AS c2_text, substring_index( (SELECT cat_3.category FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1), '/', -1) AS c3_text, substring_index( (SELECT cat_4.category FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1), '/', -1) AS c4_text, substring_index( (SELECT cat_5.category FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1), '/', -1) AS c5_text, substring_index( (SELECT cat_6.category FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1), '/', -1) AS c6_text, (SELECT cat_1.order_by FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_order, (SELECT cat_2.order_by FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1) AS c2_order, (SELECT cat_3.order_by FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1) AS c3_order, (SELECT cat_4.order_by FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1) AS c4_order, (SELECT cat_5.order_by FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1) AS c5_order, (SELECT cat_6.order_by FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1) AS c6_order FROM xcart_categories AS xc INNER JOIN xcart_products AS xp ON (xc.categoryid = xp.categoryid2) INNER JOIN emax_artikel_preisliste AS eap ON (eap.artikel_nr = xp.productcode) WHERE xc.avail='Y' AND xc.order_by>=0 AND eap.preisliste='5' AND eap.vater_artikel_nr IS NULL AND eap.IstMinMenge=-1 AND eap.auspraegung_id=0
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: INSERT INTO cache_categories (sessionid, user_id, hersteller, c1_id, c2_id, c3_id, c4_id, c5_id, c6_id, c1_text, c2_text, c3_text, c4_text, c5_text, c6_text, c1_order, c2_order, c3_order, c4_order, c5_order, c6_order) SELECT DISTINCT '0d21d5d06690063d6d9218bb9e75cdb0' as sessionid, '' AS user_id, xp.emax_hersteller, (SELECT cat_1.categoryid FROM xcart_categories AS cat_1 WHERE cat_1.category = substring_index( concat( xc.category , '/' ) , '/', 1) LIMIT 1) AS c1_id, (SELECT cat_2.categoryid FROM xcart_categories AS cat_2 WHERE cat_2.category = substring_index( concat( xc.category , '/' ) , '/', 2) LIMIT 1) AS c2_id, (SELECT cat_3.categoryid FROM xcart_categories AS cat_3 WHERE cat_3.category = substring_index( concat( xc.category , '/' ) , '/', 3) LIMIT 1) AS c3_id, (SELECT cat_4.categoryid FROM xcart_categories AS cat_4 WHERE cat_4.category = substring_index( concat( xc.category , '/' ) , '/', 4) LIMIT 1) AS c4_id, (SELECT cat_5.categoryid FROM xcart_categories AS cat_5 WHERE cat_5.category = substring_index( concat( xc.category , '/' ) , '/', 5) LIMIT 1) AS c5_id, (SELECT cat_6.categoryid FROM xcart_categories AS cat_6 WHERE cat_6.category = substring_index( concat( xc.category , '/' ) , '/', 6) LIMIT 1) AS c6_id, (SELECT cat_1.category FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_text, substring_index( (SELECT cat_2.category FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1), '/', -1) AS c2_text, substring_index( (SELECT cat_3.category FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1), '/', -1) AS c3_text, substring_index( (SELECT cat_4.category FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1), '/', -1) AS c4_text, substring_index( (SELECT cat_5.category FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1), '/', -1) AS c5_text, substring_index( (SELECT cat_6.category FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1), '/', -1) AS c6_text, (SELECT cat_1.order_by FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_order, (SELECT cat_2.order_by FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1) AS c2_order, (SELECT cat_3.order_by FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1) AS c3_order, (SELECT cat_4.order_by FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1) AS c4_order, (SELECT cat_5.order_by FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1) AS c5_order, (SELECT cat_6.order_by FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1) AS c6_order FROM xcart_categories AS xc INNER JOIN xcart_products AS xp ON (xc.categoryid = xp.categoryid3) INNER JOIN emax_artikel_preisliste AS eap ON (eap.artikel_nr = xp.productcode) WHERE xc.avail='Y' AND xc.order_by>=0 AND eap.preisliste='5' AND eap.vater_artikel_nr IS NULL AND eap.IstMinMenge=-1 AND eap.auspraegung_id=0
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: INSERT INTO cache_categories (sessionid, user_id, hersteller, c1_id, c2_id, c3_id, c4_id, c5_id, c6_id, c1_text, c2_text, c3_text, c4_text, c5_text, c6_text, c1_order, c2_order, c3_order, c4_order, c5_order, c6_order) SELECT DISTINCT '0d21d5d06690063d6d9218bb9e75cdb0' as sessionid, '' AS user_id, xp.emax_hersteller, (SELECT cat_1.categoryid FROM xcart_categories AS cat_1 WHERE cat_1.category = substring_index( concat( xc.category , '/' ) , '/', 1) LIMIT 1) AS c1_id, (SELECT cat_2.categoryid FROM xcart_categories AS cat_2 WHERE cat_2.category = substring_index( concat( xc.category , '/' ) , '/', 2) LIMIT 1) AS c2_id, (SELECT cat_3.categoryid FROM xcart_categories AS cat_3 WHERE cat_3.category = substring_index( concat( xc.category , '/' ) , '/', 3) LIMIT 1) AS c3_id, (SELECT cat_4.categoryid FROM xcart_categories AS cat_4 WHERE cat_4.category = substring_index( concat( xc.category , '/' ) , '/', 4) LIMIT 1) AS c4_id, (SELECT cat_5.categoryid FROM xcart_categories AS cat_5 WHERE cat_5.category = substring_index( concat( xc.category , '/' ) , '/', 5) LIMIT 1) AS c5_id, (SELECT cat_6.categoryid FROM xcart_categories AS cat_6 WHERE cat_6.category = substring_index( concat( xc.category , '/' ) , '/', 6) LIMIT 1) AS c6_id, (SELECT cat_1.category FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_text, substring_index( (SELECT cat_2.category FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1), '/', -1) AS c2_text, substring_index( (SELECT cat_3.category FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1), '/', -1) AS c3_text, substring_index( (SELECT cat_4.category FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1), '/', -1) AS c4_text, substring_index( (SELECT cat_5.category FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1), '/', -1) AS c5_text, substring_index( (SELECT cat_6.category FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1), '/', -1) AS c6_text, (SELECT cat_1.order_by FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_order, (SELECT cat_2.order_by FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1) AS c2_order, (SELECT cat_3.order_by FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1) AS c3_order, (SELECT cat_4.order_by FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1) AS c4_order, (SELECT cat_5.order_by FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1) AS c5_order, (SELECT cat_6.order_by FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1) AS c6_order FROM xcart_categories AS xc INNER JOIN xcart_products AS xp ON (xc.categoryid = xp.categoryid) INNER JOIN emax_kunden_nettopreise AS ekn ON (ekn.artikel_nr = xp.productcode) WHERE xc.avail='Y' AND xc.order_by>=0 AND ekn.kunden_nr=''
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: INSERT INTO cache_categories (sessionid, user_id, hersteller, c1_id, c2_id, c3_id, c4_id, c5_id, c6_id, c1_text, c2_text, c3_text, c4_text, c5_text, c6_text, c1_order, c2_order, c3_order, c4_order, c5_order, c6_order) SELECT DISTINCT '0d21d5d06690063d6d9218bb9e75cdb0' as sessionid, '' AS user_id, xp.emax_hersteller, (SELECT cat_1.categoryid FROM xcart_categories AS cat_1 WHERE cat_1.category = substring_index( concat( xc.category , '/' ) , '/', 1) LIMIT 1) AS c1_id, (SELECT cat_2.categoryid FROM xcart_categories AS cat_2 WHERE cat_2.category = substring_index( concat( xc.category , '/' ) , '/', 2) LIMIT 1) AS c2_id, (SELECT cat_3.categoryid FROM xcart_categories AS cat_3 WHERE cat_3.category = substring_index( concat( xc.category , '/' ) , '/', 3) LIMIT 1) AS c3_id, (SELECT cat_4.categoryid FROM xcart_categories AS cat_4 WHERE cat_4.category = substring_index( concat( xc.category , '/' ) , '/', 4) LIMIT 1) AS c4_id, (SELECT cat_5.categoryid FROM xcart_categories AS cat_5 WHERE cat_5.category = substring_index( concat( xc.category , '/' ) , '/', 5) LIMIT 1) AS c5_id, (SELECT cat_6.categoryid FROM xcart_categories AS cat_6 WHERE cat_6.category = substring_index( concat( xc.category , '/' ) , '/', 6) LIMIT 1) AS c6_id, (SELECT cat_1.category FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_text, substring_index( (SELECT cat_2.category FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1), '/', -1) AS c2_text, substring_index( (SELECT cat_3.category FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1), '/', -1) AS c3_text, substring_index( (SELECT cat_4.category FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1), '/', -1) AS c4_text, substring_index( (SELECT cat_5.category FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1), '/', -1) AS c5_text, substring_index( (SELECT cat_6.category FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1), '/', -1) AS c6_text, (SELECT cat_1.order_by FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_order, (SELECT cat_2.order_by FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1) AS c2_order, (SELECT cat_3.order_by FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1) AS c3_order, (SELECT cat_4.order_by FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1) AS c4_order, (SELECT cat_5.order_by FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1) AS c5_order, (SELECT cat_6.order_by FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1) AS c6_order FROM xcart_categories AS xc INNER JOIN xcart_products AS xp ON (xc.categoryid = xp.categoryid1) INNER JOIN emax_kunden_nettopreise AS ekn ON (ekn.artikel_nr = xp.productcode) WHERE xc.avail='Y' AND xc.order_by>=0 AND ekn.kunden_nr=''
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: INSERT INTO cache_categories (sessionid, user_id, hersteller, c1_id, c2_id, c3_id, c4_id, c5_id, c6_id, c1_text, c2_text, c3_text, c4_text, c5_text, c6_text, c1_order, c2_order, c3_order, c4_order, c5_order, c6_order) SELECT DISTINCT '0d21d5d06690063d6d9218bb9e75cdb0' as sessionid, '' AS user_id, xp.emax_hersteller, (SELECT cat_1.categoryid FROM xcart_categories AS cat_1 WHERE cat_1.category = substring_index( concat( xc.category , '/' ) , '/', 1) LIMIT 1) AS c1_id, (SELECT cat_2.categoryid FROM xcart_categories AS cat_2 WHERE cat_2.category = substring_index( concat( xc.category , '/' ) , '/', 2) LIMIT 1) AS c2_id, (SELECT cat_3.categoryid FROM xcart_categories AS cat_3 WHERE cat_3.category = substring_index( concat( xc.category , '/' ) , '/', 3) LIMIT 1) AS c3_id, (SELECT cat_4.categoryid FROM xcart_categories AS cat_4 WHERE cat_4.category = substring_index( concat( xc.category , '/' ) , '/', 4) LIMIT 1) AS c4_id, (SELECT cat_5.categoryid FROM xcart_categories AS cat_5 WHERE cat_5.category = substring_index( concat( xc.category , '/' ) , '/', 5) LIMIT 1) AS c5_id, (SELECT cat_6.categoryid FROM xcart_categories AS cat_6 WHERE cat_6.category = substring_index( concat( xc.category , '/' ) , '/', 6) LIMIT 1) AS c6_id, (SELECT cat_1.category FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_text, substring_index( (SELECT cat_2.category FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1), '/', -1) AS c2_text, substring_index( (SELECT cat_3.category FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1), '/', -1) AS c3_text, substring_index( (SELECT cat_4.category FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1), '/', -1) AS c4_text, substring_index( (SELECT cat_5.category FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1), '/', -1) AS c5_text, substring_index( (SELECT cat_6.category FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1), '/', -1) AS c6_text, (SELECT cat_1.order_by FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_order, (SELECT cat_2.order_by FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1) AS c2_order, (SELECT cat_3.order_by FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1) AS c3_order, (SELECT cat_4.order_by FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1) AS c4_order, (SELECT cat_5.order_by FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1) AS c5_order, (SELECT cat_6.order_by FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1) AS c6_order FROM xcart_categories AS xc INNER JOIN xcart_products AS xp ON (xc.categoryid = xp.categoryid2) INNER JOIN emax_kunden_nettopreise AS ekn ON (ekn.artikel_nr = xp.productcode) WHERE xc.avail='Y' AND xc.order_by>=0 AND ekn.kunden_nr=''
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: INSERT INTO cache_categories (sessionid, user_id, hersteller, c1_id, c2_id, c3_id, c4_id, c5_id, c6_id, c1_text, c2_text, c3_text, c4_text, c5_text, c6_text, c1_order, c2_order, c3_order, c4_order, c5_order, c6_order) SELECT DISTINCT '0d21d5d06690063d6d9218bb9e75cdb0' as sessionid, '' AS user_id, xp.emax_hersteller, (SELECT cat_1.categoryid FROM xcart_categories AS cat_1 WHERE cat_1.category = substring_index( concat( xc.category , '/' ) , '/', 1) LIMIT 1) AS c1_id, (SELECT cat_2.categoryid FROM xcart_categories AS cat_2 WHERE cat_2.category = substring_index( concat( xc.category , '/' ) , '/', 2) LIMIT 1) AS c2_id, (SELECT cat_3.categoryid FROM xcart_categories AS cat_3 WHERE cat_3.category = substring_index( concat( xc.category , '/' ) , '/', 3) LIMIT 1) AS c3_id, (SELECT cat_4.categoryid FROM xcart_categories AS cat_4 WHERE cat_4.category = substring_index( concat( xc.category , '/' ) , '/', 4) LIMIT 1) AS c4_id, (SELECT cat_5.categoryid FROM xcart_categories AS cat_5 WHERE cat_5.category = substring_index( concat( xc.category , '/' ) , '/', 5) LIMIT 1) AS c5_id, (SELECT cat_6.categoryid FROM xcart_categories AS cat_6 WHERE cat_6.category = substring_index( concat( xc.category , '/' ) , '/', 6) LIMIT 1) AS c6_id, (SELECT cat_1.category FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_text, substring_index( (SELECT cat_2.category FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1), '/', -1) AS c2_text, substring_index( (SELECT cat_3.category FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1), '/', -1) AS c3_text, substring_index( (SELECT cat_4.category FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1), '/', -1) AS c4_text, substring_index( (SELECT cat_5.category FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1), '/', -1) AS c5_text, substring_index( (SELECT cat_6.category FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1), '/', -1) AS c6_text, (SELECT cat_1.order_by FROM xcart_categories AS cat_1 WHERE cat_1.categoryid = c1_id LIMIT 1) AS c1_order, (SELECT cat_2.order_by FROM xcart_categories AS cat_2 WHERE cat_2.categoryid = c2_id LIMIT 1) AS c2_order, (SELECT cat_3.order_by FROM xcart_categories AS cat_3 WHERE cat_3.categoryid = c3_id LIMIT 1) AS c3_order, (SELECT cat_4.order_by FROM xcart_categories AS cat_4 WHERE cat_4.categoryid = c4_id LIMIT 1) AS c4_order, (SELECT cat_5.order_by FROM xcart_categories AS cat_5 WHERE cat_5.categoryid = c5_id LIMIT 1) AS c5_order, (SELECT cat_6.order_by FROM xcart_categories AS cat_6 WHERE cat_6.categoryid = c6_id LIMIT 1) AS c6_order FROM xcart_categories AS xc INNER JOIN xcart_products AS xp ON (xc.categoryid = xp.categoryid3) INNER JOIN emax_kunden_nettopreise AS ekn ON (ekn.artikel_nr = xp.productcode) WHERE xc.avail='Y' AND xc.order_by>=0 AND ekn.kunden_nr=''
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: select distinct c1_id as categoryid, c1_text as category_name, c1_order as order_by from cache_categories where user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' and c1_text<>'' ORDER BY c1_order
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: select distinct c1_id as categoryid, c1_text as category_name, c1_order as order_by from cache_categories where user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' and c1_text<>'' ORDER BY c1_order
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: select distinct c2_id as categoryid, c2_text as category_name, c2_order as order_by from cache_categories where user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' and c2_text<>'' ORDER BY c2_order
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: select distinct c2_id as categoryid, c2_text as category_name, c2_order as order_by from cache_categories where user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' AND c2_text<>'' AND c1_id='' ORDER BY c2_order
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: select distinct c3_id as categoryid, c3_text as category_name, c3_order as order_by from cache_categories where user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' and c3_text<>'' ORDER BY c3_order
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: select distinct c3_id as categoryid, c3_text as category_name, c3_order as order_by from cache_categories where user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' AND c3_text<>'' AND c2_id='' ORDER BY c3_order
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: select distinct c4_id as categoryid, c4_text as category_name, c4_order as order_by from cache_categories where user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' and c4_text<>'' ORDER BY c4_order
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: select distinct c4_id as categoryid, c4_text as category_name, c4_order as order_by from cache_categories where user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' AND c4_text<>'' AND c3_id='' ORDER BY c4_order
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: select distinct c5_id as categoryid, c5_text as category_name, c5_order as order_by from cache_categories where user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' and c5_text<>'' ORDER BY c5_order
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: select distinct c5_id as categoryid, c5_text as category_name, c5_order as order_by from cache_categories where user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' AND c5_text<>'' AND c4_id='' ORDER BY c5_order
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: select distinct c6_id as categoryid, c6_text as category_name, c6_order as order_by from cache_categories where user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' and c6_text<>'' ORDER BY c6_order
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: select distinct c6_id as categoryid, c6_text as category_name, c6_order as order_by from cache_categories where user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' AND c6_text<>'' AND c5_id='' ORDER BY c6_order
INVALID SQL: 144 : Table './elisdemoshop/cache_categories' is marked as crashed and last (automatic?) repair failed
SQL QUERY FAILURE: select distinct hersteller as emax_hersteller from cache_categories where user_id='' AND sessionid='0d21d5d06690063d6d9218bb9e75cdb0' and hersteller<>'' order by hersteller
eMax Shop - Home


Willkommen beim eMax Demo Shop der ELIS-Software GmbH

Liebe Besucher und Interessenten,
Die ELIS-Software GmbH liefert seit mehr als 10 Jahren innovative Softwarelösungen für Handel und Industrie.

Wir bieten Ihnen automatisierte Geschäftsprozesse für eine immer stärker vernetzte Welt. Unsere Kunden arbeiten mit Programmen die speziell auf die Bedürfnisse des Mittelstands abgestimmt sind. Viele unser Kunden setzen Pay by Use ein und sparen bei den Lizenzgebühren. Unsere Homepage und unsere Kataloge, welche Sie ansehen oder herunterladen können, geben Ihnen einen Überblick und alle notwendigen Informationen zu unserer Software und Dienstleistungen.

Jederzeit stehen wir Ihnen auch persönlich über die angegebenen Hotlines mit Rat und Tat zur Seite.


Ihr ELIS-Software Team.

Muster 1
Freitext mit Link
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc gravida euismod risus, vel commodo nisi congue at. Nunc sed bibendum nisi. Cras ultrices gravida arcu. mehr...

Muster 2
Tabelle
EventDatum
Event 112.12.2012
Event 212.12.2013


Preisangaben inkl. MwSt und zzgl. Service- & Versandkosten