aggiornamento da 3.4.2 a VirtueMart 3.6.0 10113

[giriga]

Hi, I updated my virtuemart from 3.4.2 to VirtueMart 3.6.0 10113 I have Joomla 3.9.11 I have a problem with my cart here are the images:

[GJC Web Design]

enable JOOMLA debug so you can see where the sql is being formed

also you can see the actual query if u do this: 

Report db query error with query
Add the actual query to the error
\libraries\joomla\database\driver\mysqli.php ~ line 650

add this line after  $this->errorMsg = $this->getErrorMessage();

$this->errorMsg = $this->errorMsg.' - '.$query;

[giriga]

here is the debug look at image

[giriga]

I added string as you say, now this happens (see image)

[GJC Web Design]

you have a syntax error

as the message says -- probably the $ missing

the query is coming from the states model

                  //Test if virtuemart_state_id fits to virtuemart_country_id
                  $q = 'SELECT * FROM `#__virtuemart_states` WHERE `virtuemart_country_id`= "'.$countryId.'" AND `virtuemart_state_id`="'.$stateId.'" and `published`="1"';

you need to see what $q is - add directly after line 127  administrator\components\com_virtuemart\models\state.php

print 'Debug Line '.__LINE__.' $q <pre>'; print_r ($q); print "</pre><br />\n"; die();

[giriga]

sorry I'm not very practical, can you send the correct files?
I tried to add your code, but it didn't solve the problem (see image)

[GJC Web Design]

Its not supposed to solve anything .. it is to give u information to find what is wrong

again your syntax is completely wrong -- please google some basic php skills

if(!isset($c[$h])){
                  //Test if virtuemart_state_id fits to virtuemart_country_id
                  $q = 'SELECT * FROM `#__virtuemart_states` WHERE `virtuemart_country_id`= "'.$countryId.'" AND `virtuemart_state_id`="'.$stateId.'" and `published`="1"';
         print 'Debug Line '.__LINE__.' $q <pre>'; print_r ($q); print "</pre><br />\n"; die();         
                  $db->setQuery($q);
                  $c[$h] = $db->loadResult();
               }

[giriga]

hi, look at the picture, it doesn't work

[GJC Web Design]

It exactly works -- it shows the query ...

ah -- I think $db isn't set

do this

if(!empty($stateId)){
               $h = $countryId.'.'.$stateId;
               if(!isset($c[$h])){
               // GJC add this
                  $db = JFactory::getDBO();
               //GJC add this
                  //Test if virtuemart_state_id fits to virtuemart_country_id
                  $q = 'SELECT * FROM `#__virtuemart_states` WHERE `virtuemart_country_id`= "'.$countryId.'" AND `virtuemart_state_id`="'.$stateId.'" and `published`="1"';
         //print 'Debug Line '.__LINE__.' $q <pre>'; print_r ($q); print "</pre><br />\n"; die();         
                  $db->setQuery($q);
                  $c[$h] = $db->loadResult();
               }

[giriga]

Hi, this is the result look image

[GJC Web Design]

then your still writing it wrong.. that is a simple syntax error.. chk your code

[giriga]

Write you, thanks, here's the file

[GJC Web Design]

try this

[giriga]

Hi, thank you very much! solved problem 

[Milbo]

The fix is in vm3.6.1 http://dev.virtuemart.net/attachments/1177/com_virtuemart.3.6.1.10121_package_or_extract.zip