vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Administrative and Maintenance Tools - vBulletin Cron Based Database Backup (https://vborg.vbsupport.ru/showthread.php?t=231481)

HMBeaty 02-09-2012 04:21 AM

Quote:

Originally Posted by ALBCODERS (Post 2297773)
i have wierd problem , after

Processing podcastitem (No Row Data)
Processing poll (25) : Processed 25 Rows in 0.007 Seconds
Processing pollvote (2230) : Processed 2230 Rows in 0.213 Seconds
Processing post (104156) : Processed 45339 Rows in 21.424 Seconds

i get this

Database error in vBulletin 4.1.9:

Invalid SQL:
SHOW CREATE TABLE `postedithistory`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, February 8th 2012 @ 10:32:35 PM
Error Date : Wednesday, February 8th 2012 @ 10:33:01 PM
Script : http://www.myweb.com/admincp/cronadm...cron&cronid=41
Referrer : http://www.myweb.com/admincp/cronadmin.php?do=modify
IP Address : *
Username : my
Classname : vB_Database
MySQL Version :


Any suggestion , never happen before . I use to run version autobackup 4.0.1 for sometime, and no problems. i got 2 weeks now with this problem and i have no idea where did com from .


i installet new version 4.1.7 i have same problem :/

can u please tell me what to do guys because hostgator is so crap when u try to back up files manualy , it never gives u full kb or mb in sql files. Autobackup make such a good job, and it gives u every bit of your website.


Regards.

Hostgator is about 99% of your problem lol ;)

Anyway, in regards to your database error, again, that's an issue with HostGator. See here for more information...

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

DAMINK 02-09-2012 04:34 AM

I can confirm its hostgators error.
I recently moved host just to get away from hostgator.
I was getting about 10 - 20 of those a day!

ALBCODERS 02-09-2012 04:45 AM

why i am not suprised :/

let say that i have to tell them te fix it , what do i actualy have to say cuz i have no idea

by theway thx for respondin back , HMbeaty and DAMIK i appreciate that.

DAMINK 02-09-2012 04:57 AM

I asked them to fix it myself ALBCODERS.
There answer was as below.

Quote:

Originally Posted by hostgator
Hello

Thank you for contacting HostGator.

We can't set individual settings regarding MySQL in shared environments. I can say that the wait_timeout is currently set to 3600 on the particular server hosting your account. Another factor may be coding and application configuration. Is your application attempting to use persistent database connections in any way?

These are not permitted on shared servers because they tie up database connections. If an application attempts to use them it may generate the Mysql Server has gone away messages. This would actually be an internal coding or configuration issue with either the whole application or a module within the application.

I would simply move to a better host mate.
I have a reseller account with them and dont use it for myself at all lol.
I had to move. I could not keep getting these errors.
Good luck with hostgator mate. I hope they do come to your assistance.

UnknownKillerMC 02-09-2012 05:00 AM

I myself would suggest not adding this the reason being, if your site is ever compromised well just admincp it would easily give the attackers a way to get to your database ;) my opinion but good work over all thanks for making this.

ALBCODERS 02-09-2012 05:07 AM

yeah i been planin for such a long time to move from hostgator but never found a good hosting company. Even worse with hostgator u can`t email your members for any updates or stuff, cuz they suspend your account for spamin.

DAMINK 02-09-2012 05:19 AM

Quote:

Originally Posted by UnknownKillerMC (Post 2297788)
I myself would suggest not adding this the reason being, if your site is ever compromised well just admincp it would easily give the attackers a way to get to your database ;) my opinion but good work over all thanks for making this.

I actually removed this mod for the same reason.
I now use a 3rd party software to do my backups. (bigdump)
I felt it would be easy for someone to point to the backup file directly just based on the fact most people dont edit anything and use the default install instructions.
It may well be safe PaulM is a great coder so i expect its safe but got me concerned regardless.


Quote:

Originally Posted by ALBCODERS (Post 2297790)
yeah i been planin for such a long time to move from hostgator but never found a good hosting company. Even worse with hostgator u can`t email your members for any updates or stuff, cuz they suspend your account for spamin.

They used to ban my ip address all the time because i kept a computer on the who is online page 24/7.
I thing i asked to have my ip whitelisted about 6 times before they actually did it.
Literally had to keep telling them i have been ip banned. They would say every time thats not the case but when investigated further it was that every time.
Find a good host mate and move. You will be happy you done it.

RustyF 02-09-2012 09:08 AM

I hate to show my ignorance this way.... :)

Do I copy the files in the includes folder to the vBulletin includes folder? Seems obvious but I'm brand new and afraid to put anything in the vbulleting file system unless I'm sure.

Thanks

Paul M 02-09-2012 01:07 PM

Quote:

Originally Posted by RustyF (Post 2297842)
Do I copy the files in the includes folder to the vBulletin includes folder?

Yes.

DAMINK 02-10-2012 09:50 PM

Quote:

Originally Posted by RustyF (Post 2297842)
I hate to show my ignorance this way.... :)

Do I copy the files in the includes folder to the vBulletin includes folder? Seems obvious but I'm brand new and afraid to put anything in the vbulleting file system unless I'm sure.

Thanks

Thats not Ignorance. Thats good practice mate.
I imagine a lot of vb owners who first start out just dump craploads of mods on there forum and end up having all sorts of problems. (guilty as charged)


All times are GMT. The time now is 07:43 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02217 seconds
  • Memory Usage 1,751KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete