can this error be due to mysql 5 running in the new server because i'm also getting now a 'p.products_id' in 'on clause' error!

I'm going to try to patch it with the user patch and see if it works.