Update to 2.8.22.1 (from 2.8.21) breaks relationship
-
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 TABLE
etdhb_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
),
KEYfield_item_idx
(field_id
,item_id
),
KEYrel_field_rel_item_idx
(related_field_id
,related_item_id
),
KEYfield_rel_item_idx
(field_id
,related_item_id
),
KEYrel_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?
- The topic ‘Update to 2.8.22.1 (from 2.8.21) breaks relationship’ is closed to new replies.