vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Attachment Database (https://vborg.vbsupport.ru/showthread.php?t=45831)

Mike11212 11-22-2002 06:49 PM

beware if installing this hack
it works fine but causes your database to overload mines simply shutdown because of this and the server had to be restarted

!!! 11-22-2002 07:10 PM

Quote:

Originally posted by Mike11212
beware if installing this hack
it works fine but causes your database to overload mines simply shutdown because of this and the server had to be restarted

Interesting...why would this hack do that?

SWFans.net 11-22-2002 07:43 PM

Quote:

Originally posted by SWFans.net
I'm not sure why, but I installed this hack to test it out, and as I tried to load attach.php my server load on a semi dedicated server wen't through the roof and stalled MySQL on my forums. I think something needs some optimization maybe.
Quote:

Originally posted by FWC
I saw it driving the loads through the roof on two servers today. It locks multiple queries in the mysql server for huge amounts of time. I restarted mysql on both of them to get them back to normal.
Quote:

Originally posted by thenetbox
Hello..

I added the templates but as soon as I did that it got very very very slow...

Weird...

Quote:

Originally posted by Mike11212
beware if installing this hack
it works fine but causes your database to overload mines simply shutdown because of this and the server had to be restarted

Don't know why, but I'm not alone in seeing it do that.

Mike11212 11-22-2002 11:29 PM

the server im on is dedicated p3 1ghz 1gb of ram
and when i executed attach.php
it worked but took about 3 minutes to load
hit the arrow for the next page and it wouldnt load server went down

LOD-squa 11-23-2002 02:37 AM

It loads fine for me o-O

lalo landa 11-23-2002 06:24 AM

Quote:

Originally posted by rake
check for this line:

$getattach = $DB_site->query("SELECT attachment.attachmentid,attachment.userid,attachme nt.dateline,attachment.filename,attachment.visible ".iif($privattach,',attachment.private','').",atta chment.counter,post.postid,post.threadid,thread.ti tle,user.username FROM attachment LEFT JOIN post on attachment.attachmentid=post.attachmentid LEFT JOIN thread USING(threadid) LEFT JOIN user on attachment.userid=user.userid WHERE attachment.visible=1 AND post.attachmentid<>0 ".iif($privattach,'AND private=0','')." LIMIT $min,$perpage");


Please update the attached file... (still wrong)

rake 11-23-2002 08:39 AM

i've identified the problem. I'll release a patch soon. Sorry for the trouble everyone.

shovel 11-25-2002 12:36 PM

Great job Alex. It's great how you can both wow myself aswell as Eric. Lol.

- Anthony AKA CS

Erwin 11-25-2002 08:01 PM

!!!,


You are appearing as unlicensed.

To download hacks you will need to go to this page and enter your email address, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.

Erwin 11-25-2002 08:03 PM

rake,

You are appearing as unlicensed. Get your admin to do the following:

To download hacks you will need to go to this page and enter your email address, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.


All times are GMT. The time now is 01:45 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.01308 seconds
  • Memory Usage 1,739KB
  • 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
  • (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