Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #16  
Old 29 Oct 2014, 07:29
cellarius's Avatar
cellarius cellarius is offline
 
Join Date: Aug 2005
Real name: Sven
Always a good recommendation for backup: http://www.mysqldumper.net/

Also works if you don't have root access.
__________________
Please note that there will be no further updates to my addons, especially they will not be upgraded for vB5. I'm leaving vB, since IB choose to go the banana-way yet again.

http://www.roma-antiqua.de
Reply With Quote
  #17  
Old 29 Oct 2014, 08:12
Marv Marv is offline
 
Join Date: Jun 2002
Originally Posted by cellarius View Post
Always a good recommendation for backup: http://www.mysqldumper.net/

Also works if you don't have root access.
MSQLD is a great tool. Unfortunal, MySQLDump wasn´t really helpful in our case. We had to repair some tables and a few were about 1.6 to 2.4GB. MSQLD couldn´t write this table back to the database, just because of the sheer amount of data. In the end we had to do this via the console. Any known workaround for MSQLD and big tables?
Reply With Quote
  #18  
Old 29 Oct 2014, 08:20
cellarius's Avatar
cellarius cellarius is offline
 
Join Date: Aug 2005
Real name: Sven
mysqldump is not the same as mysqldumper
__________________
Please note that there will be no further updates to my addons, especially they will not be upgraded for vB5. I'm leaving vB, since IB choose to go the banana-way yet again.

http://www.roma-antiqua.de
Reply With Quote
  #19  
Old 29 Oct 2014, 08:58
Marv Marv is offline
 
Join Date: Jun 2002
Erm..I was just lazy and have shortend MySQLDumper to MySQLDump. Guess we´re still talking about the same thing, Sven
Reply With Quote
  #20  
Old 29 Oct 2014, 09:30
Mark.B Mark.B is offline
 
Join Date: Feb 2004
Originally Posted by hilaryl View Post
I agree we should upgrade to 4.2.2 - but I would prefer to upgrade an error free version of vBulletin. I think upgrading while having potential corruption issues would just cause more trouble then it would be worth.

It is definitely something we will look at after getting over this obstacle though.
Sometimes such issues may be caused by bugs in earlier versions.

At the risk of sounding like a stuck record - you really need to upgrade.
It's not just about bugs, your site is *definitely* insecure at the moment due to unpatched security issues. To patch those you need to upgrade.
__________________
MARK.B (Member of the vB Support Team)
Reply With Quote
  #21  
Old 30 Oct 2014, 03:07
hilaryl hilaryl is offline
 
Join Date: Jan 2006
Originally Posted by Mark.B View Post
It's not just about bugs, your site is *definitely* insecure at the moment due to unpatched security issues. To patch those you need to upgrade.
Is this the case even if we have the latest patch's for our version?
Reply With Quote
  #22  
Old 30 Oct 2014, 04:46
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
I had this happen to me a while back, about a year or so ago maybe a bit longer and the issue was search bots hitting our site like fire ants .... the main ones were:

AhrefsBot
Baiduspider
Ezooms
MJ12bot
YandexBot

I used Ban Spiders by User Agent to help with this issue ... now these bots and others don't hit the search feature which is something others around here will say doesn't happen with bots ...

If it worked for me I am sure it will work for you... there is also other things you can do to limit and reduce the amount of hits on your search feature.... you also want to check your mods to see if they are updated .. some modes can attract unwanted activity and actions on your forums ....

And about upgrading .... if you are careful with your site, forums and stay on top of security and suspicious behaviour you don't need to upgrade at all ... I don't mean to insult any of the previous individuals who say you should upgrade but it is not necessary to do so at all ....
Reply With Quote
  #23  
Old 30 Oct 2014, 17:19
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Originally Posted by hilaryl View Post
Is this the case even if we have the latest patch's for our version?
Yes. Only 4.2.2 and 4.2.3 have the latest security fixes. http://www.vbulletin.com/forum/forum...-2-2-and-4-2-3
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #24  
Old 30 Oct 2014, 18:27
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
 
Join Date: Sep 2008
Real name: Michael Miller Jr
Limited space as someone said above and on rare occasions it could be related to spam, check the session table for an insane amount of entries (30k+ records) because once it hits around 30k records the session table is nothing but trouble and you need to truncate the table.

I'm pretty sure the disk space is the factor as Marv mentioned, tracing down the issue before attempting a fix is the best way to go about this though. As the others said upgrade to 4.2.2 in the least as 4.2.3 is still marked as Beta.
__________________
Daddy Does Dios and Figs!
https://www.linkedin.com/in/thelastsuperman

