Just in case this post appears twice, please accept my apologies, I submitted it but could not find where it had gone.

Hello,
I just uploaded the latest version of og (1.5.2) and now get this error report.

user error: Table 'DBNAME.drp_og_uid' doesn't exist
query: SELECT na.*, n.title, ou.mail_type FROM drp_node_access na INNER JOIN drp_node n ON na.nid = n.nid LEFT JOIN drp_og_uid ou ON n.nid=ou.nid WHERE gid = 1 AND realm = 'og_uid' AND grant_view = 1 in HOSTPATH/includes/database.mysql.inc on line 125.

Should I simply create a new table "og_uid" ?

I had previously been using the patch supplied by wernerbraun on February 24, 2005 - 13:01 here
Is this feature now included in the latest version (i.e. to determine whether group members are allowed to post to public or only to their own group)?

thank you

Comments

junyor’s picture

junyor commented

Duplicate of #20418.

omar’s picture

omar commented

I got this error as well... after all it was probably due to an error in the og.mysql file. There is an extra comma that results in the second table not being created. 

CREATE TABLE `og` (
  `nid` int(11) NOT NULL,
  `selective` int(11) NOT NULL default '0',
  `description` varchar(255) NULL,
  `image` varchar(255) NULL, 
  `theme` varchar(255) NULL, 
  PRIMARY KEY  (`nid`)
) TYPE=MyISAM; 

CREATE TABLE `og_uid` (
  `nid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `mail_type` int(11) NULL,, 
  PRIMARY KEY  (`nid`, uid)
) TYPE=MyISAM;

It should be:

CREATE TABLE `og` (
  `nid` int(11) NOT NULL,
  `selective` int(11) NOT NULL default '0',
  `description` varchar(255) NULL,
  `image` varchar(255) NULL, 
  `theme` varchar(255) NULL, 
  PRIMARY KEY  (`nid`)
) TYPE=MyISAM; 

CREATE TABLE `og_uid` (
  `nid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `mail_type` int(11) NULL,
  PRIMARY KEY  (`nid`, uid)
) TYPE=MyISAM;
moshe weitzman’s picture

moshe weitzman commented
Anonymous’s picture

(not verified) commented