An unexpected database error occurred. Please try again later.

[CoinBit]

Hi. I upgraded the Xenforo from 2.2 to 2.3 and it's giving me this error.

An unexpected database error occurred. Please try again later.

upon checking the source code it says

<!-- User &#039;u811976095_maghrib_pk1607&#039; has exceeded the &#039;max_user_connections&#039; resource (current value: 100) -->

The website works sometimes and then down again. I was out and it stopped working again and haven't come online since 2 hours. The upgraded is very buggy as it destroyed all my skins and probably playing with the add-ons. I have changed the default skin to Xenforo's original and turned off most of the add-ons and was hopefully it is fixed. Any advice will be helpful.

I also checked for years my resources used at the host were not exceeding 8-10% but now suddenly its throwing errors like the following.

Thank you

 

[Old Nick]

I have changed the default skin to Xenforo's original and turned off most of the add-ons and was hopefully it is fixed.

Any advice will be helpful.

Wait until your custom style and third party addons are compatible with XF 2.3, you just have no other alternatives...

 

[CoinBit]

Wait until your custom style and third party addons are compatible with XF 2.3, you just have no other alternatives...

I was using a paid skin but it was causing issues such as the pop up appearing when I pressed the post reply button. So I decided to use the default skin for everyone and then changed the colours to match the previous skin.

The website is down and I need to bring it back even if it means turning off all add-ons and deleting the skins

Is there anyway to turn off the add-on without logging into the Admin CP as it won’t let me do it

 

[Old Nick]

The website is down and I need to bring it back even if it means turning off all add-ons and deleting the skins

Yep, that's what it means...

You can't downgrade your forum, unless you restart from scratch and import a database backup... So you must provide the minimum service with the default style, compatible add-ons if any and wait for third party developers to update their products, styles and addons that you use.

 

[Old Nick]

and deleting the skins

Don't delete it, just disable it.

 

[CoinBit]

Don't delete it, just disable it.

Do you think the website will be up again in few hours as I have been seeing this errror for the past 3 hours

 

[Old Nick]

Is there anyway to turn off the add-on without logging into the Admin CP as it won’t let me do it

Add this to your config.php file @ src/config.php

$config['enableListeners'] = false;

And try access your ACP and deactivate all add-ons...

 

[CoinBit]

Add this to your config.php file @ src/config.php

$config['enableListeners'] = false;

And try access your ACP and deactivate all add-ons...

Excellent,

I was able to disable the add-ons after adding this code and the site seems to be back. But some of the features are very important so I will keep 1 or 2 plugins activated and disable rest of them

Thank you for your help

 

[Rusty Snippets]

Excellent,

I was able to disable the add-ons after adding this code and the site seems to be back. But some of the features are very important so I will keep 1 or 2 plugins activated and disable rest of them

Thank you for your help

If those 1 or 2 addons are not 2.3 compliant, they’ll cause issues.

 

[CoinBit]

If those 1 or 2 addresses ns are not 2.3 compliant, they’ll cause issues.

It's just form statistics plugin which according to the developer was upgraded to 2.3. I had downloaded the latest version published 2 days ago. So I am hoping this plugin works, I have disabled everything else

 

[Old Nick]

was able to disable the add-ons after adding this code

You can remove it now if all incompatible add-ons are disabled.

 

[CoinBit]

Update: I have disabled all plugins and skins but still my CPU usage is touching 100% of the resources. Before 2.3 upgrade it was always displaying as less than 10%.

Any idea what has gone wrong as I am currently using the default skin with everything else turned off? It's clearly a bad upgrade and I am regretting to do that

 

[briansol]

it's possible you have a rogue task still running despite the forum being in 'stock' form now.

have you restarted your mysql and php and apache/nginx services?

 

[CoinBit]

it's possible you have a rogue task still running despite the forum being in 'stock' form now.

have you restarted your mysql and php and apache/nginx services?

I have a cloud hosting and I don’t think I can restart the apache without speaking to customer services and I am trying to do that.

I turned the CDN On and it did drop the CPU usage for few hours but now going up again. It is clear that the increase in CPU only happened after the update as I never saw cpu usage above 12% prior to this update.

Is it possible that it’s linked to Ddos attack?

 

[Jeremy P]

You may want to try applying the hotfix for search rebuilds, which can cause performance issues:

Fixed Post in thread 'xf-rebuild:search --truncate fails with out-of-memory error since XenForo 2.3.0 Final'

Jul 12, 2024

This is fixed a bit more comprehensively in 2.3.1, but replacing src/XF/Job/SearchRebuild.php with the attached file should work in the meantime.

• Jeremy P

• 

 

[CoinBit]

You may want to try applying the hotfix for search rebuilds, which can cause performance issues:

Fixed Post in thread 'xf-rebuild:search --truncate fails with out-of-memory error since XenForo 2.3.0 Final'

Jul 12, 2024

This is fixed a bit more comprehensively in 2.3.1, but replacing src/XF/Job/SearchRebuild.php with the attached file should work in the meantime.

• Jeremy P

• 

Thank you for this. I downloaded the file and was going to update it but then I noticed sudden drop in CPU usage from 100% to 80%.

So I decided to wait for few hours and within 2 hours the CPU came down to 5% without doing anything and it is between 5% to 6% since last 12 hours. I will update the file if it spikes up again

 

[Rusty Snippets]

You may want to try applying the hotfix for search rebuilds, which can cause performance issues:

Fixed Post in thread 'xf-rebuild:search --truncate fails with out-of-memory error since XenForo 2.3.0 Final'

Jul 12, 2024

This is fixed a bit more comprehensively in 2.3.1, but replacing src/XF/Job/SearchRebuild.php with the attached file should work in the meantime.

• Jeremy P

• 

I’ve done this fix and of course now I get the changed file notice on every ACP open. Any way to stop it?

 

[Old Nick]

Any way to stop it?

No until you upgrade to 2.3.1

 

[Rusty Snippets]

No until you upgrade to 2.3.1

Lay it on me!

 

[CoinBit]

So the CPU usage is 100% once again. I have turned off all the plugins once again but the site is still inaccessible. Should I implement the patch provided earlier or is it a DDos attack?