Thanks Mark. But the DB is only 64kb in size at the moment. So the maximum query size should not matter. I checked the On-Rev settings in my account for max_allowed_packet and i get 268435456. This should be enough, shouldn´t it?
I will try on windows myself and will compare the settings with my Mac settings. Maybe i find something. Thanks again. Regards, Matthias > Am 30.06.2015 um 09:22 schrieb Mark Waddingham <[email protected]>: > > Hi Matthias, > > It looks like a long query so I wonder if one of the MySQL server settings is > different on the different systems? > > I found this after googling... Might be worth a look? > > http://stackoverflow.com/questions/16335011/what-is-maximum-query-size-for-mysql > > Mark > > Sent from my iPhone > >> On 29 Jun 2015, at 23:14, Matthias Rebbe | M-R-D >> <[email protected]> wrote: >> >> Hi, >> >> one of my customers is having a problem with a specific select command in a >> view on MySQL on On-Rev Diesel and also on Jasmine. >> It´s working on his MySQL on Windows. I tried it here on Mac (imported his >> DB dump). The view is listed but opening it does not show any result. But >> it crashes my MySQL and i have to restart the service. >> Even if i just execute the select command in PHPMyAdmin directly i do not >> get any results. >> >> The select command is a little bit complex, but i post it here. Is there >> something we do not see which might cause that crashes on Linux and mac, but >> works on Windows? >> >> Here´s the select command. For better reading i put it on several lines. >> >> >> — >> select >> `tagesplan`.`ID` AS `ID`, >> `tagesplan`.`Plan` AS `Plan`, >> `tagesplan`.`Tag` AS `Tag`, >> `tagesplan`.`mo1` AS `MoId1`, >> `b1`.`Bild` AS `Mobild1`, >> `b1`.`Name` AS `MoName1`, >> `tagesplan`.`mo2` AS `MoID2`, >> `b2`.`Bild` AS `Mobild2`, >> `b2`.`Name` AS `MoName2`, >> `tagesplan`.`mo3` AS `MoID3`, >> `b3`.`Bild` AS `Mobild3`, >> `b3`.`Name` AS `MoName3`, >> `tagesplan`.`mo4` AS `MoID4`, >> `b4`.`Bild` AS `Mobild4`, >> `b4`.`Name` AS `MoName4`, >> `tagesplan`.`mo5` AS `MoID5`, >> `b5`.`Bild` AS `Mobild5`, >> `b5`.`Name` AS `MoName5`, >> `tagesplan`.`mo6` AS `MoID6`, >> `b6`.`Bild` AS `Mobild6`, >> `b6`.`Name` AS `MoName6`, >> `tagesplan`.`mi1` AS `MiId1`, >> `b7`.`Bild` AS `Mibild1`, >> `b7`.`Name` AS `MiName1`, >> `tagesplan`.`mi2` AS `MiID2`, >> `b8`.`Bild` AS `Mibild2`, >> `b8`.`Name` AS `MiName2`, >> `tagesplan`.`mi3` AS `MiID3`, >> `b9`.`Bild` AS `Mibild3`, >> `b9`.`Name` AS `MiName3`, >> `tagesplan`.`mi4` AS `MiID4`, >> `b10`.`Bild` AS `Mibild4`, >> `b10`.`Name` AS `MiName4`, >> `tagesplan`.`mi5` AS `MiID5`, >> `b11`.`Bild` AS `Mibild5`, >> `b11`.`Name` AS `MiName5`, >> `tagesplan`.`mi6` AS `MiID6`, >> `b12`.`Bild` AS `Mibild6`, >> `b12`.`Name` AS `MiName6`, >> `tagesplan`.`ab1` AS `AbID1`, >> `b13`.`Bild` AS `Abbild1`, >> `b13`.`Name` AS `AbName1`, >> `tagesplan`.`ab2` AS `AbID2`, >> `b14`.`Bild` AS `Abbild2`, >> `b14`.`Name` AS `AbName2`, >> `tagesplan`.`ab3` AS `AbID3`, >> `b15`.`Bild` AS `Abbild3`, >> `b15`.`Name` AS `AbName3`, >> `tagesplan`.`ab4` AS `AbID4`, >> `b16`.`Bild` AS `Abbild4`, >> `b16`.`Name` AS `AbName4`, >> `tagesplan`.`ab5` AS `AbID5`, >> `b17`.`Bild` AS `Abbild5`, >> `b17`.`Name` AS `AbName5`, >> `tagesplan`.`ab6` AS `AbID6`, >> `b18`.`Bild` AS `Abbild6`, >> `b18`.`Name` AS `AbName6`, >> `b1`.`Textblock` AS `MoText1`, >> `b2`.`Textblock` AS `MoText2`, >> `b3`.`Textblock` AS `MoText3`, >> `b4`.`Textblock` AS `MoText4`, >> `b5`.`Textblock` AS `MoText5`, >> `b6`.`Textblock` AS `MoText6`, >> `b7`.`Textblock` AS `MiText1`, >> `b8`.`Textblock` AS `MiText2`, >> `b9`.`Textblock` AS `MiText3`, >> `b10`.`Textblock` AS `MiText4`, >> `b11`.`Textblock` AS `MiText5`, >> `b12`.`Textblock` AS `MiText6`, >> `b13`.`Textblock` AS `AbText1`, >> `b14`.`Textblock` AS `AbText2`, >> `b15`.`Textblock` AS `AbText3`, >> `b16`.`Textblock` AS `AbText4`, >> `b17`.`Textblock` AS `AbText5`, >> `b18`.`Textblock` AS `AbText6` >> from ((((((((((((((((((`tagesplan` >> join `bestandteile` `b1` on (`tagesplan`.`mo1` = `b1`.`nr`)) >> join `bestandteile` `b2` on (`tagesplan`.`mo2` = `b2`.`nr`)) >> join `bestandteile` `b3` on (`tagesplan`.`mo3` = `b3`.`nr`)) >> join `bestandteile` `b4` on (`tagesplan`.`mo4` = `b4`.`nr`)) >> join `bestandteile` `b5` on (`tagesplan`.`mo5` = `b5`.`nr`)) >> join `bestandteile` `b6` on (`tagesplan`.`mo6` = `b6`.`nr`)) >> join `bestandteile` `b7` on (`tagesplan`.`mi1` = `b7`.`nr`)) >> join `bestandteile` `b8` on (`tagesplan`.`mi2` = `b8`.`nr`)) >> join `bestandteile` `b9` on (`tagesplan`.`mi3` = `b9`.`nr`)) >> join `bestandteile` `b10` on (`tagesplan`.`mi4` = `b10`.`nr`)) >> join `bestandteile` `b11` on (`tagesplan`.`mi5` = `b11`.`nr`)) >> join `bestandteile` `b12` on (`tagesplan`.`mi6` = `b12`.`nr`)) >> join `bestandteile` `b13` on (`tagesplan`.`ab1` = `b13`.`nr`)) >> join `bestandteile` `b14` on (`tagesplan`.`ab2` = `b14`.`nr`)) >> join `bestandteile` `b15` on (`tagesplan`.`ab3` = `b15`.`nr`)) >> join `bestandteile` `b16` on (`tagesplan`.`ab4` = `b16`.`nr`)) >> join `bestandteile` `b17` on (`tagesplan`.`ab5` = `b17`.`nr`)) >> join `bestandteile` `b18` on (`tagesplan`.`ab6` = `b18`.`nr`)); >> >> >> >> Regards, >> >> Matthias >> >> >> >> >> >> _______________________________________________ >> use-livecode mailing list >> [email protected] >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
