Add item error

ganker

Joined: 2004-07-27
Posts: 2

Posted: Fri, 2004-10-15 19:39

Fresh install from cvs, install claims to be succesful. DB Postgres 7, (all ?)tables created. Uploading items results in the following error given below. Any hints ?

Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 484 (gallerystatus::error)
in modules/core/classes/GalleryStorage.class at line 133 (postgresqldatabasestorage::saveentity)
in modules/core/classes/GalleryEntity.class at line 270 (gallerystorage::saveentity)
in modules/core/classes/GalleryDerivative.class at line 251 (gallerychildentity::save)
in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 543 (galleryderivativeimage::save)
in modules/core/classes/GalleryCoreApi.class at line 1307 (galleryitemhelper_medium::addexistingitemtoalbum)
in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 359 (gallerycoreapi::addexistingitemtoalbum)
in modules/core/classes/GalleryCoreApi.class at line 1293 (galleryitemhelper_medium::additemtoalbum)
in modules/core/ItemAddFromBrowser.inc at line 79 (gallerycoreapi::additemtoalbum)
in modules/core/ItemAdd.inc at line 77 (itemaddfrombrowser::handlerequest)
in main.php at line 161 (itemaddcontroller::handlerequest)
in main.php at line 47
in main.php at line 40

mindless

Joined: 2004-01-04
Posts: 8601

Posted: Fri, 2004-10-15 20:23

Enable buffered debug output in config.php and retry.. find the database error in the debug output and post it here.

bryans

Joined: 2004-10-16
Posts: 1

Posted: Sat, 2004-10-16 14:30

The problem is with the g_postfilteroperations column of the g2_derivative table. The insert is not providing a value for the column while the column has the attribute "not null". I worked around this by executing "alter table g2_derivative alter column g_postfilteroperations drop not null;"

mindless

Joined: 2004-01-04
Posts: 8601

Posted: Sat, 2004-10-16 14:52

could be, but I thought that problem was fixed in cvs.. ?

bharat

Joined: 2002-05-21
Posts: 7994

Posted: Sat, 2004-10-16 23:16

I did fix this a week ago. You can look at the GalleryDerivative.sql for Postgres -- it no longer has a "not null" designation for the g_postFilterOperations or the g_derivativeOperations columns. Can you verify that your version matches up?

ganker Joined: 2004-07-27 Posts: 2	Posted: Fri, 2004-10-15 19:39
	Fresh install from cvs, install claims to be succesful. DB Postgres 7, (all ?)tables created. Uploading items results in the following error given below. Any hints ? Error (ERROR_STORAGE_FAILURE) in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 484 (gallerystatus::error) in modules/core/classes/GalleryStorage.class at line 133 (postgresqldatabasestorage::saveentity) in modules/core/classes/GalleryEntity.class at line 270 (gallerystorage::saveentity) in modules/core/classes/GalleryDerivative.class at line 251 (gallerychildentity::save) in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 543 (galleryderivativeimage::save) in modules/core/classes/GalleryCoreApi.class at line 1307 (galleryitemhelper_medium::addexistingitemtoalbum) in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 359 (gallerycoreapi::addexistingitemtoalbum) in modules/core/classes/GalleryCoreApi.class at line 1293 (galleryitemhelper_medium::additemtoalbum) in modules/core/ItemAddFromBrowser.inc at line 79 (gallerycoreapi::additemtoalbum) in modules/core/ItemAdd.inc at line 77 (itemaddfrombrowser::handlerequest) in main.php at line 161 (itemaddcontroller::handlerequest) in main.php at line 47 in main.php at line 40
	XUser login Username: * Password: * Create new account Request new password
mindless Joined: 2004-01-04 Posts: 8601	Posted: Fri, 2004-10-15 20:23
	Enable buffered debug output in config.php and retry.. find the database error in the debug output and post it here.

bryans Joined: 2004-10-16 Posts: 1	Posted: Sat, 2004-10-16 14:30
	The problem is with the g_postfilteroperations column of the g2_derivative table. The insert is not providing a value for the column while the column has the attribute "not null". I worked around this by executing "alter table g2_derivative alter column g_postfilteroperations drop not null;"

mindless Joined: 2004-01-04 Posts: 8601	Posted: Sat, 2004-10-16 14:52
	could be, but I thought that problem was fixed in cvs.. ?

bharat Joined: 2002-05-21 Posts: 7994	Posted: Sat, 2004-10-16 23:16
	I did fix this a week ago. You can look at the GalleryDerivative.sql for Postgres -- it no longer has a "not null" designation for the g_postFilterOperations or the g_derivativeOperations columns. Can you verify that your version matches up?

XUser login