500 error.

[danCrookes]

Hi, i am running joomla 2.5.2 and vm 2.0.18a

an error was coming up saying Maximum execution time 30 seconds exceeded....

so i turned on debug mode, and got this error,

500 - JDatabaseMySQLi::query: 1054 - Unknown column 'p.virtuemart_product_id' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `jd0gq_virtuemart_products` as `p` JOIN `jd0gq_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `jd0gq_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `jd0gq_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 10 and `slug` < "pinnacle-nutrition-muscle-mass-4kg" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY `p.virtuemart_product_id` DESC LIMIT 0,1

any help would be great, i cant seem to figure this out.

[jenkinhill]

ISTR that was fixed in 2.0.18b  - we are now at 2.0.20a

500 errors are recorded in server error logs, always worth looking there before using debug.

[danCrookes]

Cheers Jenkin, ill backup, and then update the site and see what happens.

[danCrookes]

Right, so updating the system solved the first issue, however now whenever i put something in my cart, and then click view cart, the page wont load and im getting different errors with different browsers, google chrome gives me this,

Fatal error: Maximum execution time of 60 seconds exceeded in /home/pinsup/domains/pinnaclesupplement.co.uk/public_html/modules/mod_roknavmenu/lib/providers/RokMenuProviderJoomla16.php on line 206

i have also turned this module off, however still get this error? and its only occurring when i want to view the cart. and FF is giving me this error

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request
www.pinnaclesupplement.co.uk

any clues, could you at least point me in the right direction?

thanks

[jenkinhill]

I'd uninstall mod_roknavmenu

The error page is at http://www.pinnaclesupplement.co.uk/at/my-basket.html  - where did the at come from in the url? Is htaccess causing an issue? or some SEF problem?

Anyway, not a VM bug so moving this from the bug report section.