shipping method issue

  • Posts: 26
  • Thank you received: 1
10 years 4 months ago #164752

-- url of the page with the problem -- : slimbedacht.nu/trefzekerwinkel
-- HikaShop version -- : newest
-- Joomla version -- : 3.3.1
-- PHP version -- : 5.4
-- Browser(s) name and version -- : chrome newest
-- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'Array' in 'where clause' SQL=SELECT * FROM w0ker_hikashop_shipping WHERE shipping_id = Array LIMIT 1


Hi Hikashop,

I'm having trouble with the shipping method. I have created a new shipping method with type: HikaShop manual shipping plugin.
The problem is, i can only add one shipping method of this type. When i want to add a new shipping method it's editing the existing shipping method.

Then I tried to copy the existing shipping method and it worked. But this created another problem. When I press next in the checkout section all is see is this error:
1054 - Unknown column 'Array' in 'where clause' SQL=SELECT * FROM w0ker_hikashop_shipping WHERE shipping_id = Array LIMIT 1

Do you know what is going wrong here?

Thanks!

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 4 months ago #164771

Hi,

This looks like a user session issue.
Please try again with another user account/browser and you should not have the problem.

For the creation of several manual shipping methods, you just need to click on the "new" button of the shipping methods menu.

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

  • Posts: 26
  • Thank you received: 1
10 years 4 months ago #164836

Hi Nicolas,

I tried again with another browser but its not working. You can try it with the following steps:
go to: slimbedacht.nu/trefzekerwinkel/meubilair...uct/268-butler-james and click the button"aan winkelwagen toevoegen"
then go to: slimbedacht.nu/trefzekerwinkel/winkelwagen/checkout and proceed the checkout.

When the session is empty i can enter my adress, after this step te error occurs. When this happened the error occurs right after clicking next in the shopping cart.

I know how the shipping method used to work. But it's not working properly. I tell you the exact proces:
I go to: shipping methods->press the green button new->choose HikaShop manual shipping plugin->press new.
Instead of creating a new method its editing the first created shipping method. I can only create new methods bij copying them.
Maybe this is where the problems start?

//edit
I have inspected the "new" button and this is the onclick link:
location.href='/trefzekerwinkel/administrator/index.php?option=com_hikashop&ctrl=plugins&plugin_type=shipping&task=edit&name=manual&subtask=shipping_edit';

It says edit instead of new

thanks

Last edit: 10 years 4 months ago by jannick.

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

  • Posts: 13201
  • Thank you received: 2322
10 years 4 months ago #164852

Hi,

What is your HikaShop version number ?
We had problems with sessions in 2.3.1, but this should be corrected in the 2.3.2 available on our website.

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

  • Posts: 26
  • Thank you received: 1
10 years 4 months ago #164908

I use version: 2.3.2.

I remember an error during the update 2.3.1. - 2.3.2

An error has occurred.
0 Missing field in database: JTableContenttype type_alias.

I couldn't find out the problem.
Could this be the problem?
Everything worked fine.

Last edit: 10 years 4 months ago by jannick.

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

  • Posts: 12953
  • Thank you received: 1778
10 years 4 months ago #164930

Hello,
Can you create your shipping manually and test it again ?

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

  • Posts: 26
  • Thank you received: 1
10 years 4 months ago #165002

hi,

this is what i do: I go to: shipping methods->press the green button new->choose HikaShop manual shipping plugin->press new.

So this is already a manual shipping method, isn't it?

I brought the website to my localhost and logged this errors when proceed the checkout:

Warning: Creating default object from empty value in C:\xampp\htdocs\trefzeker3\plugins\hikashopshipping\manual\manual.php on line 36
Notice: Undefined property: stdClass::$shipping_max_volume in C:\xampp\htdocs\trefzeker3\plugins\hikashopshipping\manual\manual.php on line 158

php version localhost is: 5.5.36

Last edit: 10 years 4 months ago by jannick.

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

  • Posts: 26
  • Thank you received: 1
10 years 4 months ago #165014

Hi,

I fixed the problem. Some how the manual shipping plugin was installed wrong. The files in the folder contained not the right code. I replaced the files with the right files and it's working properly now.

Thanks for the help, the service is great!

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

  • Posts: 26
  • Thank you received: 1
10 years 3 months ago #165696

Hi hikashop,

I'm having another problem with the shipping method in the checkout.

checkout proces:
step 1: select shipping location(type manual shipping plugin) and the cart
step 2: adress
step 3: extra field(additional information)

When i fill in the adress fields and press next I see the shipping adress and the billing adres, this is al working fine.
But when I press next or create a new adress and press next the checkout is going back to step 1.
This is because the selected shipping location is not selected any more.

When I follow the exact same steps right after this happened the checkout is working properly.

//edit
I noticed when i try it for the second time the url is different on the shipping en billing overview page. The url is .../checkout/task-step/step-1.
When i try it the first time the url is .../checkout/task-step/step-2.

I have disabled chache(also plugin), and set session handler to none, this is not helping.

thanks for the help

Last edit: 10 years 3 months ago by jannick.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 3 months ago #165748

Hi,

The address step will reset the shipping selection since the shipping usually depends on the address of the user.
Normally, you first enter the address and only then you display the shipping selection.
I would recommend to switch the shipping and address views in your checkout workflow and that should avoid the problem.

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

Time to create page: 0.090 seconds
Powered by Kunena Forum