Cannot update order

  • Posts: 37
  • Thank you received: 1
11 years 2 weeks ago #131303

-- url of the page with the problem -- : mywebsite.com/mypage
-- HikaShop version -- : x.x.x
-- Joomla version -- : x.x
-- PHP version -- : x.x.x
-- Browser(s) name and version -- : XXXXX x.x.x
-- Error-message(debug-mod must be tuned on) -- : Error_message

Help!

When I try to update an order to Shipped I get the following SQL error:

1054 Unknown column 'order_invoice_created' in 'field list' SQL=UPDATE `jos_hikashop_order` SET `order_status`='shipped' ...

Why do I have a missing column??

Regards,

Martin

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

  • Posts: 12953
  • Thank you received: 1778
11 years 2 weeks ago #131314

Hi,
Can you download the last Hikashop version through our website, install it, and test it again ?
Thanks :).

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

  • Posts: 37
  • Thank you received: 1
11 years 2 weeks ago #131416

Hi Mohamed:

I manually added the missing column on my test and production sites and it seems happy. I'll pick up the new version on my next update cycle. Any idea how this column came to be missing?

Regards,

Martin

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

  • Posts: 12953
  • Thank you received: 1778
11 years 2 weeks ago #131425

Not exactly, but installing Hikashop again should have add this column through this SQL request :

ALTER TABLE `#__hikashop_order` ADD `order_invoice_created` INT(10) UNSIGNED NOT NULL DEFAULT '0'
Where # is your table prefix.

The following user(s) said Thank You: tidosho

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

Time to create page: 0.075 seconds
Powered by Kunena Forum