WHMCS Products Not Showing on Addon Configuration Screen

If you are trying to use one of our modules and you are unable to select from a list of available WHMCS products under the addon's configuration interface (e.g. Addons -> [Module Name] -> Add New Item), this usually indicates that there is a collation conflict between tables in your database or that the module table is missing from the database.


In order to correct this issue, please follow these steps:

1. Go into your WHMCS file structure and open the configuration.php file, located in the root of your WHMCS installation. 


2. Check to see if the following line exists:

$mysql_charset = 'utf8';



If it does, please confirm that the value entered is the correct charset for your database's collation. You can see a reference chart for charset values here.

If the value does not exist, please add it at the bottom of the file and ensure that the charset entered is the correct charset for your database's collation. 


3. Login to your MySQL database and confirm that the collation setting for the following tables, and table columns, match (depending on module):

WordPress Auto-Provision Module

mod_appprovisionwp
tblproducts
tbladdons

WHMCS Auto-Provision Module

mod_appprovisionwhmcs
tblproducts
tbladdons

Product Image Module

mod_productimage 
tblproducts
tbladdons
tblbundles
tbldomainpricing

Note: Be sure to check that both the table and table columns all have a matching collation value. We recommend modifying our "mod_" table to match your WHMCS installation, before attempting to modify the WHMCS tables.




4. Log back into WHMCS and go to (Setup -> Addon Modules ). Deactivate and reactivate the effected module and check to see if the issue is resolved. 

If you are still unable to resolve with the above steps, please submit a support ticket and include your WHMCS and WHM login details, so that we can address the issue further.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Upgrading from PHP 5.5 and Below to PHP 5.6/7.0

If you are currently running any of our WHMCS modules on PHP 5.5 and below and you need to...

Module Compatibility with PHP 7.1 and 7.2

While all of our WHMCS modules are compatible with PHP 7.1 and 7.2, at the present time you will...