Skip to main content

Order id and order details issue

More
11 years 1 month ago #211615 by rcanetwork
-- 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

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

More
11 years 1 month ago #211621 by lousyfool
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.

More
11 years 1 month ago #211617 by Jerome
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.
The following user(s) said Thank You: rcanetwork, sivaranjani

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

More
11 years 1 month ago #211655 by rcanetwork
I fixed it, thanks for reply.

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

Time to create page: 0.208 seconds
Powered by Kunena Forum