I suspected that you would say something like this. I believe that the specific insert that is failing starts in line 242 of the admin/attributes_controller.php script. The comment immediately above this line says "TODO: MySQL5", suggesting that this insert may need tweaking for MySQL5 compatibility. That said, I've not seen this problem in my MySQL5 environments (and I have dozens).
Are you seeing this on a clean database? Or on a copy of your client's database? If the latter, has your client's database been upgraded from 1.2? If so, could you post a copy of the product_attributes table schema?
Bookmarks