- Posts: 5
- Thank you received: 0
Error with Save History On
13 years 8 months ago #92331
by Nollis
Error with Save History On was created by Nollis
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)
SQL=INSERT IGNORE INTO dj6xp_hikaserial_history (,,,) VALUES (1362040774,87,1,0),(1362040774,87,1,0)
Please Log in or Create an account to join the conversation.
13 years 8 months ago #92375
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic Error with Save History On
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,
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 or Create an account to join the conversation.
13 years 8 months ago #92403
by Nollis
Replied by Nollis on topic Error with Save History On
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.
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.
Please Log in or Create an account to join the conversation.
13 years 8 months ago #92465
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic Error with Save History On
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:
By
Regards,
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);
Code:
if(!HIKASHOP_J30){
$query .= $sep.$this->db->nameQuote($k);
} else {
$query .= $sep.$this->db->quoteName($k);
}
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Please Log in or Create an account to join the conversation.
Moderators: Obsidev
Time to create page: 0.057 seconds