When I run a query I get this error-message. It doesn't say which table, but I
checked all my tables and none is near max_table_size.
We have MyISAM-tables and we're using version: 5.0.4
Any ideas?
BR /Kenneth
This query works:
SELECT
pr.sectionid, t2.text heading, se.fungroupno, pd.pdstring
FROM
wi_description t1
LEFT OUTER JOIN lisa_part pa ON pa.textid = t1.textid
LEFT OUTER JOIN lisa_partrow pr ON pa.partid = pr.partno
LEFT OUTER JOIN lisa_pisection se ON pr.sectionid = se.sectionid
LEFT JOIN wi_description t2 ON t2.textid=se.heading1 AND t2.language = 'eng'
AND t2.country = 'GB'
LEFT JOIN lisa_pd pd ON pd.sectionid=se.sectionid , lisa_bomtomodel bm
WHERE
t1.language = 'eng' AND t1.country = 'GB'
and
t1.text LIKE '%flywheel%'
and
se.fungroupno LIKE '21%' AND ((pd.pdstring is null) OR pd.pdstring LIKE
'%FH12%')
AND
bm.bom=se.sectionid AND bm.truckmodel='FH12'
GROUP BY pr.sectionid, heading, se.fungroupno, pd.pdstring
ORDER BY heading
This one doesn't...
SELECT
distinct(pr.sectionid), t1.text,t2.text,t3.text,se.subheadtext,t5.text,
fi.vssno, fi.vsscompany,
fi.vssgroupno, infotext.text infotypetext
FROM
wi_sifilter fi
LEFT OUTER JOIN wi_siinfotype info ON fi.infotypeid=info.elementname
LEFT OUTER JOIN wi_text infotext ON infotext.textid=info.textid AND
infotext.language='eng' AND infotext.country='GB', wi_siinfoelement ie,
wi_pisection se
LEFT OUTER JOIN wi_text t1 ON t1.textid = se.heading1 AND t1.language = 'eng'
AND t1.country = 'GB'
LEFT OUTER JOIN wi_text t2 ON t2.textid = se.heading2 AND t2.language = 'eng'
AND t2.country = 'GB'
LEFT OUTER JOIN wi_text t3 ON t3.textid = se.heading3 AND t3.language = 'eng'
AND t3.country = 'GB' , wi_partrow pr
LEFT OUTER JOIN wi_pifootnote f ON pr.sectionid = f.sectionid AND f.colrowno =
'S'
LEFT OUTER JOIN wi_text t5 ON f.textid=t5.textid AND t5.language = 'eng' AND
t5.country = 'GB' , wi_text t4, wi_part pa
WHERE
pr.sectionid = se.sectionid AND t4.textid = pa.textid AND t4.language
= 'eng' AND t4.country = 'GB'
AND
pr.partno = pa.partid
AND
t4.text LIKE '%flywheel%' AND se.fungroupno LIKE '21%' AND ie.linktype
= 'partinforef'
AND
CONCAT(SUBSTRING(se.sectionid,1,14),'00001') = ie.toid
AND
ie.fromid = fi.infoelementid AND SUBSTRING(pr.sectionid,15,19) NOT LIKE
'00001'
ORDER BY fi.vssgroupno,fi.vsscompany,fi.vssno, 2,3,4,5,6 LIMIT 0, 1201
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
