Page 1 of 1
Frontend User Add Group error
Posted: Tue May 25, 2010 1:28 am
by 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.
Re: Frontend User Add Group error
Posted: Tue May 25, 2010 3:01 pm
by 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)
Re: Frontend User Add Group error
Posted: Tue May 25, 2010 4:15 pm
by 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.
Re: Frontend User Add Group error
Posted: Tue May 25, 2010 5:37 pm
by vavgust
Solved this problem installing FrontEndUsers 1.8.5 (
http://dev.cmsmadesimple.org/project/files/14#package-9) and then updating to 1.9.
Re: Frontend User Add Group error
Posted: Tue May 25, 2010 7:31 pm
by gdur
It's a known bug. Here you can find the fix.
http://dev.cmsmadesimple.org/bug/view/4955
Re: Frontend User Add Group error
Posted: Wed May 26, 2010 1:28 am
by cacharopnet
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!
Re: Frontend User Add Group error
Posted: Wed May 26, 2010 1:29 am
by cacharopnet
Thanks, it is for creating user properties. I am glad that it is a known bug and having a fix.
Re: Frontend User Add Group error
Posted: Fri May 28, 2010 3:30 pm
by 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