user warning: Table 'drupal.content_type_0' doesn't exist query

I'm experiencing the same error with the same setup; Drupal v6.16, OG 6.x-2.1, Group Admin 6.x-2.1, OG Block Visibility 6.x-1.2, OG Membership Expiration 6.x-1.0, and OG Menu 6.x-2.0. I created new content types for Group Node and Group Post.

It has something to do with the Content profile setting ("Settings for Content Profile integration.") under menu Administrator/Organic Groups/Group Admin configuration/Content profile. Changing the "Content Type" pick list to any content type listed, will change the [content type name] error to

"user warning: Table '[dbname].content_type_[content type name]' doesn't exist ..."

For me, the error occurs when viewing a group (menu home/Groups) and clicking on the "Members" link (node/grp#/groupadmin)

Thanks for the info. This sounds like an issue in the GroupAdmin CP add-on rather than in the main module. Anything unusual or non-default about your database configurations?

Having the same problem here...and fortunately it is working now. This is how I fixed it:

Problem approach :

1p.- I had the same kind of user warning message as Brian294.
2p.- The problem was related to a content type according to the SQL warning.
3p.- Just like BristolGuy, the message appeared to me on the Members Page Tab. Like BristolGuy showed it, setting any content type as a "profile" content type inside the Content Profile Config Settings is a partial sollution...because
3.1p: ...It appeared another warning telling me (us?) it has to be something with a field of the content type.

Solution .

1s. -Check that I have installed the content profile module. (1p)
2s.- Check that I have configured the content profile node type and check "Use this content type as a content profile for users". (2p)
3s.- Check that I have created at least one field, related to the username for the members. (3.0-3.1p)
4s.- Check that GroupAdmin Configuration, Content Profile Setting are pointing to the proper field created on the former step (3.1p).
4s.- Check that at least one user edits his/her account and updates the Content Profile Tab.

Done! Now the missing field related to the profile content type, used by the GroupAdmin exists.

Ideas to fix this in the future.

Content profile is not a core module, so instead GroupAdmin using the CP add on, use the Core profile module. That way there wont be warnings for fields. Or...

Instead of having just one extra submodule for Core Profile...take the code of Content Profile Settings from the parent GroupAdmin module out and make it availlable as another sub-module. That way users may choose from

Hope this text helps you guys, or at least provide extradetails for debugging!

Ok, I've tracked down what's happening. The cause is basically an invalid configuration - if you install the GroupAdmin CP module but don't properly configured the content type, you will get this warning message. So the solution is either (a) deactivate GroupAdmin CP or (b) configure the content type correctly with a CCK content-type, such as you would create for use with the Content Profile module.

So, I'm changing the category here from "bug" to "support request" :) But, I've now added a test (for the next release) that will show a message "GroupAdmin CP configuration is invalid" rather than allow this arguably less-than-helpful system error message to be displayed.

Just to be clear, you do not need to be using Content Profile in order to use GroupAdmin CP - that's why it's not shown as a module dependency. But, you do need to have a suitable content type and configure GroupAdmin CP accordingly. Put simply, you need CCK-based nodes where some field contains the user's (author's) real-name.

I have this one too. I still am stuck. I have created a new content type for a calendar using the import view and content type in this post: http://drupal.org/node/679808

I get the error:
user warning: Table 'content_type_0' doesn't exist query: SHOW COLUMNS FROM content_type_0 LIKE '0' in /includes/database.mysql.inc on line 349.

Is there anything in particular that you see wrong with the Event Content Type you see in there?

-Justin

needs a couple of fixes:

  $table = 'content_type_' . $type;
  if( !(is_string($type) && ($type!='0')) )  return;
  // Bail out if configuration is invalid.
  if (!db_column_exists($table, $realname))  return;


  $table = 'content_type_' . $type;
  if (is_string($type) && ($type!='0')) {
    if(db_table_exists($table)) {
      $query = sprintf('SHOW columns FROM %s LIKE "field\_%%_value"', $table);
      $result = db_query($query);
      while ($row = db_fetch_array($result)) {
        // Add to $cp_fields without 'field_' prefix and '_value' suffix.
        $cp_fields[$row['Field']] = substr(substr($row['Field'], 0, -6), 6);
      }
    }
  }

subscribe

#6 as patch, based on Version /Tag 6.x-2.1