Jump to:
| Project: | Image |
| Version: | 5.x-2.x-dev |
| Component: | image.module |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
user warning: Unknown column 'image.nid' in 'field list' query: SELECT DISTINCT(node.nid), rand() AS random_sort, node.title AS node_title, node.changed AS node_changed, image.nid AS image_nid FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid INNER JOIN users users ON node.uid = users.uid WHERE (node.status = '1') AND (term_node.tid IN ('10','8','9','5','7','6','40')) AND (users.uid IN ('1')) GROUP BY node.nid, random_sort ORDER BY random_sort ASC LIMIT 0, 9 in /home/isujiasi/public_html/includes/database.mysql.inc on line 172.
This is the error message and I can't get rid of it. Can anybody help me? Oh, by the way ... I got some error on latest update (5200 and 5201) but I lost the exact error string. And now ... I'm getting this ... error.
Comments
#1
# warning: Division by zero in /home/isujiasi/public_html/includes/image.inc on line 125.# warning: imagecreatetruecolor() [function.imagecreatetruecolor]: Invalid image dimensions in /home/isujiasi/public_html/includes/image.inc on line 238.
# warning: imagecopyresampled(): supplied argument is not a valid Image resource in /home/isujiasi/public_html/includes/image.inc on line 264.
# warning: imagejpeg(): supplied argument is not a valid Image resource in /home/isujiasi/public_html/includes/image.inc on line 339.
# warning: imagedestroy(): supplied argument is not a valid Image resource in /home/isujiasi/public_html/includes/image.inc on line 267.
# Unable to create scaled Original image
It seems it' from /includes/image.inc ... or not???
#2
<?php$aspect = $info['height'] / $info['width'];
if ($aspect < $height / $width) {
$width = (int)min($width, $info['width']);
$height = (int)round($width * $aspect);
}
else {
$height = (int)min($height, $info['height']);
$width = (int)round($height / $aspect);
}
?>
This means that $width it's zero and all photos are gone from db ... because they're still on disk.
#3
Some more explanations please?
I have the same problem as this one:
"After upgrade I'm getting some warning only on first page" excpet that I get it on my image nodes and views too.
I've tried to downgrade to 1.7. The message still shows up.
EDIT: Got my (specific) answer here: #208776: Upgrade to 5.x-2.xdev breaks image view
#4