Unable to manage relationships
christefano - July 23, 2008 - 02:15
| Project: | COPPA |
| Version: | 5.x-1.1 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
Great module, thank you!
Visiting the Managing Relationships page produced the error. I'm investigating this and will report back in a bit.
user warning: Unknown column 'c.cid' in 'on clause' query: SELECT cu.uid as cid, cu.name as cname, pu.uid as pid, pu.name as pname, pv.value as dob, c.status FROM users cu, coppa c, users pu LEFT JOIN profile_values pv ON pv.uid = c.cid LEFT JOIN profile_fields pf ON pv.fid = pf.fid WHERE cu.uid = c.cid AND pu.uid = c.pid in /var/www/includes/database.mysql.inc on line 172.
#1
can you report back what version of MySQL you have?
#2
christefano,
Do you have table prefixes? I was missing some curly braces around the table names for that query. Try the 1.1 release and let me know if the issue is resolve.
#3
Thanks for working through these bugs and putting out the 1.1 release!
Updating to 5.x-1.1 didn't fix it. I have MySQL 5.0.32 and this particular site isn't using any table prefixing.
#4
Got it, its due to changes in the join processing. Looking into a solution, should just need some well placed parentheses on that query.
http://dev.mysql.com/doc/refman/5.0/en/join.html
Join Processing Changes in MySQL 5.0.12
Looks like I'm overdue for an update on my dev box :-/
#5
was able to reproduce on MySQL 5.0.45.
I have created a development branch release as I realized there are a couple outstanding issues that should get into the next release.
#6
Automatically closed -- issue fixed for two weeks with no activity.