0020528: A SQL query is not compatible with 8.3 making the upgrade from 2.50 to fail

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0020528

Openbravo ERP

A. Platform

public

2012-05-16 17:32

2012-05-25 12:12

Reporter

plujan

Assigned To

shuehner

Priority

immediate

Severity

critical

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

main

Target Version

3.0MP11

Fixed in Version

3.0MP12

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0020528: A SQL query is not compatible with 8.3 making the upgrade from 2.50 to fail

Description

When trying to update a 2.50 to 3.0 MP11 I've got an error:

[java] 2083 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: select ad_tab.ad_tab_id as tabid, ad_column.ad_column_id as columnid, ad_window.name as windowname, ad_tab.name as tabname,
     [java] ad_field.name fieldname,ad_column.name as columnname, ad_field.ad_module_id as moduleid, ad_module.name as modulename
     [java] from ad_window, ad_tab, ad_field, ad_column, ad_module
     [java] where ad_field.ad_column_id = ad_column.ad_column_id
     [java] and ad_field.ad_module_id = ad_module.ad_module_id
     [java] and ad_tab.ad_tab_id = ad_field.ad_tab_id
     [java] and ad_window.ad_window_id = ad_tab.ad_window_id
     [java] and (ad_module.javapackage in (
     [java] '1') or to_char('Y')=to_char(?))
     [java] and exists (select * from ad_field subFld where
     [java] subFld.ad_tab_id = ad_field.ad_tab_id
     [java] and subFld.ad_column_id = ad_field.ad_column_id
     [java] and ad_field.ad_field_id <> subFld.ad_field_id)
     [java] order by ad_tab.ad_tab_id, ad_column.ad_column_id
     [java]
     [java] org.postgresql.util.PSQLException: ERROR: syntax error at or near "fieldname"

Steps To Reproduce

rebuild after upgrading from 2.50 to 3.0 MP11

Proposed Solution

Additional Information