Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #11  
Old 09-08-2009, 02:55 PM
squishi squishi is offline
 
Join Date: May 2006
Location: Frankfurt
Posts: 282
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have reversed the order, and told the query to only query thread smaller than startat.
PHP Code:
    $threads $db->query_read("
        SELECT title, threadid
        FROM " 
TABLE_PREFIX "thread
        WHERE threadid >= " 
$vbulletin->GPC['startat'] . "
        ORDER BY threadid
        LIMIT " 
$vbulletin->GPC['perpage']
    ); 
The process still starts with the first thread.

--------------- Added [DATE]1252425524[/DATE] at [TIME]1252425524[/TIME] ---------------

Hmm, that's weird.
I can load misc.php, but as soon as I add the variables "&do=updatethread&startat=12345", I get a 404 error.

http://mydomain.com/forum/admincp/mi...&startat=40000 gives me a 404.
http://mydomain.com/forum/admincp/misc.php loads just fine.

Must be something in the htaccess file, I guess.

--------------- Added [DATE]1252425598[/DATE] at [TIME]1252425598[/TIME] ---------------

There should be a form field added to the maintenance page that lets you define the startat value.
Reply With Quote
  #12  
Old 09-08-2009, 03:21 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Your url should be misc.php?do=updatethread&startat=40000

The query you posted is the original query, so I'm not sure what changes you made to it.
Reply With Quote
  #13  
Old 09-08-2009, 06:27 PM
squishi squishi is offline
 
Join Date: May 2006
Location: Frankfurt
Posts: 282
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Okay. The last link worked. I guess I will do it this way.
Thank you for your support.

--------------- Added [DATE]1252438206[/DATE] at [TIME]1252438206[/TIME] ---------------

Wow, the process is much faster than usual when I start it at 40,000.
It will only consider the posts that are older than id 40,000?
So it will not build the similar threads for older threads?
That's not good.
Reply With Quote
  #14  
Old 09-08-2009, 09:01 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by squishi View Post
Wow, the process is much faster than usual when I start it at 40,000.
It will only consider the posts that are older than id 40,000?
So it will not build the similar threads for older threads?
That's not good.
It only rebuilds the threads that have an id greater than 40000 if you start at 40000.

I seriously don't get what you are trying to do. You either want to rebuild ALL the threads, or do don't. If you are going to rebuild them all, then it doesn't matter if you start at id 1 or you start with the last id - you still have to go through and rebuild them all.
Reply With Quote
  #15  
Old 09-09-2009, 06:02 AM
squishi squishi is offline
 
Join Date: May 2006
Location: Frankfurt
Posts: 282
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Lynne View Post
I seriously don't get what you are trying to do. You either want to rebuild ALL the threads, or do don't. If you are going to rebuild them all, then it doesn't matter if you start at id 1 or you start with the last id - you still have to go through and rebuild them all.
I want to rebuild all of the threads.

And it does matter.
On my forum, rebuilding the similar threads takes over 24 hours.
And the process often just dies somewhere at 25,000 threads.
If I start at the end, I can rebuild the similar threads for those latest threads and do not have to worry about the process reaching the oldest threads.
Reply With Quote
  #16  
Old 09-09-2009, 03:08 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well, if you want to start at the end, then like I said, I think you will have to completely recode that section of the page.

Why don't you want to just turn on the option to create the list of similar threads when the thread is created? Do you really get so many threads created a day where that is going to cause problems? It sounds like what you are trying to do (rebuilding the similar threads all the time) is much more server intensive than just having the option on.
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 07:30 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04335 seconds
  • Memory Usage 2,221KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete