[Vtigercrm-developers] Setting sql_mode on a shared server for the mysql session?

[Alan Lord]

Has anyone done the above?

I have a customer with a fairly old Vtiger on a shared host and the 
hosting provider upgraded their server recently so now they are having 
issues due to the STRICT_TRANS_TABLES option being set.

I wonder if I could modify the initial connection string in the 
PearDatabase or wherever to try and set the sql_mode?

Before I spend a load of time trying to do this I wondered if anyone 
else has managed to do this before and how they did it?

TIA

Al