In article is shows that
" Withdraw STRICT_TRANS_TABLES and STRICT_ALL_TABLES from the sql-mode configuration directive or comment it out altogether:
# cat /etc/mysql/my.cnf|grep sql-mode
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Well I php.ini of my server there was no line with sqlmode..
I added
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
in my php.ini , restarted mysql still at the time of upgradetion it give me error every time
WARNING: Please, switch off strict mode for MySQL server
Will you please check if i provide you server details via PM ?
waiting for your response.
Thanks,