Error 500 when updating from 5.0.2 to 5.1.0

  • Posts: 29
  • Thank you received: 4
  • Hikashop Business
9 months 1 week ago #362991

-- url of the page with the problem -- : www.zoecamper.com/
-- HikaShop version -- : 5.0.2
-- Joomla version -- : 4.4.6
-- Browser(s) name and version -- : Firefox
-- Error-message(debug-mod must be tuned on) -- : 500 whoops

Hi,

I hope you re well.

Install gets 500 error when upgrading from 5.0.2 to 5.1.0. I have tried downloading it from my hika account and uploading it and from the list of required updates in Joomla.
Thanks
Zoe

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

  • Posts: 83935
  • Thank you received: 13591
  • MODERATOR
9 months 6 days ago #362994

Hi,

Could you activate the "debug" setting of the joomla configuration and try again ? You should hopefully get a more complete error message which should allow us to tell you what to do.

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

  • Posts: 29
  • Thank you received: 4
  • Hikashop Business
5 months 5 days ago #365148

Sorry for the delay and Happy New Year.

Having turned on debug, I have 2 exceptions and 2 Stack Traces when trying to update from 5.0.2 to 5.1.2. See screenshots.

Thanks

Zoe

Attachments:

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

  • Posts: 83935
  • Thank you received: 13591
  • MODERATOR
5 months 4 days ago #365149

Hi,

The errors are not really coming from HikaShop or Joomla.
They come from your MySQL server.
forum.joomla.org/viewtopic.php?t=998983
joomla.stackexchange.com/questions/933/e...server-has-gone-away
I would recommend asking your hosting company support about it.
They should be able to tell you why this is happening, and potentially even fix it for you in some cases.

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

  • Posts: 29
  • Thank you received: 4
  • Hikashop Business
5 months 1 day ago #365203

Hi,

I have an issue saving or creating products now. I haven't been able to upgrade yet due to the existing SQL issue, so that still stands but now when saving I am getting the 1054 Unknown column 'price_zone_id' in 'field list' error. I cannot edit or add any products.

Thanks

Zoe

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

  • Posts: 83935
  • Thank you received: 13591
  • MODERATOR
5 months 1 day ago #365206

Hi,

Click on the "check database" button of the HikaShop configuration page and it will fix this error.

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

  • Posts: 29
  • Thank you received: 4
  • Hikashop Business
2 weeks 4 days ago #367271

Hi

I hope you are well. I just resubscribed, and I still cannot upgrade HikaShop. It's the same error 500. My host ISP Zen Internet has been working on upgrades to SQL etc. so I was hoping by now all would be well, but it won't upgrade to 5.1.6.

Any chance of someone having a look for me?

Thanks

Zoe

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

  • Posts: 83935
  • Thank you received: 13591
  • MODERATOR
2 weeks 3 days ago #367272

Hi,

Well, the problem is that the errors you provided before ( on this message www.hikashop.com/forum/install-update/90...to-5-1-0.html#365148 ) are normal MySQL queries which should not fail.
These are Joomla MySQL queries, and are not even related to HikaShop.
Also, the error message itself usually happens when the MySQL server is too strained, and because of this, it can't process the MySQL queries anymore.
And since that happens during the installation of an extension, it probably means that the limits imposed by the hosting on the MySQL queries are too great for the important processing needed for all the MySQL queries run by the Joomla installer during that process.

So, that means that even if you provide a backend access, there is not much I'll be able to do. If you reported the issue to the hosting and they were not able to do anything, I suppose you'll have to change your hosting to something a bit more beefy or better configured to be able to support the load during updates.

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

  • Posts: 29
  • Thank you received: 4
  • Hikashop Business
1 week 4 days ago #367413

Hi Nicolas,
I hope you are well.

I was thinking it's the .zip installation that is failing not the 'product' itself. Can I upload it and then unpack the .zip using CPanel file browser for instance?

Thanks :^)

Zoe

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

  • Posts: 83935
  • Thank you received: 13591
  • MODERATOR
1 week 3 days ago #367414

Hi,

Well, the error is about the MySQL queries. Unpacking before the install indeed helps when the issue is about the PHP itself being strained (since the unzip of the files usually also requires a lot of resources). But that doesn't seem to be the case on your website since it complains about the MySQL, not the PHP, so I don't expect it would change anything.
But yes, you can try it. You never know. Maybe it will help.

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

  • Posts: 29
  • Thank you received: 4
  • Hikashop Business
1 week 4 hours ago #367474

All sorted and Hika updated. Zen Internet increased the allowances for services on my account.

Thank you!

Zoe

The following user(s) said Thank You: nicolas

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

Time to create page: 0.079 seconds
Powered by Kunena Forum