RE: [phpBT-dev] Trouble with database incompatibility..

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

I just noticed the oci8-case of the upgrade-function
does: nothing! ;(

Florian

> -----Original Message-----
> From: Florian Kolbe [mailto:Flo...@in...]
> Sent: Wednesday, September 04, 2002 9:54 AM
> To: 'php...@li...'
> Subject: [phpBT-dev] Trouble with database incompatibility..
>=20
>=20
> (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.
>=20
> How can I upgrade without logging in?
>=20
> So I started patching my database manually (ugh), like this:
> INSERT INTO phpbt_configuration VALUES ('BUG_REOPENED',   =20
> '4', 'The status
> to assign a bug when it is reopened.', 'multi');
>=20
> Now having these 'defines' I get this when I try to log in:
>=20
> DB Error: no such field
> select saved_queries from phpbt_user_pref where user_id=3D'1'
> [nativecode=3DORA-00904: invalid column name ]
>=20
> Looks like I need to drop my database???
> Or will we be able to write an sql-patch?
>=20
> Florian
>=20
> > -----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=20
> 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,=20
> 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
>=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