Reports stopping SQL bug?

[hjoesaar]

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?

[hjoesaar]

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?

[JimZ]

We had the same thing happen and support updated mySQL to 5.0 on our computer. No problems since this was done.
Jim

[hjoesaar]

Thanks Jim!
I upgraded mySQL to 5.0 and everything works well again. whew!