SimonTech Development
  • Contact Us
  • Request Quote
  • Consulting
      • Back
      • CMS Strategy
      • Custom Development
      • Server Management
      • Integrated Automation
  • Development & Design
      • Back
      • Joomla CMS
      • WordPress CMS
      • Custom Application Development
      • Marketing Automation
  • Website Maintenance
      • Back
      • Managed Cloud Hosting
      • CMS Maintenance
      • Site Security Mitigation
      • Backup, Repair & Restore
  • Plans & Pricing
  • Support
Account
Please wait, authorizing ...
Not a member? Sign up now
×

Knowledge Base

SalesPro

Timeout and variants_map' doesn't exist errors

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.

  • Services
  • Support Tickets
  • Knowledge Base
  • Extensions and Releases
  • Contact Us
Facebook LinkedIn Twitter Github
  • Terms & Conditions
  • Privacy Policy
© 2008 - 2025 SimonTech Development