Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • October 31, 2003 at 7:02 pm in reply to: Structure Syncronization dropping keys #15184
    marty
    Member

    Now, when I run this sync, I get an error!

    October 31, 2003 at 7:00 pm in reply to: Structure Syncronization dropping keys #15183
    marty
    Member

    Screenshot 2

    Note, that the sync tool suddenly thinks that Opportunity table on test2 has a CompanyName index, while test1 does not. This is incorrect. However, there are other tables within this same sync that are pulling up just fine

    October 31, 2003 at 6:59 pm in reply to: Structure Syncronization dropping keys #15182
    marty
    Member

    Screenshot 1

    Here is my object browser. Take note that test2 DOES NOT have a CompanyName index

    October 31, 2003 at 6:38 pm in reply to: Structure Syncronization dropping keys #15180
    marty
    Member

    Here is the slave (The one I am copying structure TO)

    October 31, 2003 at 6:37 pm in reply to: Structure Syncronization dropping keys #15179
    marty
    Member

    OK, here are the sql scripts

    MySQL 4.0.12-nt

    I don't know if it's going to let me post both scripts here. The first one will be the master (the one I am copying the structure FROM)

    October 31, 2003 at 6:18 pm in reply to: Structure Syncronization dropping keys #15178
    marty
    Member

    Thanks for your quick reply:

    Please review my original post. I am positive that I am clicking the right Sync Clipboard >> buttons.

    You will notice that the sql that was generated is being run on mp15:

    /* Alter table in Second database */

    alter table `mp15`.`Opportunity`,

    drop key `ContactId`,

    drop key `CreatedBy`,

    drop key `DateCreated`,

    drop key `DateInStage`,

    drop key `DateInStatus`,

    drop key `Leadsource`,

    drop key `Objection`,

    drop key `OppTitle`,

    drop key `PercentChance`,

    drop key `StageID`,

    drop key `StatusID`,

    drop key `UserID`;

    mp15 IS the second database, the one WITHOUT all the keys. If mp15 doesn't have keys that the first table does, these commands should be add key commands

    If you need, I can send you my mysql data files for testing.

    Thanks again,

    Eric

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)