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

2015-06-30 Thread Mark Waddingham
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

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

2015-06-30 Thread Matthias Rebbe | M-R-D
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

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

2015-06-29 Thread Matthias Rebbe | M-R-D
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

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

2015-06-29 Thread Peter Haworth
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