Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 12 Sep 2013, 17:18
creative-friend creative-friend is offline
 
Join Date: Feb 2009
Databse Error

Hi Guys,

Am getting these database error since two days, i really dont understand why am i getting these......anyone recognise these??

Database error in vBulletin 4.2.1:

Invalid SQL:
SELECT
P.userid, COUNT(userid) AS times
FROM thread AS T
INNER JOIN post AS P ON T.lastpostid=P.postid
WHERE P.userid=920
GROUP BY P.userid
ORDER BY P.dateline DESC, P.userid;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, September 11th 2013 @ 01:11:17 PM
Error Date : Wednesday, September 11th 2013 @ 01:15:02 PM

.........................................................

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'> function.mysql-connect</a>]: User 'shahzeb_shahzeb' has exceeded the 'max_user_connections' resource (current value: 1)
/home/shahzeb/public_html/includes/class_core.php on line 317

MySQL Error :
Error Number :
Request Date : Wednesday, September 11th 2013 @ 01:31:47 PM
Error Date : Wednesday, September 11th 2013 @ 01:31:47 PM
Reply With Quote
  #2  
Old 12 Sep 2013, 17:44
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
'shahzeb_shahzeb' has exceeded the 'max_user_connections' resource

It looks like your webhost has it set so you can only use 1 MySQL connection at a tie, you should get in touch with your webhost.
__________________
Looking for ImpEx?
Reply With Quote
  #3  
Old 12 Sep 2013, 17:56
creative-friend creative-friend is offline
 
Join Date: Feb 2009
Yes i have and they told me that they have put the block on my site.....I have asked them to open it for me to look in it and sort it out.....when they open the site what do i have to do to get rid of it???
Reply With Quote
  #4  
Old 12 Sep 2013, 18:03
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Get a better webhost.
__________________
Looking for ImpEx?
Reply With Quote
  #5  
Old 12 Sep 2013, 18:14
creative-friend creative-friend is offline
 
Join Date: Feb 2009
Originally Posted by Zachery View Post
Get a better webhost.
LOL

I am using hostgator

But even when the site is off....i am still receving the Emails of database error....i really dont know why....

No activity on site still receving the Emails of Database error.....
Reply With Quote
  #6  
Old 12 Sep 2013, 18:40
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Hostgator is the pinnacle of webhosting now? There are thousands, of webhosts out here. By shear numbers, at least one is better, and a lot more than 1 are better.
__________________
Looking for ImpEx?
Reply With Quote
  #7  
Old 12 Sep 2013, 19:34
creative-friend creative-friend is offline
 
Join Date: Feb 2009
Okay i will have a look

Let me know any good ones please
Reply With Quote
  #8  
Old 12 Sep 2013, 19:36
teamemmenracing teamemmenracing is offline
 
Join Date: Apr 2007
I got 434 email messages with database errors just like those on the 10th septon the 11th my site was hacked .....
Reply With Quote
  #9  
Old 12 Sep 2013, 19:44
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
It is possible his site was hacked, hard for him to do anything about it when his webhost isn't letting him fix it.

I like asmallorange, and wiredtree. Personally.
__________________
Looking for ImpEx?
Reply With Quote
  #10  
Old 12 Sep 2013, 20:48
creative-friend creative-friend is offline
 
Join Date: Feb 2009
Originally Posted by teamemmenracing View Post
I got 434 email messages with database errors just like those on the 10th septon the 11th my site was hacked .....
Originally Posted by Zachery View Post
It is possible his site was hacked, hard for him to do anything about it when his webhost isn't letting him fix it.

I like asmallorange, and wiredtree. Personally.
Yes you are right my site was hacked two days ago after that i start getting these Emails.....

My host have allowed me to access my site.....

Now whats the next step i should do to fix it...??any kind of mod which can help.....

they have Emailed me this aswell

Here are the top 10 database tables for the database which appears to have caused the issue. This is by row count.

Database shahzeb_pakistanipoint
Tables Columns Total Rows
------------------------------------|
| xperience_stats_changes | 8 | 2470459 |
| searchcore | 10 | 1473941 |
| searchcore_text | 3 | 1473882 |
| post | 19 | 1389915 |
| ipdata | 8 | 448759 |
| contentread | 7 | 448759 |
| tagcontent | 6 | 393795 |
| reputation | 7 | 260042 |
| post_thanks | 5 | 187698 |
| searchgroup_text | 2 | 187523 |

What can i do about it??
Reply With Quote
  #11  
Old 12 Sep 2013, 20:50
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
General advice post:

Please read the following two blog posts:
http://www.vbulletin.com/forum/blogs...ve-been-hacked
http://www.vbulletin.com/forum/blogs...vbulletin-site
Also please see these recent security announcements:
vBulletin 4.1.x-4.2.x & All versions of vBulletin 5: http://www.vbulletin.com/forum/forum...-1-vbulletin-5
vBulletin 5.0.x patch released, for a different security issue: http://www.vbulletin.com/forum/forum...d-all-versions
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not 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


New To Site? Need Help?

All times are GMT. The time now is 23:53.

Layout Options | Width: Wide Color: