1054 - Unknown column 'a.price_users' in 'where clause'

  • Posts: 2
  • Thank you received: 0
7 years 4 months ago #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!

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

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
7 years 4 months ago #274277

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.

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: 2
  • Thank you received: 0
7 years 4 months ago #274446

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 or Create an account to join the conversation.

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
7 years 4 months ago #274448

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.

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.057 seconds
Powered by Kunena Forum