Forum SQL errors on the front and back end

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
JohnW63
Registered User
Posts: 163
Joined: Tue Jul 12, 2011 2:37 am
Name: John Williamson

Forum SQL errors on the front and back end

Post by JohnW63 »

I have found that when I click on some of the tables to open them in phpMyAdmin, I get errors. Such as:

mysqli_connect(): (HY000/2002): Connection refused

mysqli_real_connect(): (HY000/2002): Connection refused

and

Failed to set configured collation connection!

I tried a quick " Repair database, but that didn't fix the issue.

On occasion I will get SQL errors just using the forum. Generally a reload gets me past it.
My server host had to "reindex" my database a few weeks ago. Clearly, that didn't fix the issue.

Here are the details under the errors:


Notice in ./libraries/classes/Config.php#909
Undefined index: collation_connection

Backtrace

./libraries/classes/Config.php#1022: PhpMyAdmin\Config->_setConnectionCollation()
./libraries/common.inc.php#457: PhpMyAdmin\Config->loadUserPreferences()
./sql.php#21: require_once(./libraries/common.inc.php)
Notice in ./libraries/classes/DatabaseInterface.php#1536
Undefined index: charset_connection

Backtrace

./libraries/classes/Config.php#911: PhpMyAdmin\DatabaseInterface->setCollation(string 'utf8mb4_unicode_ci')
./libraries/classes/Config.php#1022: PhpMyAdmin\Config->_setConnectionCollation()
./libraries/common.inc.php#457: PhpMyAdmin\Config->loadUserPreferences()
./sql.php#21: require_once(./libraries/common.inc.php)


I checked the database root level and my collation is "latin1_swedish_ci", but when I can get it to let me see the list of all table info, all of them say "utf8_bin" as the collation. Should the top level and the sub tables match?

If I click on browse for a table, I get

" Error

SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = OFF;
"



Since I installed this fresh not that long ago, I can't figure out what the cause could be.
User avatar
HiFiKabin
Community Team Member
Community Team Member
Posts: 6673
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact:

Re: Forum SQL errors on the front and back end

Post by HiFiKabin »

This appears to be an error within your cPanel and as such you should be seeking support from your hosts
JohnW63
Registered User
Posts: 163
Joined: Tue Jul 12, 2011 2:37 am
Name: John Williamson

Re: Forum SQL errors on the front and back end

Post by JohnW63 »

So, the collation settings I have are OK?
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26505
Joined: Fri Aug 29, 2008 9:49 am

Re: Forum SQL errors on the front and back end

Post by Mick »

HiFiKabin wrote: Fri Dec 02, 2022 11:01 amyou should be seeking support from your hosts
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
JohnW63
Registered User
Posts: 163
Joined: Tue Jul 12, 2011 2:37 am
Name: John Williamson

Re: Forum SQL errors on the front and back end

Post by JohnW63 »

Funny. I reported the issue to my host. They then asked for how to reproduce the errors. When I opened phpMyAdmin and started clicking on tables I no longer got errors. Funny how that worked out.
Post Reply

Return to “[3.3.x] Support Forum”