Skip to main content

error 1054

More
10 years 7 months ago #227719 by pymgym
error 1054 was created by pymgym
-- 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.

More
10 years 7 months ago #227724 by Jerome
Replied by Jerome on topic error 1054
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.

More
10 years 7 months ago #227828 by pymgym
Replied by pymgym on topic error 1054
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.

More
10 years 7 months ago #227848 by Jerome
Replied by Jerome on topic error 1054
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
Code:
`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.186 seconds
Powered by Kunena Forum