Frontend User Add Group error

[cacharopnet]

I am trying to create a group using the frontend user management, but  got this error. I am using cmsmadesimple-1.7.1-base.tar.gz, the version of FrontEndUsers is 1.9.

Column count doesn't match value count at row 1 INSERT INTO cms_module_feusers_grouppropmap VALUES('email',3,0,'2',1)
I am not sure if it is a bug, the other day I was trying to add a properties and I found the database doesn't have a column for saving "Force values of this property to be unique across all user accounts", I then manually created that column. It works now.
Thanks a lot for anyhelp. I am Made Simple beginner user.

[sublime5o]

This is happening to me too.  New 1.7 CMSMS with the newest Frontend module.  Please help.. Exact error is this when creating Group.

Column count doesn't match value count at row 1 INSERT INTO cms_module_feusers_grouppropmap VALUES('members',1,0,'3',-1)

[cacharopnet]

I think the error caused by the table definition is not the same as the front end script. Should we modify the table or the front-end to make them consistent? Thanks for any help.

[vavgust]

Solved this problem installing FrontEndUsers 1.8.5 (http://dev.cmsmadesimple.org/project/files/14#package-9) and then updating to 1.9.

[gdur]

It's a known bug. Here you can find the fix.

http://dev.cmsmadesimple.org/bug/view/4955

[cacharopnet]

Solved this problem installing FrontEndUsers 1.8.5 (http://dev.cmsmadesimple.org/project/files/14#package-9) and then updating to 1.9.

Hi, I have installed 1.8.5, but don't know how to upgrade it to 1.9. As the doc at http://wiki.cmsmadesimple.org/index.php ... ns/Modules, I copied the files over, but it doesn't have an upgrade option for me to use.
Could you tell me how to do it? Thank you very much!

[cacharopnet]

It's a known bug. Here you can find the fix.

http://dev.cmsmadesimple.org/bug/view/4955

Thanks, it is for creating user properties. I am glad that it is a known bug and having a fix.

[cacharopnet]

I found the solution here:
http://forum.cmsmadesimple.org/index.ph ... 163.0.html
it seems also that the FEU 1.9 installer create the force_unique column inthe wrong database table, as after applying your patch, if I can create properties, I still can't create groups getting a
Code:

Column count doesn't match value count at row 1 INSERT INTO cms_module_feusers_grouppropmap....



dropping the force_unique column in the cms_module_feusers_grouppropmap table, solved my the problem.

Hope this helps

regards
Logged
--------------------------------------
Zaskar