Reports stopping SQL bug?
Reports stopping SQL bug?
I installed the automatic updates on our server yesterday and removed "pc anywhere" Today, my SQL stops when I run some reports. If we click on income and production reports MySQL stops and our network locks up. When I run lists, monthly and daily reports, they work. It's only the income and production category that locks up. when I restart mysql OD runs again. What should I do? any ideas?
Re: Reports stopping SQL bug?
update... If I run an income and production report for the year or month, it works. if it's today or yesterday, it doesn't work... MMM? any ideas?
Re: Reports stopping SQL bug?
We had the same thing happen and support updated mySQL to 5.0 on our computer. No problems since this was done.
Jim
![Cool 8)](./images/smilies/icon_cool.gif)
Jim
James Zemencik, DMD
http://www.bridgeville-dentist.com/
http://www.bridgeville-dentist.com/
Re: Reports stopping SQL bug?
Thanks Jim!
I upgraded mySQL to 5.0 and everything works well again. whew!
I upgraded mySQL to 5.0 and everything works well again. whew!