Hello.
Have a look here: http://dev.mysql.com/doc/mysql/en/full-table.html Your MySQL version is rather old, upgrade to 5.0.11. "Lindh Kenneth" <[EMAIL PROTECTED]> wrote: > 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 = > =20 > pr.sectionid, t2.text heading, se.fungroupno, pd.pdstring = > =20 > FROM = > =20 > wi_description t1 = > =20 > LEFT OUTER JOIN lisa_part pa ON pa.textid =3D t1.textid = > =20 > LEFT OUTER JOIN lisa_partrow pr ON pa.partid =3D pr.partno = > =20 > LEFT OUTER JOIN lisa_pisection se ON pr.sectionid =3D se.sectionid = > =20 > LEFT JOIN wi_description t2 ON t2.textid=3Dse.heading1 AND t2.language = > =3D 'eng' AND t2.country =3D 'GB' =20 > LEFT JOIN lisa_pd pd ON pd.sectionid=3Dse.sectionid , lisa_bomtomodel bm = > =20 > WHERE = > =20 > t1.language =3D 'eng' AND t1.country =3D 'GB' = > =20 > and = > =20 > t1.text LIKE '%flywheel%' = > =20 > and = > =20 > se.fungroupno LIKE '21%' AND ((pd.pdstring is null) OR pd.pdstring = > LIKE '%FH12%') =20 > AND = > =20 > bm.bom=3Dse.sectionid AND bm.truckmodel=3D'FH12' = > =20 > GROUP BY pr.sectionid, heading, se.fungroupno, pd.pdstring=20 > ORDER BY heading =20 > > This one doesn't... > > SELECT=20 > distinct(pr.sectionid), > t1.text,t2.text,t3.text,se.subheadtext,t5.text, = > fi.vssno, fi.vsscompany,=20 > fi.vssgroupno, infotext.text infotypetext=20 > FROM=20 > wi_sifilter fi =20 > LEFT OUTER JOIN wi_siinfotype info ON fi.infotypeid=3Dinfo.elementname=20 > LEFT OUTER JOIN wi_text infotext ON infotext.textid=3Dinfo.textid AND = > infotext.language=3D'eng' AND infotext.country=3D'GB', wi_siinfoelement = > ie, wi_pisection se=20 > LEFT OUTER JOIN wi_text t1 ON t1.textid =3D se.heading1 AND t1.language = > =3D 'eng' AND t1.country =3D 'GB' =20 > LEFT OUTER JOIN wi_text t2 ON t2.textid =3D se.heading2 AND t2.language = > =3D 'eng' AND t2.country =3D 'GB' =20 > LEFT OUTER JOIN wi_text t3 ON t3.textid =3D se.heading3 AND t3.language = > =3D 'eng' AND t3.country =3D 'GB' , wi_partrow pr =20 > LEFT OUTER JOIN wi_pifootnote f ON pr.sectionid =3D f.sectionid AND = > f.colrowno =3D 'S' =20 > LEFT OUTER JOIN wi_text t5 ON f.textid=3Dt5.textid AND t5.language =3D = > 'eng' AND t5.country =3D 'GB' , wi_text t4, wi_part pa=20 > WHERE =20 > pr.sectionid =3D se.sectionid AND t4.textid =3D pa.textid AND = > t4.language =3D 'eng' AND t4.country =3D 'GB'=20 > AND=20 > pr.partno =3D pa.partid=20 > AND=20 > t4.text LIKE '%flywheel%' AND se.fungroupno LIKE '21%' AND > ie.linktype = > =3D 'partinforef'=20 > AND=20 > CONCAT(SUBSTRING(se.sectionid,1,14),'00001') =3D ie.toid=20 > AND=20 > ie.fromid =3D fi.infoelementid AND SUBSTRING(pr.sectionid,15,19) NOT = > LIKE '00001'=20 > ORDER BY fi.vssgroupno,fi.vsscompany,fi.vssno, 2,3,4,5,6 LIMIT 0, 1201 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
