Here are the steps:
rm -r og
tar -xvvzf og-6.x-2.0-rc2.tar.gz
update.php
og_notifications module:6001
og_access module: 6201
og module: 6203

    * user warning: Table 'og_access_post' already exists query: CREATE TABLE og_access_post ( `nid` INT NOT NULL, `og_public` TINYINT NOT NULL DEFAULT 1, PRIMARY KEY (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/greatbre/public_html/includes/database.inc on line 515.
    * user warning: Duplicate entry '37723' for key 1 query: INSERT INTO og_access_post (nid, og_public) SELECT DISTINCT(nid), (SELECT is_public FROM og_ancestry oga_sub WHERE oga_sub.nid = oga.nid LIMIT 1) FROM og_ancestry oga in /home/greatbre/public_html/sites/all/modules/og/modules/og_access/og_access.install on line 80.

og_access module
Update #6201

    * Failed: CREATE TABLE {og_access_post} ( `nid` INT NOT NULL, `og_public` TINYINT NOT NULL DEFAULT 1, PRIMARY KEY (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
    * Failed: INSERT INTO {og_access_post} (nid, og_public) SELECT DISTINCT(nid), (SELECT is_public FROM {og_ancestry} oga_sub WHERE oga_sub.nid = oga.nid LIMIT 1) FROM {og_ancestry} oga

Then goto front page
Fatal error: Call to undefined function dsm() in /public_html/sites/all/modules/og/modules/og_views/og_views.views.inc on line 539

Comments

moshe weitzman’s picture

moshe weitzman commented
Status: Active » Fixed

not sure why you had og_access_post table and drupal did not know it ... just fixed that fatal error. tagging new release.

mariagwyn’s picture

mariagwyn commented

I had same error, RC3 worked it.

skyredwang’s picture

skyredwang
Location Shanghai
commented
Version: 6.x-2.0-rc2 » 6.x-2.0-rc3
Status: Fixed » Active

Here are the steps:
rm -r og
tar -xvvzf og-6.x-2.0-rc3.tar.gz
update.php
og_notifications module:6001
og_access module: 6201
og module: 6203

    * user warning: Table 'og_access_post' already exists query: CREATE TABLE og_access_post ( `nid` INT NOT NULL, `og_puic` TINYINT NOT NULL DEFAULT 1, PRIMARY KEY (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/greatbre/public_html/includes/database.inc on line 515.
    * user warning: Duplicate entry '37723' for key 1 query: INSERT INTO og_access_post (nid, og_public) SELECT DISTINCT(nid), (SELECT is_public FROM og_ancestry oga_sub WHERE oga_sub.nid = oga.nid LIMIT 1) FROM og_ancestry oga in /home/greatbre/public_html/sites/all/modules/og/modules/og_access/og_access.install on line 80.

og_access module
Update #6201

    * Failed: CREATE TABLE {og_access_post} ( `nid` INT NOT NULL, `og_public` TINYINT NOT NULL DEFAULT 1, PRIMARY KEY (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
    * Failed: INSERT INTO {og_access_post} (nid, og_public) SELECT DISTINCT(nid), (SELECT is_public FROM {og_ancestry} oga_sub WHERE oga_sub.nid = oga.nid LIMIT 1) FROM {og_ancestry} oga

Looks like the same error?

skyredwang’s picture

skyredwang
Location Shanghai
commented

However, 

Fatal error: Call to undefined function dsm() in /public_html/sites/all/modules/og/modules/og_views/og_views.views.inc on line 539

is gone.

Do I need to worry about the og_access_post Table?

skyredwang’s picture

skyredwang
Location Shanghai
commented
Title: Upgrade path from 1.3 to 2.0-rc2 failed » Upgrade path from 1.3 to 2.0-rc3 failed

Before the upgrade, in my database og-1.3 does NOT have the table {og_access_post}
But after the upgrade, even though it said "failed", I have the {og_access_post} table.

Any suggestions?

moshe weitzman’s picture

moshe weitzman commented
Status: Active » Postponed (maintainer needs more info)

og.install's update 6203 does not even mention og_access_post table. not sure whats up here. Maybe you don't have latest code.

justinchev’s picture

justinchev commented

UPDATE - problem solved: I updated my OG version to og-6.x-2.0-rc3 ran update.php.
---------------------------------------------------------------------------------------

I'm not sure if this is relevant to your issue, but this is a problem I have been getting which involves 'og_access_post'.

I have a clean install with OG and OG-forum enabled. When a group has been created and a forum topic added I get the following error when in the Forum 'container' eg. General Discussion. If I create another forum topic within that 'container' the error appears twice.

user warning: Table 'mysite.og_access_post' doesn't exist query: SELECT oap.nid, COALESCE(oap.og_public, 1) AS is_public FROM og_access_post oap WHERE oap.nid = 3 in C:\xampp\htdocs\mysite\modules\og_forum\og_forum.module on line 495.

I have OG-6.x-1.3, with og_forum-6.x-2.0-rc1

skyredwang’s picture

skyredwang
Location Shanghai
commented
Status: Postponed (maintainer needs more info) » Active

Looks like the og_access_post is caused by "og_access module: 6201". From my #5 post-observation, it seems like the 6201 update was executed twice. Any thoughts?

moshe weitzman’s picture

moshe weitzman commented
Status: Active » Postponed (maintainer needs more info)
skyredwang’s picture

skyredwang
Location Shanghai
commented
Priority: Critical » Minor
Status: Postponed (maintainer needs more info) » Closed (won't fix)

I figured this out.
It's not OG's fault. I did "gunzip < Monday.sql.gz | mysql -u DATABASE -pPASSWORD USERNAME" to sync my Dev database with My production database. However, this mysql overwriting won't delete the tables that are not in the production site but in the dev site. Because I have tried OG 2.0 RCx before on the dev site, so the dev site has the og_access_post tables already.