[jira] Commented: (OFBIZ-495) User Preferences Feature

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12520929 ]

Jacques Le Roux commented on OFBIZ-495:
---------------------------------------

Adrian, David,

I agree with David about tabs (though there are not much tabs in this patch, only some in services_user.xml) but in .ftl where I far prefer 2 tabs (as Adrian did in example.patch, always not to be commited ?).

I got a problem to patch controller.xml in example.patch but was able to merge it (thanks to the great Tortoise :o).

Then I tested the link https://127.0.0.1:8443/example/control/UserPrefDemo but I got an error because location="${parameters.mainDecoratorLocation}"> is missin in <screen name="UserPrefDemo">

Then  I got a problem
Method public java.util.Map org.ofbiz.service.GenericDispatcher.runSync(java.lang.String,java.util.Map) throws org.ofbiz.service.ServiceValidationException,org.ofbiz.service.GenericServiceException threw an exception when invoked on org.ofbiz.service.WebAppDispatcher@9eb4a1 The problematic instruction: ---------- ==> assignment: resultMap=dispatcher.runSync("getUserPreference", Static["org.ofbiz.base.util.UtilMisc"].toMap("userPrefTypeId", "TEST_PREFERENCE", "userLogin", userLogin)) [on line 48, column 3 in component://example/webapp/example/viewDemo.ftl]

because in UserPrefServices.getUserPreference userPrefGroupId was null when called in userPrefMap = UserPreferences.createUserPrefMap(UserPreferences.getUserPreference(delegator, (String) context.get("userLoginId"), userPrefTypeId, userPrefGroupId));

Then I put "admin" in place of "_NA_" in UserServicesData.xml and re-imported  : no way, I stopped there.

Thanks for your work Adrian, just a little bit more and I guess it should be ok ;o)

Also to mentio,n though not related (using Derby):
2007-08-19 07:08:31,437 (main) [       DatabaseUtil.java:267:ERROR] WARNING: Column [TEXT_DATA] of table [OFBIZ.AGREEMENT] of entity [Agreement] is of type [VARCHAR] in the database, but is defined as type [CLOB] in the entity definition.
2007-08-19 07:08:31,578 (main) [       DatabaseUtil.java:274:WARN ] WARNING: Column [TASK] of table [OFBIZ.OAGIS_MESSAGE_ERROR_INFO] of entity [OagisMessageErrorInfo] has a column size of [10] in the database, but is defined to have a column size of [60] in the entity definition.
2007-08-19 07:08:31,578 (main) [       DatabaseUtil.java:267:ERROR] WARNING: Column [DESCRIPTION] of table [OFBIZ.OAGIS_MESSAGE_ERROR_INFO] of entity [OagisMessageErrorInfo] is of type [VARCHAR] in the database, but is defined as type [CLOB] in the entity definition.
2007-08-19 07:08:31,578 (main) [       DatabaseUtil.java:274:WARN ] WARNING: Column [TASK] of table [OFBIZ.OAGIS_MESSAGE_INFO] of entity [OagisMessageInfo] has a column size of [10] in the database, but is defined to have a column size of [60] in the entity definition.

> User Preferences Feature
> ------------------------
>
>                 Key: OFBIZ-495
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-495
>             Project: OFBiz
>          Issue Type: New Feature
>            Reporter: Adrian Crum
>            Priority: Minor
>         Attachments: COLLAPSD.JPG, example.patch, EXPANDED.JPG, user_pref.patch, user_pref.patch
>
>
> The User Preferences Services are intended to store and retrieve the current user's  preferences. User preferences can be used to control UI elements, frequently used search and report criteria, and more.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[David E Jones]

Jacques Le Roux (JIRA) wrote:
>
> Also to mentio,n though not related (using Derby):
> 2007-08-19 07:08:31,437 (main) [       DatabaseUtil.java:267:ERROR] WARNING: Column [TEXT_DATA] of table [OFBIZ.AGREEMENT] of entity [Agreement] is of type [VARCHAR] in the database, but is defined as type [CLOB] in the entity definition.
> 2007-08-19 07:08:31,578 (main) [       DatabaseUtil.java:274:WARN ] WARNING: Column [TASK] of table [OFBIZ.OAGIS_MESSAGE_ERROR_INFO] of entity [OagisMessageErrorInfo] has a column size of [10] in the database, but is defined to have a column size of [60] in the entity definition.
> 2007-08-19 07:08:31,578 (main) [       DatabaseUtil.java:267:ERROR] WARNING: Column [DESCRIPTION] of table [OFBIZ.OAGIS_MESSAGE_ERROR_INFO] of entity [OagisMessageErrorInfo] is of type [VARCHAR] in the database, but is defined as type [CLOB] in the entity definition.
> 2007-08-19 07:08:31,578 (main) [       DatabaseUtil.java:274:WARN ] WARNING: Column [TASK] of table [OFBIZ.OAGIS_MESSAGE_INFO] of entity [OagisMessageInfo] has a column size of [10] in the database, but is defined to have a column size of [60] in the entity definition.

Jacques: these are errors you should get familiar with as they are an important feature of the Entity Engine to help with maintenance on productions systems. These simply mean that the entity definitions have changed and the database you are testing against is old, ie was created before these changes were made. The solution is to update your database, or if it is a dev one you can usually blow it away and just have OFBiz create a new database.

-David

[Jacques Le Roux]

Thanks David,

I will upgrade Derby DB

Jacques

De : "David E Jones" <[hidden email]>
> Jacques Le Roux (JIRA) wrote:
> >
> > Also to mentio,n though not related (using Derby):
> > 2007-08-19 07:08:31,437 (main) [       DatabaseUtil.java:267:ERROR] WARNING: Column [TEXT_DATA] of table [OFBIZ.AGREEMENT] of
entity [Agreement] is of type [VARCHAR] in the database, but is defined as type [CLOB] in the entity definition.
> > 2007-08-19 07:08:31,578 (main) [       DatabaseUtil.java:274:WARN ] WARNING: Column [TASK] of table
[OFBIZ.OAGIS_MESSAGE_ERROR_INFO] of entity [OagisMessageErrorInfo] has a column size of [10] in the database, but is defined to have
a column size of [60] in the entity definition.
> > 2007-08-19 07:08:31,578 (main) [       DatabaseUtil.java:267:ERROR] WARNING: Column [DESCRIPTION] of table
[OFBIZ.OAGIS_MESSAGE_ERROR_INFO] of entity [OagisMessageErrorInfo] is of type [VARCHAR] in the database, but is defined as type
[CLOB] in the entity definition.
> > 2007-08-19 07:08:31,578 (main) [       DatabaseUtil.java:274:WARN ] WARNING: Column [TASK] of table [OFBIZ.OAGIS_MESSAGE_INFO]
of entity [OagisMessageInfo] has a column size of [10] in the database, but is defined to have a column size of [60] in the entity
definition.
>
> Jacques: these are errors you should get familiar with as they are an important feature of the Entity Engine to help with
maintenance on productions systems. These simply mean that the entity definitions have changed and the database you are testing
against is old, ie was created before these changes were made. The solution is to update your database, or if it is a dev one you
can usually blow it away and just have OFBiz create a new database.
>
> -David