• Resolved Han Leentvaar

    (@hleenwp)


    Hi, the update broke my relationship between the 2 pods I have (project and praise)
    When I look into the database table I see that my podsrel table is extended from 87 to 101 records. The original 87 records are unchanged.
    The extra records contain fields values that are already in the original records.
    The are also duplicates in the extra records.

    When I restore my previous database and pos plugin, everything is fine again.

    The deinition of my the table is:

    CREATE TABLEetdhb_podsrel` (
    id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    pod_id int(10) unsigned DEFAULT NULL,
    field_id int(10) unsigned DEFAULT NULL,
    item_id bigint(20) unsigned DEFAULT NULL,
    related_pod_id int(10) unsigned DEFAULT NULL,
    related_field_id int(10) unsigned DEFAULT NULL,
    related_item_id bigint(20) unsigned DEFAULT NULL,
    weight smallint(5) unsigned DEFAULT 0,
    PRIMARY KEY (id),
    KEY field_item_idx (field_id,item_id),
    KEY rel_field_rel_item_idx (related_field_id,related_item_id),
    KEY field_rel_item_idx (field_id,related_item_id),
    KEY rel_field_item_idx (related_field_id,item_id)
    ) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;`

    The content of the table is (after update) is:

    (11,34667,34692,34674,34689,34691,31037,0),
    (12,34689,34691,31037,34667,34692,34674,0),
    (13,34667,34692,34688,34689,34691,30348,0),
    (14,34689,34691,30348,34667,34692,34688,0),
    (15,34667,34692,34693,34689,34691,30295,0),
    (16,34689,34691,30295,34667,34692,34693,0),
    (17,34667,34692,34696,34689,34691,31186,0),
    (18,34689,34691,31186,34667,34692,34696,0),
    (19,34667,34692,34697,34689,34691,30266,0),
    (20,34689,34691,30266,34667,34692,34697,0),
    (21,34667,34692,34698,34689,34691,30345,0),
    (22,34689,34691,30345,34667,34692,34698,0),
    (23,34667,34692,34699,34689,34691,31176,0),
    (24,34689,34691,31176,34667,34692,34699,0),
    (25,34667,34692,34700,34689,34691,31176,0),
    (26,34689,34691,31176,34667,34692,34700,1),
    (29,34667,34692,34704,34689,34691,31308,0),
    (30,34689,34691,31308,34667,34692,34704,0),
    (31,34667,34692,34705,34689,34691,31054,0),
    (32,34689,34691,31054,34667,34692,34705,0),
    (35,34667,34692,34708,34689,34691,33885,0),
    (36,34689,34691,33885,34667,34692,34708,0),
    (37,34667,34692,34709,34689,34691,34238,0),
    (38,34689,34691,34238,34667,34692,34709,0),
    (39,34667,34692,34710,34689,34691,34238,0),
    (40,34689,34691,34238,34667,34692,34710,1),
    (41,34667,34692,34706,34689,34691,33885,0),
    (42,34689,34691,33885,34667,34692,34706,1),
    (43,34667,34692,34717,34689,34691,32892,0),
    (44,34689,34691,32892,34667,34692,34717,0),
    (45,34667,34692,34718,34689,34691,31054,0),
    (46,34689,34691,31054,34667,34692,34718,1),
    (49,34689,34691,31054,34667,34692,34719,2),
    (50,34667,34692,34719,34689,34691,31054,0),
    (51,34667,34692,34721,34689,34691,30376,0),
    (52,34689,34691,30376,34667,34692,34721,0),
    (53,34667,34692,34722,34689,34691,30348,0),
    (54,34689,34691,30348,34667,34692,34722,1),
    (55,34667,34692,34723,34689,34691,30345,0),
    (56,34689,34691,30345,34667,34692,34723,1),
    (63,34689,34691,32606,34667,34692,34701,0),
    (64,34667,34692,34701,34689,34691,32606,0),
    (65,34667,34692,34731,34689,34691,30345,0),
    (66,34689,34691,30345,34667,34692,34731,2),
    (67,34667,34692,34732,34689,34691,30357,0),
    (68,34689,34691,30357,34667,34692,34732,0),
    (69,34689,34734,34238,0,0,34241,0),
    (70,34689,34734,34238,0,0,34256,1),
    (72,34689,34734,33885,0,0,33852,0),
    (73,34689,34734,33885,0,0,33886,1),
    (74,34689,34734,32892,0,0,32893,0),
    (75,34689,34734,32892,0,0,32890,1),
    (76,34689,34734,31054,0,0,31055,0),
    (77,34689,34734,31054,0,0,31063,1),
    (78,34689,34734,30376,0,0,31065,0),
    (79,34689,34734,30376,0,0,31064,1),
    (80,34689,34734,30373,0,0,31068,0),
    (81,34689,34734,30373,0,0,31069,1),
    (82,34689,34734,31176,0,0,31177,0),
    (83,34689,34734,31176,0,0,31180,1),
    (84,34689,34734,31070,0,0,31071,0),
    (85,34689,34734,31070,0,0,31072,1),
    (86,34689,34734,31073,0,0,31074,0),
    (87,34689,34734,31073,0,0,31075,1),
    (88,34689,34734,31073,0,0,31076,2),
    (89,34689,34734,31077,0,0,31078,0),
    (90,34689,34734,31077,0,0,31079,1),
    (91,34689,34734,31077,0,0,31080,2),
    (92,34689,34734,31081,0,0,31082,0),
    (93,34689,34734,31081,0,0,31083,1),
    (94,34689,34734,31081,0,0,31084,2),
    (95,34689,34734,31085,0,0,31086,0),
    (96,34689,34734,31085,0,0,31088,1),
    (97,34689,34734,31085,0,0,31087,2),
    (98,34689,34734,31089,0,0,31090,0),
    (99,34689,34734,31089,0,0,31091,1),
    (100,34689,34734,31089,0,0,31092,2),
    (101,34689,34734,31093,0,0,31094,0),
    (102,34689,34734,31093,0,0,31095,1),
    (103,34689,34734,31093,0,0,31096,2),
    (104,34689,34734,31097,0,0,31098,0),
    (105,34689,34734,31097,0,0,31099,1),
    (106,34689,34734,31097,0,0,31100,2),
    (107,34689,34734,33814,0,0,33811,0),
    (108,34689,34734,33814,0,0,33815,1),
    (109,34689,34734,33814,0,0,33807,2),
    (111,34689,34734,34744,0,0,34747,0),
    Extra:
    (112,34667,34692,34709,34689,34691,34238,0),
    (113,34689,34691,34238,34667,34692,34709,0),
    (114,34667,34692,34709,34689,34691,34238,0),
    (115,34689,34691,34238,34667,34692,34709,0),
    (116,34667,34692,34704,34689,34691,31308,0),
    (117,34689,34691,31308,34667,34692,34704,0),
    (118,34667,34692,34709,34689,34691,34238,0),
    (119,34689,34691,34238,34667,34692,34709,0),
    (120,34667,34692,34709,34689,34691,33885,0),
    (121,34689,34691,33885,34667,34692,34709,0),
    (122,34667,34692,34709,34689,34691,34238,0),
    (123,34689,34691,34238,34667,34692,34709,0),
    (124,34667,34692,34709,34689,34691,34238,0),
    (125,34689,34691,34238,34667,34692,34709,0);

    Any clue?

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Update to 2.8.22.1 (from 2.8.21) breaks relationship’ is closed to new replies.