CMS Made Simple Forums

in FEU, when I try to add my user properties to group, I get an error 500. Below is system info, and debug info and attached the access logs info and a photo of myphpadmin's sql file for module_feusers_propdefn
Please let me know what I need to do to establish the group setting for FEU. I uninstalled self registration, in case this was the issue, but using self registration is my end goal.

system info:
----------------------------------------------
Cms Version: 2.1.3
Installed Modules:
AdminSearch: 1.0.1
CGExtensions: 1.53.5
CGSimpleSmarty: 2.1
CMSContentManager: 1.1
CMSMailer: 6.2.14
DesignManager: 1.1.1
FileManager: 1.5.2
FrontEndUsers: 1.31.2
MicroTiny: 2.0.3
ModuleManager: 2.0.2
Navigator: 1.0.3
News: 2.50.5
Search: 1.50.2

Config Information:
php_memory_limit:
max_upload_size: 128000000
url_rewriting: none
page_extension:
query_var: page
auto_alias_content: true
locale:
set_names: true
timezone: America/New_York
permissive_smarty: false

Php Information:
phpversion: 5.5.31
md5_function: On (True)
json_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_ALL: 32767
E_STRICT: 2048
E_DEPRECATED: 8192
test_file_timedifference: No time difference found
test_db_timedifference: No time difference found
create_dir_and_file: 1
memory_limit: 128M
max_execution_time: 30
register_globals: Off (False)
output_buffering: On
disable_functions:
open_basedir:
test_remote_url: Success
file_uploads: On (True)
post_max_size: 128M
upload_max_filesize: 128M
session_save_path: /tmp (1777)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)
check_ini_set: On (True)
curl: On

Performance Information:
allow_browser_cache: Off (False)
browser_cache_expiry: 60
php_opcache: Off (False)
smarty_cache: Off (False)
smarty_compilecheck: Off (False)
smarty_cache_udt: Off (False)
auto_clear_cache_age: On (True)
Server Information:
Server Software: Apache
Server Api: cgi-fcgi
Server Os: Linux 3.14.25-grsec.3.el5 On x86_64
Server Db Type: MySQL (mysqli)
Server Db Version: 5.5.40
Server Db Grants: Found a "GRANT ALL" statement that appears to be suitable

Permission Information:
tmp: /home/macmultifamily/public_html/tmp (0755)
tmp_cache: /home/macmultifamily/public_html/tmp/cache (0755)
templates_c: /home/macmultifamily/public_html/tmp/templates_c (0755)
modules: /home/macmultifamily/public_html/modules (0755)
uploads: /home/macmultifamily/public_html/uploads (0755)
File Creation Mask (umask): /home/macmultifamily/public_html/tmp/cache (0755)
config_file: 0644
----------------------------------------------

Debug info:
----------------------------------------------
Notice: Undefined variable: val in /home/macmultifamily/public_html/modules/FrontEndUsers/FrontEndUsers.module.php on line 1167

Fatal error: Uncaught cg_sql_error 'Column 'required' cannot be null -- Column 'required' cannot be null' in /home/macmultifamily/public_html/modules/CGExtensions/lib/class.cge_utils.php:67 #0 /home/macmultifamily/public_html/lib/adodb_lite/adodbSQL_drivers/mysqli/mysqli_driver.inc(332): cge_utils::{closure}('mysqli', 'EXECUTE', 1048, 'Column 'require...', 'INSERT INTO cms...', Array, Object(pear_ADOConnection)) #1 /home/macmultifamily/public_html/lib/adodb_lite/adodb.inc.php(315): mysqli_driver_ADOConnection->do_query('INSERT INTO cms...', -1, -1, Array) #2 /home/macmultifamily/public_html/modules/FrontEndUsers/lib/class.FrontEndUsersManipulator.php(348): ADOConnection->Execute('INSERT INTO cms...', Array) #3 /home/macmultifamily/public_html/modules/FrontEndUsers/FrontEndUsers.module.php(1167): FrontEndUsersManipulator->AddGroupPropertyRelation(2, 'company', 0, -1, NULL) #4 /home/macmultifamily/public_html/modules/FrontEndUsers/action.do_addgroup.php(138): FrontEndUsers->AddGroupPropertyRelation(2, 'company', 0, -1, '1') in /home/macmultifamily/public_html/modules/CGExtensions/lib/class.cge_utils.php on line 67
---------------------------------

I just tested this numerous times... and debugged the code. I have no issues with this code at all. I also checked the database tables on my end and there is no error there.

I looked at the code, and it should be impossible for that to happen. Unless it's a bug in that particular version of php or something.

Strange. What are your suggestions? Should I contact my server provider and ask them to check their php? They automatically update php for me. Do you know what I should tell them?
My cms was set up through softaculous and I have made no changes to the code structure provided.

If I manually added the required field to the database, do you think that would fix the problem?

Thank you for your follow up Calguy, you are my hero!

I have a message sent to my host, site5. I will let you know what they say. Meanwhile, I uninstalled and completely removed cgextensions, cmsmailer, cgsimplesmarty, frontendusers and self registration, then reloaded them one-by-one. Unfortunately that didn't fix the issue. I also tried to add the binary for {required} manually in the sql database and that didn't fix it either.

If anyone else has some suggestions, I am all ears! Thanks!

This was from my site5 people.

Hi Jennifer,
According to the debug information this does appear to be code related, however could you developer provide the details of their tests? Such as what version of php they are testing with currently?
Thanks,
Luke K.
Technical Support Specialist, Site5.com

By accident I came across the same error and informed calguy.

A fix will be released this weekend. Thank you for your patience.

Thank you Velden! I am curious about what could make it do that. I bet it is a curly bracket or something simple...lol!

Yahoooo!

You fixed it in your new version of FEU! Thank you for your help!

I did mention Calguy is my hero right? I am so impressed with your skills!