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.

Comments

jgraham’s picture

jgraham commented
Status: Active » Postponed (maintainer needs more info)

can you report back what version of MySQL you have?

jgraham’s picture

jgraham commented
Status: Postponed (maintainer needs more info) » Fixed

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.

christefano’s picture

christefano commented
Version: 5.x-1.0 » 5.x-1.1
Status: Fixed » Active

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.

jgraham’s picture

jgraham commented

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 :-/

jgraham’s picture

jgraham commented
Status: Active » Fixed

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.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.