WHMCS产品信息无法修改写入的解决办法

网站从美国搬到香港后,这个问题困扰了我好几天,最后整得没办法了,给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 @@global.sql_mode= ”;

2 thoughts on “WHMCS产品信息无法修改写入的解决办法”

  1. 我和你的问题有点不一样,是服务器无法修改,产品可以,用你的方法试了,不行,如果你知道,请告诉我,谢谢
    QQ 67396603 😉

Leave a Reply

Your email address will not be published. Required fields are marked *