[OGo-Users] r2051 & tasks (Change Announcement!)

Adam Tauno Williams users@opengroupware.org
Fri, 16 Nov 2007 15:27:16 -0500


--=-6cSDIYq3XT45XHyPFzZh
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable


As of r2051 the Logic regarding jobs & tasks has changed somewhat.
Anyone having an OpenGroupware database that has been around for awhile
may be affected.  Previously some fields in the job table ("kind" &
"is_control_job")[1] caused records to be filtered out by Logic;  this
is no longer the case.   This means if such jobs exist in your database
they will now appear in WebUI and possibly other places if you update to
r0251 or later.

You can check your database with:
SELECT COUNT(*) FROM job=20
WHERE ((kind IS NOT NULL) OR (is_control_job =3D 1))

If the COUNT(*) is 0 then you are all set.   Otherwise you probably want
to purge these records from your database; after backing up, of course.

For more information:
http://svn.opengroupware.org/viewcvs?rev=3D2050&view=3Drev
http://svn.opengroupware.org/viewcvs?rev=3D2051&view=3Drev
http://www.opengroupware.org/changeblogger/200711.html (Nov. 14th)
http://mail.opengroupware.org/pipermail/developer/2007-November/003236.html=
=20

[1] These fields were used by a now defunct application.

--=-6cSDIYq3XT45XHyPFzZh
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)

iD8DBQBHPf0kLRePpNle04MRAhgzAJ9Qygk4p9Wis5isYcOTm6mJUAN/hwCeK+v9
Ea7MQvbVWcTcDCnXHRvu930=
=EnSF
-----END PGP SIGNATURE-----

--=-6cSDIYq3XT45XHyPFzZh--