Hey VerticalScope, our database sucks - Xtratime Community
 37Likes
Reply
 
LinkBack Thread Tools Display Modes
post #1 of 231 (permalink) Old February 16th, 2014, 23:48 Thread Starter
*the drum drum*
Xtratime Legend
 
Zico 10's Avatar
 
Join Date: 09 2000
Posts: 42,433
Hey VerticalScope, our database sucks

Guys,

Sick of shooting off emails to your team to look at the database, so I figure let's make this a community request.

We, the people of XT, want you to please fix the database issues that have been ongoing for several months.

Cheers.

EDIT - Instructions on how to report the error behind the error so VS can realise that they need to allow XT more connections.
Zico 10 is offline  
Sponsored Links
Advertisement
 
post #2 of 231 (permalink) Old February 16th, 2014, 23:51
Administrators
Xtratime Legend
 
Inácio's Avatar
 
Join Date: 08 2002
Location: Portugal
Teams: SL Benfica
Posts: 24,345
hell yes!!!!

"there is a crack in everything, that's how the light gets in"

"rocks on my path? i keep them all , one day i'll build a castle"
Inácio is offline  
post #3 of 231 (permalink) Old February 16th, 2014, 23:53
TTM
Forum Manager
Legend
 
TTM's Avatar
 
Join Date: 11 2011
Posts: 12,168
**** yes damn it!

Ding ding ding da ding da ding ding ding
TTM is offline  
 
post #4 of 231 (permalink) Old February 16th, 2014, 23:56
Forum Manager
World Class Player
 
YesilTimsah's Avatar
 
Join Date: 01 2011
Location: Delaware, USA
Teams: Bursaspor, Turkiye
Posts: 8,439
Signed.

Get it fixed you mugs.

Adı Aşk Bu Eziyetin
YesilTimsah is offline  
post #5 of 231 (permalink) Old February 17th, 2014, 00:02
The Parameter
Star Player
 
Harokin's Avatar
 
Join Date: 01 2011
Location: Europe
Teams: Real, Barca, ManU, ManC, Chelsea, Bayern, Juve, PSG
Posts: 4,309
Don't do it!

I like things as it is.

EDIT: Dammit, having trouble posting!
Harokin is offline  
post #6 of 231 (permalink) Old February 17th, 2014, 00:02
Hateful extremist
Forum Manager
Xtratime Legend
 
Nacka's Avatar
 
Join Date: 09 2001
Teams: FC Internazionale
Posts: 22,056


This message was brought to you by VerticalScope

Quote:
Originally Posted by BM_1 View Post
ha! i read about height. nacka, you are mongoloid.
Materazzi: "Benitez is one of those who thinks they know everything and if you meet him in the pub you will punch him."
Nacka is offline  
post #7 of 231 (permalink) Old February 17th, 2014, 00:16
First Place winner, June 2010 Photo Contest
Xtratime Legend
 
Boyo's Avatar
 
Join Date: 05 2000
Posts: 36,652
Blog Entries: 7
This is a very dangerous request. You first have to tell them exactly what's wrong and then in great detail how it should be fixed, otherwise they might just delete the whole thing. "You wanted it fixed? It's fixed! What's the problem?!"

Woke AF!
Boyo is offline  
post #8 of 231 (permalink) Old February 17th, 2014, 00:59
Administrators
Legend
 
Reza's Avatar
 
Join Date: 08 2001
Location: Canada
Teams: Milan
Posts: 10,717
I will fix .... for a fee
Reza is offline  
post #9 of 231 (permalink) Old February 17th, 2014, 00:59
Administrators
Legend
 
Reza's Avatar
 
Join Date: 08 2001
Location: Canada
Teams: Milan
Posts: 10,717
^ That was to VerticalScope by the way, not community funding
Reza is offline  
post #10 of 231 (permalink) Old February 17th, 2014, 01:08 Thread Starter
*the drum drum*
Xtratime Legend
 
Zico 10's Avatar
 
Join Date: 09 2000
Posts: 42,433
I will fix, given access.

Haven't touched a database or run an SQL query in a decade, but I'll figure it out.
Zico 10 is offline  
post #11 of 231 (permalink) Old February 17th, 2014, 18:19
Forum Manager
Xtratime Legend
 
The Green One's Avatar
 
Join Date: 04 2002
Location: M22
Teams: Manchester City, West Didsbury & Chorlton AFC
Posts: 38,223
XT always sucked, stop blaming VS. Those guys are cool.

