I have loaded the latest whmcs solidcp plugin, but the configurable options names are not displaying, is there any fix for this ?
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.
Hello,
Would you be able to add this to the github code as either a pull request or bug report?
Regards,
Trevor