Constant MySQL Syntax Errors after upgrading PHP

[castus]

After I painstaking upgraded php on my server from 4+ to 5.1.3 I constantly get MySQL Syntax errors when trying to update any of my databases through phpMyAdmin.

The databases seem to be updateable through any CMS apps I have on the server - just not phpMyAdmin.

Anyone have a clue why this is?

I'm on IIS6, php 5.1.3 mysql 4.1.7 phpmyadmin 2.0.8

 

[jpadie]

there was a change in one of the recent mysql versions in the way that where clauses in groupings and joins have to be constructed.

phpmyadmin is now at 2.8.3, as a first step toward problem resolution, I would install this version.

 

[castus]

Thanks for the info. Having a look on the php web site, it seems that the version 5.1.3 had a bug or two and have quickly released 5.1.4.

So after upgrading to this and overwriting the old libmysql.dll, everything seems to be fine.

I think it was the libmysql.dll that was bundled with the other php version.

Phew - what a relief it I upgraded at the weekend - hopefully my clients won't have noticed much over the weekend.