SQL Error on product page

Shane created the topic: SQL Error on product page

Hi

We have installed your Spider Catalog on Joomla 3.2.1. On the products page in the admin area the nothing is displayed except for the following error:

An error has occurred.
0 SQL=SELECT * FROM aftw2_spidercatalog_product_categories WHERE id IN () AND published=1 order by ordering

I can get products to show up by changing (".$db->escape($ids).") to (1) on the following line in spidercatalog.php (line 1077 in this installation):

$query="SELECT * FROM #__spidercatalog_product_categories WHERE id IN (".$db->escape($ids).") AND published=1  order by ordering ";

Can anyone advise on how to sort this out?

Thanks

#15201

Last Edit: 9 years 9 months ago by Shane. Reason: clarity

Please Log in or Create an account to join the conversation.

Topic Author
Shane
Offline
Fresh Boarder

9 years 9 months ago

Support replied the topic: SQL Error on product page

Dear customer,

Could you please give us (to [email protected]) admin access to your site, by indicating the forum post link in your email subject. We'll try to fix the problem as soon as possible.

Best regards,
Web-Dorado team

Joomla extensions ,
Wordpress plugins ,
Drupal modules

#15216

Please Log in or Create an account to join the conversation.