网站从美国搬到香港后,这个问题困扰了我好几天,最后整得没办法了,给WHMCS官方发邮件求助,解决办法很简单,去掉MYSQL的STRICT MODE问题就迎刃而解了。 具体方法: Open your “my.ini” file within the MySQL installation directory, and look for the text “sql-mode”. Find: Code: # Set the SQL mode to strict sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”Replace with: Code: # Set the SQL mode to strict sql-mode=”NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”Or, you can run an SQL query within your database management tool, such as phpMyAdmin: Code: SET Read More