vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   New Reputation Comments (and Posts) Since Your Last Visit. (https://vborg.vbsupport.ru/showthread.php?t=91146)

divided_by_fear 11-07-2005 10:32 PM

does anyone know how to get this to work with vBadvanced CMPS v2.0

Matt_270581 11-09-2005 09:45 AM

After installing this on 3.51 I just receive a blank page after uploading the file via product manager. Any ideas?

Matt_270581 11-09-2005 10:13 AM

The one you had for 3.5 Beta where it was necessary to run the queries on the tables before installing works on another site I have. Just this one doesn't work on 3.51.

Paul M 11-09-2005 05:15 PM

Quote:

Originally Posted by Matt_270581
After installing this on 3.51 I just receive a blank page after uploading the file via product manager. Any ideas?

Did you do the template edits ?

sHORTYWZ 11-12-2005 12:33 AM

This product will not install with 3.51 - I click on upload and get a blank page in the product manager.

Paul M 11-12-2005 12:09 PM

I think this is a bit of poor feedback from the vb product install system.

This hacks install code adds an index to the post table. If you have a lot of posts, this can take time, during which nothing is displayed. Just leave it to install and it should be okay.

Matt_270581 11-20-2005 02:56 PM

It fully hoses my server, Memory & CPU when trying to import this, even though it just shows a blank page it's obviously trying to do something.

Threads: 37,696, Posts: 525,031
PHP 5
MYSQL 5

Edit: Hoses the server when running just SQL statement too. Guess there is too many posts to alter the table.

Paul M 11-20-2005 03:42 PM

Quote:

Originally Posted by Matt_270581
It fully hoses my server, Memory & CPU when trying to import this, even though it just shows a blank page it's obviously trying to do something.

Threads: 37,696, Posts: 525,031
PHP 5
MYSQL 5

Quote:

Originally Posted by Paul M
This hacks install code adds an index to the post table. If you have a lot of posts, this can take time, during which nothing is displayed.

Check your mysql process list while it's importing, what do they show ?.

Matt_270581 11-20-2005 03:49 PM

Just blows out the Memory of MYSQL and you know what this can do when memory is up near maximum level.

Tried running ALTER TABLE post ADD INDEX (dateline) from MYSQL Control Centre. Same thing.

Worked fine on my board with 9000 posts.

Matt_270581 11-20-2005 03:55 PM

I should really take my forum offline and try lol. Will take it offline later and try it and see what happens.

One question though, if I run the queries:

1. ALTER TABLE post ADD INDEX (dateline) ; - This will speed up the new posts query.

2. ALTER TABLE user ADD lastrepcheck INT(10) UNSIGNED NOT NULL ; - Required for new reputation check.

3. UPDATE user SET lastrepcheck = lastvisit ; - Initilise the new field above.

Then I import the new XML file will it try to rebuild the index? or will it just check and skip that part?


All times are GMT. The time now is 05:00 AM.

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.01439 seconds
  • Memory Usage 1,734KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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