Hi there

I've noticed a couple of errors in my logs which relate to imagefield when a user is creating a new node and uploading images to that node, I'm not sure exactly when it started but I've recently upgraded to drupal 5.9 and to Imagefield 2.1.

1. 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 'FROM content_ WHERE vid = 0 LIMIT 0, 1' at line 1 query: SELECT FROM content_ WHERE vid = 0 LIMIT 0, 1 in /www/thesite/www/includes/database.mysqli.inc on line 154.

2. The selected image handling toolkit imagemagick can not correctly process image_imagemagick_resize.

Below may also be useful. It's the same in each log entry :

Location http://www.thesite.com/imagefield/js
Referrer http://www.thesite.com/node/add/eptemp

Drupal 5.9
CCK 5.x-1.7
ImageAPI 5.x-1.2
ImageField 5.x-2.1
files/tmp dirs are owned by the apache daemon user and don't have a problem being used.

MySql 5.0.51b
Apache 2.2.9
PHP 5.2.6

Thanks

Comments

drewish’s picture

drewish commented
Category: bug » support
Status: Active » Postponed (maintainer needs more info)

the whole content_ and vid=0 bit in the sql make it sound like there's a problem that's occurring, no file is being loaded so imagemagick has nothing to work on...

paulnem’s picture

paulnem commented

I'm getting the second error quite often now, usually when new users are adding or updating their newly created nodes. I don't see subsequente updates to those nodes causing errors.

2. The selected image handling toolkit imagemagick can not correctly process image_imagemagick_resize.

I've tried creating a new user and uploading all sorts of different images, gif, jpg, bmp etc. I've also uploaded an image with no extension and it just doesn't upload. I can't recreate the error and the users aren't experiencing (as far as I know) any problems.

So I'm just curious what the problem is or why the error is appearing.

drewish’s picture

drewish commented
Status: Postponed (maintainer needs more info) » Closed (duplicate)

looks like a duplicate of #274205: Image upload error executing more than one