WHMCS and configura...
 
Notifications
Clear all

WHMCS and configurable options names not displaying.

3 Posts
2 Users
0 Reactions
640 Views
Posts: 237
Topic starter
(@hxkd)
Reputable Member
Joined: 8 years ago

I have loaded the latest whmcs solidcp plugin, but the configurable options names are not displaying, is there any fix for this ?

2 Replies
Posts: 237
Topic starter
(@hxkd)
Reputable Member
Joined: 8 years ago

Hi,

ok after an hour of checking I traced it dowwn to the configurableoptions.php file in the addons\solidcp_module\lib folder, in the code for the configurable options your sql has an error in it. On line 56 the sql code is:

$this->configurableoptions = Capsule::select("select concat(g.name, ' -> ', o.optionname, ' -> ', os.optionname) as name, c.whmcs_id as whmcs_id, c.scp_id as scp_id, os.hidden as hidden from ".SOLIDCP_CONFIGURABLE_OPTIONS_TABLE." as c
left join tblproductconfigoptionssub as os on c.whmcs_id=osconfig.id
left join tblproductconfigoptions as o on os.configid=o.id
left join tblproductconfiggroups as g on o.gid=g.id
order by g.name, o.`order`, os.sortorder");

and this this should be

$this->configurableoptions = Capsule::select("select concat(g.name, ' -> ', o.optionname, ' -> ', os.optionname) as name, c.whmcs_id as whmcs_id, c.scp_id as scp_id, os.hidden as hidden from ".SOLIDCP_CONFIGURABLE_OPTIONS_TABLE." as c
left join tblproductconfigoptionssub as os on c.whmcs_id=os.id
left join tblproductconfigoptions as o on os.configid=o.id
left join tblproductconfiggroups as g on o.gid=g.id
order by g.name, o.`order`, os.sortorder");

once this is changed the sql works and the product descriptions display correctly.

Reply
Posts: 1457
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hello,

Would you be able to add this to the github code as either a pull request or bug report?

Regards,

Trevor

Reply
Share: