Knowledge Base

Details

Parent Category: Knowledge base

Category: SalesPro

Are you experiencing the error of: '#__spr_item_variants_map' doesn't exist ?

It may look a lot like this, with default Joomla deployment settings:

Table 'joomla.jos_spr_item_variants_map' doesn't exist

Well the issues lies in the installation of SalesPro components SQL query where this Table is created:

CREATE TABLE IF NOT EXISTS `#__spr_item_variants_map` (
`variant_id` int(11) NOT NULL,
`attribute` int(11) NOT NULL,
`attribute_value` int(11) NOT NULL,
UNIQUE KEY `item_id_2` (`variant_id`,`attribute`,`attribute_value`),
KEY `item_id` (`variant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8_unicode_ci;

This code should have had COLLATE=utf8mb4_unicode_ci

Since this was not the case in SQL, even upon download of the latest version of SalesPro 1.1.8 the table got skipped during installation.

To fix this bug, go to you phpMyAdmin and run the following SQL query to create the correct type of table:

 

CREATE TABLE IF NOT EXISTS `#__spr_item_variants_map` (
`variant_id` int(11) NOT NULL,
`attribute` int(11) NOT NULL,
`attribute_value` int(11) NOT NULL,
UNIQUE KEY `item_id_2` (`variant_id`,`attribute`,`attribute_value`),
KEY `item_id` (`variant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

 

 Make sure to replace the first 2 letters of the table name #_ with your database table prefix before excuting or just rename the table after excuting.