Order id and order details issue

  • Posts: 13
  • Thank you received: 5
9 years 3 months ago #211615

-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.4.3
-- Error-message(debug-mod must be tuned on) -- : Frontend: none
Backend: order not found

Hi,
Everything working fine, then I just try to edit last order id on database table "hikashop_order" via phpmyadmin like "3435435764" to test the order id and invoice id.

After then it's generating strange order no like, A3A5A0A2A1A4A7A6A0A9AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABARCTWWF

and order details also not showing if I click this order no.

Here attached current order configuration screenshot, unfortunately it's still in localhost.

Thanks

Attachments:

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

  • Posts: 2143
  • Thank you received: 747
9 years 3 months ago #211621

Hi,

Why would you edit an order ID - or anything else - in the database? Doing so directly in the database is - like changing other key values in the database directly - highly destructive. Since various database tables, fields and their values are related to each other, your change has destroyed the relationships for at least this order.

It should go without saying that manual interference with the database is highly risky, and indeed, in your case harmful.

Change the order number back, if you can, or restore a backup.


Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 3 months ago #211617

Hi,

And what exactly did you do with the order_id or the invoice_id ?
Because the conversion of the order_id "3435435764" using the hikashop_base function is : "B3A4E3T5J4W3M5J764"

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.
The following user(s) said Thank You: rcanetwork, sivaranjani

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

  • Posts: 13
  • Thank you received: 5
9 years 3 months ago #211655

I fixed it, thanks for reply.

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

Time to create page: 0.068 seconds
Powered by Kunena Forum