Posted by AntiNSA on June 3, 2010 at 5:30pm
5 followers
| Project: | Group Admin |
| Version: | 6.x-2.1 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
user warning: Table 'cyberfan.content_type_0' doesn't exist query: SHOW COLUMNS FROM content_type_0 LIKE '0' in /home/cyberfan/htdocs/includes/database.mysql.inc on line 349.
Im scared... any ideas? I cant see the list with member pictures... Thanks for any help! I can see the list of users with email..... The "List" tab is missing... now only the MEMBER tags is available
Comments
#1
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.
#2
subscribe
#3
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)) {
#4
#5
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);
}
}
}
#6
This is (I think!) fixed in 2.2 beta1.
#7
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.
#8
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.)