Databse Error

[creative-friend]

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

[Zachery]

'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.

[creative-friend]

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???

[Zachery]

Get a better webhost.

[creative-friend]

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.....

[Zachery]

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.

[creative-friend]

Okay i will have a look

Let me know any good ones please

[teamemmenracing]

I got 434 email messages with database errors just like those on the 10th septon the 11th my site was hacked .....

[Zachery]

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.

[creative-friend]

I got 434 email messages with database errors just like those on the 10th septon the 11th my site was hacked .....

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??

[ozzy47]

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/zachery/3993888-fixing-your-site-after-you-have-been-hacked)
http://www.vbulletin.com/forum/blogs...vbulletin-site (http://www.vbulletin.com/forum/blogs/zachery/3993849-best-practices-for-securing-your-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 (http://www.vbulletin.com/forum/forum/vbulletin-announcements/vbulletin-announcements_aa/3991423-potential-vbulletin-exploit-vbulletin-4-1-vbulletin-5)
vBulletin 5.0.x patch released, for a different security issue: http://www.vbulletin.com/forum/forum...d-all-versions (http://www.vbulletin.com/forum/forum/vbulletin-announcements/vbulletin-announcements_aa/3993204-vbulletin-5-connect-security-patches-released-all-versions)