Issue with bugzilla

I only noticed now, but all comments to the bug reports before the migration
have (supposedly) been lost. Or at least, they don't display. From bug 801 on,
the comments display again. I'm assuming they ended up in the wrong table or
so. We'll have to figure this out.

Peter

Issue with bugzilla

On Tuesday 22 February 2011 17:05:30 Peter Soetens wrote:
> I only noticed now, but all comments to the bug reports before the
> migration have (supposedly) been lost. Or at least, they don't display.
> From bug 801 on, the comments display again. I'm assuming they ended up in
> the wrong table or so. We'll have to figure this out.

An update here. The missing tables are 'longdescs' (which was not copied at
all) and 'bugs_fulltext' which has 'NULL' contents in its 'comments' field.

The migration already failed at the first step: the importing of the original
.txt tables in the pgsql server failed, this could be caused by an encoding
problem, I don't know yet.

Peter

Issue with bugzilla

On Wednesday 23 February 2011 11:14:11 Peter Soetens wrote:
> On Tuesday 22 February 2011 17:05:30 Peter Soetens wrote:
> > I only noticed now, but all comments to the bug reports before the
> > migration have (supposedly) been lost. Or at least, they don't display.
> > From bug 801 on, the comments display again. I'm assuming they ended up
> > in the wrong table or so. We'll have to figure this out.
>
> An update here. The missing tables are 'longdescs' (which was not copied at
> all) and 'bugs_fulltext' which has 'NULL' contents in its 'comments' field.
>
> The migration already failed at the first step: the importing of the
> original .txt tables in the pgsql server failed, this could be caused by
> an encoding problem, I don't know yet.

Yep, original database was in SQL_ASCII, while I created one in UTF-8. I have
restored the old database and migrated it to mysql/Bugzilla3.6.3. I will now
merge the two databases, so please don't report/update any bugs for now.

Peter

Issue with bugzilla

On Wednesday 23 February 2011 13:28:46 Peter Soetens wrote:
> On Wednesday 23 February 2011 11:14:11 Peter Soetens wrote:
> > On Tuesday 22 February 2011 17:05:30 Peter Soetens wrote:
> > > I only noticed now, but all comments to the bug reports before the
> > > migration have (supposedly) been lost. Or at least, they don't display.
> > > From bug 801 on, the comments display again. I'm assuming they ended up
> > > in the wrong table or so. We'll have to figure this out.
> >
> > An update here. The missing tables are 'longdescs' (which was not copied
> > at all) and 'bugs_fulltext' which has 'NULL' contents in its 'comments'
> > field.
> >
> > The migration already failed at the first step: the importing of the
> > original .txt tables in the pgsql server failed, this could be caused by
> > an encoding problem, I don't know yet.
>
> Yep, original database was in SQL_ASCII, while I created one in UTF-8. I
> have restored the old database and migrated it to mysql/Bugzilla3.6.3. I
> will now merge the two databases, so please don't report/update any bugs
> for now.

The migration is complete. If you see something fishy, let us know. One thing
we didn't restore are the email settings of the users that created their
account on bugs.orocos.org. If you changed anything there, you need to re-make
that change.

Peter