roll back to older version

[henmar]

After i have upgraded the sugarcrm installtion 4.2.0d im getting mysql errors, so i want to go back to the older version.
is it possible?

[rohitdsouza]

Dear

plz give some details or screen shots of the errors as only them myself or sugar crm team members can help u

Regards
Rohit D'souza

[henmar]

After upgrading to 4.2.0d, i get this error:
Error selecting sugarbean: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS total FROM users,opportunities WHERE opportunities
This is error show up in all the modules except admin, even when i login.
i have attached the diagnostics and the mysql version : is 4.0.27 and php version:5.1.4

thanks