Group Admin Error - After updating to 6.17, member list gives :user warning: Table 'cyberfan.content_type_0' doesn't exist query

Same problem with 6.16.

content_type_0' doesn't exist query: SHOW COLUMNS FROM content_type_0 LIKE '' in /var/www/html/drupal-6.16/includes/database.mysql.inc on line 349. I think this is Group Admin module.

subscribe

Problem in 2 places:

- $table = 'content_type_' . $type;
-

+  $table = 'content_type_' . $type;
+  if( !(is_string($type) && ($type!='0')) )  return;

-  $table = 'content_type_' . $type;
-  if ( db_table_exists($table) {

+  $table = 'content_type_' . $type;
+  if ( ( is_string($type) && ($type!='0') ) && db_table_exists($table)) {

sorry second part not right:

  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);
      }
    }
  }

This is (I think!) fixed in 2.2 beta1.

No, it is not fixed. I just installed the 2.2beta1 and the list-view gives me:

    * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS realname FROM content_type_profil JOIN node n USING (vid) WHERE n.type = "pro' at line 1 query: SELECT COUNT(*) FROM users u JOIN (SELECT uid, is_active, is_admin FROM og_uid WHERE nid=138 AND is_active != 0) g ON u.uid = g.uid LEFT JOIN (SELECT uid, AS realname FROM content_type_profil JOIN node n USING (vid) WHERE n.type = "profil") r ON u.uid = r.uid WHERE u.uid in /www/htdocs/.../sites/all/modules/groupadmin/groupadmin.module on line 119.
    * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS realname FROM content_type_profil JOIN node n USING (vid) WHERE n.type = "pro' at line 1 query: SELECT realname, u.name, u.uid, u.mail, g.is_active, g.is_admin FROM users u JOIN (SELECT uid, is_active, is_admin FROM og_uid WHERE nid=138 AND is_active != 0) g ON u.uid = g.uid LEFT JOIN (SELECT uid, AS realname FROM content_type_profil JOIN node n USING (vid) WHERE n.type = "profil") r ON u.uid = r.uid WHERE u.uid ORDER BY realname ASC LIMIT 0, 10 in /www/htdocs/.../sites/all/modules/groupadmin/groupadmin.module on line 119.

Ok, so bug in the Group Admin CP sub-module it seems. Can anyone confirm that SangersDrupalDude's proposed fix in #3 above fix works? (the code looks sane to me.)