the whmcs plugin for addons has issues not displaying the product info

[kdovale]

when adding addons and configurable options the product name does not diaplay in the list

to resolve this issue on line 56 is the code line

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:

The left join on line 3 says the join should be on osconfig.id and this is wrong it shoulld be o.id once this is rectified in the code as below the issue is resolved.

$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.

---

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.