Can't save products, servers, promotions

[polestar]

Hello,

my WHMCS 5.2.24 is not saving data when editing products, promotions, servers etc. Site is reloading but new data is not stored.

 

I wrote to support yesterday but so far they proposed me only solution that I found on this forum, and it's not working (sql strict mode entry in my.cnf). I really need to change some settings but I'm stuck. When I edit server via PhpMyAdmin changes is visible in whmcs but it's not an option since password is encoded and I don't now how.. Maybe you have some ideas?

[polestar]

WHMCS staff, can anybody take care of #TMY-427423 ticket?

 

Hosting is 24/7 business and it's really annoying when I can't even edit server DirectAdmin password or add product because your support seem to not working on weekends..

[polestar]

I fixed it by myself. WHMCS probably during the updates has not added a few table fields in tables like tblproducts or tblservers. Due to "fantastic" support I installed clean WHMCS and compared what is missing..

 

- - - Updated - - -

 

Now all works properly.

[cilu]

Hi,

 

When I edit server, in sql log

 

UPDATE tblservers SET (..) accesshash`='',`secure`='on',`disabled`='',`active`='0' WHERE id='2';

 

I got error

 

#1366 - Incorrect integer value: '' for column 'disabled' at row 1

[cilu]

I had in my.cnf

 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

 

after hash it, works ok