Closed (fixed)
Project:
Webform
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
22 Feb 2008 at 20:25 UTC
Updated:
2 Apr 2008 at 07:22 UTC
Jump to comment: Most recent file
It could have something to do with a packet being sent that was bigger than the default settings so it created that error. I believe there is a way to cancel the message from appearing but I am not totally sure how to do that. Thank you!
| Comment | File | Size | Author |
|---|---|---|---|
| #8 | webform-5.x-1.2.tar_.gz | 61.97 KB | Dynamic Ecology |
Comments
Comment #1
keith.smith commentedWhat was the error message you received?
Comment #2
Dynamic Ecology commenteduser warning: Unknown column 'w.uid' in 'on clause' query: SELECT DISTINCT(n.nid), n.title, n.type, w.sid FROM og_uid o INNER JOIN node n ON o.nid = n.nid LEFT JOIN webform_submissions w ON w.uid = o.uid AND w.nid = o.nid WHERE n.type = "webform" AND o.uid = 1 AND w.sid IS NULL in /home/content/g/a/b/gabealejandro/html/drupal/includes/database.mysql.inc on line 172.
THIS IS THE ERROR MESSAGE
Comment #3
Dynamic Ecology commentedI am not sure which module it corresponds to if it is one particular module.
Comment #4
Dynamic Ecology commentedmaybe the webform module but I removed it and the error message was still there.
Comment #5
keith.smith commentedI would start at the Webform module, though, since this seems to be an issue with a webform table.
Comment #6
Dynamic Ecology commentedok thanks, I will look more into that. I really appreciate the attention and support. I will let you know what comes of it soon. Thanks again
Comment #7
quicksketchHey there Dynamic Ecology, I'm the maintainer of webform. Could you provide me with some information about which version of webform you're using and when the problem occurred? Instructions to reproduce the problem from a stock Drupal install are always most helpful, so far the problem description has been a little vague.
At first glance it does look like webform is causing the SQL error, but the
og_uid oportion of the query leads me to suspect Organic Groups module also. Without knowing what or how to cause the error, it's hard to say at this point.I renamed the issue to reflect the problem.
Comment #8
Dynamic Ecology commentedawsome, Thanks so much for the message. I will attach the version of the webform module I was using. The file name is webform-5.x-1.2.tar.gz.
Comment #9
Dynamic Ecology commentedwhat was the issue renamed to? thanks again
Comment #10
Dynamic Ecology commentedHey it was fixed some what! I disabled all the og modules and the webform was erased and now there is no more error message! I am going to enable og modules and see if there is a way to use them still. Any ideas? Thank so much again!
Comment #11
quicksketchUsing the issue queue is different than the forms or leaving a normal comment. You had named the entire issue "If someone could help that would be so nice and helpful! Any clues or ideas are greatly appreciated.". Rather than requesting help, the issue title should reflect the problem, so I changed it to "SQL Error on submissions table" (which I just did again). If you change the title in your comment, you change the title of the entire node.
Also "Assigned" is the person volunteering to fix the problem (if any), so usually the person reporting the problem isn't actually the one that solves it (unless they're submitting a patch). Hope this is all clear.
Good to hear that it's working better! We may have found a conflict with OG and webform, please keep testing and see what you uncover.
Comment #12
quicksketchClosing after 2 weeks with no activity. I don't think it's a webform specific problem as I'm using webform with OG on a few of our sites. Please reopen if the problem reoccurs.