I can not add New Category (and other...)
Reported by Vladimir | November 9th, 2010 @ 06:28 PM | in 2.0.1
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)
Comments and changes to this ticket
-

theory November 9th, 2010 @ 10:18 PM
- State changed from new to open
- Milestone set to 2.0.1
- Tag set to attribute, category, length, value
- Milestone order changed from 9 to 0
Did you actually try to create a category with the description "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. "? And if so, how did you do it? With what browser?
Oh. Opera. We don't support that. Though we should prevent you from getting this error…
David
So the thing to do to fix this is to check that field values are valid before sending them to the database.
-

Vladimir November 10th, 2010 @ 10:26 AM
Here's something else ...
I installed the Bricolage again: I can create a new user, but I don't see in the list.
I can't create a new category.
I can create New Contributor Groups and I see in the list.
Tested in the an epiphany. -

theory November 10th, 2010 @ 04:03 PM
Some objects are all shown by default in the manager UI. Others aren't. When you can't see anything, search on %.
Best,
David
-

theory January 17th, 2011 @ 09:17 PM
- Assigned user changed from Bugs (at bricolage) to phillipadsmith
-

Bugs (at bricolage) January 17th, 2011 @ 10:55 PM
- State changed from open to resolved
(from [0152ca8d5d7f1b438d1586a15e32f69c75656827]) Fix to limit the length of category descriptions (Bug #215). [Phillip Smith] [#215 state:resolved] https://github.com/bricoleurs/bricolage/commit/0152ca8d5d7f1b438d15...
-

Bugs (at bricolage) January 17th, 2011 @ 10:56 PM
(from [839247049ebc874f22fa7777a21df5b0d91c4f73]) Fix to limit the length of category descriptions (Bug #215). [Phillip Smith] [#215 state:resolved] https://github.com/bricoleurs/bricolage/commit/839247049ebc874f22fa...
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
People watching this ticket
Attachments
Referenced by
-
#215 I can not add New Category (and other...)
(from [0152ca8d5d7f1b438d1586a15e32f69c75656827])
Fix to ...
-
#215 I can not add New Category (and other...)
(from [0152ca8d5d7f1b438d1586a15e32f69c75656827])
Fix to ...
-
#215 I can not add New Category (and other...)
(from [839247049ebc874f22fa7777a21df5b0d91c4f73])
Fix to ...
-
#215 I can not add New Category (and other...)
(from [839247049ebc874f22fa7777a21df5b0d91c4f73])
Fix to ...