Error 1054 in Mass Actions filter after Hikashop Upgrade

  • Posts: 10
  • Thank you received: 0
3 years 10 months ago #317917

-- HikaShop version -- : 4.2.3
-- Joomla version -- : 3.9.16
-- PHP version -- : 7.3
-- Browser(s) name and version -- : Any
-- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'hk_user.kundennummer' in 'where clause' SELECT COUNT(DISTINCT hk_user.user_id) FROM otm9q_hikashop_user as hk_user LEFT JOIN otm9q_users as joomla_user ON = hk_user.user_cms_id WHERE (`hk_user.kundennummer` > '500000')


I have a strange filter selection problem in my mass actions. It worked fine in my old version before the last upgrade.
Every time I try to filter a certain custom user field named Kundennummer > 500000 I get a MySQL error.

I do get a certain amount of entries right before I enter the number.

I have a testsystem running and can give you credentials.

Thanks in advance for a tipp.

Best regards


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

  • Posts: 81182
  • Thank you received: 12995
3 years 10 months ago #317925


That's ineed very strange. I don't see why it would generate that error.
We would need a backend access and an access your database in order to check what's going on there.
You can send that along with a link to this thread via our contact form:

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

Time to create page: 0.057 seconds
Powered by Kunena Forum