Re: [irm-discuss] MDB Error

[Kevin M. <kma...@he...>]

Ok,
=20
Thanks for the input. I'll try that.
=20
Kevin

________________________________

From: irm...@li... on behalf of =
bud...@bu...
Sent: Wed 9/6/2006 4:32 PM
To: irm...@li...
Subject: Re: [irm-discuss] MDB Error



On Tue, Sep 05, 2006 at 01:43:19PM -0300, Kevin MacDonald wrote:
> Hello,
>=20
> I've upgraded my irm-1.4 to the irm-1.5.7 version. All went well for =
this as I could see the old data in the new version of irm and I could =
access all information. Now I seem to be getting this error when I =
access irm.
>=20
> PHP Fatal error:  Database Error: MDB Error: no such table (SELECT =
tracking.ID\n\t\t\t\tFROM tracking LEFT JOIN computers\n\t\t\t\t\tON =
tracking.computer=3Dcomputers.ID,\n\t\t\t\t    =
tracking_status\n\t\t\t\tWHERE (tracking_status.closed =3D 0)\n  =
\t\t\t\t\tAND (tracking_status.status=3Dtracking.status)\n  =
\t\t\t\t\tAND (tracking.assign =3D 'kevin')\n\t\t\t\tORDER BY =
tracking.date DESC [nativecode=3D1146]) in =
/usr/local/irm-1.5.7/lib/IRMDB.php on line 346, referer: =
http://191.168.217.3/irm/
>=20
> Thanks for any help,

Ok one of the tables is missing in your database.

Unfortunately we don't know which one.


What I would do would be to set up a brand new copy of IRM for
comparison.

Then do a schema dump (phpmyadmin is your friend) for the new db and
your old upgraded db.

Then do a diff and see which table is missing.

Regards

Martin Stevens


-------------------------------------------------------------------------=

Using Tomcat but need to do more? Need to support web services, =
security?
Get stuff done quickly with pre-integrated technology to make your job =
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache =
Geronimo
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
121642
_______________________________________________
irm-discuss mailing list
irm...@li...
https://lists.sourceforge.net/lists/listinfo/irm-discuss