Different results when looged in

  • Posts: 116
  • Thank you received: 1
10 years 8 months ago #184965

-- url of the page with the problem -- : http://walliser-weine
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.5
-- Browser(s) name and version -- : all
-- Error-message(debug-mod must be tuned on) -- : 1054

Hello Support-Team

Happy new year to everybody :)
Thanks for the great support in the past years.

I am not sure if this problem did occure in the previous version. but now i have installed the latest Hikashop 2.3.5 and i can see a strange phanomen.
All queries to see products and product details work fine as long i am not logged in. But as soon i log in the product pages does not show any products anymore.

walliser-weine.ch/shop/index.php/de/wein...ory/rotwein-barrique
As soon i log in with
user: This email address is being protected from spambots. You need JavaScript enabled to view it. PW:mw1956

i get an error 1054 or just no products displayed.

What could be wrong?

Regards

Markus

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

  • Posts: 84304
  • Thank you received: 13698
  • MODERATOR
10 years 8 months ago #185002

Hi,

For reference the error is:

Unknown column 'accepted_zip' in 'where clause' SQL=SELECT DISTINCT b.* FROM q1em7_hikashop_product_category AS a LEFT JOIN q1em7_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN q1em7_hikamarket_vendor AS hikam_vendor ON b.product_vendor_id = hikam_vendor.vendor_id LEFT JOIN q1em7_falang_content AS trans_table ON trans_table.reference_table='hikashop_product' AND trans_table.language_id=2 AND trans_table.reference_field='product_name' AND b.product_id=trans_table.reference_id WHERE (accepted_zip LIKE '%3952%') OR (accepted_zip LIKE '%395*%') OR (accepted_zip LIKE '%39**%') OR (accepted_zip LIKE '%3***%') OR (accepted_zip LIKE '%****%') AND (hikam_vendor.vendor_id IS NULL OR hikam_vendor.vendor_id IN (0,1)) ORDER BY trans_table.value ASC, b.product_name ASC LIMIT 0, 50
The column accepted_zip is not something we have by default in HikaShop.
Do you know of any place where you configured a custom field with the name accepted_zip or developed a custom plugin with that column name or using another extension integrating with HikaShop which would use such name ?
Also, does the zip code 3952 ring a bell ? Did you configure it somewhere on your website ?

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

  • Posts: 116
  • Thank you received: 1
10 years 8 months ago #185117

Hi,

This definetely happens since i have installed the latest HikaShop Version and i haven't installed any other module or made changes.
3952 is the Zip-code of the Shop-provider (Address walliser-weine)!!

I can register a new user, i am getting the Emails and i can activate the account. But when i login with that user and i want to select products from the Category-List, i get this error.

No one can order something anymore!!! :(

Thanks for your help.

Regrds

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

  • Posts: 84304
  • Thank you received: 13698
  • MODERATOR
10 years 8 months ago #185118

Hi,

Well, I don't see why the new version of HikaShop would create that error since there is no accepted_zip column anywhere in HikaShop. So it has to come from another extension.

You only have HikaShop installed on your website, no other extension ? I doubt that.
But ok, create a custom field of the table "product" via the menu Display>Custom fields and call it "accepted_zip" and that will avoid the SQL error. But that column should not even be mentioned in that SQL query...

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

  • Posts: 116
  • Thank you received: 1
10 years 8 months ago #185226

Hi,

The SQL-error is gone but i still cannot display products, categories only when i am logged in.

Regards

Markus

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

  • Posts: 116
  • Thank you received: 1
10 years 8 months ago #185233

Hi again,

I did create a new user, i can make an order, but when i login again with this user, no products are displayed.

But, when i login in with my Admin-account or a vendor account, the products are displayed properly.

Could it be an permission issue?

With one of my earlier emails i asked for displaying the vendor name in some pages. Jerôme mentioned, that he has prepared his program and that this feature should be available also in Hikashop in the next release. Could there be a problem?

Thanks for your feedback.

Regards

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

  • Posts: 12953
  • Thank you received: 1778
10 years 8 months ago #185228

Hello Markus,
What do you exactly mean by :

i still cannot display products, categories only when i am logged in.

Did you use access level on your products/categories can you tell us how you configured your product ?

Last edit: 10 years 8 months ago by Mohamed Thelji.

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

  • Posts: 116
  • Thank you received: 1
10 years 8 months ago #185509

Hi,

Here some examples and screenshots. I didn't change anything beside the installation of the latest HikaShop-version. This worked fine before and it works also when i log in with a vendor or admin-account.

Many thanks for your help. No one can order something at the moment..

Regards

Markus

Attachments:

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

  • Posts: 26274
  • Thank you received: 4045
  • MODERATOR
10 years 8 months ago #185559

Hi,

I guess that you have the "vendor location" plugins activated and these plugins are there to filter the products depending the user address (in order to display the products in the customer area).
That could explain why when you're login you do not see any product if you do not have vendors in your area.

Unpublishing these plugins would solve your issue.
If you still have troubles, will would need a temporally backend access to your website in order to check some elements (that you can send us using the "contact us" page).

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.
The following user(s) said Thank You: MWALTHER

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

  • Posts: 116
  • Thank you received: 1
10 years 8 months ago #185589

Jerome wrote: Hi,

I guess that you have the "vendor location" plugins activated and these plugins are there to filter the products depending the user address (in order to display the products in the customer area).
That could explain why when you're login you do not see any product if you do not have vendors in your area.

Unpublishing these plugins would solve your issue.
If you still have troubles, will would need a temporally backend access to your website in order to check some elements (that you can send us using the "contact us" page).

Regards,

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

Time to create page: 0.087 seconds
Powered by Kunena Forum