vb.org Archive - Administrative and Maintenance Tools

Page 2 of 8

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

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

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Administrative and Maintenance Tools - Auto Purge Threads (https://vborg.vbsupport.ru/showthread.php?t=275314)

THX_Ultra

01-08-2012 09:36 AM

Hi, I don't know why, but it seems that the Plugin does not work anymore since the 1.03b update.
Just for my understanding - If I want to move threads after 3 days from one forum to another.
I enter at "Thread must have been created earlier than X days." the number 3 - right?

So everything worked fine until I updated to 1.03b - now It doesn't move threads anymore, even If i start the cron job manually.

Do I have to completely uninstall the addon before updating, or is there anything I missed?

I'd appreciate your help, because the addon would be extremely helpful for me.

Seductor

01-09-2012 05:16 PM

It seems to be broken. However, it works If I run it manually.

The cron path seems to be right. The scheduled hour seems to be okay too.

@THX_Ultra could you help me? Go to Scheduled Tasks > Scheduled Task Log and check if there is any Auto Purge Threads action. I have one everyday at 5 AM. Do you have any?

Btw, I have edited the AutoPurge options, perhaps you should recheck them. Do you have Enable Plugin set to "yes" and Move threads and/or Delete threads to "yes" too?

@Trangalleiro: I have received your PM, however you have set you don't want to receive PMs. I can't answer you through private messaging.

OldSchoolDSL

01-09-2012 05:52 PM

This is the error I got on every version of this modification. The error happen only when I enabled this.

Code:

 Invalid SQL:

SELECT * from `thread`

                               Where  forumid  IN(2)

                               AND `postuserid` NOT IN ()

                               AND `dateline` <= '1323405149';



MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')

                               AND `dateline` <= '1323405149'' at line 3

Disabling this resolved the issue.

THX_Ultra

01-09-2012 06:42 PM

Quote:

Originally Posted by Seductor (Post 2285587)

@THX_Ultra could you help me? Go to Scheduled Tasks > Scheduled Task Log and check if there is any Auto Purge Threads action. I have one everyday at 5 AM. Do you have any?

Yes it is, but i switched back to 1.0.2 and everything works fine now. It was also working with 1.0.3 but since switching to the 1.0.3b it didn't...

One more thing - I realised that the field for protected users have to be filled with something, but for moving threads, I do not want to have any user protected. Can I enter 0 instead of eg. 1 or any other userid?
Does this affect the addon?

Seductor

01-09-2012 06:43 PM

Oh, @OldSchoolDSL, It is an easy error. I have never tought that Protected Users could be void. I will fix it but, meanwhile, have you seen any other bug?

Quote:

Originally Posted by THX_Ultra (Post 2285633)

Yes it is, but i switched back to 4.0.2 and everything works fine now. It was also working with 4.0.3 but since switching to the 4.0.3b it didn't...

1.03 worked? That is odd, 1.03b only fixes a SQL sentence, but it is almost the same as 1.03. As OldSchoolDSL pointed, have you got Protected users void?

OldSchoolDSL

01-09-2012 06:56 PM

Quote:

Originally Posted by Seductor (Post 2285635)

Oh, @OldSchoolDSL, It is an easy error. I have never tought that Protected Users could be void. I will fix it but, meanwhile, have you seen any other bug?

1.03 worked? That is odd, 1.03b only fixes a SQL sentence, but it is almost the same as 1.03. As OldSchoolDSL pointed, have you got Protected users void?

That's the thing. I didn't have any protected users. Wanted this mod to apply to all.

Because of the error, nothing ever happen... ie... The modification to my knowledge didn't work. I never did see the error on my screen, only got the e-mails about it.

THX_Ultra

01-09-2012 07:02 PM

Yes 1.03 worked fine - when I use 1.03b and leave everything unchanged - it doesnt. If i start it manually it just does not move threads.
I have one protected user, but i just use it because I get an error messag if I leave it blank.

Seductor

01-09-2012 10:28 PM

Now (1.03c) you can void Protected users.

I have changed the SQL sentences and now it is easier to edit the them. Now it works like:

Code:

                $query = "SELECT * from `" . TABLE_PREFIX . "thread` Where  forumid  IN($frommove) AND `dateline` <= '" . (TIMENOW - ($whencreated * 86400)) . "'";

                if(!$deletesticky)

                {

                        $query .= " AND NOT `sticky`";

                }



                if(!empty($idadmin))

                {

                        $query .= " AND `postuserid` NOT IN (".$idadmin.")";

                }

If you have not protected users, empty($idadmin) will be true and then the condition AND `postuserid` NOT IN ( ) will not be added. You will not have the SQL error because of it.

It seems to work for me. I have not Protected users and I don't want to move stickies. I have enabled the debug mode and it shows this:
https://vborg.vbsupport.ru/external/2012/01/57.png

So it seems to work perfectly.

FYI: 1.04 will have "Protected threads". I'm working on it.

micro image

01-31-2012 07:32 PM

Installing this, will report soon. GREAT mod, thank you!

spillage

02-01-2012 01:34 AM

Option request; Last post X days as move/delete criteria.

All times are GMT. The time now is 12:03 AM.

Page 2 of 8

Last »

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

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