When trying to view an already submitted webform by clicking on the following:

"You have already submitted this form. View your previous submissions:"

the following warning appears when the user requests to view formally submitted webform:

----
* user warning: Column 'uid' in where clause is ambiguous query: SELECT COUNT(*) FROM webform_submissions s LEFT JOIN users u ON u.uid = s.uid WHERE nid = 8 AND uid = 1 in /usr/share/drupal/modules/webform-DRUPAL-6--3/includes/webform.submissions.inc on line 297.
* user warning: Column 'uid' in where clause is ambiguous query: SELECT sid FROM webform_submissions s LEFT JOIN users u ON u.uid = s.uid WHERE nid = 8 AND uid = 1 ORDER BY sid ASC LIMIT 0, 50 in /usr/share/drupal/modules/webform-DRUPAL-6--3/includes/webform.submissions.inc on line 297.
----

Even though the webform was submitted, the webform results are not viewable. Below the warning (cited above), the following appears. Still, the user will receive the above warning again when clicking on "View this form"

----
Showing all results.
#sort icon Submitted User IP Address Operations
There are no submissions for this form. View this form.

* Go back to the form
----

BTW, the 'admin' does not have this warning.

CommentFileSizeAuthor
#2 webform_submissions_uid_filter.patch741 bytesquicksketch

Comments

quicksketch’s picture

Status: Active » Closed (duplicate)
quicksketch’s picture

Version: 6.x-3.x-dev » 6.x-3.0
Status: Closed (duplicate) » Fixed
StatusFileSize
new741 bytes

Oop, or not. I found this error again. It's cause when viewing an individual user's submissions (even user #1), rather than viewing all submissions. This patch should correct the problem.

bradfuller’s picture

Seems to work! Thanks!

Status: Fixed » Closed (fixed)

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