Do not see exisitng webforms under /admin/content/webform/mysql (Webform 3.x)

Highrockmedia, did you ever find a solution? I appear to be having a similar issue. I have reviewed the documentation as well as watched a screencast by NodeOne, but I still can't seem to get any webforms to display at /admin/content/webform/mysql

Highrock, thanks for the response! It's too bad to hear that you didn't get it resolved. This feature, or at least something close to it, is a definite need for a site that I am currently developing. If I can make any progress with the matter, I will post my findings.

Hi have the same issue, drupal 6.2 and webform 3.6, i'm creating a new tab in results page with a filter by user name and date submission. When finish i put link here.

I wonder if this has to do with the array of databases. I had to add a patch to all my installs and have the same exact issue.

Actually I found that if you have multiple document types enabled this will not work. If you only have webforms enabled it seems to work just fine. The issue was on line 191 of webform_mysql_views.module. When it creates the query it is escaping the list with \',\.

Hope someone can fix the line as I am not sure how to.

Thanks for digging into this sandy.girl - I'll try and take a look soon.

I dropped this code in at that location to make a temporary fix for my testing site... I don't pretend this is the best way to do it, but at least I can experiment with webforms_mysql_views until a proper fix is out. (I was a little worried about a sql injection using a user named content type...)

//Get list of all webform nodes
// $query = db_rewrite_sql("SELECT nid, title FROM {node} n WHERE type IN ('%s') AND status = 1 ORDER BY nid");
// $result = db_query($query, "'".implode("','", $types)."'");
$query = "SELECT nid, title FROM {node} n WHERE type IN (";
$tt="";
foreach ($types as $t) {
if ($tt!="") {
$tt.=",";
}
$tt.="'".($t)."'";
}
$query.=$tt.") AND status = 1 ORDER BY nid";
$query=db_rewrite_sql($query);
$result = db_query($query);

The fix in #10 worked for me as well, thank you kifwebe.

The attached patch properly creates placeholders for the query, which allows it to safely use multiple webform node types.

Additionally, this patch removes the requirement for webforms to be published before they're listed and it also shows the node nid and node type in the listing.

Thanks Cafuego!

Patch works great for me. Thanks for fixing this!

Now I just need to figure out how to get the module to use something other than the node title to create the MySQL View Name.

Steve

Is there any progress on this issue. Wouldn't it be possible to wrap up some of the available patches in a dev release? This would make my life and that of a few others a lot easier. I changed the issue status to critical, because it really is. Without this issue solved this module is unusable.

Well, attached patch works for me, so without any additonal info about why it might not work for others, there's a not a lot I can do :-/

Well, i couldn't apply the patch using my favourite IDE: Netbeans. It complained about some wrong context. So i then applied the patch by hand and guess what... it worked! Would be nice however if this patch got applied to the downloadable version of this module.

So considering it works for gvdenis and there's no information about how it does NOT work for highrockmedia, I'm setting this back to 'needs review'.

#10 worked, thanks!

looking for safer a permanent solution, suggestions welcome

Apply the patch and test it, so we can ask the module maintainer to apply it.

Patch at #12 applied and tested- works fine.

Patch at #12 works great - and is safe.

Re: At #20 "looking for safer a permanent solution, suggestions welcome"
The patch at #12 is a safe solution, as opposed to the code chunk at #10, which is not safe. If your comment referred to #10, please take a look at the patch in #12. If your comment was in regards to the patch at #12, what is the safety concern you see in that code?

Patch from comment #20 ported to the latest git version and applied to 6.x-1.x-dev.