search

craftsmancoding / assetmanager

Asset Manager for MODX Revolution
36 stars 15 forks source link

Database insert errors #16

Closed ghost closed 10 years ago

ghost commented 10 years ago

2014-07-18 19:45:23] (ERROR @ /manager/index.php) Error HY000 executing statement: INSERT INTO ass_assets (content_type_id, stub, width, height, size, duration, sig, is_image, is_active, is_protected) VALUES (9, '2014/07/18/gotland 1.jpg', 932, 617, 204657, 0, '95663f56e794f5ca582ee7d4b2f45723', 1, 1, 0) Array ( [0] => HY000 [1] => 1364 [2] => Field 'title' doesn't have a default value )

Also getting this error: [2014-07-18 19:47:36](ERROR @ /Users/williamastrom/Development/pixneyone.dev/public/core/components/assman/model/assman/asset.class.php : 651) PHP warning: Invalid argument supplied for foreach()

And then i also get this: [2014-07-18 19:53:39](ERROR in Asset @ /Users/williamastrom/Development/pixneyone.dev/public/core/components/assman/model/assman/asset.class.php : 458) Prefix (/Users/williamastrom/Development/pixneyone.dev/public/assets/lib/) not found in path ()

fireproofsocks commented 10 years ago

Steps to reproduce?

ghost commented 10 years ago

I get the first when dropped an image into place and press saved. There is still a red cross on the image and the insert error comes up in the error report.

The second one appears then too.

The third one comes up then too. That message is also shown in a red box where i add the image. ( above the area ).

See image: http://www.webpagescreenshot.info/img/53c9725473cab9-21272947

ghost commented 10 years ago

What is the title field? I cant really see where i should enter a title. And maybe it would be preferred to have it nullable?

alroniks commented 10 years ago

I have the same error.

alroniks commented 10 years ago

General problem - some field saved to database as empty, but in database field attribute "NULL" set up as NOT NULL, but default value not defined. Fields: title, alt, manual_url, thumbnail_manual_url, stub and seq. When I set default values for this fields, all works fine.

fireproofsocks commented 10 years ago

Is your code an new install from the latest release or an upgrade from 1.0?

alroniks commented 10 years ago

Asset Manager version 1.1.0, modx 2.3, new installation

fireproofsocks commented 10 years ago

Please report back if the problem persists in version 1.1.1