Welcome, Guest
Username: Password: Remember me
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 3 years 4 weeks ago #15722

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 3 years 3 weeks ago #15723

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.
Time to create page: 0.101 seconds

MaterialMart

for Virtuemart 3

Google's Material Design has finally arrived to Virtuemart

Virtumart Template - MaterialMart Virtumart Template - CleanMart Virtumart Template - CleanMart Virtumart Template - CleanMart

Fully responsive!

Buy Now   |   Live Demo