Upgrade existing postgres database with latest ofbiz give table fields mismatch error.

[Anchit Jindal]

Hi All,

I want to upgrade my old ofbiz with its latest version from trunk and also want to use my existing database(which is postgres) with latest ofbiz. For this i set my database name in entityengine.xml file. While running the ofbiz it gives error for table fields datatype mismatch e.g (Column [ATTR_VALUE] of table [public.CUST_REQUEST_ATTRIBUTE] of entity [CustRequestAttribute] is of type [text] in the database, but is defined as type [VARCHAR] in the entity definition.). Can any one tell me how to solve this type mismatch error for the fields except alter datatype of each table.

[Jacques Le Roux]

Since you don't want to alter your DB, I guess the easier for you is to change fieldtypepostgres.xml
Replace VARCHARby TEXT where needed. Beware though: TEXT is unlimited, should be ok most of the time

Jacques

Le 12/01/2015 13:41, Anchit Jindal a écrit :

> Hi All,
>
> I want to upgrade my old ofbiz with its latest version from trunk and also
> want to use my existing database(which is postgres) with latest ofbiz. For
> this i set my database name in entityengine.xml file. While running the
> ofbiz it gives error for table fields datatype mismatch e.g (Column
> [ATTR_VALUE] of table [public.CUST_REQUEST_ATTRIBUTE] of entity
> [CustRequestAttribute] is of type [text] in the database, but is defined as
> type [VARCHAR] in the entity definition.). Can any one tell me how to solve
> this type mismatch error for the fields except alter datatype of each table.
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Upgrade-existing-postgres-database-with-latest-ofbiz-give-table-fields-mismatch-error-tp4661247.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Anchit Jindal]

Hi Jacques, thanks for the information. 

On Mon, Jan 12, 2015 at 8:41 PM, Jacques Le Roux [via OFBiz] <[hidden email]> wrote:

Since you don't want to alter your DB, I guess the easier for you is to change fieldtypepostgres.xml
Replace VARCHARby TEXT where needed. Beware though: TEXT is unlimited, should be ok most of the time

Jacques

Le 12/01/2015 13:41, Anchit Jindal a écrit :

> Hi All,
>
> I want to upgrade my old ofbiz with its latest version from trunk and also
> want to use my existing database(which is postgres) with latest ofbiz. For
> this i set my database name in entityengine.xml file. While running the
> ofbiz it gives error for table fields datatype mismatch e.g (Column
> [ATTR_VALUE] of table [public.CUST_REQUEST_ATTRIBUTE] of entity
> [CustRequestAttribute] is of type [text] in the database, but is defined as
> type [VARCHAR] in the entity definition.). Can any one tell me how to solve
> this type mismatch error for the fields except alter datatype of each table.
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Upgrade-existing-postgres-database-with-latest-ofbiz-give-table-fields-mismatch-error-tp4661247.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

---

If you reply to this email, your message will be added to the discussion below:

http://ofbiz.135035.n4.nabble.com/Upgrade-existing-postgres-database-with-latest-ofbiz-give-table-fields-mismatch-error-tp4661247p4661254.html

To unsubscribe from Upgrade existing postgres database with latest ofbiz give table fields mismatch error., click here.
NAML