Results 1 to 1 of 1

Thread: Missing Join Tables after Upgrade from CE 6.2.2 to 6.2.3

  1. #1
    ldebaets is offline Sugar Community Member
    Join Date
    Jul 2010
    Location
    Ottawa, Ontario, CANADA
    Posts
    39

    Unhappy Missing Join Tables after Upgrade from CE 6.2.2 to 6.2.3

    I did an upgrade from version 6.2.2 to 6.2.3 CE and there were two missing missing tables for modules in a custom package. It happens for the case of two modules having a one-to-many relationship with another common module. I have two such cases. The relationship table shows the problem and a picture is attached.

    I checked the metadata files that were generated by the modulebuilder and they are correct. I believe the moduleinstaller could be making an error and using the previous join table that was created for the right-hand-side module instead of using the name of the join table for the new relationship table. This join table existed correctly in the 6.2.2 application database.

    Please help! There is a requirement to be able to do upgrades of existing applications and installs of the custom package for new applications to be deployed.

    I'm running on a LAMP stack with Ubuntu: PHP Version 5.3.2-1ubuntu4.9, Apache version 2.2.14, MySQL API version 5.1.41.

    The problem appears consistently and even for installs on the latest 6.3.0RC3 load.
    There is no sign of a problem in the Apache or sugar logs (which are on in Debug mode).
    Attached Images Attached Images  
    Leonard De Baets
    TIM Program
    Carleton University, Ottawa, Ontario, Canada

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Basic/Adv Search join/left join seaches
    By kenneth.thorman in forum Developer Help
    Replies: 25
    Last Post: 2011-03-16, 12:44 PM
  2. missing tables in version 5.2.0 for SQL server
    By zzpiff in forum Installation and Upgrade Help
    Replies: 1
    Last Post: 2009-08-05, 10:46 AM
  3. Fresh 5.0.0 installation, missing tables
    By eduardob in forum Installation and Upgrade Help
    Replies: 4
    Last Post: 2007-12-31, 06:14 PM
  4. Can't seem to get 4.5.1g running - db tables missing
    By Matthias.Qwerty in forum Installation and Upgrade Help
    Replies: 1
    Last Post: 2007-10-31, 04:20 PM
  5. Replies: 0
    Last Post: 2005-08-28, 05:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •