Openbravo Issue Tracking System - Modules
2. create a new image column/field of type BLOB for the M_Product table
3. immediately apply the changes and rebuild the application
You will find a warning about nonexisting M_PRODUCT_TRG (see also screenshot attached)
set.code.rev:
code.rev:
init:
core.lib:
init:
compile:
build.jar:
build:
copy.core.lib:
database.lib:
init:
compile:
build.jar:
jar:
buildvalidation:
buildvalidation:
update.database.mod:
update.database.mod.java:
[java] 0 INFO - Database connection:
jdbc:postgresql://localhost:5432/openbravo. [^] User: tad
[java] 908 INFO - Creating submodel for application dictionary
[java] 18269 INFO - Loading data from XML files
[java] 33265 INFO - Loading and applying configuration scripts
[java] Checking if database structure was modified locally.
[java] Checking if data has changed in the application dictionary.
[java] 33618 INFO - Change detected in table: AD_Element
[java] 33678 INFO - Database was modified locally, but as
update.database
command is forced, the database will be updated anyway.
[java] 33965 INFO - Updating module: com.woofinc.openbravo.module
[java] 33970 INFO - Loading submodel from database...
[java] 34019 INFO - Reading tables...
[java] 74076 INFO - Reading views...
[java] 74086 INFO - Reading sequences...
[java] 74093 INFO - Reading triggers...
[java] 74145 INFO - Reading functions...
[java] 74203 INFO - Sorting foreign keys, indexes and checks...
[java] 74207 INFO - Starting function and trigger standardization.
[java] 74213 INFO - Submodel loaded
[java] 74496 INFO - Updating database model...
[java] 77777 WARN - SQL Command failed with: ERROR: trigger
"m_product_trg"
for table "m_product" does not exist
[java] 77785 WARN - -- END
[java] --
-----------------------------------------------------------------------
[java] -- TRIGGER M_PRODUCT_TRG
[java] --
-----------------------------------------------------------------------
[java] DROP TRIGGER M_PRODUCT_TRG ON M_PRODUCT CASCADE
[java] 77847 WARN - SQL Command failed with: ERROR: trigger
"m_product_trg2"
for table "m_product" does not exist
[java] 77851 WARN - -- END
[java] --
-----------------------------------------------------------------------
[java] -- TRIGGER M_PRODUCT_TRG2
[java] --
-----------------------------------------------------------------------
[java] DROP TRIGGER M_PRODUCT_TRG2 ON M_PRODUCT CASCADE
[java] 78125 INFO - Executed 71 SQL command(s) with 2 error(s)
[java] 78130 INFO - Model update complete.
[java] 78134 INFO - Loading data from XML files
[java] 78529 INFO - Comparing databases to find data differences
[java] 78535 INFO - Updating database data...
[java] 78597 INFO - Disabling foreign keys
[java] 79600 INFO - Executed 185 SQL command(s) successfully
[java] 79610 INFO - Disabling triggers
[java] 79778 INFO - Executed 132 SQL command(s) successfully
[java] 85405 INFO - Executed 5013 SQL command(s) successfully
[java] 85418 INFO - Updating database data for module Woof Inc Module
[java] 85422 INFO - Recreating Primary Keys
[java] 85567 INFO - Executed 5 SQL command(s) successfully
[java] 85571 INFO - Removing invalid rows.
[java] 101082 INFO - Executed 171 SQL command(s) successfully
[java] 101089 INFO - Executing update final script (NOT NULLs and
dropping
temporary tables)
[java] 103268 INFO - Executed 89 SQL command(s) successfully
[java] 115893 INFO - Executed 120 SQL command(s) successfully
[java] 115898 INFO - Enabling Foreign Keys and Triggers
[java] 147228 INFO - Executed 5509 SQL command(s) successfully
[java] 149877 INFO - Executed 185 SQL command(s) successfully
[java] 186232 INFO - Executed 132 SQL command(s) successfully
[java] 186237 INFO - Executing default postscript
[java] 188708 INFO - Executed 22 SQL command(s) successfully
...
...
...
BTTerroraddnewfield.png (70,387) 2010-06-16 15:38https://issues.openbravo.com/file_download.php?file_id=2695&type=bug