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

roxtaz’s picture

roxtaz commented
Title: After upgrade I'm getting some warning only on first page » Update 
# 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???

roxtaz’s picture

roxtaz commented 
  $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.

doc2@drupalfr.org’s picture

doc2@drupalfr.org commented

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

drewish’s picture

drewish commented
Status: Active » Closed (fixed)