OT mysql select command works on windows, but not on On-Rev or Mac

Peter Haworth pete at lcsql.com
Mon Jun 29 18:46:17 EDT 2015


Hi Matthias,
If it works on one machine, it's unlikely to be a syntax problem. I would
guess that some mySQL setting is different between the three computers but
I have no idea which one.   Wish I could help more.

On Mon, Jun 29, 2015 at 3:14 PM Matthias Rebbe | M-R-D <
matthias_livecode_150811 at m-r-d.de> 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
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



More information about the Use-livecode mailing list