[Skip to main content](#vessel-content) # 1054 - Unknown column 'a.price\_users' in 'where clause' ## - **[thal0029](/forum/user/32076-thal0029 "View thal0029's Profile")** - [![thal0029's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32076-thal0029 "View thal0029's Profile") Topic Author - [ Offline](/forum/user/32076-thal0029) Less More - Posts: 2 - Thank you received: 0 - - 9 years 3 months ago [\#274276](#274276) by [thal0029](/forum/user/32076-thal0029 "View thal0029's Profile") *[1054 - Unknown column 'a.price\_users' in 'where clause'](/forum/25-install-update/891201-1054-unknown-column-a-price-users-in-where-clause#274276 "When I tried to update hikashop to the latest version the site crashed. The front end gives this error message: 1054 - Unknown column 'a.price_users' in 'where clause' backend is a 500 error message. any help would be greatly appreciated! thank you!")* was created by *[thal0029](/forum/user/32076-thal0029 "View thal0029's Profile")* When I tried to update hikashop to the latest version the site crashed. The front end gives this error message: 1054 - Unknown column 'a.price_users' in 'where clause' backend is a 500 error message. any help would be greatly appreciated! thank you! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTIwMS0xMDU0LXVua25vd24tY29sdW1uLWEtcHJpY2UtdXNlcnMtaW4td2hlcmUtY2xhdXNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 3 months ago [\#274277](#274277) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1054 - Unknown column 'a.price\_users' in 'where clause'](/forum/25-install-update/891201-1054-unknown-column-a-price-users-in-where-clause#274277 "When I tried to update hikashop to the latest version the site crashed. The front end gives this error message: 1054 - Unknown column 'a.price_users' in 'where clause' backend is a 500 error message. any help would be greatly appreciated! thank you!")* Hello, Please try perform a "check database" from your HikaShop backend configuration. Displaying the error messages (or checking your PHP error log to see them) would help to get more details about the source of your SQL issue and the nature of your 500 error page. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTIwMS0xMDU0LXVua25vd24tY29sdW1uLWEtcHJpY2UtdXNlcnMtaW4td2hlcmUtY2xhdXNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[thal0029](/forum/user/32076-thal0029 "View thal0029's Profile")** - [![thal0029's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32076-thal0029 "View thal0029's Profile") Topic Author - [ Offline](/forum/user/32076-thal0029) Less More - Posts: 2 - Thank you received: 0 - - 9 years 3 months ago [\#274446](#274446) by [thal0029](/forum/user/32076-thal0029 "View thal0029's Profile") Replied by *[thal0029](/forum/user/32076-thal0029 "View thal0029's Profile")* on topic *[1054 - Unknown column 'a.price\_users' in 'where clause'](/forum/25-install-update/891201-1054-unknown-column-a-price-users-in-where-clause#274446 "When I tried to update hikashop to the latest version the site crashed. The front end gives this error message: 1054 - Unknown column 'a.price_users' in 'where clause' backend is a 500 error message. any help would be greatly appreciated! thank you!")* I tried uninstalling hikashop and reinstalling it. on the backend I"m getting a 500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed. I have error reporting set to maximum. and no errors show up? And debug system... again no errors. Any other ideas?? Or how else do I get you the information you need to help better? thank you! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTIwMS0xMDU0LXVua25vd24tY29sdW1uLWEtcHJpY2UtdXNlcnMtaW4td2hlcmUtY2xhdXNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 3 months ago [\#274448](#274448) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1054 - Unknown column 'a.price\_users' in 'where clause'](/forum/25-install-update/891201-1054-unknown-column-a-price-users-in-where-clause#274448 "When I tried to update hikashop to the latest version the site crashed. The front end gives this error message: 1054 - Unknown column 'a.price_users' in 'where clause' backend is a 500 error message. any help would be greatly appreciated! thank you!")* Hello, So please check your PHP error log and your Server error log. Without the error message related to the issue, it will be very difficult for us to provide a fix. Due to the SQL error you got, I think your database is not up-to-date so you might got an error during the last update (when the "price_users" column has been added). Afterwards, it might be require to perform the SQL modification manually (all the code is in the "install.hikashop.php" file) but you'll need to know from which version you performed the update. Also, please check the file permission in your website to be sure that all files are up-to-date. If some files were "read only", the old version could still be there and it could also cause SQL errors. You can also see to go directly in specific pages in HikaShop and try to avoid the HikaShop dashboard. But knowing the error message which generate the "500 page" would be far better ! Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTIwMS0xMDU0LXVua25vd24tY29sdW1uLWEtcHJpY2UtdXNlcnMtaW4td2hlcmUtY2xhdXNlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.196 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)