User Accounts Error

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

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: [MRI] User Accounts Error

By Dave - January 29, 2010

Hi MRI,

Can you try upgrading to the latest version (2.02)?

If that doesn't fix it feel free to email me CMS & FTP login details and I can figure out what the issue is and patch if for you if needed.

Note: If you need to send login details email them to me directly at dave@interactivetools.com. Don't post login details to the forum.
Dave Edis - Senior Developer

interactivetools.com

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