- Posts: 92
- Thank you received: 0
error 1054
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
-- 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.
10 years 7 months ago #227724
by Jerome
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.
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,
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.
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
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.
10 years 7 months ago #227848
by Jerome
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.
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
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,
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',
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