The UI of phpMyAdmin differs a lot between versions, so please bear with me. I'll try to describe what you should be seeing.
Find the gl_groups table and click on it. You should have a tab "Structure" where you can see the fields in that table. There should be 4 of them: grp_id, grp_name, grp_descr, and grp_gl_core.
From your description, it seems like you are missing the last one, grp_gl_core.
If so: There should be an option to add 1 field at the end of the table. Do that with the following information:
- Field name is "grp_gl_core"
- Type is "TINYINT"
- Length is "1"
- Attributes is "UNSIGNED"
- for Null select "not null"
- Default is "0"
- leave any other options (collation, extra) empty
Click on "Save", then try to get into Geeklog's Groups editor again.
Fortunately, that field is really only used for filtering out the Admin groups in the Groups editor. That won't work for you, but other than that you won't be missing any functionality.
thanks dirk that worked!! however i am getting the same error on the plugins page too, how can i rectifify this??
this is the error i am getting in error.log
Sun May 31 20:38:41 2009 - 1054: Unknown column 'pi_gl_version' in 'field list'. SQL in question: SELECT pi_name, pi_version, pi_gl_version, pi_enabled, pi_homepage FROM ge_plugins WHERE 1=1
Something about your setup is really very odd. Is this a new install or has it been running for a while (1.4.1 isn't exactly new)? If it's not a new install - have these things worked before?
To add the missing field: Go into the "Structure" tab for the gl_plugins table, add a new field "pi_gl_version" with Type "VARCHAR", Length "20", and null set to "not null". Leave the other entries blank.
Again, nothing vital missing there. But I've never seen such an install before ...
all working, ive had geeklog for about a year now and i think there must be something odd about my hosts installer as these have never worked (until today!)