Print Page - Errot 1064 You have an error in your SQL syntax; #__virtuemart

Title: Errot 1064 You have an error in your SQL syntax; #__virtuemart_states WHERE vir
Post by: m.davide82 on October 22, 2016, 11:03:53 AM

I have this error this morning, anyone can help me please?

I'm not able to access to the backend too..

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 '' at line 1 SQL=SELECT state_name FROM #__virtuemart_states WHERE virtuemart_state_id=

Thank you very much!

Title: Re: Errot 1064 You have an error in your SQL syntax; #__virtuemart_states WHERE vir
Post by: GJC Web Design on October 22, 2016, 11:12:40 AM

after 57 posts is this really still needed?

http://forum.virtuemart.net/index.php?topic=79799.0
http://forum.virtuemart.net/index.php?topic=104795.0

and as code can't write its self what changed?

Title: Re: Errot 1064 You have an error in your SQL syntax; #__virtuemart_states WHERE vir
Post by: m.davide82 on October 22, 2016, 11:16:36 AM

Sorry! ;)

Virtuemart 3.0.18
Joomla 3.6.3

Php version 5.6.23

Title: Re: Errot 1064 You have an error in your SQL syntax; #__virtuemart_states WHERE vir
Post by: GJC Web Design on October 22, 2016, 11:20:04 AM

and what has changed?

the error is obvious .. the state id is missing in the query... you need to find what script is making this query (if u can use php xdebug or even Joomla debug to try and trace) and then fix why the state id is missing

and again . what has changed?

Title: Re: Errot 1064 You have an error in your SQL syntax; #__virtuemart_states WHERE vir
Post by: m.davide82 on October 22, 2016, 11:24:43 AM

The problem is this, nothing was changed.

Yesterday it was working, this morning... no!

I'm not able to access the backend too for the same error.

I activated the joomla debug but no debug is showing.

Title: Re: Errot 1064 You have an error in your SQL syntax; #__virtuemart_states WHERE vir
Post by: GJC Web Design on October 22, 2016, 12:19:08 PM

can't find that query in any 3.0.18 admin file -- 3rd party stuff?

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: m.davide82 on October 22, 2016, 11:03:53 AM