MySQL Issue

[PrvtPilot]

Hi

 

I just finished moving WHMCS to a new server.

 

I also upgraded from MySQL 4.1 to 5.0

 

Once I imported the database into the new server WHMCS works but with several issues. I was able to change almost all the settings except those in "Products/Services" and "Promotions".

 

Here is the problem, when I try to modify "Module Settings" in "Products/Services" it will not allow any changes. Once the new information is typed in and you click save the information is reverted back to the original data. Any data edited in the "Promotions" area also reverts back.

 

I can Add, Edit, Delete and Modify anything else but these two areas.

 

Anyone have any ideas?

 

Thanks,

Dean

[PrvtPilot]

Problem Solved By WHMCS Support...

 

 

The issue was that Strict Mode was set to "On" in the MySQL Server.

[brundle]

In my case the strict mode setting that was causing this problem was specifically the "STRICT_TRANS_TABLES" option of the strict mode setting.

[wiszmaster]

Brundle,

Is this a recent issue? The original post appears to be from January this year.

[Polk]

How do you disable STRICT MODE? Set it to TRADITIONAL or which one?

[brumstix]

I'm having a similar problem with settings not being saved. How to disable strict mode? Thanks

[mylove4life]

By default, MySQL is enabled with strict_mode ON.

currently does not fully support MySQL5.x in strict_mode

 

So, for now, strict_mode needs to be turned off.

This can be done in two ways...

 

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= '';

[vincent1]

I'm about to upgrade from MySQL 4.1 to 5.0

Is this still an issue with current WHMCS?

Thanks,

 

- Vincent