General Error SQL ERROR [ mysqli ]

User avatar
DanielIndru
King Meeple
King Meeple
Posts: 5456
Joined: 20 Dec 2010, 10:32
Custom Rank: Going Cardboard
Location: Timisoara
Contact:

General Error SQL ERROR [ mysqli ]

Post: # 103753Post DanielIndru
28 Oct 2019, 10:44

Primesc din cand in cand eroarea asta, dispare dupa un F5:

General Error
SQL ERROR [ mysqli ]

User r62072foru_root already has more than 'max_user_connections' active connections [1203]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

User avatar
VickdaReaper
Super Moderator
Super Moderator
Posts: 3051
Joined: 16 Feb 2010, 19:00
Location: Bucuresti
Contact:

Re: General Error SQL ERROR [ mysqli ]

Post: # 103754Post VickdaReaper
28 Oct 2019, 10:49

Idem.
Pentru board games sunt fidel cum era Castro pentru Cuba...

Colectie

User avatar
Daemian1981
Wizard Meeple
Wizard Meeple
Posts: 259
Joined: 30 Aug 2012, 20:25
Location: Bucuresti

Re: General Error SQL ERROR [ mysqli ]

Post: # 103758Post Daemian1981
28 Oct 2019, 11:11

Mi-a dat eroarea asta cand am incercat sa deschid acest topic :lol:
Dar mi-a mai aparut si in alte locuri.

User avatar
26octombrie
King Meeple
King Meeple
Posts: 3841
Joined: 30 Aug 2012, 15:24
Custom Rank: winner

Re: General Error SQL ERROR [ mysqli ]

Post: # 103761Post 26octombrie
28 Oct 2019, 11:47

me too

Imago
Administrator
Administrator
Posts: 1123
Joined: 13 May 2014, 23:05
Location: Bucuresti

Re: General Error SQL ERROR [ mysqli ]

Post: # 103762Post Imago
28 Oct 2019, 12:06

Cred ca tuturor le-a dat aceasta eroare la un moment dat. Eu evident ca tot am avut-o odata. Refresh si viata merge inainte.
Last edited by Imago on 28 Oct 2019, 12:10, edited 1 time in total.

User avatar
LookyRo
Wizard Meeple
Wizard Meeple
Posts: 290
Joined: 31 Mar 2015, 12:38
Location: Oradea

Re: General Error SQL ERROR [ mysqli ]

Post: # 103763Post LookyRo
28 Oct 2019, 12:09

Nu-mi amintesc s-o fi vazut vreodata; motivul e ca suntem prea multi care intram pe forum simultan :D

User avatar
Haddeo
Administrator
Administrator
Posts: 1740
Joined: 28 Dec 2015, 19:59
Location: Bucuresti

Re: General Error SQL ERROR [ mysqli ]

Post: # 103765Post Haddeo
28 Oct 2019, 12:28

Da, e un semn al popularității forumului :)
But what if they are creating the disaster within themselves?
Things are OK now but I never know when it's going to change.

User avatar
makowey
Chief Meeple
Chief Meeple
Posts: 106
Joined: 06 Aug 2016, 09:52
Location: Sibiu
Contact:

Re: General Error SQL ERROR [ mysqli ]

Post: # 103766Post makowey
28 Oct 2019, 12:30

Cred ca se poate face increase la max_user_connections... am inteles ca se poate seta valoarea 0

User avatar
LookyRo
Wizard Meeple
Wizard Meeple
Posts: 290
Joined: 31 Mar 2015, 12:38
Location: Oradea

Re: General Error SQL ERROR [ mysqli ]

Post: # 103772Post LookyRo
28 Oct 2019, 13:30

makowey wrote:
28 Oct 2019, 12:30
Cred ca se poate face increase la max_user_connections... am inteles ca se poate seta valoarea 0
Depinde de server; unele au nr limitat de conexiuni, in functie de planul tarifar.

Imago
Administrator
Administrator
Posts: 1123
Joined: 13 May 2014, 23:05
Location: Bucuresti

Re: General Error SQL ERROR [ mysqli ]

Post: # 103792Post Imago
28 Oct 2019, 17:42

Cred ca se intampla ceva ciudat - counterul imi arata ca suntem 1309 de utilizatori simultani pe forum, dintre care doar 5 inregistrati. Ca forum, tinand cont de traficul acestuia si de baza de utilizatori de cateva sute de membri, am ales un pachet de date care sa acomodeze acel numar de utilizatori. Nu imi dau seama ce fac acei 1304 de utilizatori neinregistrati... (insa sigur ocupa si ei banda de memorie)

