I got this error when creating a new account on one of my installations:

	•	user warning: Unknown column 'b.nid' in 'on clause' query: SELECT b.uid FROM bloginfo b INNER JOIN node_access na ON na.nid = b.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 0 AND na.realm = 'og_all'))) AND b.uid = 0 in /home/fabmin/public_html/includes/database.mysql.inc on line 120.
	•	warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fabmin/public_html/modules/contrib/bloginfo/bloginfo.module on line 100.
	•	user warning: Duplicate entry '0' for key 1 query: INSERT INTO bloginfo (uid, title, description) VALUES (0, "", "") in /home/fabmin/public_html/includes/database.mysql.inc on line 120.

It appears to me that there's a conflict with bloginfo and og, but that's just a guess based on looking at the error.

I'm using 4.7.3 and bloginfo.module,v 1.1 2006/09/21 00:24:31.

CommentFileSizeAuthor
#2 bloginfo_og.patch1.33 KBmfer

Comments

mfer’s picture

mfer commented

huh, that explains some other errors. I'll dig into this in 2 weeks when I get back from my vacation. This is good to know now since I will be using OG with this in an upcoming install.

Thanks for the info.

- matt

mfer’s picture

mfer commented
StatusFileSize
new bloginfo_og.patch1.33 KB

This patch should fix it and the update is in the cvs version.

Christefano-oldaccount’s picture

Christefano-oldaccount commented

Thank you, it works!

Here's to another great vacation (I'm assuming you already had it, worked on the module, and came back in a time machine). Thanks again!

mfer’s picture

mfer commented
Assigned: Unassigned » mfer
Status: Active » Fixed

Patch worked. All fixed.

Anonymous’s picture

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