[p4] p4dti + bugzilla 2.22 + MySQL 5.0

[Leo Zelevinsky]

Thanks very much for your reply!

Do you have any idea when this might happen? I need to decide whether
I should try to install p4dti as it is and just figure out the problem
myself (I'm pretty good with SQL) or wait until you get to it, or try
to get my 5.0 db downgraded to 4.1 (I'd hate to do that though).

What's the best way to stay on top of issues like that - I subscribed
to the p4dti mailing list - is that enough?

Thanks again!

On 8/2/06, Nick Barnes <Nick.Barnes at pobox.com> wrote:
> At 2006-08-01 21:52:29+0000, "Leo Zelevinsky" writes:
>
> > How painful is it to downgrade an existing MySQL 5.0 db to version
> > 4.1? I have already done some bugzilla setup work and would prefer not
> > to lose it. Is it possible to downgrade it and still keep the
> > database?
> >
> > Any chance 5.0 will become supported by p4dti?
>
> Yes, this is likely to happen in future.  I'm away on vacation at the
> moment, and don't have access to my notes on this subject, but as I
> recall there is a problem related to the SQL parsing in MySQL 5.x; one
> of the P4DTI's queries, which appears to be legitimate SQL and works
> fine in MySQL 3.22 and 4.x, triggers a syntax error in 5.0.
>
> MySQL 5.1 is still in beta and I don't suppose we'll support it until
> that changes.  But there's no deep fundamental reason why the P4DTI
> shouldn't work with MySQL 5.0, and it's on my list of things to work
> on.
>
> Nick Barnes
> P4DTI Project
> Ravenbrook Limited
>