Only the WCS column is updated properly because the filename has an extra .fits on the end.
UPDATE photlco SET WCS=0 WHERE filename='tfn0m419-sq32-20240206-0184-e91.fits'
UPDATE photlco SET psf='X' WHERE filename='tfn0m419-sq32-20240206-0184-e91.fits.fits'
UPDATE photlco SET psfmag=9999 WHERE filename='tfn0m419-sq32-20240206-0184-e91.fits.fits'
UPDATE photlco SET apmag=9999 WHERE filename='tfn0m419-sq32-20240206-0184-e91.fits.fits'
UPDATE photlco SET mag=9999 WHERE filename='tfn0m419-sq32-20240206-0184-e91.fits.fits'
Only the WCS column is updated properly because the filename has an extra .fits on the end.