Found some duplicate filename entries in our schedule page remote database. PB found that these were due to some files with filenames beginning with a carriage return - ASCII 13 -
and he found there were 144 such duplicated files.
and he found there were 144 such duplicated files.
I found that these had been added in the early days - double digit index numbers - and so could be deleted - did
SELECT * FROM `name_of_table` where LEFT (fileName, 1) = '\r'
and then deleted all those 141 records using the phpmyadmin interface.
No comments:
Post a Comment