Hi.
Really hope someone here can solve this puzzle...

I'm running Zencart v1.5.5a on the domain www.artos.dk and are trying to build a Facebook-shop with the products from one of the categories. To do this a PHP-feed has been copied to the root www.artos.dk/zencart and was supposed to return data with all the products from the shop, but it is returning an empty feed.

This is what the support for the Facebook-app (StoreYa) is answering:

The feed (http://artos.dk/zencart/storeya_feed.php) is empty which is why your store cannot be imported.
We recommend that you contact your webmaster for why the following query does not return data:

$prdqry= mysql_query("select ".DB_PREFIX."products.products_id,products_price,products_price_sorter,products_ image,products_name,products_description,products_url from ".DB_PREFIX."products,".DB_PREFIX."products_description where ".DB_PREFIX."products.products_status='1' and ".DB_PREFIX."products.products_id=".DB_PREFIX."products_description.products _id and ".DB_PREFIX."products_description.language_id='".$language_id."' order by ".DB_PREFIX."products.products_id ");

Language is the following:

$lang=mysql_fetch_assoc(mysql_query("select languages_id from ".DB_PREFIX."languages where code in (select configuration_value from ".DB_PREFIX."configuration where configuration_key='DEFAULT_LANGUAGE')"));
$language_id=$lang['languages_id'];

I have no idea why this is happening and are hoping for your help?