Drupal 4.7.0 Beta 3

Filed under: Uncategorized. Tags:

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.

Comments

16 Responses to “Drupal 4.7.0 Beta 3”

  1. Cole on January 11th, 2006 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.

  2. D'Arcy on January 11th, 2006 4:57 pm

    Cole, are you using Organic Groups?

  3. Chris Garrett on January 12th, 2006 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?

  4. D'Arcy on January 12th, 2006 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…

  5. Chris Garrett on January 12th, 2006 7:42 am

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

  6. D'Arcy on January 12th, 2006 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.

  7. D'Arcy on January 12th, 2006 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!

  8. Alan on January 12th, 2006 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.

  9. D'Arcy on January 12th, 2006 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.

  10. D'Arcy on January 12th, 2006 3:39 pm

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

  11. Jason on January 13th, 2006 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.

  12. D'Arcy on January 13th, 2006 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! :-) )

  13. SMALLTALK on January 16th, 2006 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

  14. New to Drupal on February 10th, 2006 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?

  15. CorpX on March 3rd, 2006 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.

  16. D'Arcy on March 3rd, 2006 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.

Creative Commons License
This work is licensed under a Creative Commons Attribution 2.5 Canada License.