willemb2

Sorry, 2.3.2 did not fully fix it. We were not sending a MailPoet newsletter when it happened this time. But the site is alive and kicking, so don’t let this spoil your weekend.

An error of type E_ERROR was caused in line 589 of the file /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php. Foutmelding: Uncaught PDOException: SQLSTATE[HY000] [1203] User <db_user> already has more than 'max_user_connections' active connections in /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connectors/Connector.php:53
Stack trace:
#0 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connectors/Connector.php(53): PDO->__construct('mysql:host=loca...', '<db_user>', 'M)1ZtJs%cNElD[#...', Array)
#1 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connectors/Connector.php(34): IAWPSCOPED\Illuminate\Database\Connectors\Connector->createPdoConnection('mysql:host=loca...', '<db_user>', 'M)1ZtJs%cNElD[#...', Array)
#2 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connectors/MySqlConnector.php(22): IAWPSCOPED\Illuminate\Database\Connectors\Connector->createConnection('mysql:host=loca...', Array, Array)
#3 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connectors/ConnectionFactory.php(157): IAWPSCOPED\Illuminate\Database\Connectors\MySqlConnector->connect(Array)
#4 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(884): IAWPSCOPED\Illuminate\Database\Connectors\ConnectionFactory->IAWPSCOPED\Illuminate\Database\Connectors\{closure}()
#5 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(913): IAWPSCOPED\Illuminate\Database\Connection->getPdo()
#6 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(374): IAWPSCOPED\Illuminate\Database\Connection->getReadPdo()
#7 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(319): IAWPSCOPED\Illuminate\Database\Connection->getPdoForSelect(true)
#8 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(587): IAWPSCOPED\Illuminate\Database\Connection->IAWPSCOPED\Illuminate\Database\{closure}('select exists(s...', Array)
#9 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(561): IAWPSCOPED\Illuminate\Database\Connection->runQueryCallback('select exists(s...', Array, Object(Closure))
#10 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(323): IAWPSCOPED\Illuminate\Database\Connection->run('select exists(s...', Array, Object(Closure))
#11 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Query/Builder.php(2250): IAWPSCOPED\Illuminate\Database\Connection->select('select exists(s...', Array, true)
#12 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Query/Builder.php(2267): IAWPSCOPED\Illuminate\Database\Query\Builder->exists()
#13 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/IAWP/Database.php(39): IAWPSCOPED\Illuminate\Database\Query\Builder->doesntExist()
#14 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/iawp-bootstrap.php(249): IAWP\Database::is_missing_all_tables()
#15 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/iawp.php(70): require_once('/var/www/vhosts...')
#16 /var/www/vhosts/example.com/httpdocs/wp-settings.php(473): include_once('/var/www/vhosts...')
#17 /var/www/vhosts/example.com/httpdocs/wp-config.php(108): require_once('/var/www/vhosts...')
#18 /var/www/vhosts/example.com/httpdocs/wp-load.php(50): require_once('/var/www/vhosts...')
#19 /var/www/vhosts/example.com/httpdocs/wp-admin/admin-ajax.php(22): require_once('/var/www/vhosts...')
#20 {main}
Next IAWPSCOPED\Illuminate\Database\QueryException: SQLSTATE[HY000] [1203] User <db_user> already has more than 'max_user_connections' active connections (SQL: select exists(select * from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = <db_user> and TABLE_NAME LIKE wp_independent_analytics_%) as exists) in /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php:589
Stack trace:
#0 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(561): IAWPSCOPED\Illuminate\Database\Connection->runQueryCallback('select exists(s...', Array, Object(Closure))
#1 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(323): IAWPSCOPED\Illuminate\Database\Connection->run('select exists(s...', Array, Object(Closure))
#2 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Query/Builder.php(2250): IAWPSCOPED\Illuminate\Database\Connection->select('select exists(s...', Array, true)
#3 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/vendor/illuminate/database/Query/Builder.php(2267): IAWPSCOPED\Illuminate\Database\Query\Builder->exists()
#4 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/IAWP/Database.php(39): IAWPSCOPED\Illuminate\Database\Query\Builder->doesntExist()
#5 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/iawp-bootstrap.php(249): IAWP\Database::is_missing_all_tables()
#6 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/independent-analytics/iawp.php(70): require_once('/var/www/vhosts...')
#7 /var/www/vhosts/example.com/httpdocs/wp-settings.php(473): include_once('/var/www/vhosts...')
#8 /var/www/vhosts/example.com/httpdocs/wp-config.php(108): require_once('/var/www/vhosts...')
#9 /var/www/vhosts/example.com/httpdocs/wp-load.php(50): require_once('/var/www/vhosts...')
#10 /var/www/vhosts/example.com/httpdocs/wp-admin/admin-ajax.php(22): require_once('/var/www/vhosts...')
#11 {main} thrown

• This reply was modified 11 months, 3 weeks ago by willemb2.

I will. The next one is due April 6th. We installed IA about a month ago. A newsletter was sent once before without this error occurring. But that was before 2.3.0 and I have changed a setting since then: enabled ‘Track logged in users’.

Hi @bensibley,

That returns a value of 75. I have sites on 2 other hosting comanies and they also return 75. They are similar though, all based on Plesk and Litespeed.

Thanks for clarifying, @lynnjat7. We’re currently very happy with the Italian alternative. The next time I need a newsletter setup I’ll check back here to see what the outcome of the A12s rethinking is.

