Re: [Social-discuss] Upgrading from Statusnet to GNU Social - when can users work with it?

[Michael Vogel]

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