Error 1054 when disabling Opening Hours Plug-IN

  • Posts: 31
  • Thank you received: 0
7 years 7 months ago #267276

-- HikaShop version -- : 3.0.1
-- Joomla version -- : 3.6.5

Hi,

when I tried to disable a entry I have made with HikaShop Closing Hours Plug-IN I get the error message

1054 Unknown column 'shipping_id' in 'where clause' SQL=UPDATE #__hikashop_plugin SET shipping_published = 0 WHERE shipping_id IN ( 9 )

You can see in attached pic.

Attachments:

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

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 7 months ago #267303

Hi,

I'm not able to reproduce the problem on my end.
Could you provide the URL of the page where you do that and the full error message you have when you reproduce it with the "debug mode" and "error reporting" settings of the Joomla configuration activated ?
That should give us more insight on what's going on.

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

  • Posts: 31
  • Thank you received: 0
7 years 7 months ago #267328

Hi,

1054 Unknown column 'shipping_id' in 'where clause' SQL=UPDATE ww3b8_hikashop_plugin SET shipping_published = 0 WHERE shipping_id IN ( 5 )
Call stack
# Function Location
1 JApplicationCms->execute() /storage/h4/160/885160/public_html/administrator/index.php:51
2 JApplicationAdministrator->doExecute() /storage/h4/160/885160/public_html/libraries/cms/application/cms.php:261
3 JApplicationAdministrator->dispatch() /storage/h4/160/885160/public_html/libraries/cms/application/administrator.php:152
4 JComponentHelper::renderComponent() /storage/h4/160/885160/public_html/libraries/cms/application/administrator.php:98
5 JComponentHelper::executeComponent() /storage/h4/160/885160/public_html/libraries/cms/component/helper.php:380
6 require_once() /storage/h4/160/885160/public_html/libraries/cms/component/helper.php:405
7 hikashopController->execute() /storage/h4/160/885160/public_html/administrator/components/com_hikashop/hikashop.php:54
8 JControllerLegacy->execute() /storage/h4/160/885160/public_html/administrator/components/com_hikashop/helpers/helper.php:1728
9 PluginsController->unpublish() /storage/h4/160/885160/public_html/libraries/legacy/controller/legacy.php:702
10 hikashopController->unpublish() /storage/h4/160/885160/public_html/administrator/components/com_hikashop/controllers/plugins.php:49
11 hikashopController->_toggle() /storage/h4/160/885160/public_html/administrator/components/com_hikashop/helpers/helper.php:1602
12 JDatabase->query() /storage/h4/160/885160/public_html/administrator/components/com_hikashop/helpers/helper.php:1638
13 JDatabaseDriverMysqli->execute() /storage/h4/160/885160/public_html/libraries/joomla/database/database.php:33

Will send you the Login through your contact form.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 7 months ago #267338

Hello,

Please edit the file "administrator/components/com_hikashop/controllers/plugins.php" and replace the function _getToggle with that content

	function _getToggle() {
		$this->type = JRequest::getCmd('plugin_type');
		if($this->type == 'plugin') {
			$this->toggle = array('plugin_published' => 'plugin_id');
		} else if($this->type == 'payment') {
			$this->toggle = array('payment_published' => 'payment_id');
		} else {
			$this->toggle = array('shipping_published' => 'shipping_id');
		}
	}
I think it will fix your issue.
But we will need your confirmation in order to integrate the patch in HikaShop.

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.

  • Posts: 31
  • Thank you received: 0
7 years 7 months ago #267366

Thx, this fixed it. Works fine.

I noticed another thing. When I reopen an existing day, the hours field is blank. See attached a pic.

Attachments:

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

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 7 months ago #267399

Hi,

I'm not able to reproduce that, neither on my end, nor on your website:
monosnap.com/file/fZPtfjCrFGSCHuU0hQHmo6Co1zRoes

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

  • Posts: 31
  • Thank you received: 0
7 years 7 months ago #267441

HI,

I see, interessting. I have a copy of that site offline for development. There I experience this issue. Any idea what it could be?

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 7 months ago #267480

Hello,

You can activate the Joomla debug mode in your offline website ; it will allow you to see the SQL queries made for the page loading.
The plugin should load the configuration from the database and if you see the fields empty, it means that there is an issue with the loading of the data.
But because we are not able to reproduce, it will be difficult for us to give you more indication on where the problem would be.

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.

  • Posts: 31
  • Thank you received: 0
7 years 7 months ago #267540

Hi,

I have been trying around a bit.

Online, on the side you have access to, this is a complete new setup of joomla and hikashop 3.0.1.

When I do an update of an f.e. 2.6.4 HIkasShop installation to 3.0.1 and I configure an Opening Hours Plugin.
I will see the entry in HikaShop when I go to Plugins, but in _hikashop_plugin, the table is empty. So this explains to me why I won't see any time when I open up the entry.

You have any idea why this could happen?

PS: I have add an entry by hand in _hikashop_plugin, but it won't show up in Plugins on Hikashop

Last edit: 7 years 7 months ago by Jim.

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

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 7 months ago #267555

Hi,

I don't see how you could have something on the listing of the plugins in the menu System>Plugins with the hikashop_plugin table empty. I'm not able to reproduce and looking at the code I don't see how that could happen.

If you configure an entry in the menu System>Plugins, then you should see it there after your save & close it, and it should be stored there.

Note however that the plugin will only work with the new checkout of HikaShop 3. So the checkout legacy setting, which is turned on by default when you update from a 2.6.x, has to be turned off.

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

Time to create page: 0.073 seconds
Powered by Kunena Forum