Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Upgrading from 2.3.0 to 3.0 Beta 1

Help
2008-05-31
2013-03-08
  • Mark Parker
    Mark Parker
    2008-05-31

    I am trying to upgrade Postbooks v2.3.0 upto 3.0Beta1.  I run the update manager and first run the 2.3.0to2.3.1 package.  The prerequesite checks fail with the error:

    Checking for Itemless Itemtax
    Failed

    One or more Itemtax records do not reference an Item or refer to a missing record.

    I have checked the itemtax and item tables for any orphaned records and they match on both record count and each itemid in itemtax matches a record in the item table.  Does anyone have any ideas what could be causing this or know what the sql statement the update program is using the determine this error (or how I find it?)?

     
    • Gil
      Gil
      2008-06-02

      msp1974,

      I just posted a draft document describing how to debug upgrade problems on the xTuple Wiki:
      http://www.xtuple.org/ -> wiki and search for HowToDebugUpgradeErrors

      In the case you describe the query is:
      SELECT COUNT(*)=0 FROM itemtax WHERE (itemtax_item_id NOT IN (
      SELECT item_id FROM item WHERE (item_id=itemtax_item_id)
      ));

      For some reason with your data the query is returning FALSE. Try running this next query and see what you get:
      SELECT * FROM itemtax WHERE (itemtax_item_id NOT IN (
      SELECT item_id FROM item WHERE (item_id=itemtax_item_id)
      ));

      Gil