[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543485 ]
David E. Jones commented on OFBIZ-1399: --------------------------------------- There are certainly lots of little things that can be done to improve the user experience. In this case if a user didn't understand that they were creating a link between the catalog and the category, then a message saying that the category didn't exist wouldn't make any sense to the user. There's no way around it: for generic user interfaces like most of those in OFBiz you have to know a bit about what you are doing in order to get things done. It is certainly possible to create user interfaces that guide the user through a process, but you have to have the process defined first! For most processes automated with OFBiz that means narrowing down to a certain role and operation that is part of a coordinated set of roles for a certain type of organization. If you only have one organization to worry about this is easy, but for OFBiz in general we don't have that luxury, so it's hard to get that sort of efficient UI into the project. This is the dilemma that we face... There are more specific solutions for certain roles and processes in the specialpurpose components, but in the general application components we are trying to keep things pretty generic in order to avoid huge confusion due to a large number of custom UIs that are irrelevant or bad practices for various user organizations. > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > Assignee: Jacques Le Roux > Fix For: SVN trunk > > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog > [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] > process [problem creating the newEntity value: Error while inserting: > [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 > 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 > 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 > 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 > 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 > 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] > (SQL Exception while executing the following:INSERT INTO > OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, > PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered > trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.