[Skip to main content](#vessel-content) # Order id and order details issue ## - **[rcanetwork](/forum/user/30424-rcanetwork "View rcanetwork's Profile")** - [![rcanetwork's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30424-rcanetwork "View rcanetwork's Profile") Topic Author - [ Offline](/forum/user/30424-rcanetwork) Less More - Posts: 13 - Thank you received: 5 - - 11 years 2 months ago [\#211615](#211615) by [rcanetwork](/forum/user/30424-rcanetwork "View rcanetwork's Profile") *[Order id and order details issue](/forum/35-orders-management/878782-order-id-and-order-details-issue#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")* was created by *[rcanetwork](/forum/user/30424-rcanetwork "View rcanetwork's Profile")* -- 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 - [ ![orderiderror.jpg](/forum/attachment/25998) ](/forum/attachment/25998 "orderiderror.jpg") [ ](/forum/attachment/25998?download=1 "orderiderror.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3ODc4Mi1vcmRlci1pZC1hbmQtb3JkZXItZGV0YWlscy1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile")** - [![lousyfool's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28604.jpg)](/forum/user/28604-lousyfool "View lousyfool's Profile") - [ Offline](/forum/user/28604-lousyfool) Less More - Posts: 2143 - Thank you received: 747 - - [](http://www.inphase.one) - 11 years 2 months ago [\#211621](#211621) by [lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile") Replied by *[lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile")* on topic *[Order id and order details issue](/forum/35-orders-management/878782-order-id-and-order-details-issue#211621 "-- 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")* 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!](/component/uddeim/?task=new) (Don't forget to turn on [ "E-mail notification of new messages"](/component/uddeim/?task=settings)) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3ODc4Mi1vcmRlci1pZC1hbmQtb3JkZXItZGV0YWlscy1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 2 months ago [\#211617](#211617) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Order id and order details issue](/forum/35-orders-management/878782-order-id-and-order-details-issue#211617 "-- 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")* 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](/forum/user/30424-rcanetwork "View rcanetwork's Profile"), [sivaranjani](/forum/user/45208-sivaranjani "View sivaranjani's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3ODc4Mi1vcmRlci1pZC1hbmQtb3JkZXItZGV0YWlscy1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rcanetwork](/forum/user/30424-rcanetwork "View rcanetwork's Profile")** - [![rcanetwork's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30424-rcanetwork "View rcanetwork's Profile") Topic Author - [ Offline](/forum/user/30424-rcanetwork) Less More - Posts: 13 - Thank you received: 5 - - 11 years 2 months ago [\#211655](#211655) by [rcanetwork](/forum/user/30424-rcanetwork "View rcanetwork's Profile") Replied by *[rcanetwork](/forum/user/30424-rcanetwork "View rcanetwork's Profile")* on topic *[Order id and order details issue](/forum/35-orders-management/878782-order-id-and-order-details-issue#211655 "-- 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")* I fixed it, thanks for reply. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3ODc4Mi1vcmRlci1pZC1hbmQtb3JkZXItZGV0YWlscy1pc3N1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.135 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)