Page 1 of 1

[SOLVED] cms_module_feusers_grouppropmap - Why don't I have it?

Posted: Mon May 31, 2010 11:57 am
by Locker101
Hi all,

Fresh install of everything.

CMSMS 1.7.1
CGExtensions 1.18.8
FrontEnd Users 1.9.2

When I go to add a GROUP to FRONTEND USERS, I receive this error:

Table 'server_mpcms.cms_module_feusers_grouppropmap' doesn't exist INSERT INTO cms_module_feusers_grouppropmap VALUES('contact',1,0,'1',-1)

All I have done is installed CG Extensions, and FrontEnd Users.

When I go to MyPhpAdmin, it doesn't appear there (the table).
I have tried removing and reinstalling them too.

Any help would be great!

Cheers.

Re: cms_module_feusers_grouppropmap - Why don't I have it?

Posted: Mon May 31, 2010 12:03 pm
by Locker101
After I receive the error, the group appears to be created. When I try and delete the group, it just says "Error" on the following page.

Re: cms_module_feusers_grouppropmap - Why don't I have it?

Posted: Mon May 31, 2010 1:14 pm
by Locker101
WOOHOO, worked it out.
I scoured the install code to see if there were any issues. I'm not overly good with that sort of thing but I found a comma in the install PHP file, at the end of the last field to be added.

Was : lostunflag I,

Now : lostunflag I

And it works.

Re: [SOLVED] cms_module_feusers_grouppropmap - Why don't I have it?

Posted: Tue Jun 01, 2010 6:48 am
by networker
Brilliant!
Thank you!

Re: [SOLVED] cms_module_feusers_grouppropmap - Why don't I have it?

Posted: Tue Jun 01, 2010 8:30 am
by YourFace
Probably a dumb question but still a question. Where do i find the install code so a i can change this error???
Thanks a bunch.

Re: [SOLVED] cms_module_feusers_grouppropmap - Why don't I have it?

Posted: Tue Jun 01, 2010 8:55 am
by YourFace
So i found the install.php file, deleted the comma. but i still i cant delete groups and also i get this message when i click on a group:

"no properties can be found for this group"

Also when i delete and reinstall FEUsers i get this message: Warning: implode() [function.implode]: Invalid arguments passed in /usr/www/users/cultif/cultimo_web/lib/adodb_lite/adodb-datadict.inc.php  on line 726
Das Modul wurde installiert.
Stellen Sie sicher, dass die Berechtigung "Modify FrontEndUser Properties" gesetzt wurde. Zusätzlich wird die Installation des Captcha-Moduls empfohlen. Nach dessen Installation wird bei der Anmeldung ergänzend zu Benutzernamen und Passwort der Inhalt eines Captcha-Bildes abgefragt. Dies soll helfen, Brute-force-Attacken zu verhindern. Hinweis: Diese Funktionalität kann mit dem Parameter nocaptcha deaktiviert werden, auch wenn das Captcha-Modul installiert ist.

I have no clue what is going on please help!!!!!

Thank You Very Much.

Re: [SOLVED] cms_module_feusers_grouppropmap - Why don't I have it?

Posted: Sat Jun 05, 2010 10:33 am
by stevew
Uninstall FrontEndUsers from the Modules page, then edit the file method.install.php in /modules/FrontEndUsers

Search for "lostunflag":

Code: Select all

// group property map
    // used to associate a property to a group
    $flds = "
              name    C(40) KEY,
              group_id I KEY,
              sort_key I, 
              required I NOT NULL,
              lostunflag I,
            ";
Remove the comma after "lostunflag I".

On the Modules page reinstall FrontEndUsers.  For me, that worked.