vb.org Archive - Administrative and Maintenance Tools

Page 8 of 11

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Administrative and Maintenance Tools - Automatic Database Back-up (https://vborg.vbsupport.ru/showthread.php?t=114097)

jamshed

05-01-2006 08:17 AM

Hay

when i hit Scheduled Task Manager on Run Now i got problem :S

Code:

Invalid SQL:



                        INSERT INTO upload_cronlog

                                (cronid, dateline, description)

                        VALUES

                                (25, 1146474570, 'Saved backup of databse to /public_html/forum/XXXX on 05-1-2006 at 5:09am (file name 05-1-2006.tar.gz');



MySQL Error  : Table 'slipenc_vb.upload_cronlog' doesn't exist

Error Number : 1146

Date         : Monday, May 1st 2006 @ 05:09:31 AM

Script       : http://www.XXXXX.com/forum/admincp/cronadmin.php?do=runcron&cronid=25

Referrer     : http://www.XXXXXX.com/forum/admincp/cronadmin.php?do=modify

IP Address   : XXXXXXXXXXX

Username     : XXXXXX

Classname    : vb_database

help plz

Logikos

05-01-2006 10:16 AM

Jamshed, It looks like your log_cron_action() function was changed. The default vBulletin table is called cronlog. In your error, it is showing up as upload_cronlog.

What is your table_prefix named? You can find the name by opening the /includes/config.php file and looking for:

PHP Code:


		
			
$config['Database']['tableprefix']

I also need you to post your log_cron_action() function. Open /includes/functions_cron.php and search for:

PHP Code:


		
			
function log_cron_action($description, $nextitem)

Post the code in between the brackets ({}). The default vB function is:

PHP Code:


		
			
function log_cron_action($description, $nextitem)
{
    global $vbulletin;

    if (defined('ECHO_CRON_LOG'))
    {
        echo "<p>$description</p>";
    }

    if ($nextitem['loglevel'])
    {
        /*insert query*/
        $vbulletin->db->query_write("
            INSERT INTO " . TABLE_PREFIX . "cronlog
                (cronid, dateline, description)
            VALUES
                ($nextitem[cronid], " . TIMENOW . ", '" . $vbulletin->db->escape_string($description) . "')
        ");
    }
}

Also, does this happen on all your task managers? Try running another one and let me know if the same thing happens. :)

tqvn2004

05-01-2006 10:38 AM

I cann't get this hack to work on my site! I did as instructed, and chmod the folder as 777, but there is no output sql file when I try to run the cron task!

My host does not specify _SERVER[PATH_TRANSLATED], _SERVER["DOCUMENT_ROOT"] is "/customers/x-cafe.com/x-cafe.com/httpd.www/", therefore I set the File Dump Path as "/customers/x-cafe.com/x-cafe.com/httpd.www/forum/backups". And the backups folder is 777. I received no error message when running cron task, it said DONE. But no file is outputed! Please help!

jamshed

05-01-2006 12:59 PM

LiveWire Big Thanks problem solve..:banana: :banana:

creedmaniac

05-01-2006 02:47 PM

Quote:

Originally Posted by creedmaniac

is this supposed to create a date.sql and a date-error.sql everytime it runs? (i'm hoping it's supposed to be making the error.sql...cuz if it's not something's wrong with mine...it's going to the correct folder though so i don't know what else would be wrong)

you skipped me livewire :)

Logikos

05-01-2006 09:00 PM

@creedmaniac and tqvn2004: Upload the attached file anywhere on your site and send me a PM of the link so I can check your server settings.

Didn't mean to skip :p

Logikos

05-02-2006 02:50 AM

@creedmaniac: Thanks for the quick PM! Okay make sure that your File Dump Path setting is set to the following.

I would suggest place this in a folder outsite of the public_html folder for security reason. To do this, log into your website via FTP. This will place you in the /home/inara/ directory. Create a folder and name it whatever you want. I named mine databack.

Once you have finished that. Log into your admincp panel and make your way to the Database Backup Settigs. This is under the vBulletin Options. Make your your File Dump Path settings is set to /home/inara/databack (no ending slash). Then run the cron and give it a good 15 mins to transfer the database to that folder. The time all depends on the size of your database. Let me know if that fixed it. :)

ConqSoft

05-02-2006 02:57 AM

How about an option to have it keep the last X number of backups, and rotate out the old ones as needed? (Sorry if this has already been suggested; I didn't read the whole thread.)

Thanks!

hadog

05-02-2006 08:15 AM

LiveWire
get any time to check on my problem? Mysql5 and autobackup?

rmxs	05-02-2006 08:25 AM

Thanks very Usefull

All times are GMT. The time now is 09:34 AM.

Page 8 of 11

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01208 seconds Memory Usage 1,749KB 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 (1)bbcode_code_printable (3)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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
Messages: