Jump to content

Duplicate Configurable Options


Recommended Posts

Hey guys

View that after spending some time searching for somehow identical issue without any result, I thought that this thread could be the most closest one.

Strange situation: while switching currency, the configurable options are displayed twice. Switching back to another currency (3 -> EUR), the dropdown goes back to normal, displaying correct options, once at the time (ie: OS choice, extra IPs, control panel, extra RAM on dedi server). Using default product link (and default currency), all items are displayed twice.

Most probably the fix could be very simple but I really can't 'see' it ATM.

What am I missing? :?:

Link to comment
Share on other sites

What am I missing? :?:

it doesn't look like a template issue as even when you change the template, it still occurs... also, it doesn't seem to affect all products.. e.g some reseller products seem to work fine, but there is a problem with "Servere Dedicate Quad Core - Server Dedicat QC 2"... i'm seeing the configuration options displaying twice.


my advice would be to take a look at the configuration option setup used with the dedicated server products and compare them to those used in the reseller products... there must be an error in the dedicated server configuration options and hopefully you will see it when comparing it with the reseller configuration options.

Link to comment
Share on other sites

  • WHMCS Support Manager


I've split this into ta new thread as it was not related to the OP.


@Experthost: What you're experiencing here suggests you have duplicate entries for your configurable options inside the tblpricing table. Running a quiery on your databas elike this should resolve that for you:


CREATE TABLE tbltemporarytable LIKE tblpricing;
INSERT INTO tbltemporarytable SELECT * FROM tblpricing GROUP BY type, currency, relid ORDER by id
ALTER TABLE tblpricing RENAME tbloriginalpricing;
ALTER TABLE tbltemporarytable RENAME tblpricing;

This will leave you with a backup table tbltemporarytable which can you delete once you've confirmed the issue is resolved.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated