Jump to:
| Project: | imgupload |
| Version: | 6.x-1.9 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
Below error message.
Another thing is after enabling the module with image module I received "acess denied" page although I'm the admin. It was strange. After clicked Image Taxonomy there is an error:
* 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 '= and i.nid=t.nid and i.fid=f.fid and i.image_size='thumbnail'' at line 1 query: SELECT f.filepath,i.nid FROM files f,term_node t,image i WHERE t.tid= and i.nid=t.nid and i.fid=f.fid and i.image_size='thumbnail' in /Users/konrad/Sites/drupal/modules/imgupload/imgupload/imgupload/imgtax.module on line 672.
* 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 '= and i.nid=t.nid and i.fid=f.fid and i.image_size='thumbnail'' at line 1 query: SELECT f.filepath,i.nid FROM files f,term_node t,image i WHERE t.tid= and i.nid=t.nid and i.fid=f.fid and i.image_size='thumbnail' in /Users/konrad/Sites/drupal/modules/imgupload/imgupload/imgupload/imgtax.module on line 672.
Comments
#1
I guess 'thumbnail''
is wrong there is ' on first place and " on last place in the string.
#2
But I need help - don't know where to find $tid variable from line 671 from imgtax.module ?
#3
Still need a help with that sql statement in imgtax.module...
#4
Still don't now what to do...
error message in drupal:
* 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 '= and i.nid=t.nid and i.fid=f.fid and i.image_size='thumbnail'' at line 1 query: SELECT f.filepath,i.nid FROM files f,term_node t,image i WHERE t.tid= and i.nid=t.nid and i.fid=f.fid and i.image_size='thumbnail' in /Users/konrad/Sites/drupal/modules/imgupload/imgupload/imgupload/imgtax.module on line 672.
* 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 '= and i.nid=t.nid and i.fid=f.fid and i.image_size='thumbnail'' at line 1 query: SELECT f.filepath,i.nid FROM files f,term_node t,image i WHERE t.tid= and i.nid=t.nid and i.fid=f.fid and i.image_size='thumbnail' in /Users/konrad/Sites/drupal/modules/imgupload/imgupload/imgupload/imgtax.module on line 672.
and the file in line 672:
"SELECT f.filepath,i.nid FROM {files} f,{term_node} t,{image} i WHERE t.tid=".$tid." and i.nid=t.nid and i.fid=f.fid and i.image_size='thumbnail'";
anyone knows whats wrong?
I've updated database like used to do after installation...
#5
ok - the error is out when created any gallery.
However the applet in Java is working unstable...