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

Description

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

Steps To Reproduce

- Configure Openbravo POS 2.0 with MySQL database and run
- Configure Openbravo POS 2.30 with the same database and run

Proposed Solution

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)
) ;

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0017177) hgbot (developer) 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 ---

Issue History
Date Modified	Username	Field	Change
2009-06-08 17:45	mirurita	New Issue
2009-06-08 17:45	mirurita	Assigned To	=> mirurita
2009-06-10 13:10	hgbot	Checkin
2009-06-10 13:10	hgbot	Note Added: 0017177
2009-06-10 13:10	hgbot	Status	new => resolved
2009-06-10 13:10	hgbot	Resolution	open => fixed
2009-06-10 13:10	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/pos/devel/main/rev/1f3e63951f7f45e963149643142e7906fe01d315 [^]
2010-07-22 13:59	adrianromero	Status	resolved => closed
2010-07-22 13:59	adrianromero	Fixed in Version	=> 2.30.1
2010-07-23 00:00	anonymous	sf_bug_id	0 => 3033254
2011-06-03 12:22	dalsasua	Assigned To	mirurita => adrianromero
2012-11-07 09:40	priyam	Category	05 - Database => (No Category)