Re: [irm-discuss] MDB Error

[<bud...@bu...>]

On Tue, Sep 05, 2006 at 01:43:19PM -0300, Kevin MacDonald wrote:
> Hello,
>  
> 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.
>  
> 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=computers.ID,\n\t\t\t\t    tracking_status\n\t\t\t\tWHERE (tracking_status.closed = 0)\n  \t\t\t\t\tAND (tracking_status.status=tracking.status)\n  \t\t\t\t\tAND (tracking.assign = 'kevin')\n\t\t\t\tORDER BY tracking.date DESC [nativecode=1146]) in /usr/local/irm-1.5.7/lib/IRMDB.php on line 346, referer: http://191.168.217.3/irm/
>  
> 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