To make us come back anything related to Google or tracking should be absent or at least strictly optional. We don’t like the Pied Pipers tune and we don’t want to look at the Internet through his colored goggles.

This is how the people from Ninja Forms do it: they publish a link to the beta (pre-release copy they call it) right in the support topic here on www.ads-software.com. The users affected by ‘fatal errors’ or other severe issues are always eager to test and report back their results, usually within a few hours. If no negative side effects are being reported, the fix is published as a new release 3-5 days later. Example.

Hello @geraltrivia,

Thanks for clarifying this. Over the past week we have evaluated alternatives to MailPoet and we think we have found a plugin that is still capable of sending newsletters to inform our members, instead of campaigns to track people and trick them into impulse buys.

Adding to that: yesterday, March 6 2024 the Digital Markets Act (DMA) became effective in Europe and in the course of the year extra steps in the Digital Services Act will be taken. These will make Google’s business model* become a lot less profitable. So embedding Google Maps might become expensive or they might even stop offering it.

So this is another reason to have an alternative.

*) ‘our service for your data and we will not tell you how much money we make on your data’

Hello @d0153,

Thanks for the update. If I can help by doing beta testing, let me know.

In the meantime I have come across this topic on your old forum. I tried the code provided there in my child theme’s functions.php, but it doesn’t change the order. Maybe TEC itself has undergone changes since 2018 causing that fix to work no longer.

Hello @tristan083,

1. PHP 8.1.22
2. WordPress 6.4.3
3. The Events Calendar 6.3.3.1
4. Theme and Version ColorMag Pro 4.1.4

But as I wrote, I’m seeing the same issue at your demo calendar feed.

Thank you, @plamenm. That worked.

Hello @plamenm,

Here’s the wp-debug.log:

[22-Feb-2024 21:52:23 UTC] PHP Fatal error: Uncaught TypeError: array_key_exists(): Argument #1 ($key) must be a valid array offset type in /var/www/vhosts/domain.tld/httpdocs/wp-content/plugins/sg-security/vendor/siteground/siteground-data/src/Settings.php:352
Stack trace: 0 /var/www/vhosts/domain.tld/httpdocs/wp-content/plugins/sg-security/vendor/siteground/siteground-data/src/Settings.php(352): array_key_exists(Array, Array) 1 /var/www/vhosts/domain.tld/httpdocs/wp-content/plugins/sg-security/vendor/siteground/siteground-data/src/Settings.php(292): SiteGround_Data\Settings->get_hosting_provider() 2 /var/www/vhosts/domain.tld/httpdocs/wp-content/plugins/sg-security/vendor/siteground/siteground-data/src/Settings.php(213): SiteGround_Data\Settings->get_main_data() 3 /var/www/vhosts/domain.tld/httpdocs/wp-content/plugins/sg-security/vendor/siteground/siteground-data/src/Settings.php(139): SiteGround_Data\Settings->prepare_data() 4 /var/www/vhosts/domain.tld/httpdocs/wp-content/plugins/sg-security/vendor/siteground/siteground-data/src/Settings.php(126): SiteGround_Data\Settings->send_data() 5 /var/www/vhosts/domain.tld/httpdocs/wp-content/plugins/sg-security/uninstall.php(49): SiteGround_Data\Settings->stop_collecting_data() 6 /var/www/vhosts/domain.tld/httpdocs/wp-admin/includes/plugin.php(1245): include_once('/var/www/vhosts…') 7 /var/www/vhosts/domain.tld/httpdocs/wp-admin/includes/plugin.php(960): uninstall_plugin('sg-security/sg-…') 8 /var/www/vhosts/domain.tld/httpdocs/wp-admin/includes/ajax-actions.php(4748): delete_plugins(Array) 9 /var/www/vhosts/domain.tld/httpdocs/wp-includes/class-wp-hook.php(324): wp_ajax_delete_plugin('') 10 /var/www/vhosts/domain.tld/httpdocs/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters('', Array) 11 /var/www/vhosts/domain.tld/httpdocs/wp-includes/plugin.php(517): WP_Hook->do_action(Array) 12 /var/www/vhosts/domain.tld/httpdocs/wp-admin/admin-ajax.php(188): do_action('wp_ajax_delete-…') 13 {main}
thrown in /var/www/vhosts/domain.tld/httpdocs/wp-content/plugins/sg-security/vendor/siteground/siteground-data/src/Settings.php on line 352

• This reply was modified 1 year ago by willemb2.

Hello @plamenm,

I have no problem deleting other plugins. In fact there were 2 others by Siteground: Speed Optimizer and ….. This site was moved from Siteground to another hosting about a month ago.

Those rules are not present in wp-config.php. But I noticed something else. Could this be related:

/** Sets up WordPress vars and included files. */
@include_once('/var/lib/sec/wp-settings-pre.php'); // Added by SiteGround WordPress management system
require_once ABSPATH . 'wp-settings.php';
@include_once('/var/lib/sec/wp-settings.php'); // Added by SiteGround WordPress management system

In all my other 6 sites wp-settings.php is in the same folder as wp-config.php and none of them has a wp-settings-pre.php

@frankremmy Thanks, that works. Very elegant solution without @media only screen stuff.

Thanks, @d0153. That works fine, even without the !important. On mobile, the 3 columns are stacked beneath each other. That is per design, I assume. But IMHO it could use a separator or some padding above the 2nd (organizer) and 3rd (venue).

• This reply was modified 1 year, 1 month ago by willemb2.

Some more info: WP 6.4.3, PHP 8.1.22, theme: Colormag Pro 4.1.2