Admin Area Issues (Data Not Saving)

[opsoftware]

Hi,

 

I am in the process of setting up the various sections of the admin area and I am hitting some problems.

 

I have tried to add some products, the form loads , I add the required information, hit save changes, page refreshes but nothing goes into the database.

 

I have been able to add Groups, and make other changes without issue.

 

This is also happening when I try to add a test client, fill in the form, hit save, page refreshes and nothing.

 

Any ideas???

 

Regards,

 

Ozzie

Edited August 27, 2010 by opsoftware
typo

[opsoftware]

Hi,

 

I am in the process of setting up the various sections of the admin area and I am hitting some problems.

 

I have tried to add some products, the form loads , I add the required information, hit save changes, page refreshes but nothing goes into the database.

 

I have been able to add Groups, and make other changes without issue.

 

This is also happening when I try to add a test client, fill in the form, hit save, page refreshes and nothing.

 

Any ideas???

 

Regards,

 

Ozzie

 

Just been in the admin area and seen the following recent activity: Created Client Tester Test - User ID: 0

 

This is obviously wrong as the tblaccounts table is empty but somewhere things are being added........

 

Ozzie

[opsoftware]

OK for anyone else who may run into this you need to do the following:

 

Method 1:

Open the "my.ini" file within the MySQL installation directory and look for something like...

# Set the SQL mode to strict

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

 

Replace with:

# Set the SQL mode to strict

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

 

Method 2:

You may be able to run an SQL query within your database management tool such as phpMyAdmin which can normally be found from your web hosting control panel:

 

SET @@global.sql_mode= '';

[WHMCS John]

Yes, MySQL Strict Mode should be disabled for WHMCS.