Order numbers not updated in 2.3.3

  • Posts: 43
  • Thank you received: 0
10 years 10 months ago #172875

-- url of the page with the problem -- : nordic-medical.de
-- HikaShop version -- : 2.3.3
-- Joomla version -- : 3.3.3

After updating to the latest version (not latest Joomla), the system doesn't update order numbers - neither in back-end or front-end. Any fix?

//David

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 26264
  • Thank you received: 4043
  • MODERATOR
10 years 10 months ago #172882

Hi,

HikaShop 2.3.3 is just HikaShop 2.3.2 with the security patch explained in the article we made.
So the problem is not coming from that.

Please check the order in your backend and please provide us some information about your configuration, elements which will help us to understand your problem which does not come from the HikaShop 2.3.2 -> 2.3.3 update.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 43
  • Thank you received: 0
10 years 10 months ago #172938

Hi,

Everything works as it should during the order process. The system generates the correct next order number, which is included in both the email sent to the user and to the administrator. However, upon completing the order, the number is not stored in the MySQL database. The user will not see the order number in the frontend in 'view order history' (and therefore cannot access order details), the number is not visible in the order backend, and the MySQL hikashop_order table has a blank order number.

Oddly, even though the system doesn't store the new number in the hikashop_orders table, the 'correct' next order number is generated for the next order (and again no details stored in the MySQL table)..

Another issue that has poped up in conjunction with this is that the cron update rates task is triggered every 15 minutes even though is should only trigger once a week.

I tried upgrading to Joomla 3.3.4 and reinstall HikaShop, but it didn't work. Still same problem. No order number stored.

Any idea what could be happening?

Thanks for the support,
David

Please Log in or Create an account to join the conversation.

  • Posts: 84220
  • Thank you received: 13671
  • MODERATOR
10 years 10 months ago #172959

Hi,

The order number being empty would indicate that the "order number format" option has been emptied in your HikaShop configuration resulting in the order number generated as empty as well.

The frequency of the rates update is defined by the "frequency" option of the rates auto update plugin where you need to enter the frequency in seconds. So please check that option by editing your plugin via the Joomla plugins manager.

Please Log in or Create an account to join the conversation.

  • Posts: 43
  • Thank you received: 0
10 years 10 months ago #173014

Hi,

Order number format is set to WO1483{automatic_code} and invoice number format is set to WI1483{automatic_code} in the configuration. These numbers are correctly generated during the checkout process, included in user and admin email, but the order number is not stored in the MySQL database after the order is completed. I've tried to change the number format and saved and then changed back. No luck.

As for the cron: Rates auto update frequency in the plugin is set to 604800. Currency rates refresh frequency in the configuration is set to 1 week. I'm still getting a trigger and report every 15 minutes.

One question: If i uninstall HikaShop and then reinstall: Will all data and setting be restored or will data be lost?

Thanks for the support,
David

Please Log in or Create an account to join the conversation.

  • Posts: 84220
  • Thank you received: 13671
  • MODERATOR
10 years 10 months ago #173051

Hi,

You don't need to uninstall HikaShop. Simply install the package you want (for example the 2.3.2) and it will revert to it without lossing anything. But I don't see how it would change anything for you as the 2.3.3 is the same as the 2.3.2 with just a joomla 3.3.4 patch and a security patch.

If you could provide a backend access via our contact form with a link to this thread, we could have a link at the problem.

The following user(s) said Thank You: DavidThor

Please Log in or Create an account to join the conversation.

  • Posts: 43
  • Thank you received: 0
10 years 10 months ago #173237

Login details sent. Thanks. //David

Please Log in or Create an account to join the conversation.

  • Posts: 84220
  • Thank you received: 13671
  • MODERATOR
10 years 10 months ago #173445

Hi,

I've indentified the source of the problem.
The order_number of orders is not generated anymore because between the query which creates the order and the query which retrieves the id generated, there is something which does a query and thus the id is missing and HikaShop doesn't get the id of the order that got generated and thus cannot generated the order number.
After some thoughts, testing and code checking, we found out that by disabling the Falang system plugin the problem disappeared.
So I'm not sure what that plugin does differently in the actual version than in previous versions but there is probably something to change in the plugin to avoid that.
I notified the developer of Falang so that he can look at the issue as he knows everything there is to know about Falang and should be able to better understand the issue with the plugin.

Please Log in or Create an account to join the conversation.

  • Posts: 33
  • Thank you received: 3
10 years 10 months ago #173705

Hi,

I'm stéphane from Falang - Faboba.
You can write me directly with the contact form on faboba.com and ask me the modified file even for free falang version

I will launch a new version of falang soon version 1.4.3

Stéphane

Please Log in or Create an account to join the conversation.

Time to create page: 0.077 seconds
Powered by Kunena Forum