VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: jmkaep on April 09, 2017, 22:56:43 PM

Title: SQL error causes 404 error....
Post by: jmkaep on April 09, 2017, 22:56:43 PM
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.


Title: Re: SQL error causes 404 error....
Post by: johnkont on April 18, 2017, 11:02:48 AM
try another php version