Weird problem with Virtuemart

[dmeimaris]

Hi, I have a strange problem that's been bothering me for 2 months and I am really out of options.
You can get the first glimpse here:
http://lussile.com/errorsite/
and here goes what I know and have done so far...

Facts
1. The only way to repair it is if I create a new database and upload an older db backup.
2. No need to change anything to the files to make it work (so my guess is that there couldnt be an sql syntax)
3. I have done check and repair from cpanel and plesk, nothing works.
4. If I perform simple sql queries manually to the database it works.
5. The administrator panel shows the same error.

This thing happens once every 1-2 days.

Right now I use Joomla 3.6 and Virtuemart 3.0.14. The problem existed with previous versions of Joomla (3.4, 3.5) and Virtuemart (starting with 3.0.9)
I have no idea what causes it and I have no idea how to debug it.

I have tried it on 2 different servers (plesk and cpanel) and there seems to be no standard method of what causes it.
Some times I have new orders between crashes, sometimes not.
Sometimes it is around the time of an automatic db backup but most times it seems to be around times that nothing I have scheduled is happening.

Can you please help???

[PRO]

greece does not have "states" does it?

if it doesnt, what happens when you add one on backend?

[GJC Web Design]

is this always the error?

SELECT STATE_NAME FROM GREEK_VIRTUEMART_STATES WHERE VIRTUEMART_STATE_ID=

is your DB prefix greek?

if so this query should be relatively easy to find and then debug why it triggers when no state id is present

[dmeimaris]

It's always the same error. Yes the prefix is greek. And the states are not required and are unpublished in the Virtuemart configuration.

I have tracked the error and it goes like this:

Call stack
#   Function   Location
1   JApplicationCms->execute()   httpdocs/errorsite/administrator/index.php:51
2   JApplicationAdministrator->render()   httpdocs/errorsite/libraries/cms/application/cms.php:263
3   JApplicationCms->render()   httpdocs/errorsite/libraries/cms/application/administrator.php:433
4   JApplicationBase->triggerEvent()   httpdocs/errorsite/libraries/cms/application/cms.php:1074
5   JEventDispatcher->trigger()   httpdocs/errorsite/libraries/joomla/application/base.php:106
6   JEvent->update()   httpdocs/errorsite/libraries/joomla/event/dispatcher.php:159
7   call_user_func_array()   httpdocs/errorsite/libraries/joomla/event/event.php:69
8   plgSystemVmtracking->onAfterRender()   
9   plgSystemVmtracking->trackingTransaction()   httpdocs/errorsite/plugins/system/vmtracking/vmtracking.php:671
10   JDatabaseDriver->loadResult()   httpdocs/errorsite/plugins/system/vmtracking/vmtracking.php:331
11   JDatabaseDriverMysqli->execute()   httpdocs/errorsite/libraries/joomla/database/driver.php:1728

I think the problem may be in the VM tracking extension for google analytics:

http://extensions.joomla.org/extension/vm-transaction-tracker-for-google-analytics

But I am not sure...

[GJC Web Design]

yep .. its not checking if the id exists before querying

you need to contact the support for this plugin