Hello
Thanks for your maintenance effort for this nice module.

By the way, I'm experiencing the warning messages as below when I tried submitting a bio entry whose tab is included in the user profile page as a super admin.

# warning: Invalid argument supplied for foreach() in /virtual/***/public_html/modules/node/node.module on line 521.
# warning: implode() [function.implode]: Invalid arguments passed in /virtual/***/public_html/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 /virtual/***/public_html/includes/database.mysql.inc on line 172.

I would like to understand what these warning messages stand for. Sorry, I cannot get it myself because I'm not a programmer.
It would be very much appreciated if you should teach me the meaning.

The situation could be described in other words ;
1. There is a user account already created.
2. "Content type for user biographies" is set as "Company information" premade with CCK
3. The bio is set as below;
> Use bio for user profiles
> Takeover profile
> Show fields on registration form:enable
3. As user/1, I tried submitting whitout inputting any field items (as experiment).

Thanks in advance.

Comments

STyL3’s picture

STyL3 commented

I have this exact error...however, I am not using the bio module. I receive the error when trying to delete an uploaded file. Anyone know what is causing this?

john bickar’s picture

john bickar commented

I also get this error, using the Conference Organizing Install Profile.

Here's the surrounding error codes from the devel module:

0.42	5	user_load	SELECT * FROM users u WHERE uid = 12
0.26	5	user_load	SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 12
0.28	5	profile_load_profile	SELECT f.name, f.type, v.value FROM profile_fields f INNER JOIN profile_values v ON f.fid = v.fid WHERE uid = 12
0.25	8	bio_for_user	SELECT nid FROM bio WHERE uid = 12
0.27	5	og_user	SELECT og_email FROM og_uid_global WHERE uid = 12
0.24	8	bio_for_user	SELECT nid FROM bio WHERE uid = 12
1.68	1	watchdog	INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (12, 'php', '<em>Invalid argument supplied for foreach()</em> in <em>/afs/ir.stanford.edu/group/conf/cgi-bin/drupal/modules/node/node.module</em> on line <em>521</em>.', 2, '', 'http://stanford.edu/group/conf/cgi-bin/drupal/user/12/bio', '', '171.64.132.96', 1202949076)
1.42	1	watchdog	INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (12, 'php', '<em>implode() [&lt;a href=&#039;function.implode&#039;&gt;function.implode&lt;/a&gt;]: Bad arguments.</em> in <em>/afs/ir.stanford.edu/group/conf/cgi-bin/drupal/modules/node/node.module</em> on line <em>525</em>.', 2, '', 'http://stanford.edu/group/conf/cgi-bin/drupal/user/12/bio', '', '171.64.132.96', 1202949076)
0.32	1	node_load	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
1.45	1	watchdog	INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (12, 'php', '<em>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 &amp;#039;&amp;#039; at line 1\nquery: node_load\nSELECT 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 </em> in <em>/afs/ir.stanford.edu/group/conf/cgi-bin/drupal/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://stanford.edu/group/conf/cgi-bin/drupal/user/12/bio', '', '171.64.132.96', 1202949076)
0.44	1	drupal_lookup_path	SELECT dst FROM url_alias WHERE src = 'user/12'
0.45	1	drupal_lookup_path	SELECT dst FROM url_alias WHERE src = 'user/12/view'
0.31	1	drupal_lookup_path	SELECT dst FROM url_alias WHERE src = 'user/12/edit'
0.29	1	drupal_lookup_path	SELECT dst FROM url_alias WHERE src = 'user/12/bio'
0.36	1	drupal_lookup_path	SELECT dst FROM url_alias WHERE src = 'user/12/load'
STyL3’s picture

STyL3 commented

Just thought I'd share on how I fixed my issue. It seems it was related to the "filefield" module, at least in my case.

http://drupal.org/node/181346

Not sure about cubbtech's error.