bio_for_user() not working [#288624]

for some reason, in my installation the following line doesn't return a value even though the current logged-in user has a bio:

SELECT nid FROM {bio} WHERE uid = %d

I'm guessing this might be the result of a larger problem, however I have fixed this problem with the attached patch that changes the above line to look through the node table instead.

Comment	File	Size	Author
	bio_for_user_fix.patch	663 bytes	jjeff

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

dww

we/he/they

CreditAttribution: dww commented 31 July 2008 at 05:44

Is this an installation that predates bio_update_5100()?

Comment #2

kulfi CreditAttribution: kulfi commented 4 August 2008 at 06:47

Need help figuring out why the following snippet in my Workflow NG Login Redirect results in errors:

Condition:

$nid = bio_for_user($account->uid);
$node = node_load($nid);

if (!$node->field_bio_name || sizeof($node->field_bio_name) == 0) {
  return FALSE;
} else {
  return TRUE;
}

Error:

warning: Invalid argument supplied for foreach() in modules/node/node.module on line 521. 
warning: implode() [function.implode]: Bad arguments. in modules/node/node.module on line 525. 
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 '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in includes/database.mysql.inc on line 172.