Database errors...

[Jerry Coleman]

Blade,

I've just installed the router traffice monitor plug-in and I'm having trouble getting it setup. I have a WRT54G and I'm using Hyperwrt. I'm using HS 2.0.2020.0. Any suggestions as to why I'm getting this error???

Thanks for your help,
Jerry


<TABLE cellSpacing=2 cellPadding=0 width="100%" border=0><TBODY><TR><TD class=LOGDateTime0 noWrap align=left>11/28/2005 6:33:56 AM </TD><TD class=LOGType0 align=left colSpan=3>Router Traffic Monitor Error </TD><TD class=LOGEntry0 align=left colSpan=8>DatabaseFunctions.PerformDatabaseMultiSelect(): An error has occurred during database select query: ERROR [42S02] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'tblComputers'. Make sure it exists and that its name is spelled correctly.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>11/28/2005 6:33:56 AM </TD><TD class=LOGType1 align=left colSpan=3>Router Traffic Monitor Error </TD><TD class=LOGEntry1 align=left colSpan=8>DatabaseFunctions.PerformDatabaseMultiSelect(): DatabasePathAndName: C:\Program Files\HomeSeer 2\Data\RouterTrafficMonitor\RouterTrafficMonitor.mdb</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>11/28/2005 6:33:56 AM </TD><TD class=LOGType0 align=left colSpan=3>Router Traffic Monitor Error </TD><TD class=LOGEntry0 align=left colSpan=8>DatabaseFunctions.PerformDatabaseMultiSelect(): connString: DSN=RouterTrafficMonitor</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>11/28/2005 6:33:56 AM </TD><TD class=LOGType1 align=left colSpan=3>Router Traffic Monitor Error </TD><TD class=LOGEntry1 align=left colSpan=8>DatabaseFunctions.PerformDatabaseMultiSelect(): selectQueryString: SELECT txtName,txtIPAddress FROM tblComputers ORDER BY txtIPAddress</TD></TR></TBODY></TABLE>

[Blade]

Hi Jerry

It sounds like you are missing the tblComputers table. Not sure how that is.

Try going into Microsoft Access and create a query and execute this SQL from the query. This will create the tblComputers table

CREATE TABLE tblComputers (txtIPAddress TEXT(20) Constraint txtIPAddress Primary Key, txtName TEXT(40) NOT NULL, txtLocation TEXT(60), txtMacAddress TEXT(25), txtOnImage TEXT(100), txtOffImage TEXT(100), txtCustom TEXT(5) NOT NULL, txtEmailNotify TEXT(5) NOT NULL, txtPingFailures TEXT(5) NOT NULL )


Let me know if this fixes the issue.

[Blade]

Jerry,

Did you get this resolved?

[Jerry Coleman]

I haven't had a chance to get into it, but I thought I would take the .mdb file out of the zip file and install it over the other one. That should work okay.

Thanks for asking.

Jerry