Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
OptimizeDB Details »»
OptimizeDB
Version: 1.00, by Scheccia Scheccia is offline
Developer Last Online: May 2003 Show Printable Version Email this Page

Version: 2.2.x Rating:
Released: 04-10-2002 Last Update: Never Installs: 5
 
No support by the author.

delete the space in excess in your database whit a click.
Optimize Table's space.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #22  
Old 04-14-2002, 09:51 AM
Scott MacVicar Scott MacVicar is offline
 
Join Date: Oct 2001
Location: Glasgow, Scotland
Posts: 1,199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I know but I'd rather optimize it before I back it up, saves me doing it if i have to use a backup.
Reply With Quote
  #23  
Old 04-14-2002, 02:20 PM
Webmasta XT's Avatar
Webmasta XT Webmasta XT is offline
 
Join Date: Mar 2002
Posts: 359
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

When I use repair.php, I get this error..

PHP Code:
Database error in vBulletin 2.2.4:

Invalid SQL: USE xtreme-forumz_cc
mysql error
You have an error in your SQL syntax near '-forumz_cc' at line 1

mysql error number
1064

Date
Sunday 14th of April 2002 10:17:33 AM
Script
: [url]http://www.xtreme-forumz.cc/repair.php?check=1&iterations=4&forum=xtreme-forumz_cc[/url]
Referer
Reply With Quote
  #24  
Old 04-14-2002, 05:48 PM
GuruXL's Avatar
GuruXL GuruXL is offline
 
Join Date: Feb 2002
Location: Queens, NY
Posts: 61
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

it's probably because it doesn't support the '-' in "xtreme-forumz_cc"
Reply With Quote
  #25  
Old 04-15-2002, 07:33 AM
Wolf42's Avatar
Wolf42 Wolf42 is offline
 
Join Date: Nov 2001
Location: Vienna, Austria, Europe
Posts: 150
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by Webmasta XT
When I use repair.php, I get this error..

PHP Code:
Database error in vBulletin 2.2.4:

Invalid SQL: USE xtreme-forumz_cc
mysql error
You have an error in your SQL syntax near '-forumz_cc' at line 1

mysql error number
1064

Date
Sunday 14th of April 2002 10:17:33 AM
Script
: [url]http://www.xtreme-forumz.cc/repair.php?check=1&iterations=4&forum=xtreme-forumz_cc[/url]
Referer
As far as I know you has to run the script from the admin-folder and not from the forums-root.
Reply With Quote
  #26  
Old 04-15-2002, 08:37 AM
DiSS Troya's Avatar
DiSS Troya DiSS Troya is offline
 
Join Date: Nov 2001
Location: Las Vegas
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Scheccia, how do i solve this:

Warning: Supplied argument is not a valid MySQL result resource in /home/remin/www/board/admin/optidb.php on line 10

Someone else asked the same thing too. Help.
Reply With Quote
  #27  
Old 04-19-2002, 06:37 AM
v0nreagan's Avatar
v0nreagan v0nreagan is offline
 
Join Date: Nov 2001
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The error's there only when you run it for the first time, then it creates table optimize_gain and it's all ok...

I think there is something wrong with count tho':
"You have saved in your database: 128946.435 Kb"
That's 129Mb in like 5 seconds? Impossible.
Reply With Quote
  #28  
Old 05-01-2002, 09:22 AM
KISS's Avatar
KISS KISS is offline
 
Join Date: Jan 2002
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

DiSS Troya,

I had the same error the first time I ran it. After I ran it the error went away so I think its cool to run.

Nice hack and Thanks!!
Reply With Quote
  #29  
Old 05-01-2002, 12:10 PM
proton242 proton242 is offline
 
Join Date: Nov 2001
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Work great! Thanks for this hack!!!
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 12:56 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.08877 seconds
  • Memory Usage 2,284KB
  • Queries Executed 23 (?)
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
  • (2)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (8)postbit
  • (9)postbit_onlinestatus
  • (9)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_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