Openbravo Issue Tracking System - Java Client POS
View Issue Details
0009391Java Client POS(No Category)public2009-06-08 17:452011-06-03 12:22
mirurita 
adrianromero 
normalminoralways
closedfixed 
20rPath Linux
2.30 
2.402.30.1 
0009391: Upgrade from Openbravo 2.0 to 2.30 process fails in MySQL
com.openbravo.basic.BasicException:
java.sql.SQLException: Can't create table './testing/TAXLINES.frm' (errno: 150)

com.openbravo.basic.BasicException:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'testing.TAXLINES' doesn't exist

com.openbravo.basic.BasicException:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'testing.TAXLINES' doesn't exist

- Configure Openbravo POS 2.0 with MySQL database and run
- Configure Openbravo POS 2.30 with the same database and run
Change the creation of the table TAXLINES in MySQL-upgrade-2.00.sql (com.openbravo.pos.scripts).

CREATE TABLE TAXLINES (
    ID VARCHAR(255) NOT NULL,
    RECEIPT VARCHAR(255) NOT NULL,
    TAXID VARCHAR(255) NOT NULL,
    BASE DOUBLE NOT NULL,
    AMOUNT DOUBLE NOT NULL,
    PRIMARY KEY (ID),
    CONSTRAINT TAXLINES_TAX FOREIGN KEY (TAXID) REFERENCES TAXES(ID)
) ;
No tags attached.
Issue History
2009-06-08 17:45miruritaNew Issue
2009-06-08 17:45miruritaAssigned To => mirurita
2009-06-10 13:10hgbotCheckin
2009-06-10 13:10hgbotNote Added: 0017177
2009-06-10 13:10hgbotStatusnew => resolved
2009-06-10 13:10hgbotResolutionopen => fixed
2009-06-10 13:10hgbotFixed in SCM revision => http://code.openbravo.com/pos/devel/main/rev/1f3e63951f7f45e963149643142e7906fe01d315 [^]
2010-07-22 13:59adrianromeroStatusresolved => closed
2010-07-22 13:59adrianromeroFixed in Version => 2.30.1
2010-07-23 00:00anonymoussf_bug_id0 => 3033254
2011-06-03 12:22dalsasuaAssigned Tomirurita => adrianromero
2012-11-07 09:40priyamCategory05 - Database => (No Category)

Notes
(0017177)
hgbot   
2009-06-10 13:10   
Repository: pos/devel/main
Changeset: 1f3e63951f7f45e963149643142e7906fe01d315
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Mon Jun 08 18:05:36 2009 +0200
URL: http://code.openbravo.com/pos/devel/main/rev/1f3e63951f7f45e963149643142e7906fe01d315 [^]

Fixes issue 0009391: Upgrade from Openbravo 2.0 to 2.30 process fails in MySQL

---
M src-pos/com/openbravo/pos/scripts/MySQL-upgrade-2.00.sql
---