error 1054

  • Posts: 92
  • Thank you received: 0
9 years 6 months ago #227719

-- url of the page with the problem -- : www.veypro.com
-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.3.13
-- Error-message(debug-mod must be tuned on) -- : 1054
Unknown column 'a.badge_access' in 'where clause' SQL=SELECT a.* FROM xjvk3_hikashop_badge AS a WHERE a.badge_start = 1453798495 OR a.badge_end =0 ) AND a.badge_published=1 AND (a.badge_quantity='' OR a.badge_quantity=-1) AND (badge_discount_id='0' OR badge_discount_id='') AND (a.badge_access = 'all' OR a.badge_access LIKE '%,1,%') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '40' OR badge_category_id LIKE '%,40,%' OR badge_category_id = '200' OR badge_category_id LIKE '%,200,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '199' OR badge_category_id LIKE '%,199,%' OR badge_category_id = '200' OR badge_category_id LIKE '%,200,%' OR badge_category_id = '222' OR badge_category_id LIKE '%,222,%' OR badge_category_id = '38' OR badge_category_id LIKE '%,38,%' OR badge_category_id = '21' OR badge_category_id LIKE '%,21,%' OR badge_category_id = '12' OR badge_category_id LIKE '%,12,%' OR badge_category_id = '40' OR badge_category_id LIKE '%,40,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC

The page you are looking for does not exist or an other error occurred.
Go back or head over to the home page to choose a new direction.

I recently upgraded my Hikashop version to 2.6.1.
Backend work right, but error 1054 display wen I try to see any product in frontend.
Please, I need some help

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

  • Posts: 26264
  • Thank you received: 4043
  • MODERATOR
9 years 6 months ago #227724

Hi,

Please go in your HikaShop configuration and click on the "check database" button in the toolbar.

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: 92
  • Thank you received: 0
9 years 6 months ago #227828

Hi,
I checked database and all tables are ok, but the same error 1054 displays.
Best regards

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

  • Posts: 26264
  • Thank you received: 4043
  • MODERATOR
9 years 6 months ago #227848

Hi,

I'm sorry but that is not possible.
The file "table.sql" in HikaShop 2.6.1 right contains the definition of the badge_access

`badge_access` varchar(255) NOT NULL DEFAULT 'all',
so you should have that column in your database and the "check database" should have re-create you that column if it doesn't exists.

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.

Time to create page: 0.042 seconds
Powered by Kunena Forum