Even me too facing the same problem.
The godaddy mysql server is working fine in connecting with other CMS like joomla and drupal. and even when i tried with the code.
could not justify where the problem lies
.
i referred to the doc specified for the requirements of roundcube in the link
http://trac.roundcube.net/wiki/Howto_Requirements and focused on the line
" MySQL or PostgreSQL database engine or the SQLite Extension for PHP
* If using MySQL 5.0.2 or later, disable STRICT_TRANS_TABLES and STRICT_ALL_TABLES "
the mysql version iam using is :
# Server version: 5.0.45-log
# MySQL client version: 5.0.27
# Protocol version: 10
# Server: 10.6.166.194 via TCP/IP
i might be failed in disabling STRICT_TRANS_TABLES and STRICT_ALL_TABLES in resolving the issue. i dint find these two parameters in my.ini.
PHP Version 4.3.11 is the version i am currently using.
Please help
Thank you in advance.