SQL – ERROR tipam_network

If this error happens on the top of the screen:

('ALTER TABLE `tipam_network` ADD COLUMN `name_network` varchar(255) default '';') in /var/www/html/pandora_console/include/functions_db.php

Check what information you have in the database using the following SQL query:

 SELECT * FROM tconfig WHERE token = "ipam_installed"\G;

If the information returned by the SQL query is as follows:

mysql> SELECT * FROM tconfig WHERE token = "ipam_installed"\G;
******************************* 1. row *****************************
id_config: 280
token: ipam_installed
value: 3
******************************* 2nd row *************************
id_config: 3560
token: ipam_installed
value: 2
2 rows in set (0.01 sec)

To solve this error, you must remove the token repeated with the lowest value (since the correct value is 3).

To remove the token:

DELETE FROM tconfig WHERE id_config = "3560";