Problem with taxes (Canada)

Hi,

I got the FTP access and started working on it. However, I hit a road block.
You have opcache activated on your website.
Because of that, when I modify the PHP files, I sometimes don't get the change to apply before a long time.
For example, it's been 20 minutes I've added this code to the address.php file:

//RHD



$query = 'UPDATE '.hikashop_table('address').' SET address_state = \'\' WHERE address_id = '.(int)$addressData->address_id;

$this->database->setQuery($query);

hikashop_writeToLog($query);

$this->database->execute();

$query = 'SELECT * FROM '.hikashop_table('address').' WHERE address_id = '.(int)$addressData->address_id;

$this->database->setQuery($query);

hikashop_writeToLog($query);

$ret = $this->database->loadObject();

hikashop_writeToLog($ret, 'nicolas_test');

Hi,

Yes. I was able to do the necessary debugging.

Here is the report:
In the file administrator/components/com_hikashop/classes/address.php I've left the code:

$query = 'UPDATE '.hikashop_table('address').' SET address_state = \'\' WHERE address_id = '.(int)$addressData->address_id;

$this->database->setQuery($query);

$this->database->execute();

$query = 'SELECT * FROM '.hikashop_table('address').' WHERE address_id = '.(int)$addressData->address_id;

$this->database->setQuery($query);

$ret = $this->database->loadObject();

hikashop_writeToLog($addressData, 'before onAfterAddressUpdate');

$query = 'SELECT * FROM '.hikashop_table('address').' WHERE address_id = '.(int)$addressData->address_id;

$this->database->setQuery($query);

$ret = $this->database->loadObject();

hikashop_writeToLog($ret, 'Address Table');

hikashop_writeToLog($addressData, 'after onAfterAddressUpdate');

$query = 'SELECT * FROM '.hikashop_table('address').' WHERE address_id = '.(int)$addressData->address_id;

$this->database->setQuery($query);

$ret = $this->database->loadObject();

hikashop_writeToLog($ret, 'Address Table');

if($event== 'onafteraddressupdate'){ 
$db = JFactory::getDBO();
$db->setQuery('SELECT * FROM #__hikashop_address WHERE address_id = '.$args[0]->address_id);
$address = $db->loadObject();
hikashop_writeToLog($address, 'xxx');
hikashop_writeToLog(get_class($this->_observers[$key]), 'xxx');
$db->setQuery('SELECT * FROM #__hikashop_address WHERE address_id = '.$args[0]->address_id);
$address = $db->loadObject();
hikashop_writeToLog($address, 'xxx');
}

Hi,

I tried to look at the problem today but I was not able to reproduce the problem.
I've made several orders after disabling the address_state custom field and the massaction, but by the time I was at the end of the checkout, the mass action was enabled again.
So each time I was able to place an order with the address in Germany and the VAT number DE322326233 but I'm not sure if it's because someone reactivated the mass action in the mean time or not.

Please provide a precise set of instructions to reproduce the issue and I can look into it.

Hi,

Thanks, I was able to reproduce the issue with that exact address and a guest checkout.
I did some debug on this today and I found that it is linked to country being somehow wrongly overridden by something when the address is updated on the cart which invalidate the progression to the next step.
So I'm not sure what is the source of the problem.
However, I've made a patch in HikaShop's code to only update the address in the cart if the address is not already the one in the cart. And since the address is already set in the cart when the address is saved, going to the next step doesn't need to update it if it's the same one. So doing it like that avoids the country being overridden and invalidating the progression, and thus, the checkout can go the next step properly. We'll add that modification on our end too.

I won't ask anything for the debug today. However, I'll still ask you for the payment of the debug I did last week.

Hello,

we process a lots of tests and here some idea and theories :
1. Your website behavior is really erratic, as an example, we were able to process complete checkout in guest mode but not in login mode.
2. In "login mode" we succeed to process a complete checkout as well with account your provide for access the backend but not with your "Canadian" account (and the Canada country).
3. When I process some tests with another navigator, I fill the cart with a product, the cart is automatically empties... That don't allow to process freely more tests...

Conclusion, a little as said as previous, all of this prevent us to process tests and make conclusion about what happen unfortunately...
Now the point is what ? A plugin ? A custom code in a override view (seems unlikely) or directly in HikaShop core file ?
Almost impossible to understand without any clue from yourself, does there are a plugin in order to automatically login your website that confuse the checkout process ? Or a custom directly in the core file ?

Actually we need some help and elements that can point us the root issue.
Regards