FLUX Bug after Page Copy

gistfile1.txt

###########
WORKING below
##########

## DO NOT ##
UPDATE tt_content 
SET tx_flux_parent = SUBSTRING(tx_flux_column, INSTR(tx_flux_column, ':') + 1) 
WHERE tx_flux_column != "" AND tx_flux_column IS NOT NULL AND tx_flux_parent IS NULL AND uid = 27

#######################
# After Page Copy!!
UPDATE tt_content
SET tx_flux_column = CONCAT(SUBSTRING_INDEX(tx_flux_column, ':' , 1),':',tx_flux_parent) 
WHERE tx_flux_column IS NOT NULL 
AND tx_flux_parent IS NOT NULL 
AND tx_flux_parent != 0 
AND PID = 29;
#######################


## UPDATE tx_flux_parent after flux extension update###
UPDATE tt_content 
SET tx_flux_parent = SUBSTRING(tx_flux_column, INSTR(tx_flux_column, ':') + 1) 
WHERE tx_flux_column != "" AND tx_flux_column IS NOT NULL AND tx_flux_parent IS NOT NULL AND tx_flux_parent != 0 AND pid = 28

## WORKS ##
SELECT uid,pid,tx_flux_column,tx_flux_parent  FROM tt_content WHERE tx_flux_column != "" AND tx_flux_column IS NOT NULL AND tx_flux_parent IS NULL