Add a default value to users.usersFullname field
Virtual Research Environment / On-line Bibliography Manager
Brought to you by:
sirfragalot
Adding a user (without entering the fullName), I get the following (after running the new repairKit):
#0 SQL->sqlDie(Field 'usersFullname' doesn't have a default value, [SQL ERROR] INSERT INTO wkx_users (`usersUsername`, `usersEmail`) VALUES ('mark', 'mgbotswana@gmail.com'); ) called at [/Applications/XAMPP/xamppfiles/htdocs/wikindx6/trunk/core/libs/SQL.php:3179] #1 SQL->internalQuery(INSERT INTO wkx_users (`usersUsername`, `usersEmail`) VALUES ('mark', 'mgbotswana@gmail.com');, ) called at [/Applications/XAMPP/xamppfiles/htdocs/wikindx6/trunk/core/libs/SQL.php:229] #2 SQL->query(INSERT INTO wkx_users (`usersUsername`, `usersEmail`) VALUES ('mark', 'mgbotswana@gmail.com');, ) called at [/Applications/XAMPP/xamppfiles/htdocs/wikindx6/trunk/core/libs/SQL.php:254] #3 SQL->queryNoResult(INSERT INTO wkx_users (`usersUsername`, `usersEmail`) VALUES ('mark', 'mgbotswana@gmail.com');) called at [/Applications/XAMPP/xamppfiles/htdocs/wikindx6/trunk/core/libs/SQL.php:1290] #4 SQL->insert(wkx_users, Array ([0] => usersUsername,[1] => usersEmail), Array ([0] => mark,[1] => mgbotswana@gmail.com)) called at [/Applications/XAMPP/xamppfiles/htdocs/wikindx6/trunk/core/usersgroups/USER.php:264] #5 USER->writeUser(1, 2) called at [/Applications/XAMPP/xamppfiles/htdocs/wikindx6/trunk/core/modules/admin/ADMINUSER.php:200] #6 ADMINUSER->add() called at [/Applications/XAMPP/xamppfiles/htdocs/wikindx6/trunk/index.php:110] [SQL ERROR] INSERT INTO wkx_users (`usersUsername`, `usersEmail`) VALUES ('mark', 'mgbotswana@gmail.com');
Field 'usersFullname' doesn't have a default value
Fixed by commit [r1237].
Related
Commit: [r1237]