Not sure if the title of this post makes sense, but as a manager, when you go to the decisions tab (www.yoursite.com/?q=conference/manage/decision) , the name of the reviewer in the table is duplicated the second time to assign it to him and triplicated the third time it is assigned to him, 4 times on the fourth assignment and the number of times the name of the reviewer appears goes on increasing accordingly.

Please see the attached images from the demo side and mysite for clarification

How can I rectify this? Grateful for any help

CommentFileSizeAuthor
conferencemysite.JPG36.43 KBlovedrupal6
conference.JPG26.4 KBlovedrupal6

Comments

lovedrupal6’s picture

lovedrupal6 commented

no updates yet?

drupalicasso’s picture

drupalicasso commented

I am having the exact problem, dont know what the solution is

finex’s picture

finex commented

I've the same problem using drupal 6.15 and conference 6.x-1.2-beta2

finex’s picture

finex commented

This simple patch fixes the bug:

--- conference.module   2009-06-11 09:50:14.000000000 +0200
+++ conference.module.new       2010-01-03 15:40:18.000000000 +0100
@@ -1157,6 +1157,7 @@ function conference_manage_decision() {
     $review_users = db_query ($sql);

     $r_user = NULL;
+    $r_users = NULL;
     while ($review_user = db_fetch_object($review_users)) {
       $r_user = user_load(array( 'uid' => $review_user->ruid ));
       $r_users .= l( $r_user->name, 'user/'. $r_user->uid)."<br />";
finex’s picture

finex commented
Status: Active » Needs review
lovedrupal6’s picture

lovedrupal6 commented

Thanks, It fixed the above issue.

But when a reviewer writes a review and clicks save, the following error is being displayed:
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 'r , drup_ users_roles ur , drup_ users u where r.rid = ur.rid and ur.uid = u.u' at line 1 query: SELECT u.uid FROM drup_ role r , drup_ users_roles ur , drup_ users u where r.rid = ur.rid and ur.uid = u.uid and r.rid = "5" in /public_html/yoursite/sites/all/modules/conference/conference.module on line 2068.

Thanks for your help

finex’s picture

finex commented

#6 : I think that is a different bug.

lovedrupal6’s picture

lovedrupal6 commented

It came up after
$r_users = NULL;
was added

finex’s picture

finex commented

Dunno... :-(

lovedrupal6’s picture

lovedrupal6 commented
Status: Needs review » Needs work
azemel’s picture

azemel commented
Priority: Critical » Normal
Status: Needs work » Fixed

Hi
The bug of post #6 is like this
"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 'r , drup_ users_roles ur , drup_ users u where r.rid = ur.rid and ur.uid = u.u' at line 1 query: SELECT u.uid FROM drup_ role r , drup_ users_roles ur , drup_ users u where r.rid = ur.rid and ur.uid = u.uid and r.rid = "5" in /public_html/yoursite/sites/all/modules/conference/conference.module on line 2068."

The solution is

1. go to your public_html/yoursite/sites/all/modules/conference
2. Find the line (2068)
$muid = db_result(db_query('SELECT u.uid FROM { role } r , { users_roles } ur , { users } u WHERE r.rid = ur.rid and ur.uid = u.uid and r.rid = "%s"', variable_get('conference_role_management', '')));
3. Replace it by the line
$muid = db_result(db_query('SELECT u.uid FROM {role} r , {users_roles} ur , {users} u WHERE r.rid = ur.rid and ur.uid = u.uid and r.rid = "%s"', variable_get('conference_role_management', '')));

Hope this will help.
P.S. In my case this solve the warming and the message to the conference manager role was sent

Status: Fixed » Closed (fixed)

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