×

 

Home Contact Us Payments SC Commerce SC Commerce Docs SC Commerce Snippets

Simply Computing

We make websites. Simple.

Update Database Table Prefix

When activating SC Commerce, some new SQL tables are added in your database. But this process can fail sometimes if the SQL tables prefix is too long: the table name can’t contain more than 64 characters.

This can cause a known issue where a customer who purchases a downloadable product finds the Complete Order Email doesn’t contain any download link for the purchased products.

The SQL Table prefix is defined during the CMS installation process, and is stored in the file called wp-config.php.

How to solve the issue?

To solve this issue, there’s only one solution: renaming the SQL table prefix.

You can search for a plugin to do this for you, or you can do it manually.

If you want to do it yourself, you need to rename all tables names using a tool like phpMyAdmin, reduce the table’s prefix, and update the prefix value in wp-config.php. When you’ve done this, deactivate SC Commerce and re-activate it. Don’t worry you won’t lose any data, and re-enabling SC Commerce should force it to create missing SQL tables.

Please create a backup of your database and of your site before doing such actions.