Openbravo Issue Tracking System - Java Client POS | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0009391 | Java Client POS | (No Category) | public | 2009-06-08 17:45 | 2011-06-03 12:22 |
| Reporter | mirurita | ||||
| Assigned To | adrianromero | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 20 | OS Version | rPath Linux | |
| Product Version | 2.30 | ||||
| Target Version | 2.40 | Fixed in Version | 2.30.1 | ||
| Regression date | |||||
| Regression introduced by commit | |||||
| Regression level | |||||
| Review Assigned To | |||||
| OBNetwork customer | No | ||||
| Support ticket | |||||
| Regression introduced in release | |||||
| Summary | 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) ) ; | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| 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) | ||
| Notes | |||||
|
|
|||||
|
|
||||