SQL error causes 404 error....

[jmkaep]

The following error is causing a 404 error this SQL error message when a Virtuemart product category menu item is clicked in joomla 3.0.

SELECT c.* FROM #__virtuemart_customs as c INNER JOIN #__virtuemart_product_customfields as pc on (c.virtuemart_custom_id=pc.virtuemart_custom_id) INNER JOIN #__virtuemart_product_categories as cat ON (pc.virtuemart_product_id=cat.virtuemart_product_id) WHERE virtuemart_category_id="28" and searchable="1" and (field_type="S" or field_type="P") GROUP BY c.virtuemart_custom_id

This is on a local server. At first there was just a blank Joomla page but when I increased values like max execution time, etc in php and mysql this error came up with a 404 page.

Any help would be appreciated.

[johnkont]

try another php version