Routerbackup plugin error (see log)

[Cornel]

I get this error when I try to add anything, a new user, new device, anything. I try to add new device/user/etc, and nothing happens. I tried to search the forums but nothing came up for this.
Could anyone please please help me?

07/17/2014 09:00:56 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_devices"
07/17/2014 09:00:56 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_devices ORDER BY hostname limit 0, 30"

07/17/2014 09:07:11 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_accounts"
07/17/2014 09:07:11 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_accounts limit 0, 30"
07/17/2014 09:07:11 AM - CMDPHP: Poller[0] ERROR: SQL Save Command Failed for Table 'plugin_routerconfigs_accounts'. Error was 'Table 'cacti.plugin_routerconfigs_accounts' doesn't exist'
07/17/2014 09:06:54 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_accounts"
07/17/2014 09:06:54 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_accounts limit 0, 30"
07/17/2014 09:06:52 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_devices"
07/17/2014 09:06:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_devices ORDER BY hostname limit 0, 30"

[cigamit]

I take it you didn't import the sql file for the router configs plugin.

[Cornel]

I take it you didn't import the sql file for the router configs plugin.

I thought I followed the instructions on the plugins directory. How do I import the sql file?
Thanks...

[Cornel]

I take it you didn't import the sql file for the router configs plugin.

Never mind. I found another thread that showed about the sql import and was able to import it.
THANK YOU AGAIN...

[Cornel]

I take it you didn't import the sql file for the router configs plugin.

OK I did run the SQL import command, but when I try to do backups, I still don't work. I was able to get all the IDs, devices, etc.
This is what I get from the log:

07/17/2014 09:31:51 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "
07/17/2014 09:31:51 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "
07/17/2014 09:31:14 PM - SYSTEM THOLD STATS: Time:36.4537 Tholds:3 TotalHosts:36 DownHosts:3 NewDownHosts:0
07/17/2014 09:30:38 PM - SYSTEM STATS: Time:37.0850 Method:cmd.php Processes:1 Threads:N/A Hosts:37 HostsPerProcess:37 DataSources:2563 RRDsProcessed:1297
07/17/2014 09:30:35 PM - CMDPHP: Poller[0] Host[43] NOTICE: HOST EVENT: Host Returned from DOWN State:
07/17/2014 09:25:39 PM - SYSTEM THOLD STATS: Time:0.0329 Tholds:3 TotalHosts:36 DownHosts:3 NewDownHosts:0
07/17/2014 09:25:39 PM - SYSTEM STATS: Time:37.9872 Method:cmd.php Processes:1 Threads:N/A Hosts:37 HostsPerProcess:37 DataSources:2563 RRDsProcessed:1297
07/17/2014 09:21:25 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "
07/17/2014 09:21:20 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "
07/17/2014 09:21:20 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "

[Cornel]

I take it you didn't import the sql file for the router configs plugin.

OK I was able to get further with some help from forums threads. Here is the latest I get:
Cacti Log:
07/17/2014 10:36:17 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_devicetypes WHERE id = 0"

When I try to run it from sql CLI, I get this:
mysql> SELECT * FROM plugin_routerconfigs_devicetypes WHERE id = 0
-> SELECT * FROM plugin_routerconfigs_devicetypes WHERE id = 0;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM plugin_routerconfigs_devicetypes WHERE id = 0' at line 2

These are the tables I have:
plugin_routerconfigs_accounts |
| plugin_routerconfigs_backups |
| plugin_routerconfigs_devices |

What do I need to do to get this to work?
Thanks...

[Cornel]

Database changed
mysql> SELECT * FROM plugin_routerconfigs_backups WHERE id =;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql>

[Cornel]

I take it you didn't import the sql file for the router configs plugin.

Question:
I see in the updates of the route config in plugins directory that it states in 0.2 you added support for SSH. Is that correct? Does the plugin use ssh? All our equipment has telnet turned off, we ONLY use SSH.
Thanks...

[sharekhan]

07/15/2016 05:21:33 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "
07/15/2016 05:21:33 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "
07/15/2016 05:21:18 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_devicetypes WHERE id = 0"
07/15/2016 05:20:16 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "
07/15/2016 05:20:16 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "
07/15/2016 05:20:03 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "
07/15/2016 05:20:03 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "
07/15/2016 05:19:43 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_devicetypes WHERE id = 0"

i have disable the telnet from device and only enable SSH.