In my continued activities as the designated CMS Twiddler for the Learning Commons, I’m putting together a site for a client that will serve as both a “traditional” website (but they can edit through a browser), and a “community” site, with blogs, forums, resource databases and the like. I was playing with both Drupal 4.6.x and the betas of 4.7 (now up to beta 3), and I’ve found a combination of modules that will let us do pretty much exactly what we had planned on.
I’m using these modules:
- Organic Groups
- Dashboard
- Front Page
- CSS
- and likely Flexinode as well
It’s working extremely well, and is almost ready for the drop of content from the client. But I’ve got one (hopefully) minor glitch, related to the Organic Groups module. I can install and enable it OK. I can even create a group. But, then I’m faced with a cryptic error message:
Table 'drupal_cpep.og_term' doesn't exist query: SELECT t.* FROM term_node r INNER JOIN og_term ogt ON t.tid = ogt.tid INNER JOIN node_access ogna ON ogt.nid = ogna.nid AND realm = 'og_uid' AND gid = 1 INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 5 ORDER BY v.weight, t.weight, t.name in /Library/WebServer/Documents/cpep/includes/database.mysql.inc on line 108.
The .sql file doesn’t mention a og_term table, nor does the .module file. I’ll play some more tomorrow to see if I can figure this one out.
{ 16 comments… read them below or add one }
“The .sql file doesn’t mention a og_term table” – sounds like your problem right there, if the table isnt in the setup script you need to find out the schema and get it created?
Cole, are you using Organic Groups?
We just got 4.7 running for a forthcoming podcasting solution … I think it is running well. If you need anything hit me up offblog.
Well, yeah… duh… I was poking through the cvs repository for the og module and didn’t find a version of the .sql file that included the og_term table. I suppose the next step is to reverse engineer the table from the php source…
Just trying to help! I would email the developer rather than try to reverse engineer, unless you already tried.
Yeah, and thanks, Chris. Sorry for the early morning snarkiness.
I’ll be checking out the project site, and contacting the developer.
Ahah! Tracked down the cause… Seems to be in the new “OG Forums” module. Some borkage in there somewhere, but simply disabling the module (leaving the main “OG” module running) seems to fix it nicely.
The new group content display page is much nicer than the table of contents view used before. Yay River Of News!
I might be begging your expertise– looking for over the summer to replace our scotch taped / rubberbanded together of MovableType 2.6 phpBB and UseMod for our Ocotillo Project. I am suspecting Drupal is the route to go, maybe Moodle… but I want to have a site where the content is public viewable but admin controls on who gets to edit, etc.
And I am not really wanting to learn another server tool, but cannot escape that one.
Apparently Moodle and Drupal can be integrated on some level – I’ll try to play with that when I get a chance.
Why are you moving off the Scotch Tapeâ„¢ platform? Something not work properly? I haven’t seen the whole thing, but what I’ve seen looks pretty complete.
Oh, and Alan – of course you’re more than welcome to tap any of my “expertise” any time!
The free tagging support is worth switching to Drupal 4.7. Thanks for posting the info on the organic groups module.
btw .. you might find the from updater module useful if you are trying to get some of your older 4.6 modules converted and working.
Jason, thanks for the tip about the updater module, I’ll check it out.
4.7 is just SOOOO much nicer to work in than 4.6, and nicer for the users too. I cringe when hopping into 4.6 on a production site. So much so that I’m going to be using 4.7B3 to release a production version of a client’s website. No problems so far (damn you, Murphy!
)
Political Mud Slinging
Seems like the upcoming election is getting dirty with both the Liberals and the Conservatives slinging mud all over the place. Advertisements against both Steven Harper and Paul Martin have been spotted on the tube. I am an unabashed liberal, which is k
I am also tring to get organic groups working on 4.7. The forums are a must for what I am tring to accomplish is there anyone out there who can give assistance?
CorpX – I think if a Role has been granted “Administer Nodes” permissions, that may override OG. Also, be sure to check out the Simple Access module if you’re looking to allow multiple users to edit the same content without granting them Administer Nodes privs.
I too am tring to use organic groups. The issue that I am having is that even when I set post visibilty to Private (only seen by members of target group) all post for all groups and the content of the groups homepage is public. Where do I change this setting? Have any of you had any luck with this?
THanks in advance.