Quote:
Originally Posted by Rob
Of course you need TGO you retards.
Quote:
Originally Posted by Mutu
ill be honest, im plastered but i well into that women and she was me and i lost her ass
The Green One is offline  
post #12 of 231 (permalink) Old February 18th, 2014, 06:36
Administrators
Xtratime Legend
 
JCamilo's Avatar
 
Join Date: 08 2002
Location: Brasil
Teams: Atletico-MG
Posts: 28,566
Sad day when a legit englishman goes licking canadian balls...

Kat: "JCam, you may quote me now, but you are quite wise".

Kat: "JCam knows, we do not doubt in him".
JCamilo is offline  
post #13 of 231 (permalink) Old February 20th, 2014, 12:31 Thread Starter
*the drum drum*
Xtratime Legend
 
Zico 10's Avatar
 
Join Date: 09 2000
Posts: 42,433
When you get a database error, please do the following.

Step 1 - Don't refresh the page! Not yet ..

Step 2 - View the source for the page with the database error
......In Chrome, right-click somewhere on the page then select View page source
......In Internet Explorer, right-click and then select View source
......etc

Step 3 - Look for a section in that code that starts with "<!-- Database error in vBulletin"

Step 4 - copy that text, REMOVE YOUR IP ADDRESS, and paste that code into this thread.

Example of the section of code,



Do not be shy and feel free to post the snippet of code every time you receive it. Even if it's the same error.
Zico 10 is offline  
post #14 of 231 (permalink) Old February 20th, 2014, 13:06
First Place winner, June 2010 Photo Contest
Xtratime Legend
 
Boyo's Avatar
 
Join Date: 05 2000
Posts: 36,652
Blog Entries: 7
Seems like the site isn't on a dedicated server... or TBF tripped on the cable again.

Woke AF!
Boyo is offline  
post #15 of 231 (permalink) Old February 20th, 2014, 14:37
Administrators
Legend
 
Reza's Avatar
 
Join Date: 08 2001
Location: Canada
Teams: Milan
Posts: 10,717
Takes me back to the days I was using vBulletin. MySQLi and vbulletin were both good and bad together.

EDIT: And by the way "Too many connections" is pretty clear cut, usually there is only one solution.
Reza is offline  
post #16 of 231 (permalink) Old February 20th, 2014, 15:06
Müdür müdür müdür
Forum Manager
World Class Player
 
rastgele's Avatar
 
Join Date: 05 2007
Location: Where I live
Teams: The Best o TSL
Posts: 8,433
Database error in vBulletin :

mysqli_real_connect(): (HY000/1040): Too many connections
/usr/sites/xtratime.org/www/htdocs/forum/includes/class_core.php on line 1040

MySQL Error :
Error Number :
Date : Thursday, February 20th 2014 @ 10:04:31 AM
Script : https://www.xtratime.org/forum/
Referrer : https://www.xtratime.org/
Username :
Classname : vB_Database_MySQLi

BAM BAM BAM
rastgele is offline  
post #17 of 231 (permalink) Old February 20th, 2014, 15:22
YBC
Legend
 
Join Date: 06 2011
Posts: 12,331
YBC is offline  
post #18 of 231 (permalink) Old February 20th, 2014, 15:25
Müdür müdür müdür
Forum Manager
World Class Player
 
rastgele's Avatar
 
Join Date: 05 2007
Location: Where I live
Teams: The Best o TSL
Posts: 8,433
what's your ip address YBC? Zico needs that.

BAM BAM BAM
rastgele is offline  
post #19 of 231 (permalink) Old February 20th, 2014, 15:25
YBC
Legend
 
Join Date: 06 2011
Posts: 12,331
12.34.567.89
YBC is offline  
post #20 of 231 (permalink) Old February 20th, 2014, 19:50 Thread Starter
*the drum drum*
Xtratime Legend
 
Zico 10's Avatar
 
Join Date: 09 2000
Posts: 42,433
Quote:
Originally Posted by Boyo View Post
Seems like the site isn't on a dedicated server... or TBF tripped on the cable again.
Yep, the other error that pops up is as telling as it gets,

mysqli_real_connect(): (HY000/1203): User xtratime already has more than 'max_user_connections' active connections
Zico 10 is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the Xtratime Community forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive. Try to avoid choosing short (like '1'), simple (like 'abcd') and easy to guess passwords (like a name of your favorite team, player, etc)! Complex and long enough passwords, that consists of random string of alphabet and numerical characters, are almost impossible to be stolen and misused.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in











Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome