Error with Save History On

  • Posts: 5
  • Thank you received: 0
11 years 1 month ago #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)

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

  • Posts: 26000
  • Thank you received: 4004
  • MODERATOR
11 years 1 month ago #92375

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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 5
  • Thank you received: 0
11 years 1 month ago #92403

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.

Attachments:

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

  • Posts: 26000
  • Thank you received: 4004
  • MODERATOR
11 years 1 month ago #92465

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:

			$query .= $sep.$this->db->nameQuote($k);
By
			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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Moderators: Obsidev
Time to create page: 0.062 seconds
Powered by Kunena Forum