problem with modifying user data [SOLVED]

[ZibiX]

Hi.

My system: 1 x db, 3 x vici, 1 x web.

Vicibox version: 4.0.3
System version: 2.8-406a BUILD: 130627-0745
SVN Version: 1998
DB Schema Version: 1352

mySQL version: 5.1

What was done that trigers the problem:
- 3 people use same account (6666) with level 9
- one of the people changed password to 6666 acount
- system block access to system for 15 minutes because other 2 people still want to log to 6666 account with old password
- one of the people log via SSH to db serwer with root access. He opened MC and in MC edit the file vicidial_users.MYD from mySQL database. He change password to old password (the password was longer then prevoius one). He saves this file in MC


And now the problem:
- I can add new user (the user can have every level). After adding an user I can modify Agent interface options and Admin interface options. A can save this user.
- after this step when i want to change user data (e.g. name of the user or user level or agent interface options or admin interface options) and i click save all the options from section admin interface options become empty (no 1, no 0, just empty)
- it happens on all user levels. Even when i want to modify my accont and i click save all the options become empty. Then i need to use phpmyadmin to alter manualy this options.

I have done mysqlcheck (no errors, no effect).

What I can do to solve this problem?

[ZibiX]

UPDATE

- from phpmyadmin i have exported vicidial_users table to csv format. I have checked the file and make some adjusment (putting 0 or 1 in coresponding columns).
- from phpmyadmin i have deleted all rows in vicidial_users table
- I have done mysqlcheck with optimalization option
- I have imported my file to vicidial_users

No luck - still when i have make adjustments in user tab and click SUBMIT button all my options from Admin interface options ale gone (empty).

Next thing I have done was updating all my system do newest SVN.

Still no luck.

Anyone?

[mflorell]

I can't replicate this on our dev servers. This is usually a db schema version mismatch. Check the Apache error_log file when this happens.

[ZibiX]

Thanks to mflorell problem was solved

In error_log there was an entry everytime when I click submit button:

Thu Apr 10 23:40:06 2014] [error] PHP Warning: Unknown: Input variables exceeded 1000. To increase the limit change max_input_vars in php.ini. in Unknown on line 0

So I have edited this value in file /etc/php5/apache2/php.ini to 10000

I have restarted apache and te problem was solved

Thanks mflorell, you are The Man!

[mflorell]

Thank for posting your solution