[Solved] Db errors adding new user

[gdvlk]

Hi everybody. I have a 3.45 installation migrated from previous vesions.
Database schema seems to be ok visiting setup page, but when I try to add a new user (internal agent, not customer), I get this error:
____________________________
Application Error [256]
MySQL Query Error Unknown column 'user_startdate' in 'field list' in /home/applicazioni/sit/user_add.php @ line 245 trigger_error()

The SiT schema may need updating to fix this problem.Visit Setup

Application Error [256]
MySQL Query Error Duplicate entry '0-1' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-2' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-3' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-4' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-5' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-6' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-7' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-8' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-9' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-10' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-11' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-12' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-13' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-14' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-15' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-16' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-17' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-18' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-19' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-20' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-21' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-22' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-23' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-24' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-25' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-26' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-27' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-28' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-29' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-30' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-32' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-33' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-34' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-35' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-36' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-37' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-38' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-39' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-40' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-41' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-42' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-43' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-44' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-45' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-46' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-47' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-48' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-49' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-50' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-51' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-52' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-53' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-54' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-55' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-56' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-57' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-58' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-59' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-60' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-61' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-62' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-63' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-64' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-65' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-66' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-67' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-68' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-69' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-70' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-71' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-72' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-73' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-74' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-75' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-76' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-77' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-78' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-79' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Error [256]
MySQL Query Error Duplicate entry '0-80' for key 1 in /home/applicazioni/sit/user_add.php @ line 257 trigger_error()

Application Notice [1024]
setup_user_triggers() Invalid userid '0' specified in /home/applicazioni/sit/lib/functions.inc.php @ line 7314 trigger_error() setup_user_triggers()
__________________


Anyone have suggestion on how to fix this issue?
Thanks
g

[gdvlk]

Ok, solved by myself inserting the date field required in sit_users database table. At the moment the main error disappeared, hope none other related issues arise ...
g