WP Google Maps Crashes Website
-
We had to rename the folder where this plugin was stored because it was generating too many user connections to the database, crashing the site completely. Please see the error message:
Fatal error: SQLSTATE[42000] [1203] User **** already has more than ‘max_user_connections’ active connections in /home/gonzo/domains/***.com/public_html/members/library/Am/Lite.php on line 885
The error message is linked to the aMember plugin but was in fact caused by WP Google Maps locking up queries :
| 130 | gonzo_dbadmin | localhost | gonzo_wp | Query | 0 | creating table | ALTER TABLE qbr521e_wpgmza_maps CHANGE COLUMN traffic traffic INT(10) NOT NULL |
| 133 | gonzo_dbadmin | localhost | gonzo_wp | Query | 39 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN polyname polyname VARCHAR(100) NOT NULL |
| 137 | gonzo_dbadmin | localhost | gonzo_wp | Query | 75 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohopacity ohopacity VARCHAR(3) NOT NULL |
| 139 | gonzo_dbadmin | localhost | gonzo_wp | Query | 31 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohopacity ohopacity VARCHAR(3) NOT NULL |
| 141 | gonzo_dbadmin | localhost | gonzo_wp | Query | 19 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohopacity ohopacity VARCHAR(3) NOT NULL |
| 144 | gonzo_dbadmin | localhost | gonzo_wp | Query | 63 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohlinecolor ohlinecolor VARCHAR(7) NOT NULL |
| 146 | gonzo_dbadmin | localhost | gonzo_wp | Query | 38 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohlinecolor ohlinecolor VARCHAR(7) NOT NULL |
| 148 | gonzo_dbadmin | localhost | gonzo_wp | Query | 36 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohlinecolor ohlinecolor VARCHAR(7) NOT NULL |
| 151 | gonzo_dbadmin | localhost | gonzo_wp | Query | 4 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohlinecolor ohlinecolor VARCHAR(7) NOT NULL |
| 153 | gonzo_dbadmin | localhost | gonzo_wp | Query | 82 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohfillcolor ohfillcolor VARCHAR(7) NOT NULL |
| 156 | gonzo_dbadmin | localhost | gonzo_wp | Query | 56 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohfillcolor ohfillcolor VARCHAR(7) NOT NULL |
| 159 | gonzo_dbadmin | localhost | gonzo_wp | Query | 50 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohfillcolor ohfillcolor VARCHAR(7) NOT NULL |
| 161 | gonzo_dbadmin | localhost | gonzo_wp | Query | 46 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohfillcolor ohfillcolor VARCHAR(7) NOT NULL |There’s a lot more, I only pasted an excerpt.
Please advise.
Thank you,
Alain
The topic ‘WP Google Maps Crashes Website’ is closed to new replies.