Add Staff to Staff Directory

///Add Staff to Staff Directory
Add Staff to Staff Directory2017-10-10T13:27:12+00:00

Home Forums Abre Support Add Staff to Staff Directory

  • Author
    Posts
  • Anonymous
    Post count: 5

    When adding staff to the staff directory module. We receive the following error message: Field ‘archived’ doesn’t have a default value

  • Christopher Rose
    Keymaster
    Post count: 10

    Adam,

    Depending on the type/version of SQL you are using you might need to set a default value in the database column. For example, go to the Abre database, then the directory table, then give the archived column a default value of “0”. That way when a user is added it returns “0” by default.

    On our production servers we are using MySQL 5.5 and PHP 7. By default our system configuration does not require a default value for int fields but setting that value on your configuration should work.

    Hope that helps!

  • Anonymous
    Post count: 5

    Ther server is currently running MySQL 5.7.19, PHP 7.0, on Ubuntu 16.04.3. I have made the changes to the archived column to 0 using PHPMyAdmin. After the change a new error occured ‘Field ‘RefID’ dosen’t have a default value’ Below is a copy of the Apache 2 error log when trying to add people to the staff directory.

    [Wed Oct 11 11:56:09.066909 2017] [:error] [pid 12796] [client 10.11.4.18:64063] PHP Notice: Undefined index: sysadmin in /var/www/html/Abre.talawanda.org/Abre/modules/directory/updateuser.php on line 164, referer: https://abre.talawanda.org/
    [Wed Oct 11 11:56:09.066946 2017] [:error] [pid 12796] [client 10.11.4.18:64063] PHP Notice: Undefined index: role in /var/www/html/Abre.talawanda.org/Abre/modules/directory/updateuser.php on line 166, referer: https://abre.talawanda.org/
    [Wed Oct 11 11:56:09.066956 2017] [:error] [pid 12796] [client 10.11.4.18:64063] PHP Warning: implode(): Invalid arguments passed in /var/www/html/Abre.talawanda.org/Abre/modules/directory/updateuser.php on line 166, referer: https://abre.talawanda.org/
    [Wed Oct 11 12:01:29.446270 2017] [:error] [pid 14138] [client 10.11.4.18:64153] PHP Notice: Undefined index: sysadmin in /var/www/html/Abre.talawanda.org/Abre/modules/directory/updateuser.php on line 164, referer: https://abre.talawanda.org/
    [Wed Oct 11 12:01:29.446312 2017] [:error] [pid 14138] [client 10.11.4.18:64153] PHP Notice: Undefined index: role in /var/www/html/Abre.talawanda.org/Abre/modules/directory/updateuser.php on line 166, referer: https://abre.talawanda.org/
    [Wed Oct 11 12:01:29.446326 2017] [:error] [pid 14138] [client 10.11.4.18:64153] PHP Warning: implode(): Invalid arguments passed in /var/www/html/Abre.talawanda.org/Abre/modules/directory/updateuser.php on line 166, referer: https://abre.talawanda.org/

  • Christopher Rose
    Keymaster
    Post count: 10

    The previous logs are just warnings and notices….nothings stopping it from running. You must have a different mysql configuration that requires a default value. You could just try setting this to 0 like you did with archived.

You must be logged in to reply to this topic.