User Accounts Error

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

Archived
Reply
Reply

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

Archived
Reply
Reply

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

Archived
Reply
Reply

By MRI - January 29, 2010

1.28

Re: [MRI] User Accounts Error

Archived
Reply
Reply

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

Archived
Reply
Reply

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