I keep getting the following error when saving a content type with slideshow enabled (whether there is a slideshow on that node or not)

user warning: Unknown column 'nid' in 'where clause' query: SELECT fid, filename, filemime FROM files WHERE nid = 119 in /home/mysite/public_html/sites/all/modules/slideshow/slideshow.module on line 317.

Comments

efaerber’s picture

efaerber commented

I fixed it by changing this line 317 in slideshow.module:

$result = db_query("SELECT fid, filename, filemime FROM {files} WHERE nid = %d", $node->nid);

to

$result = db_query("SELECT f.fid, f.filename, f.filemime FROM {files} f, {upload} u WHERE u.nid = %d AND u.fid = f.fid", $node->nid);

greta_drupal’s picture

greta_drupal commented

Much appreciated. I was encountering the same problem. This seemed to work for me. Could the developer/maintainer please respond about this hack and whether it will be included in next release?