[Skip to main content](#vessel-content) # Error with Save History On ## - **[Nollis](/forum/user/13904-nollis "View Nollis's Profile")** - [![Nollis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/splatter_hand.png)](/forum/user/13904-nollis "View Nollis's Profile") Topic Author - [ Offline](/forum/user/13904-nollis) Less More - Posts: 5 - Thank you received: 0 - - - - 13 years 8 months ago [\#92331](#92331) by [Nollis](/forum/user/13904-nollis "View Nollis's Profile") *[Error with Save History On](/forum/16-serial-bug-report/78817-error-with-save-history-on#92331 "When I have save history set to on in Global settings, I get this error when I change Order to Assigned. SQL=INSERT IGNORE INTO dj6xp_hikaserial_history (,,,) VALUES (1362040774,87,1,0),(1362040774,87,1,0)")* was created by *[Nollis](/forum/user/13904-nollis "View Nollis's Profile")* When I have save history set to on in Global settings, I get this error when I change Order to Assigned. SQL=INSERT IGNORE INTO dj6xp_hikaserial_history (,,,) VALUES (1362040774,87,1,0),(1362040774,87,1,0) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE2LXNlcmlhbC1idWctcmVwb3J0Lzc4ODE3LWVycm9yLXdpdGgtc2F2ZS1oaXN0b3J5LW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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) - 13 years 8 months ago [\#92375](#92375) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error with Save History On](/forum/16-serial-bug-report/78817-error-with-save-history-on#92375 "When I have save history set to on in Global settings, I get this error when I change Order to Assigned. SQL=INSERT IGNORE INTO dj6xp_hikaserial_history (,,,) VALUES (1362040774,87,1,0),(1362040774,87,1,0)")* Hi, I am trying to reproduce your problem in my local website. Could you indicate the steps that you have made in order to have this problem ? Thanks, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE2LXNlcmlhbC1idWctcmVwb3J0Lzc4ODE3LWVycm9yLXdpdGgtc2F2ZS1oaXN0b3J5LW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Nollis](/forum/user/13904-nollis "View Nollis's Profile")** - [![Nollis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/splatter_hand.png)](/forum/user/13904-nollis "View Nollis's Profile") Topic Author - [ Offline](/forum/user/13904-nollis) Less More - Posts: 5 - Thank you received: 0 - - - - 13 years 8 months ago [\#92403](#92403) by [Nollis](/forum/user/13904-nollis "View Nollis's Profile") Replied by *[Nollis](/forum/user/13904-nollis "View Nollis's Profile")* on topic *[Error with Save History On](/forum/16-serial-bug-report/78817-error-with-save-history-on#92403 "When I have save history set to on in Global settings, I get this error when I change Order to Assigned. SQL=INSERT IGNORE INTO dj6xp_hikaserial_history (,,,) VALUES (1362040774,87,1,0),(1362040774,87,1,0)")* Well, first I place an order in the frontend. Then, under Orders I change the **Orderstatus** from **Created** to **Shipped** with no email sent to customer. After that I set the **Orderstatus** to **Confirmed** and send email to customer to yes. And when I press OK I get the error message. - [ ![settings.JPG](/forum/attachment/8828) ](/forum/attachment/8828 "settings.JPG") [ ](/forum/attachment/8828?download=1 "settings.JPG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE2LXNlcmlhbC1idWctcmVwb3J0Lzc4ODE3LWVycm9yLXdpdGgtc2F2ZS1oaXN0b3J5LW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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) - 13 years 8 months ago [\#92465](#92465) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error with Save History On](/forum/16-serial-bug-report/78817-error-with-save-history-on#92465 "When I have save history set to on in Global settings, I get this error when I change Order to Assigned. SQL=INSERT IGNORE INTO dj6xp_hikaserial_history (,,,) VALUES (1362040774,87,1,0),(1362040774,87,1,0)")* Hi, The problem was linked to Joomla 3. I have updated your website with the latest version which contains the fix for this. The new version of HikaSerial should be release begin of next week (in the same time than the next release of HikaShop). In order to fix the problem, you have to edit the administrator/components/com_hikaserial/classes/history.php file and replace: Code: $query .= $sep.$this->db->nameQuote($k); By Code: if(!HIKASHOP_J30){ $query .= $sep.$this->db->nameQuote($k); } else { $query .= $sep.$this->db->quoteName($k); } Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE2LXNlcmlhbC1idWctcmVwb3J0Lzc4ODE3LWVycm9yLXdpdGgtc2F2ZS1oaXN0b3J5LW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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? Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile") [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.101 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)