// Add your reply above here
==================================================
Vladimir updated this ticket at November 9th, 2010 @ 06:28 PM
Hello. I install Bricolage on localhost:
FreeBSD 8.1;
Apache 2.2 MPM;
PostgreSQL;
Opera.
I try create new category - result SQL Error:
Unable to execute SQL statement
DBD::Pg::st execute failed: ERROR: value too long for type character varying(256) [.for Statement "INSERT INTO category (id,site__id,directory,asset_grp_id,active,uri,parent_id,name,description) VALUES (NEXTVAL('seq_category'),?,?,?,?,?,?,?,?)" with ParamValues: 1='100', 2='new_dir_for_new_cat', 3='1030', 4='1', 5='/new_dir_for_new_cat/', 6='1', 7='New Category', 8='Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. '] at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1138, <GEN1> line 2.
And Error Details:
Error Details (hide)
Fault Class:
Bric::Util::Fault::Exception::DA
Description:
Data Access Exception
Timestamp:
2010-11-09 20:22:59.000000
Package:
Bric::Util::DBI
Filename:
/usr/local/bricolage/lib/Bric/Util/DBI.pm
Line:
1139
And Stack:
Trace begun at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1139
Bric::Util::DBI::execute('DBI::st=HASH(0xbedffb8)', 100, 'new_dir_for_new_cat', 1030, 1, '/new_dir_for_new_cat/', 1, 'New Category', 'Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. ') called at /usr/local/bricolage/lib/Bric/Biz/Category.pm line 1827
Bric::Biz::Category::_insert_category('Bric::Biz::Category=HASH(0xbec1dcc)') called at /usr/local/bricolage/lib/Bric/Biz/Category.pm line 1528
Bric::Biz::Category::save('Bric::Biz::Category=HASH(0xbec1dcc)') called at /usr/local/bricolage/lib/Bric/App/Callback/Profile/Category.pm line 155
Bric::App::Callback::Profile::Category::save('Bric::App::Callback::Profile::Category=HASH(0xaf81e5c)') called at /usr/local/lib/perl5/site_perl/5.8.9/Params/CallbackRequest.pm line 296
eval {...} at /usr/local/lib/perl5/site_perl/5.8.9/Params/CallbackRequest.pm line 286
Params::CallbackRequest::request('Params::CallbackRequest=HASH(0xaf883ec)', 'HASH(0xb891d08)', 'requester', 'MasonX::Interp::WithCallbacks=HASH(0xb9be598)', 'apache_req', 'Apache2::Request=SCALAR(0xbeeafb4)') called at /usr/local/lib/perl5/site_perl/5.8.9/MasonX/Interp/WithCallbacks.pm line 119
MasonX::Interp::WithCallbacks::make_request('MasonX::Interp::WithCallbacks=HASH(0xb9be598)', 'comp', '/admin/profile/category', 'args', 'ARRAY(0xbeeb140)', 'ah', 'HTML::Mason::ApacheHandler=HASH(0xb9b7af0)', 'apache_req', 'Apache2::Request=SCALAR(0xbeeafb4)') called at /usr/local/lib/perl5/site_perl/5.8.9/HTML/Mason/ApacheHandler.pm line 868
eval {...} at /usr/local/lib/perl5/site_perl/5.8.9/HTML/Mason/ApacheHandler.pm line 867
HTML::Mason::ApacheHandler::prepare_request('HTML::Mason::ApacheHandler=HASH(0xb9b7af0)', 'Apache2::RequestRec=SCALAR(0x9feb548)') called at /usr/local/lib/perl5/site_perl/5.8.9/HTML/Mason/ApacheHandler.pm line 822
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xb9b7af0)', 'Apache2::RequestRec=SCALAR(0x9feb548)') called at /usr/local/bricolage/lib/Bric/App/Handler.pm line 307
eval {...} at /usr/local/bricolage/lib/Bric/App/Handler.pm line 296
Bric::App::Handler::handler('Apache2::RequestRec=SCALAR(0x9feb548)') called at -e line 0
eval {...} at -e line 0
Create a New user may login under his account as possible, but a new user in the user list is missing.
(The attachment not match)
--------------------------------------------------------------------------------
Assigned: Bugs (at bricolage)
State: new
Assets:
- 20101109error_bricolage.mht http://bricolage.lighthouseapp.com/projects/29601/tickets/215/a/761773/20101109error_bricolage.mht
View this ticket online: http://bricolage.lighthouseapp.com/projects/29601/tickets/215-i-can-not-add-new-category-and-other
Stop being notified of this ticket's changes: http://bricolage.lighthouseapp.com/projects/29601/tickets/215-i-can-not-add-new-category-and-other/watch
Update your Profile: http://bricolage.lighthouseapp.com/profile
Support: support@lighthouseapp.com or http://help.lighthouseapp.com
==================================================
Vladimir updated this ticket at November 9th, 2010 @ 06:28 PM
Hello. I install Bricolage on localhost:
FreeBSD 8.1;
Apache 2.2 MPM;
PostgreSQL;
Opera.
I try create new category - result SQL Error:
Unable to execute SQL statement
DBD::Pg::st execute failed: ERROR: value too long for type character varying(256) [.for Statement "INSERT INTO category (id,site__id,directory,asset_grp_id,active,uri,parent_id,name,description) VALUES (NEXTVAL('seq_category'),?,?,?,?,?,?,?,?)" with ParamValues: 1='100', 2='new_dir_for_new_cat', 3='1030', 4='1', 5='/new_dir_for_new_cat/', 6='1', 7='New Category', 8='Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. '] at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1138, <GEN1> line 2.
And Error Details:
Error Details (hide)
Fault Class:
Bric::Util::Fault::Exception::DA
Description:
Data Access Exception
Timestamp:
2010-11-09 20:22:59.000000
Package:
Bric::Util::DBI
Filename:
/usr/local/bricolage/lib/Bric/Util/DBI.pm
Line:
1139
And Stack:
Trace begun at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1139
Bric::Util::DBI::execute('DBI::st=HASH(0xbedffb8)', 100, 'new_dir_for_new_cat', 1030, 1, '/new_dir_for_new_cat/', 1, 'New Category', 'Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. Description the New Category. ') called at /usr/local/bricolage/lib/Bric/Biz/Category.pm line 1827
Bric::Biz::Category::_insert_category('Bric::Biz::Category=HASH(0xbec1dcc)') called at /usr/local/bricolage/lib/Bric/Biz/Category.pm line 1528
Bric::Biz::Category::save('Bric::Biz::Category=HASH(0xbec1dcc)') called at /usr/local/bricolage/lib/Bric/App/Callback/Profile/Category.pm line 155
Bric::App::Callback::Profile::Category::save('Bric::App::Callback::Profile::Category=HASH(0xaf81e5c)') called at /usr/local/lib/perl5/site_perl/5.8.9/Params/CallbackRequest.pm line 296
eval {...} at /usr/local/lib/perl5/site_perl/5.8.9/Params/CallbackRequest.pm line 286
Params::CallbackRequest::request('Params::CallbackRequest=HASH(0xaf883ec)', 'HASH(0xb891d08)', 'requester', 'MasonX::Interp::WithCallbacks=HASH(0xb9be598)', 'apache_req', 'Apache2::Request=SCALAR(0xbeeafb4)') called at /usr/local/lib/perl5/site_perl/5.8.9/MasonX/Interp/WithCallbacks.pm line 119
MasonX::Interp::WithCallbacks::make_request('MasonX::Interp::WithCallbacks=HASH(0xb9be598)', 'comp', '/admin/profile/category', 'args', 'ARRAY(0xbeeb140)', 'ah', 'HTML::Mason::ApacheHandler=HASH(0xb9b7af0)', 'apache_req', 'Apache2::Request=SCALAR(0xbeeafb4)') called at /usr/local/lib/perl5/site_perl/5.8.9/HTML/Mason/ApacheHandler.pm line 868
eval {...} at /usr/local/lib/perl5/site_perl/5.8.9/HTML/Mason/ApacheHandler.pm line 867
HTML::Mason::ApacheHandler::prepare_request('HTML::Mason::ApacheHandler=HASH(0xb9b7af0)', 'Apache2::RequestRec=SCALAR(0x9feb548)') called at /usr/local/lib/perl5/site_perl/5.8.9/HTML/Mason/ApacheHandler.pm line 822
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xb9b7af0)', 'Apache2::RequestRec=SCALAR(0x9feb548)') called at /usr/local/bricolage/lib/Bric/App/Handler.pm line 307
eval {...} at /usr/local/bricolage/lib/Bric/App/Handler.pm line 296
Bric::App::Handler::handler('Apache2::RequestRec=SCALAR(0x9feb548)') called at -e line 0
eval {...} at -e line 0
Create a New user may login under his account as possible, but a new user in the user list is missing.
(The attachment not match)
--------------------------------------------------------------------------------
Assigned: Bugs (at bricolage)
State: new
Assets:
- 20101109error_bricolage.mht http://bricolage.lighthouseapp.com/projects/29601/tickets/215/a/761773/20101109error_bricolage.mht
View this ticket online: http://bricolage.lighthouseapp.com/projects/29601/tickets/215-i-can-not-add-new-category-and-other
Stop being notified of this ticket's changes: http://bricolage.lighthouseapp.com/projects/29601/tickets/215-i-can-not-add-new-category-and-other/watch
Update your Profile: http://bricolage.lighthouseapp.com/profile
Support: support@lighthouseapp.com or http://help.lighthouseapp.com