- Posts: 13
- Thank you received: 5
Order id and order details issue
- rcanetwork
-
Topic Author
- Offline
Less
More
11 years 1 month ago #211615
by rcanetwork
Order id and order details issue was created 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
-- 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.
11 years 1 month ago #211621
by lousyfool
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" )
Replied by lousyfool on topic Order id and order details issue
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.
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.
11 years 1 month ago #211617
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic Order id and order details issue
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,
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.
- rcanetwork
-
Topic Author
- Offline
Less
More
- Posts: 13
- Thank you received: 5
11 years 1 month ago #211655
by rcanetwork
Replied by rcanetwork on topic Order id and order details issue
I fixed it, thanks for reply.
Please Log in or Create an account to join the conversation.
Time to create page: 0.208 seconds