View Issue Details

IDProjectCategoryView StatusLast Update
2081RackTablesdefaultpublic2024-03-12 21:53
ReporterJose Luis Le Vraux Assigned To 
PriorityhighSeverityfeatureReproducibilityalways
Status newResolutionopen 
Platformdebian 11OSdebian 11OS Versiondebian 11
Product Version0.22.0 
Summary2081: RackTables installation: step 5 of 7
Descriptionhttp://localhost/racktables/wwwroot/?module=installer

RackTables installation: step 5 of 7
Your database is already holding 74 tables, so I will stop here and let you check it yourself.
There is some important data there probably.

borre la base y la cree de nuevo, borre las tablas probe varias formas, pero siempre quedo en el paso 5 de 7, las tablas se crean automaticamente
Additional InformationMariaDB [racktables_db]> show tables
    -> ;
+---------------------------+
| Tables_in_racktables_db |
+---------------------------+
| Atom |
| Attribute |
| AttributeMap |
| AttributeValue |
| CachedPAV |
| CachedPNV |
| CachedPVM |
| Chapter |
| Config |
| Dictionary |
| EntityLink |
| File |
| FileLink |
| IPv4Address |
| IPv4Allocation |
| IPv4LB |
| IPv4Log |
| IPv4NAT |
| IPv4Network |
| IPv4RS |
| IPv4RSPool |
| IPv4VS |
| IPv6Address |
| IPv6Allocation |
| IPv6Log |
| IPv6Network |
| LDAPCache |
| Link |
| Location |
| Molecule |
| MountOperation |
| Object |
| ObjectHistory |
| ObjectLog |
| ObjectParentCompat |
| PatchCableConnector |
| PatchCableConnectorCompat |
| PatchCableHeap |
| PatchCableHeapLog |
| PatchCableOIFCompat |
| PatchCableType |
| Plugin |
| Port |
| PortAllowedVLAN |
| PortCompat |
| PortInnerInterface |
| PortInterfaceCompat |
| PortLog |
| PortNativeVLAN |
| PortOuterInterface |
| PortVLANMode |
| Rack |
| RackObject |
| RackSpace |
| RackThumbnail |
| Row |
| Script |
| TagStorage |
| TagTree |
| UserAccount |
| UserConfig |
| VLANDescription |
| VLANDomain |
| VLANIPv4 |
| VLANIPv6 |
| VLANSTRule |
| VLANSwitch |
| VLANSwitchTemplate |
| VLANValidID |
| VS |
| VSEnabledIPs |
| VSEnabledPorts |
| VSIPs |
| VSPorts |
+---------------------------+
74 rows in set (0,001 sec)
TagsNo tags attached.

Activities

Jose Luis Le Vraux

Jose Luis Le Vraux

2023-05-01 00:24

reporter  

index.php (10,033 bytes)   
index.php (10,033 bytes)   
Jose Luis Le Vraux

Jose Luis Le Vraux

2023-05-01 00:28

reporter   ~0004485

despues de presionar muchas veces RETRY aparece el siguiente mensaje en http://localhost/racktables/wwwroot/?module=installer

PDOException
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'innodb_test' already exists (42S01)
at file /var/www/html/racktables/wwwroot/inc/dictionary.php, line 46

/var/www/html/racktables/wwwroot/inc/dictionary.php:46 query()
/var/www/html/racktables/wwwroot/inc/install.php:357 isInnoDBSupported()
/var/www/html/racktables/wwwroot/inc/install.php:59 init_database_static()
/var/www/html/racktables/wwwroot/index.php:299 renderInstallerHTML()
Error info:
Array
(
    [0] => 42S01
    [1] => 1050
    [2] => Table 'innodb_test' already exists
)
Parameters:
GET
(array)
module installer
POST
(array)
step 5
COOKIE
(array)
Pycharm-3f5a1ac 0029b808-6642-4403-9d44-6c0439c81323
infrastation

infrastation

2023-05-01 00:42

administrator   ~0004487

I do not remember seeing such an error before. Could you post detailed steps to reproduce please?
buckyswider

buckyswider

2024-03-01 04:15

reporter   ~0004541

I encountered this very same issue installing on Ubuntu 22. It looks like the current installation script is trying to configure the database twice- once in step 2 (or maybe it was 3?- when I was asked to enter the database credentials) and again here in step 5. My workaround was to comment out the 7 lines in install.php:

# if (count ($tables))
#ji {
# echo 'Your database is already holding ' . count ($tables);
# echo ' tables, so I will stop here and let you check it yourself.
';
# echo 'There is some important data there probably.
';
# return FALSE;
# }

I was then able to proceed- I received pages and pages of errors trying to re-create the tables that already were created, but the installer allowed me to proceed, and everything seems to be working OK.

An alternate workaround would be to delete all 74 tables.
infrastation

infrastation

2024-03-12 21:53

administrator   ~0004545

As mentioned before, this bug needs the exact steps to reproduce. To the best of my understanding, the logic that guards pre-existing tables in the database has been in place for many years and always worked as intended.

Issue History

Date Modified Username Field Change
2023-05-01 00:24 Jose Luis Le Vraux New Issue
2023-05-01 00:24 Jose Luis Le Vraux File Added: index.php
2023-05-01 00:28 Jose Luis Le Vraux Note Added: 0004485
2023-05-01 00:42 infrastation Note Added: 0004487
2024-03-01 04:15 buckyswider Note Added: 0004541
2024-03-12 21:53 infrastation Note Added: 0004545