vb.org Archive
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   freddie's Repair & Optimize Database (vB integration) (https://vborg.vbsupport.ru/showthread.php?t=38144)

TECK 05-02-2002 02:04 PM
Quote:
Originally posted by FireFly
Yes nakkid, even your script - can fail. Don't be so brutal and yell at people for doing nothing other than clicking a button.
firefly, is not my script. i only did as usual a little mod to it, you know i'm not the best at this. but when i know for sure one thing, i put my foot on the floor. is obvious that a script can fail, nothing is perfect, but 80%??? kmon... you can admit firefly that there is no diff between phpmyadmin and a query ran in VB. i have the tendency to believe that 225 is alot more stable in this area.

and i dont yell. i simply state that people have a tendency to blamne someone(something) else for their mistakes. so what if corrupted? if is no good, why would it be in the VB package??? i doubth Jelsoft wants to promote a crappy code image.

i know freddie from this board and he pulls amasing stuff. period. there is no but, maybe or how. and people had problems with the script because maybe it wasnt well documented? look at this situaton with Kaelon. he ran the script with the board ON. now we all know what to do. constructive, right?

@Slynderdale: dont panic, that's me.. when you will know me better, you will see that this is my wierd way to talk sometimes. dont take it bad because that's how i am, i say what i think... sometimes to fast.

regulars start laughing at me while i pull one of my panic attacs... and i join them also shortly after...

Slynderdale 05-02-2002 02:05 PM
that was taken around 1 am in the morning, that was my stats

Admin 05-02-2002 02:15 PM
Quote:
Originally posted by nakkid
and i dont yell. i simply state that people have a tendency to blamne someone(something) else for their mistakes. so what if corrupted? if is no good, why would it be in the VB package??? i doubth Jelsoft wants to promote a crappy code image.
Oh you do yell, maybe you can't see it but you are. The script in vBulletin's zip file is not like your file. It's different, you altered it and added stuff - no matter what you did, you changed it.
And I don't care if the PHP authors wrote the script themselves, the fact is, many people can't get it to work correctly. So unless everyone here except you are complete idiots, something must be wrong, right?

Quote:
Originally posted by nakkid
@Slynderdale: dont panic, that's me.. when you will know me better, you will see that this is my wierd way to talk sometimes. dont take it bad because that's how i am, i say what i think... sometimes to fast.

regulars start laughing at me while i pull one of my panic attacs... and i join them also shortly after...
Maybe you should start thinking before you post? Think over what you're going to say, and choose your words carefully. I don't know about others, but I certainly don't laught at your panic attacks, they actually annoy me quite a bit. If you feel angry don't take it out on the forum users, get a cigarette. People don't deserve your yells.

See, I'm not yelling.

TECK 05-02-2002 02:17 PM
true. i apologise about the tension i created like an idiot. i mean it.

now, about the script. if i understand correctly, people had problems with my mod? not with freddie's file?

Sparkz 05-02-2002 02:32 PM
Quote:
Originally posted by nakkid
true. i apologise about the tension i created like an idiot. i mean it.
No offence, but it seems to me that this is something you do alot.

Maybe you should consider grabbing a glass of water, or maybe even counting to 100 before posting when you see something that makes you go off like this?

Freddie Bingham 05-02-2002 03:02 PM
Hmm lots of talk about me.

I wrote repair.php as something that I could run nightly on my forum as it was getting periodic corruption. It has run nightly for probably a year now and I have not had a corrupt table since.

I thought that perhaps it might help out others and be an easier than telling everyone to go run myisamchk on their databases to fix problems. That being said, I only tested it on my forum so that is why it says "Not Supported". It won't work on non MyISAM tables and it won't work if the user table is corrupted.

Kaelon - your post table was corrupted before you opened repair.php. You can have corruption without it being to the point of causing visible problems. The error 28 that the script generated shows that your database ran out of space while trying to repair the post table. There was nothing inherent to the script that caused your problem. Your post table is very small so for this to have occurred would have to be a fault of your hosting company in terms of managing disk space. In fact, the corrupted index that brought up the repair procedure to begin with was probably caused by the lack of disk space.

Ren 05-02-2002 03:09 PM
Very nice , I installed this and backed up my forums and it worked great .. thanks :)

NTLDR 05-02-2002 08:06 PM
Very nice addition to the Admin CP, thank you nakkid and freddie :D

@Slynderdale would you mind sharing how you got the custom avatar and attachment count in the stats?

Floris 05-03-2002 11:22 AM
NTLDR: hack by freddie

NTLDR 05-03-2002 12:11 PM
Quote:
Originally posted by xiphoid
NTLDR: hack by freddie
I have freddies hack installed, but I wanted to know how the avatar and attachment count was added as that isn't part of the freddies hack (or at least not the version I installed).

I'll take another look.

Floris 05-03-2002 12:22 PM
it is in his attached screenshot

Stretchr 05-27-2002 01:25 AM
The script seems to be working for me but I'm getting this error:
PHP Code:
Warning: Supplied argument is not a valid MySQL result resource in /home/wdj/www/forums/admin/db_mysql.php on line 154 
FYI, here's the block which includes line 154 in my db_mysql.php
PHP Code:
function fetch_array($query_id=-1,$query_string="") {
    // retrieve row
    if ($query_id!=-1) {
      $this->query_id=$query_id;
    }
    if ( isset($this->query_id) ) {
      $this->record = mysql_fetch_array($this->query_id);
    } else {
      if ( !empty($query_string) ) {
        $this->halt("Invalid query id (".$this->query_id.") on this query: $query_string");
      } else {
        $this->halt("Invalid query id ".$this->query_id." specified");
      }
    } 

Any help would be appreciated.

Also: I didn't realize until I ran it the first time you modified repair.php. Might make a note of that, (unless you already did and I missed it somewhere) or, better yet, rename repair.php to something else and change it in the hack.

Anyway, this is really handy to have available from the Admin console. Thank you!

Boofo 07-08-2002 12:38 AM
If you find out how this is done, I would be very interested to know. :)

Quote:
Originally posted by NTLDR


I have freddies hack installed, but I wanted to know how the avatar and attachment count was added as that isn't part of the freddies hack (or at least not the version I installed).

I'll take another look.

Schorsch 08-20-2002 08:35 PM
thank you Nakkid and freddie, I'll try this later, hope it works...

Schorsch

Schorsch 08-21-2002 01:39 AM
ok I tried it now, no errors :banana:

DB size

before: 64.71 MB
after: 63.47 MB

has this repair.php any other features, like better performance of the board, etc.. ???

cu
Schorsch

TECK 08-21-2002 02:04 AM
yes it does. is like you format your hard drive in a way.. you basically order your database to remove errors and little empty spaces.

Asso 09-17-2002 06:13 PM
great hack m8!

tuga-gsm 04-26-2006 05:34 PM
any update on this tool or similar for vbulletin 3.5.1?

best regards


All times are GMT. The time now is 01:16 AM.
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

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.01228 seconds
  • Memory Usage 1,775KB
  • 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_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (18)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