Problema baza de date user_max_connection

[|^Wind^|]

Un fost administrator mia instalat foarte multe moduri ... uneel chiar nefolositoare gen phpbb optimize .. acest mod a modificat tabelele si toata baza astfel incat imi da eroarea user_max_connection

Ma poate ajuta cineva dintre administratori sa o rezolv la loc ..

Hostul mia zis ca daca nu rezolv aceasta problema va ramane asa , cica din 12 coreuri , forumul meu le foloseste 4
Uitati logurile catre baza de date pe care le face queriurile

Cod: Selectaţi tot

| 7094187 | xtremexp_forumer     | 89.44.246.252:39249 | xtremexp_forumer | Query          |   22 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094220 | xtremexp_forumer     | 89.44.246.252:39267 | xtremexp_forumer | Query          |   22 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094240 | xtremexp_forumer     | 89.44.246.252:39277 | xtremexp_forumer | Query          |   21 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094241 | xtremexp_forumer     | 89.44.246.252:39278 | xtremexp_forumer | Query          |   21 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094278 | xtremexp_forumer     | 89.44.246.252:39301 | xtremexp_forumer | Query          |   20 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094294 | xtremexp_forumer     | 89.44.246.252:39309 | xtremexp_forumer | Query          |   21 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094295 | xtremexp_forumer     | 89.44.246.252:39310 | xtremexp_forumer | Query          |   21 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094300 | xtremexp_forumer     | 89.44.246.252:39312 | xtremexp_forumer | Query          |   21 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094354 | xtremexp_forumer     | 89.44.246.252:39339 | xtremexp_forumer | Query          |   20 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094360 | iconszon_smf         | 89.44.246.250:50178 | iconszon_smf     | Sleep          |   20 |                      | NULL                                                                                                 |
| 7094366 | xtremexp_forumer     | 89.44.246.252:39345 | xtremexp_forumer | Query          |   18 | Locked               | UPDATE phpbb_topics
                SET topic_views = topic_views + 1, topic_last_view_time = 1300469659
                WHERE t |
| 7094380 | xtremexp_forumer     | 89.44.246.252:39353 | xtremexp_forumer | Query          |   19 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094382 | xtremexp_forumer     | 89.44.246.252:39354 | xtremexp_forumer | Query          |   19 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094393 | xtremexp_forumer     | 89.44.246.252:39356 | xtremexp_forumer | Query          |   19 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094406 | xtremexp_forumer     | 89.44.246.252:39361 | xtremexp_forumer | Query          |   19 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094410 | xtremexp_forumer     | 89.44.246.252:39364 | xtremexp_forumer | Query          |   19 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094439 | xtremexp_forumer     | 89.44.246.252:39370 | xtremexp_forumer | Query          |   18 | Copying to tmp table | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094453 | xtremexp_forumer     | 89.44.246.252:39377 | xtremexp_forumer | Query          |   18 | Locked               | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094459 | xtremexp_forumer     | 89.44.246.252:39381 | xtremexp_forumer | Query          |   18 | Locked               | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094482 | xtremexp_forumer     | 89.44.246.252:39393 | xtremexp_forumer | Query          |   18 | Locked               | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |
| 7094498 | xtremexp_forumer     | 89.44.246.252:39398 | xtremexp_forumer | Query          |   18 | Locked               | SELECT f.*, t.topic_id, t.topic_title FROM (phpbb_forums f) LEFT JOIN phpbb_topics t ON (f.forum_las |

[bogdan]

Daca nu stii ce modificari ai instalat si ai probleme cu scriptul actual, poti suprascrie fisierele forumului cu cele din arhiva originala (mai putin config.php) si reinstala ulterior ce MOD-uri doresti.

Mai intai incearca pe un forum de test (o copie a forumului actual).

[N3@mTzZzU]

ia legatura cu samlus.... Cel mai bine... este de la php-ul serverului node.