Wrong parameters for ProcessWire\WireDatabaseQueryException

[Jon]

Hello All,

I have started getting the following error when trying to add a image to a image field. This seems to just be effecting the field on 1 template any ideas and works on others? 

Error

Wrong parameters for ProcessWire\WireDatabaseQueryException([string $message [, long $code [, Throwable $previous = NULL]]])

 

File: .../public_html/wire/core/FieldtypeMulti.php:345

335:                
336:                if($exception) break;
337:    
338:                $sort++;
339:            }
340:        
341:            if($exception) {
342:                /** @var \PDOException $exception */
343:                if($useTransaction) $database->rollBack();
344:                if($config->allowExceptions) throw $exception; // throw original
345:                throw new WireDatabaseQueryException($exception->getMessage(), $exception->getCode(), $exception); 
346:            } else {
347:                if($useTransaction) $database->commit();
348:            }

Also had SQLSTATE[HY000}: General error: 1364 Field 'tag' doesn't have a default value

[elabx]

This just happened to me a few days ago when I disabled the tags on the image field (I think there is a Use Tags? checkbox). Adding it back fixed although I haven't had time to  figure out what's going on. 

[Jon]

Thanks Elabx, I tried this but still having the same issue. " SQLSTATE[HY000]: General error: 1364 Field 'tag' doesn't have a default value"

 

[Jon]

Manged to resolve this by deleting the tag field within the database, May have been something to do with a "Image Extra" field.  

[Pete]

@ryan I can confirm this on latest PW dev - having "tags" on an images field with extra custom fields, then removing tags from that field, then trying to upload images shows this error.

For now I just re-enabled tags on that field.

[Pete]

Haha just got caught out by it again 3 months later and end up here only to find my own comment on it ?