MantisBT - v3.0 Release
View Issue Details
0000983v3.0 Release[All Projects] Generalpublic2011-09-26 02:312013-08-28 11:24
Assigned Topedroa 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version3.0.0 
Summary0000983: User creation fails
DescriptionSystem created by copying existing database, running install and creating config file only. Admin and one user already existed in database.
Attempting to create additional user (fred) fails with
Fails with message Unknown column 'perm_func' in 'field list'
logs show -
[Mon Sep 26 22:06:58 2011] [error] [client] /opt/web2dev/classes/w2p/Database/Query.class.php(1128): query failed(INSERT INTO `users`(`user_id`,`user_username`,`user_password`,`user_type`,`user_contact`,`perm_func`) VALUES ('0','fred','2697359d57024a8f41301b0332a8ba39','0','5','addLogin')) - error was: <span style="color:red">Unknown column 'perm_func' in 'field list'</span>, referer:
but a Contact is created for the use.
Also cannot create User from existing Contact.
Additional InformationUbuntu 10.04.1 LTS 64bit fully patched.
System timezone set to Pacific/Auckland & linked to ntp.
Testing information:
Using svn to pull current development versions from sourceforge
- config.php points to existing database ie did not create dayabase on install but used a copy of an existing one
- database updates applied
- Documentation, Importers, Exporters, Holiday modules added
- includes and files & files/temp set to permission 777
TagsNo tags attached.
related to 0000984closed pedroa User changing password fails 
Attached Files

2011-10-03 00:40   
The same happens with a clean install, no users can be added.

If the column 'perm_func' is created manually in the users table, the user is created and the column is populated with 'addlogin' but the user roles are not assigned. The system ends on a white page. If the roles are then manually assigned everything seems to work.
2011-10-03 18:23   
This is the same issue as 984 -
2011-10-06 03:42   
Fixed on SVN files are:


The first file fixes issue with creating external users
Second file fixes this specific bug


Pedro A.

Issue History
2011-09-26 02:31sasquatch58New Issue
2011-09-27 23:47caseydkPrioritynormal => high
2011-10-03 00:40kareljjNote Added: 0002231
2011-10-03 18:23trevormorseRelationship addedrelated to 0000984
2011-10-03 18:23trevormorseNote Added: 0002237
2011-10-03 18:24trevormorseAssigned To => trevormorse
2011-10-03 18:24trevormorseStatusnew => confirmed
2011-10-06 03:41pedroaStatusconfirmed => assigned
2011-10-06 03:41pedroaAssigned Totrevormorse => pedroa
2011-10-06 03:42pedroaNote Added: 0002245
2011-10-06 03:42pedroaStatusassigned => resolved
2011-10-06 03:42pedroaResolutionopen => fixed
2013-08-28 11:13caseydkFixed in Version => 3.0.0
2013-08-28 11:24caseydkStatusresolved => closed