Well, I have updated to 4.7.0. I had been using OG in 4.6.5, and everything was OK. I had 2 groups, with members in each.

Now I have updated to 4.7.0. I read the OG install script, and it says "run the SQL script as usual." Well, there is no .mysql script. There is an og.install script, and I have no idea what to do with that. The instructions say nothing about the .install script. It seems like a PHP script, but I'm not sure if I'm supposed to execute it from a web page or what.

The old groups seem to exist, and I can read their main pages, but none of the old group-flagged content is flagged for them anymore. Now, I can live with that, but... there seems no way to see members, add members, or any of that. I am assuming the module didn't quite "take" because either I have to run a mysql script (which is not in the tar file nor in CVS), or the .install file somehow, or something, but I must admit I am rather confused here.

What am I missing? Any help would be appreciated.

Comments

Steve Viscido’s picture

Steve Viscido commented

Here's a follow up.

I thought maybe the old groups were incompatible so I re-enabled OG, and made up a new group. One major issue is that after you submit the group and make it up, if you go into edit, all options checked are re-set. The one-line description is always blanked out (even though there was one before), and the options like how subscriptions work etc, always get re-set.

Beyond that, the new group gave me this error:
Unknown column 'website' in 'field list' query: SELECT selective AS og_selective, description AS og_description, theme AS og_theme, website AS og_website, register AS og_register, directory AS og_directory, language AS og_language FROM og WHERE nid = 337 in /home/u5/chessack/roleplay-cafe.org/html/includes/database.mysql.inc on line 120.

Not sure what is going on, but it definitely looks like the MYSQL database is not configured right with regard to OG.

Any help would be appreciated.

Steve

webchick’s picture

webchick
she/they
Primary language English
Location Vancouver 🇨🇦
commented

Run update.php (make a backup first). You're missing some database changes between versions of OG. Not sure if this will address some of the other problems at the same time, but it might.

Steve Viscido’s picture

Steve Viscido commented

Thank you webchick! This worked and my organic groups are back. :)

Much appreciated.

Steve

webchick’s picture

webchick
she/they
Primary language English
Location Vancouver 🇨🇦
commented
Status: Active » Fixed

Cool. :) Marking fixed.

benedett’s picture

benedett commented

I just want to say this worked for me, too. I kept getting an error like:
"unknown column 'language' in 'field list'"

After enabling og, I ran update.php again. It said there wasn't an og update to do, but I selected the most recent one from the drop-down. Now things look like they're working normally.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)