Hi,
Thanks for the report.
It looks like the user do not have any pack and it generates that SQL error.
The easier would be to edit the file "components/com_hikaserials/views/serialsmarket/view.html.php"
And to replace
Code:
if($target_vendor_id == 0) {
$query = 'SELECT COUNT(serial.serial_id) as count, serial.serial_pack_id, serial.serial_status FROM '.hikaserial::table('serial').' AS serial '.
' WHERE serial.serial_pack_id IN ('.implode(',', $pack_ids).') '.
' GROUP BY serial.serial_pack_id, serial.serial_status;';
} else {
By
Code:
if($target_vendor_id == 0) {
$query = 'SELECT COUNT(serial.serial_id) as count, serial.serial_pack_id, serial.serial_status FROM '.hikaserial::table('serial').' AS serial '.
' WHERE serial.serial_pack_id IN ('.implode(',', $pack_ids).') '.
' GROUP BY serial.serial_pack_id, serial.serial_status;';
} else {
if(empty($own_packs))
$own_packs = array(0);
It would avoid the SQL issue.
I will improve the patch in order to display a message to the user instead of displaying an "empty" page.
Regards,