User avatar
makowey
Chief Meeple
Chief Meeple
Posts: 106
Joined: 06 Aug 2016, 09:52
Location: Sibiu
Contact:

Re: General Error SQL ERROR [ mysqli ]

Post: # 103797Post makowey
28 Oct 2019, 19:06

Ar trebui identificați ceilalti care nu sunt autentificati. E posibil ca o mare parte sa fie si boti. Din ce am citit restricția e dată pe userDb nu per totalul de nr. de conexiuni. Poti avea in cazul asta cred si 2 useri pe db cand ajunge la limita. Dar cum s-a pomenit si de planul tarifar e posibil sa fie si o restricție acolo. Trebuie întrebat hosting-ul.

Imago
Administrator
Administrator
Posts: 1123
Joined: 13 May 2014, 23:05
Location: Bucuresti

Re: General Error SQL ERROR [ mysqli ]

Post: # 103858Post Imago
29 Oct 2019, 16:28

O sa caut azi o extensie de blocare a botilor, pentru ca avem 11 utilizatori reali, si 1263 de vizitatori guests. Nu stiu de ce au aparut in ultimele zile, insa e un soi de DDOS.

User avatar
danyelb
Wizard Meeple
Wizard Meeple
Posts: 205
Joined: 31 Dec 2018, 01:56
Location: Iasi

Re: General Error SQL ERROR [ mysqli ]

Post: # 103859Post danyelb
29 Oct 2019, 16:38

Si asa s-a spulberat si iluzia cu miile de useri :|

Imago
Administrator
Administrator
Posts: 1123
Joined: 13 May 2014, 23:05
Location: Bucuresti

Re: General Error SQL ERROR [ mysqli ]

Post: # 103861Post Imago
29 Oct 2019, 16:44

danyelb wrote:
29 Oct 2019, 16:38
Si asa s-a spulberat si iluzia cu miile de useri :|
Da, speram atat de mult, insa m-au mintit. Nu mai cred nici in Mos Craciun de azi inainte:)

User avatar
danyelb
Wizard Meeple
Wizard Meeple
Posts: 205
Joined: 31 Dec 2018, 01:56
Location: Iasi

Re: General Error SQL ERROR [ mysqli ]

Post: # 103864Post danyelb
29 Oct 2019, 17:42

Inocenta odata pierduta nu mai poate fi recapatata :(

Imago
Administrator
Administrator
Posts: 1123
Joined: 13 May 2014, 23:05
Location: Bucuresti

Re: General Error SQL ERROR [ mysqli ]

Post: # 103867Post Imago
29 Oct 2019, 18:04

Am trimis un ticket catre host, specificand numarul mare de utilizatori vizitatori. Imediat dupa email traficul a scazut de la 1300 la 70. Cred ca au blocat niste IP-uri, insa poate ca nu pe toate, doar pe cele mai suspicioase.
Cum am timp, verific si eu de pe cPanel IP-urile, sa vad cam ce de pe unde vine.

User avatar
makowey
Chief Meeple
Chief Meeple
Posts: 106
Joined: 06 Aug 2016, 09:52
Location: Sibiu
Contact:

Re: General Error SQL ERROR [ mysqli ]

Post: # 103879Post makowey
29 Oct 2019, 19:20

Se pare ca eroarea persista. Cineva sabotează site-ul :(

User avatar
suf
King Meeple
King Meeple
Posts: 2670
Joined: 30 Jul 2010, 17:16
Location: Timisoara

Re: General Error SQL ERROR [ mysqli ]

Post: # 103881Post suf
29 Oct 2019, 19:26

O fi un bot care face scraping la forumurile cu peste 100000 de posturi.

User avatar
suf
King Meeple
King Meeple
Posts: 2670
Joined: 30 Jul 2010, 17:16
Location: Timisoara

Re: General Error SQL ERROR [ mysqli ]

Post: # 103882Post suf
29 Oct 2019, 19:29

Si cine-i r62072foru_root asta? Ca nu a cumparat nimic de la mine pana acum.

User avatar
makowey
Chief Meeple
Chief Meeple
Posts: 106
Joined: 06 Aug 2016, 09:52
Location: Sibiu
Contact:

Re: General Error SQL ERROR [ mysqli ]

Post: # 103884Post makowey
29 Oct 2019, 19:33

r62072foru_root e userul de baza de date :). El a cam cumpărat si vandut tot ce e pe aici. E tata la useri.

Post Reply

Return to “Despre forum - reguli, feedback, ajutor, noutati”