[phpBT-dev] Trouble with database incompatibility..

[Florian K. <Flo...@in...>]

(changed the topic)
I found that these defines are in the table phpbt_configuration,
and that I am missing some of these.
The function 'upgrade' in upgrade.php defines these.

How can I upgrade without logging in?

So I started patching my database manually (ugh), like this:
INSERT INTO phpbt_configuration VALUES ('BUG_REOPENED',    '4', 'The =
status
to assign a bug when it is reopened.', 'multi');

Now having these 'defines' I get this when I try to log in:

DB Error: no such field
select saved_queries from phpbt_user_pref where user_id=3D'1'
[nativecode=3DORA-00904: invalid column name ]

Looks like I need to drop my database???
Or will we be able to write an sql-patch?

Florian

> -----Original Message-----
> From: Jirka Pech [mailto:fi...@us...]
> Sent: Wednesday, September 04, 2002 9:24 AM
> To: php...@li...
> Subject: Re: [phpBT-dev] Could someone help fix the Oracle-SQL stuff?
>=20
>=20
> > First of all, I think there is a comma too much after the=20
> second 'sum'.
> > If I fix that, it gives me the following:
> >
> > DB Error: no such field
> > SELECT sum(decode( s.status_id, BUG_UNCONFIRMED, 1, BUG_PROMOTED, =
1,
> > BUG_ASSIGNED, 1, BUG_REOPENED, 1, 0 )), sum(decode( s.status_id,
> > BUG_UNCONFIRMED, 0, BUG_PROMOTED, 0, BUG_ASSIGNED, 0,=20
> BUG_REOPENED, 0, 1 ))
> > from phpbt_bug b, phpbt_status s where b.status_id =3D=20
> s.status_id (+) and
> > b.assigned_to =3D 1 [nativecode=3DORA-00904: invalid column name ]
> >
> > If I pretty print that in SQL*Plus Worksheet, I get:
> > SELECT
> > sum(decode(s.status_id,
> >   BUG_UNCONFIRMED, 1,
> >   BUG_PROMOTED,    1,
> >   BUG_ASSIGNED,    1,
> >   BUG_REOPENED,    1,
> >   0 )),
> > sum(decode(s.status_id,
> >   BUG_UNCONFIRMED, 0,
> >   BUG_PROMOTED,    0,
> >   BUG_ASSIGNED,    0,
> >   BUG_REOPENED,    0,
> >   1 ))
> > from phpbt_bug b, phpbt_status s where b.status_id =3D=20
> s.status_id (+) and
> > b.assigned_to =3D 1;
> >
> > Where the error is:
> >   BUG_REOPENED,    0,
> >   *
> > FEHLER in Zeile 12:
>=20
> This means error on line 12? I hope so.
>=20
> > ORA-00904: Ung=FCltiger Spaltenname (invalid column name)
>=20
> ORACLE doesn't know BUG_REOPENED column.
>=20
> > Any hints on how to fix it?
>=20
> What DECODE does is that it takes at least three parameters:=20
> DECODE (haystack,=20
> needle_1, value_1, ... , needle_n, value_n, value_when_null),
> where needle_X is value, which must be found in the haystack=20
> column and when=20
> it is, DECODE will replace this value with value_X. Other=20
> parameters are self=20
> explanatory.
>=20
> phpbt_status.status_id is a number, so I actually don't know=20
> why there is a=20
> DECODE function used, replacing constants with numbers.
>=20
> I hope you will be able to repair this, because I have no=20
> time to look on it.
>=20
> Have a nice day!
> Jirka Pech
>=20
>=20
>=20
> -------------------------------------------------------
> This sf.net email is sponsored by: OSDN - Tired of that same old
> cell phone?  Get a new here for FREE!
> https://www.inphonic.com/r.asp?r=3Dsourceforge1&refcode1=3Dvs3390
> _______________________________________________
> phpbt-dev mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpbt-dev
>=20