SQL Error in Manage My Groups
jacobson - October 11, 2007 - 21:13
| Project: | OG Subscriber Management |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | dwees |
| Status: | closed |
Jump to:
Description
I get the following error when I click on Manage My Groups:
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 ') AND o.uid = 1 ORDER BY o.nid ASC' at line 1 query: SELECT o.is_active, o.is_admin, o.nid FROM og_uid o WHERE o.nid IN () AND o.uid = 1 ORDER BY o.nid ASC in /home/jacobson/public_html/matt/includes/database.mysql.inc on line 172.
#1
Do you have any Organic groups on your site yet?
I'll fix it so my form doesn't throw an error when a site has no Organic groups yet.
Dave
#2
This is not a duplicate error my bad. This error would show up either if a user had no groups that they were able to join (because no groups have either Open or Invite status) or there are no groups yet created for a site. The most recent version in cvs (wait for the packaging scripts to tar it for download) fixes this error.
Dave
#3
I do not have any groups with open joining capability, so that must have been the problem.
#4
The bug is fixed in the latest CVS version. Thanks.
#5