error #2008: MySQL client run out of memory

[Michael Post]

Hallo Sebastian,
hallo Liste,

jetzt bin ich selber ein wenig durcheinander gekommen.
Entschuldigung. Ich setze eine ganze Reihe von einfachen Queries ab 
(siehe unten) (nicht mehr/nicht weniger). Beim letzten Query bricht er ab.
Es ist sehr merkwürdig.

Die folgenden Queries laufen in PHPMyAdmin ohne Probleme.
Als PHP-Aufruf mittels der PHP-Funktionen bricht er merkwürdigerweise 
beim letzten Querie mit der Fehlermeldung aus dem eMail-Subject ab.

Viele Grüße

Michael


-----------
SELECT title, value, type_id FROM pma$config WHERE shop_id=3;
SELECT a.category_id, IFNULL(b.title, "<em>No title available</em>") 
title FROM pma$categories a LEFT JOIN pma$cat_text b USING (category_id) 
WHERE a.shop_id=3 AND (b.language_id = 8 OR b.language_id IS NULL) AND 
a.modelling_isuptodate != 1;
SELECT modelling_isuptodate, meth.method_id method_id, meth.title 
methtitle, sub.method_sub_id submeth_id, modelling_textalternate, 
modelling_textmove, modelling_textheight, modelling_textwidth FROM 
pma$categories cat LEFT JOIN pma$modell_method_sub sub 
USING(method_sub_id) LEFT JOIN pma$modell_method meth USING(method_id) 
WHERE cat.shop_id=3 AND cat.category_id=47;
UPDATE pma$categories SET modelling_isuptodate=2 WHERE shop_id=3 AND 
category_id=47;
DELETE FROM pma$modell_cat WHERE shop_id=3 AND category_id=47;
DELETE FROM pma$modell_cat_piclink WHERE shop_id=3 AND category_id=47;
SELECT a.prod_id, b.pic_id, c.width, c.height height FROM pma$products 
f, pma$prod_cat a LEFT JOIN pma$prod_pic b USING(prod_id) LEFT JOIN 
pma$pictures c USING(pic_id) WHERE a.shop_id=3 AND f.prod_id = a.prod_id 
AND f.is_deactivated = 0 AND a.category_id=47 ORDER BY a.sort_order, 
b.picture_status;
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=284 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 284, 2, 1, 1, 175, 145);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13205, 28);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 28, 1, 1, 131, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=286 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 286, 2, 193, 251, 175, 145);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13207, 31);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 31, 1, 193, 1, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=288 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 288, 2, 369, 1, 175, 145);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13209, 30);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 30, 1, 369, 131, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=150 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 150, 2, 561, 251, 186, 156);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13211, 77);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 77, 1, 561, 1, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=152 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 152, 2, 753, 1, 186, 156);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13213, 78);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 78, 1, 753, 142, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=154 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 154, 2, 945, 251, 186, 156);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13215, 79);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 79, 1, 945, 1, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=158 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 158, 2, 1153, 1, 181, 151);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13217, 81);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 81, 1, 1153, 137, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=160 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 160, 2, 1345, 251, 181, 151);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13219, 82);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 82, 1, 1345, 1, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=162 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 162, 2, 1537, 1, 181, 151);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13221, 83);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 83, 1, 1537, 137, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=174 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 174, 2, 1729, 251, 181, 151);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13223, 112);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 112, 1, 1729, 1, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=176 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 176, 2, 1921, 1, 181, 151);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13225, 113);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 113, 1, 1921, 137, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=180 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 180, 2, 2113, 251, 178, 148);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13227, 118);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 118, 1, 2113, 1, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=181 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 181, 2, 2305, 1, 178, 148);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13229, 119);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 119, 1, 2305, 134, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=184 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 184, 2, 2497, 251, 178, 148);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13231, 120);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 120, 1, 2497, 1, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=186 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 186, 2, 2689, 1, 178, 148);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13233, 121);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 121, 1, 2689, 134, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=194 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 194, 2, 2881, 251, 178, 148);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13235, 125);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 125, 1, 2881, 1, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=198 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 198, 2, 3073, 1, 178, 148);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13237, 126);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 126, 1, 3073, 134, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=237 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 237, 2, 3265, 251, 178, 148);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13239, 114);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 114, 1, 3265, 1, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=239 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 239, 2, 3457, 1, 178, 148);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13241, 115);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 115, 1, 3457, 134, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=306 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 306, 2, 3649, 251, 178, 148);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13243, 65);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 65, 1, 3649, 1, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=362 AND c.category_id=47;
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 362, 2, 3841, 1, 178, 148);
SELECT LAST_INSERT_ID() last_id;
INSERT INTO pma$modell_cat_piclink(shop_id, category_id, object_id, 
prod_id) VALUES(3, 47, 13245, 67);
INSERT INTO pma$modell_cat(shop_id, category_id, item_id, item_type, 
top, left_, height, width) VALUES(3, 47, 67, 1, 3841, 134, 140, 250);
SELECT a.prod_id, b.model FROM pma$prod_pic a LEFT JOIN pma$products b 
USING(prod_id) LEFT JOIN pma$prod_cat c USING(prod_id) WHERE a.shop_id=3 
AND a.pic_id=360 AND c.category_id=47;
-------------


-- 
Infos zur Mailingliste, zur Teilnahme und zum An- und Abmelden unter
-->>  http://www.4t2.com/mysql