Search - Use the search feature to find similar issues/answers.
Information - Include screenshots, copy/pasted error codes, url etc.
Fixed - Please return to your thread/post and let us know how it was fixed!
Thanks - For participating! Click the "Like" on a post if someone helped you!
Reply With Quote
  #25  
Old 30 Oct 2014, 18:28
tbworld tbworld is offline
 
Join Date: Oct 2008
Originally Posted by CAG CheechDogg View Post
And about upgrading .... if you are careful with your site, forums and stay on top of security and suspicious behaviour you don't need to upgrade at all ... I don't mean to insult any of the previous individuals who say you should upgrade but it is not necessary to do so at all ....
I have looked at the latest patches to vBulletin and although I have not tried to exploit the possible vulnerabilities, it does seem prudent to make the changes. When vBulletin releases their patched distribution, script kiddies get to work and try to exploit older boards that have not upgraded. Granted most of the script kiddies aren't the brightest, but it only takes one to release an attacking script.

Everything else I agree with you. Your still the man.
Reply With Quote
  #26  
Old 31 Oct 2014, 19:14
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
Originally Posted by tbworld View Post
I have looked at the latest patches to vBulletin and although I have not tried to exploit the possible vulnerabilities, it does seem prudent to make the changes. When vBulletin releases their patched distribution, script kiddies get to work and try to exploit older boards that have not upgraded. Granted most of the script kiddies aren't the brightest, but it only takes one to release an attacking script.

Everything else I agree with you. Your still the man.
I hear you tbworld ... thanks for the little props lol ... And I was thinking after my post and for those who aren't as active and "savvy" maybe as most of us it would be best for them to update or upgraded to the latest version with patches ...

It was not at all smart or considerate of myself to say that upgrading is not necessary and I apologize to everyone ... because we should all upgrade and install the patches regardless of our experience to "avoid" headaches later on ...

So I am really truly sorry you guys ...
Reply With Quote
  #27  
Old 31 Oct 2014, 19:32
tbworld tbworld is offline
 
Join Date: Oct 2008
You are being too hard on yourself. I think in general you were referring to upgrades not vulnerability patches. In this case I just happened to be snooping at the changes they made in the code from v4.2.2 to v4.2.3. I'm a big snoop!

You do way more good around here then any slight miswording error. I have to retreive my own foot out of my mouth at least once a day. I was trying to inform, not cast judgement, I am sorry if it felt that way.
Reply With Quote
  #28  
Old 01 Nov 2014, 03:53
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
I second that.

Don't worry about Cheech!
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #29  
Old 02 Nov 2014, 23:58
hilaryl hilaryl is offline
 
Join Date: Jan 2006
Hi everyone,

First of all - thanks for all your feedback and suggestions. It has definitely helped to isolate where we should be looking, and what we should be looking for.

After some trial and error testing, we did find that during our nightly database back-ups, we were running out of space on the server. This caused somewhat of a chain effect which was congesting our mysql database, effectively shutting it down. Somewhere in that chain, the 'searchcore_text' table was trying to be optimised, and because of a lack of space, this couldn't complete and left the table corrupt.

We will obviously need to upgrade the space on our server - which is our next step.

The 'searchcore_text' was a contributor to our issue, but only because of the sheer size of the table. We will potential have to look at making this smaller without jeopardising the search function of our forum.

And then look at upgrading to the latest vBulletin.

Thanks again,
hilaryl
Reply With Quote
  #30  
Old 03 Nov 2014, 00:26
Marv Marv is offline
 
Join Date: Jun 2002
Thumbs up

Originally Posted by hilaryl View Post
Hi everyone,

First of all - thanks for all your feedback and suggestions. It has definitely helped to isolate where we should be looking, and what we should be looking for.

After some trial and error testing, we did find that during our nightly database back-ups, we were running out of space on the server. This caused somewhat of a chain effect which was congesting our mysql database, effectively shutting it down. Somewhere in that chain, the 'searchcore_text' table was trying to be optimised, and because of a lack of space, this couldn't complete and left the table corrupt.

We will obviously need to upgrade the space on our server - which is our next step.

The 'searchcore_text' was a contributor to our issue, but only because of the sheer size of the table. We will potential have to look at making this smaller without jeopardising the search function of our forum.

And then look at upgrading to the latest vBulletin.

Thanks again,
hilaryl
Good to hear you were able to figure that out. We had ourselfs a hard night until we stumbled over the disk quota issue, when we run into that. Nice to get a feedback that we could help you out getting back in the tracks.
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 02:09.

Layout Options | Width: Wide Color: