cacti.mac_track_ports doesn't exist

Support questions about the MAC Track plugin

Moderators: Developers, Moderators

Post Reply
sd3m0n
Posts: 3
Joined: Tue Dec 29, 2015 1:25 am

Re: cacti.mac_track_ports doesn't exist

Post by sd3m0n »

sd3m0n wrote: ↑Mon Feb 22, 2021 3:34 am Hi,

I have the same issue: Error: Table 'cacti.mac_track_ports' doesn't exist

Cacti 1.2.16, MariaDB 10.3, Debian 10.7
This messages appeared in logs after plugin installation:

Code: Select all

2021-02-23 15:49:43 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[655]:plugin_mactrack_install(), /plugins/mactrack/setup.php[48]:mactrack_setup_table_new(), /plugins/mactrack/setup.php[217]:mactrack_setup_database(), /plugins/mactrack/includes/database.php[918]:api_plugin_db_table_create(), /lib/plugins.php[472]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2021-02-23 15:49:43 - CMDPHP ERROR: A DB Exec Failed!, Error: Invalid default value for 'port_number'
2021-02-23 15:49:43 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[655]:plugin_mactrack_install(), /plugins/mactrack/setup.php[48]:mactrack_setup_table_new(), /plugins/mactrack/setup.php[217]:mactrack_setup_database(), /plugins/mactrack/includes/database.php[811]:api_plugin_db_table_create(), /lib/plugins.php[472]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2021-02-23 15:49:43 - CMDPHP ERROR: A DB Exec Failed!, Error: Invalid default value for 'port_number'
2021-02-23 15:49:43 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[655]:plugin_mactrack_install(), /plugins/mactrack/setup.php[48]:mactrack_setup_table_new(), /plugins/mactrack/setup.php[217]:mactrack_setup_database(), /plugins/mactrack/includes/database.php[737]:api_plugin_db_table_create(), /lib/plugins.php[472]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2021-02-23 15:49:43 - CMDPHP ERROR: A DB Exec Failed!, Error: Invalid default value for 'port_number'
2021-02-23 15:49:43 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[655]:plugin_mactrack_install(), /plugins/mactrack/setup.php[48]:mactrack_setup_table_new(), /plugins/mactrack/setup.php[217]:mactrack_setup_database(), /plugins/mactrack/includes/database.php[494]:api_plugin_db_table_create(), /lib/plugins.php[472]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2021-02-23 15:49:43 - CMDPHP ERROR: A DB Exec Failed!, Error: Invalid default value for 'port_number'
I've resolved the issue by correcting default values in the /plugins/mactrack/includes/database.php (the default value '' for the int port_number is incorrect). After that plugin was successfully installed and is working now.
Top
zooq
Posts: 2
Joined: Thu Feb 25, 2021 8:50 am

Re: cacti.mac_track_ports doesn't exist

Post by zooq »

sd3m0n wrote: ↑Wed Feb 24, 2021 9:18 am
sd3m0n wrote: ↑Mon Feb 22, 2021 3:34 am Hi,

I have the same issue: Error: Table 'cacti.mac_track_ports' doesn't exist

Cacti 1.2.16, MariaDB 10.3, Debian 10.7
This messages appeared in logs after plugin installation:

Code: Select all

2021-02-23 15:49:43 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[655]:plugin_mactrack_install(), /plugins/mactrack/setup.php[48]:mactrack_setup_table_new(), /plugins/mactrack/setup.php[217]:mactrack_setup_database(), /plugins/mactrack/includes/database.php[918]:api_plugin_db_table_create(), /lib/plugins.php[472]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2021-02-23 15:49:43 - CMDPHP ERROR: A DB Exec Failed!, Error: Invalid default value for 'port_number'
2021-02-23 15:49:43 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[655]:plugin_mactrack_install(), /plugins/mactrack/setup.php[48]:mactrack_setup_table_new(), /plugins/mactrack/setup.php[217]:mactrack_setup_database(), /plugins/mactrack/includes/database.php[811]:api_plugin_db_table_create(), /lib/plugins.php[472]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2021-02-23 15:49:43 - CMDPHP ERROR: A DB Exec Failed!, Error: Invalid default value for 'port_number'
2021-02-23 15:49:43 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[655]:plugin_mactrack_install(), /plugins/mactrack/setup.php[48]:mactrack_setup_table_new(), /plugins/mactrack/setup.php[217]:mactrack_setup_database(), /plugins/mactrack/includes/database.php[737]:api_plugin_db_table_create(), /lib/plugins.php[472]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2021-02-23 15:49:43 - CMDPHP ERROR: A DB Exec Failed!, Error: Invalid default value for 'port_number'
2021-02-23 15:49:43 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[655]:plugin_mactrack_install(), /plugins/mactrack/setup.php[48]:mactrack_setup_table_new(), /plugins/mactrack/setup.php[217]:mactrack_setup_database(), /plugins/mactrack/includes/database.php[494]:api_plugin_db_table_create(), /lib/plugins.php[472]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2021-02-23 15:49:43 - CMDPHP ERROR: A DB Exec Failed!, Error: Invalid default value for 'port_number'
I've resolved the issue by correcting default values in the /plugins/mactrack/includes/database.php (the default value '' for the int port_number is incorrect). After that plugin was successfully installed and is working now.
Hi, I have the same issue, can you explian more about the solution, in wich line and what is the correct value? thanx
Top
zooq
Posts: 2
Joined: Thu Feb 25, 2021 8:50 am

Re: cacti.mac_track_ports doesn't exist

Post by zooq »

zooq wrote: ↑Thu Feb 25, 2021 8:54 am
sd3m0n wrote: ↑Wed Feb 24, 2021 9:18 am
sd3m0n wrote: ↑Mon Feb 22, 2021 3:34 am Hi,

I have the same issue: Error: Table 'cacti.mac_track_ports' doesn't exist

Cacti 1.2.16, MariaDB 10.3, Debian 10.7
This messages appeared in logs after plugin installation:

Code: Select all

2021-02-23 15:49:43 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[655]:plugin_mactrack_install(), /plugins/mactrack/setup.php[48]:mactrack_setup_table_new(), /plugins/mactrack/setup.php[217]:mactrack_setup_database(), /plugins/mactrack/includes/database.php[918]:api_plugin_db_table_create(), /lib/plugins.php[472]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2021-02-23 15:49:43 - CMDPHP ERROR: A DB Exec Failed!, Error: Invalid default value for 'port_number'
2021-02-23 15:49:43 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[655]:plugin_mactrack_install(), /plugins/mactrack/setup.php[48]:mactrack_setup_table_new(), /plugins/mactrack/setup.php[217]:mactrack_setup_database(), /plugins/mactrack/includes/database.php[811]:api_plugin_db_table_create(), /lib/plugins.php[472]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2021-02-23 15:49:43 - CMDPHP ERROR: A DB Exec Failed!, Error: Invalid default value for 'port_number'
2021-02-23 15:49:43 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[655]:plugin_mactrack_install(), /plugins/mactrack/setup.php[48]:mactrack_setup_table_new(), /plugins/mactrack/setup.php[217]:mactrack_setup_database(), /plugins/mactrack/includes/database.php[737]:api_plugin_db_table_create(), /lib/plugins.php[472]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2021-02-23 15:49:43 - CMDPHP ERROR: A DB Exec Failed!, Error: Invalid default value for 'port_number'
2021-02-23 15:49:43 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[655]:plugin_mactrack_install(), /plugins/mactrack/setup.php[48]:mactrack_setup_table_new(), /plugins/mactrack/setup.php[217]:mactrack_setup_database(), /plugins/mactrack/includes/database.php[494]:api_plugin_db_table_create(), /lib/plugins.php[472]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2021-02-23 15:49:43 - CMDPHP ERROR: A DB Exec Failed!, Error: Invalid default value for 'port_number'
I've resolved the issue by correcting default values in the /plugins/mactrack/includes/database.php (the default value '' for the int port_number is incorrect). After that plugin was successfully installed and is working now.
Hi, I have the same issue, can you explian more about the solution, in wich line and what is the correct value? thanx
OK, resolved, I have just changed the default type of port_number from '' to '0' in all of this lines : $data['columns'][] = array('name' => 'port_number', 'type' => 'int(10)', 'unsigned' => true, 'NULL' => false, 'default' => '');
Top
Post Reply

Return to “Plugin: (MAC Track)”

Who is online

Users browsing this forum: No registered users and 0 guests