Am 27.07.2017 um 19:12 schrieb Mikael Nordfeldth: > On 2017-07-19 18:29, Michael Vogel wrote: >> I executed the query by hand that showed me the 4 long file entries with >> duplicates. Then I simply deleted the duplicate entries, then it skipped >> that part after I executed the upgrade script again. >> >> The problem has to be the query that fetches all entries that are >> duplicates - although this query looks fine to me. > Thank you for being so proficient with the necessary tools and knowledge > to do this kind of thing. .)
No problem. Since I'm one of the core developers of Friendica (which is also written in PHP) I should be able to basically understand these things ;-) > I will surely check if I can reproduce this and whether the algorithm is > peculiar somewhere. Maybe some weird behaviour with PEAR::DB that > fetches unexpected entries. I can imagine that it is maybe some casting problem that leads to an empty string in the query with the "like". I hadn't got time to analyze this in details because the server is productive and I have got several users on it. But I still have a database backup that I could use for tests. > As I understand it seemed to solve itself (by not executing) when you > removed the extraneous entries manually? Yeah, exactly. I had a look at the first query that searched for duplicates. I executed that query by hand in the mysql console and simply removed the duplicates by hand. Not very elegant, but working ;-) Michael
signature.asc
Description: OpenPGP digital signature
