User Accounts Error

5 posts by 2 authors in: Forums > CMS Builder
Last Post: February 3, 2010   (RSS)

By MRI - January 29, 2010

Hi,

Im trying to set up an account where a user can access and create new users without having admin access...

when that user logs in and trys to create a new user it brings up this error:

MySQL Error: Column 'isAdmin' cannot be null

Re: [MRI] User Accounts Error

By Dave - January 29, 2010

Hi MRI,

Can you let me know what version of CMS Builder you are running?

Thanks!
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] User Accounts Error

By MRI - January 29, 2010

1.28

Re: [Dave] User Accounts Error

By Dave - February 3, 2010

Just a follow up on this. This issue was fixed in 1.29:
- User Accounts: Fixed MySQL Error when non-admin users would add new user accounts: "Column 'isAdmin' cannot be null"

So the solution would be to upgrade or try this patch:

- Open /lib/menus/default/save.php
- Search for = NULL
- Around line 232 add this code in red:

if ($value == '' && $isIntColumn && $fieldType != 'checkbox') {
$colsToValuesString .= "`$colName` = NULL, ";
}

Hope that helps!
Dave Edis - Senior Developer
interactivetools.com