Drupal 4.7.0 Beta 3

January 11, 2006 · 16 comments

in Uncategorized

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 }

1 Chris Garrett January 12, 2006 at 3:59 am

“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?

Reply

2 D'Arcy January 11, 2006 at 4:57 pm

Cole, are you using Organic Groups?

Reply

3 Cole January 11, 2006 at 3:44 pm

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.

Reply

4 D'Arcy January 12, 2006 at 7:12 am

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…

Reply

5 Chris Garrett January 12, 2006 at 7:42 am

Just trying to help! I would email the developer rather than try to reverse engineer, unless you already tried.

Reply

6 D'Arcy January 12, 2006 at 7:50 am

Yeah, and thanks, Chris. Sorry for the early morning snarkiness.

I’ll be checking out the project site, and contacting the developer.

Reply

7 D'Arcy January 12, 2006 at 8:18 am

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!

Reply

8 Alan January 12, 2006 at 3:04 pm

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.

Reply

9 D'Arcy January 12, 2006 at 3:23 pm

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.

Reply

10 D'Arcy January 12, 2006 at 3:39 pm

Oh, and Alan – of course you’re more than welcome to tap any of my “expertise” any time!

Reply

11 Jason January 13, 2006 at 11:50 am

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.

Reply

12 D'Arcy January 13, 2006 at 12:10 pm

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! :-) )

Reply

13 SMALLTALK January 16, 2006 at 8:45 pm

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

Reply

14 New to Drupal February 10, 2006 at 5:10 am

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?

Reply

15 D'Arcy March 3, 2006 at 7:40 am

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.

Reply

16 CorpX March 3, 2006 at 12:58 am

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.

Reply

Leave a Comment

Previous post:

Next post: