Virtuemart Support :: Topic: *** 1064 *** You have an error in your SQL syntax (1/1)

Welcome, Guest

Use this Category for your support questions about Virtuemart Template - MaterialMart (SKU# FLEX-00020)

TOPIC: * 1064 * You have an error in your SQL syntax

* 1064 * You have an error in your SQL syntax 5 years 5 months ago #15722

Martin Richta

When I open link to eshop like "virtuemart front page" template is broken and see error:

*** 1064 *** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') WHERE `a`.`virtuemart_media_id` = `b`.`virtuemart_media_id`' at line 3

After an exam lesson and a google search hour, I discovered that she was coming from /html/com_virtuemart/sublayouts/manufacturer-logo.php

When I delete this file, the template works.

The administrator has disabled public write access.

* 1064 * You have an error in your SQL syntax 5 years 5 months ago #15723

Support

Hi Martin,

You could have also tried to disabling the "Manufacturer Logo" feature via "Flexible VM3 Template" plugin settings. This error occurs because you have some manufacturers that don't have logo uploaded. You must upload logos to manufacturer if you enable the show manufacturer logo parameter.

But the method you come up with also fixes the error message, because MaterialMart won't try to disable the manufacturer logo.

Regards.

The administrator has disabled public write access.