WordPress database error: [Incorrect file format 'wpspnt_blc_synch']SHOW FULL COLUMNS FROM wpspnt_blc_synch;
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']SHOW INDEX FROM `wpspnt_blc_synch`;
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']ALTER TABLE `wpspnt_blc_synch` ADD COLUMN `container_id` int(20) unsigned NOT NULL
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']ALTER TABLE `wpspnt_blc_synch` ADD COLUMN `container_type` varchar(40) NOT NULL
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']ALTER TABLE `wpspnt_blc_synch` ADD COLUMN `synched` tinyint(2) unsigned NOT NULL
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']ALTER TABLE `wpspnt_blc_synch` ADD COLUMN `last_synch` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']ALTER TABLE `wpspnt_blc_synch` ADD PRIMARY KEY (`container_type`, `container_id`)
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']ALTER TABLE `wpspnt_blc_synch` ADD KEY `synched` (`synched`)
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']DELETE synch.*
FROM wpspnt_blc_synch AS synch
WHERE
synch.container_type NOT IN ('comment', 'post', 'page', 'dummy')
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']DELETE instances.*
FROM
wpspnt_blc_instances AS instances LEFT JOIN wpspnt_blc_synch AS synch
ON instances.container_type = synch.container_type AND instances.container_id = synch.container_id
WHERE
synch.container_id IS NULL
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']DELETE synch.*
FROM
wpspnt_blc_synch AS synch LEFT JOIN wpspnt_comments AS comments
ON comments.comment_ID = synch.container_id
WHERE
synch.container_type = 'comment'
AND (comments.comment_ID IS NULL OR comments.comment_approved <> '1')
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']INSERT INTO wpspnt_blc_synch(container_id, container_type, synched)
SELECT comment_ID, 'comment', 0
FROM
wpspnt_comments AS comments LEFT JOIN wpspnt_blc_synch AS synch
ON (synch.container_id = comments.comment_ID and synch.container_type='comment')
WHERE
comments.comment_approved = '1'
AND synch.container_id IS NULL
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']DELETE synch.* FROM wpspnt_blc_synch AS synch WHERE synch.container_id NOT IN ('9315', '9289', '8689', '8451', '7985', '7931', '7902', '7623', '5019', '4407', '4381', '4344', '4310', '4123', '4124', '4125', '4126', '4122', '4024', '4023', '4019', '4017', '4018', '4020', '4021', '4009', '4008', '4007', '4006', '4010', '4011', '4012', '4013', '4014', '4015', '4016', '3988', '3986', '3951', '3930', '3929', '3928', '3931', '3915', '3913', '3912', '3906', '3835', '3413', '3403', '3380', '3344', '3321', '3303', '3170', '3169', '3168', '3154', '3137', '3125', '3116', '3101', '3098', '2994', '2965', '2942', '2890', '2862', '2790', '2639', '2621', '2274', '2259', '1773', '1686', '1673', '1663', '1653', '1615', '1605', '1335', '1180', '1173', '1137', '1124', '1113', '1103', '1098', '1081', '1045', '1006', '953', '916', '900', '843', '800', '782', '752', '693', '561', '526', '20', '19', '18', '17', '14', '13', '12', '15', '2', '350', '349', '348', '7')
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']UPDATE
wpspnt_blc_synch AS synch
JOIN wpspnt_posts AS posts ON (synch.container_id = posts.ID and synch.container_type=posts.post_type)
SET
synched = 0
WHERE
synch.last_synch < posts.post_modified
WordPress database error: [Incorrect file format 'wpspnt_blc_synch']INSERT INTO wpspnt_blc_synch(container_id, container_type, synched)
SELECT posts.id, posts.post_type, 0
FROM
wpspnt_posts AS posts LEFT JOIN wpspnt_blc_synch AS synch
ON (synch.container_id = posts.ID and synch.container_type=posts.post_type)
WHERE
posts.post_status IN ('publish')
AND posts.post_type IN ('post', 'page')
AND synch.container_id IS NULL