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

Reply
 
Thread Tools Display Modes
  #1  
Old 08-03-2011, 11:37 PM
Gamelobby's Avatar
Gamelobby Gamelobby is offline
 
Join Date: Jul 2007
Location: Long Beach, CA
Posts: 997
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Repair / Optimize Tables - error.?

My site is slow, very slow from time to time, & when i try to optimize the tables.. it has real issues, & i usually get an Internal Error page.



I can select a few to optimize, & it will work, but the first ones i notice to have problems is the
Quote:
adv_links
adv_links_banners
etc..
So im wondering what these are..?
My guess is the vBAdvanced Links mod, but i haven't had that installed for a long time, i uninstalled it a long time ago, & i see no traces of it anywhere. (acp or server)

1. Any idea if in fact that is what these are.?
2. Any ideas on what else could be the problem, because even when i dont tick those, it can still give me errors.


Thanks
Attached Images
File Type: jpg adv.jpg (72.5 KB, 0 views)
File Type: jpg error.jpg (42.1 KB, 0 views)
Reply With Quote
  #2  
Old 08-04-2011, 05:16 PM
Gamelobby's Avatar
Gamelobby Gamelobby is offline
 
Join Date: Jul 2007
Location: Long Beach, CA
Posts: 997
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ok so even though i'd still like to know why the "Adv_Links" are still in the system, I was able to optimize them.

But I still can't run it on the whole list.. I went through and did each one individually, & had some errors on some, but at one point or another was able to get them all to go through. (i think)

Any idea why i cant run them all at once.?
Reply With Quote
  #3  
Old 08-04-2011, 05:49 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Those are from a modification. I would guess it wasn't uninstalled correctly, or there was no uninstall code and so you were supposed to remove them manually. You would have to go read the instructions for that modification to find out what you were supposed to do.

On my old server, I could not run repair/optimize on all the tables - I had to do them in groups. It was a php timeout issue, I believe. Well, and it also would kill my server loads which I didn't like to do.
Reply With Quote
  #4  
Old 08-05-2011, 01:42 AM
Gamelobby's Avatar
Gamelobby Gamelobby is offline
 
Join Date: Jul 2007
Location: Long Beach, CA
Posts: 997
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks lynn, i'll check that out.


Also i just noticed that when i ran a diagnostic i did the System information>Table Status & the ones that were giving me issues were blank under "update time" & "check time" & also under "comments" it said:
Quote:
InnoDB free: 0 kB
--------------- Added [DATE]1312574480[/DATE] at [TIME]1312574480[/TIME] ---------------

Update..

I found that some of the info in my config file was wrong, so i changed it (corrected it) & now i get this error...

Quote:
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'NCJB327'@'184.168.193.22' (using password: YES)

/home/content/08/4856008/html/forums/includes/class_core.php on line 314

MySQL Error :
Error Number :
Request Date : Friday, August 5th 2011 @ 12:51:32 PM
Error Date : Friday, August 5th 2011 @ 12:51:33 PM
Script : http://**********.com/forums/admincp/index.php
Referrer : http://**********.com/forums/login.php?do=login
IP Address : 98.255.6.219
Username :
Classname : vB_Database
MySQL Version :

-->
Is it a db name that is wrong, or password, or something else..? (FYI, i'm 99.999999% positive the password is correct.)

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

Quote:
Originally Posted by Gamelobby View Post
Ok so even though i'd still like to know why the "Adv_Links" are still in the system, I was able to optimize them.

But I still can't run it on the whole list.. I went through and did each one individually, & had some errors on some, but at one point or another was able to get them all to go through. (i think)

Any idea why i cant run them all at once.?

Also on these columns that wont update they seem to all be related to search/content..
  • contenttype
  • searchcore
  • searchgroup
  • searchlog
  • tag
  • tagcontent
  • tagsearch

Any of this raise a flag to anyone..?
Reply With Quote
  #5  
Old 08-06-2011, 12:41 AM
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Posts: 3,085
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Who cares why they're in the system. If you don't have an advertising mod delete them (I assume you're making backups).

And the only reason to get a "access denied" error to your db is if the username or password is wrong. Just restore the config from your last monthly backup if you have to and start over.
Reply With Quote
Благодарность от:
mrdiger
  #6  
Old 08-06-2011, 04:35 AM
Gamelobby's Avatar
Gamelobby Gamelobby is offline
 
Join Date: Jul 2007
Location: Long Beach, CA
Posts: 997
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Videx View Post
Who cares why they're in the system. If you don't have an advertising mod delete them (I assume you're making backups).

And the only reason to get a "access denied" error to your db is if the username or password is wrong. Just restore the config from your last monthly backup if you have to and start over.
Appreciate the reply, but... I care why they are in the system. lol
Had i gone by your logic (and my guessing that it is a vBA mod), & deleted them because i dont have an advertising mod, i would have deleted my "links" mod.


1st. I'm only guessing the "adv_links" is from vBAdvanced "Links" mod (maybe they are from an advertising mod. idk?) If i'm not sure what they are for, i dont know for sure if i'm using them or not. know what i mean.?

2nd. Yes access denied, was a username/pw issue that part is fixed.. but..

I'm still not able to run the "Repair / Optimize Tables" from the maintenance/acp. THAT is my main issue that i am trying to figure out.! (why i can't)
Reply With Quote
  #7  
Old 08-06-2011, 04:45 AM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Look at the Advanced links mod and see if it makes those tables on install. You can see in the xml. If it does, then that is where they are from. You have to remember to remove all files when uninstalling any mods (bitfield, as well as any others).

Also, like Lynne said, if you db is big enough, it can time out when try to do all the tables at once.
Reply With Quote
  #8  
Old 08-06-2011, 04:56 AM
Gamelobby's Avatar
Gamelobby Gamelobby is offline
 
Join Date: Jul 2007
Location: Long Beach, CA
Posts: 997
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yea i am looking into the "adv_links" but they aren't the ones that time-out, (as i previously thought they were the culprit.. after testing i found that they were able to run fine)


It's the others that time-out almost every time by themselves.
Quote:
  • contenttype
  • searchcore
  • searchgroup
  • searchlog
  • tag
  • tagcontent
  • tagsearch
If i go to repair/optimize, then select ALL, then un-check those 7 it'll run fine. but if i run any one of those 7 tables individually they time-out (nine out of ten times)
So i can only guess that they are more of an issue than the adv_links.

Sorry to confuse you all, but as always i do appreciate the help.
Reply With Quote
  #9  
Old 08-06-2011, 08:05 AM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

IIRC, those tables you listed don't handle repair and optimize. I get a message on each one about having to do something else with those tables other than repair and optimize. I will try to capture the message the next time I see it.

How big is your db?
Reply With Quote
  #10  
Old 08-06-2011, 03:29 PM
Gamelobby's Avatar
Gamelobby Gamelobby is offline
 
Join Date: Jul 2007
Location: Long Beach, CA
Posts: 997
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Not sure how big.. I know it is less than 1GB, cuz thats the limit. lol
Where can i find that info.?
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 11:34 PM.


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.05760 seconds
  • Memory Usage 2,289KB
  • Queries Executed 12 (?)
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
  • (6)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
  • (10)post_thanks_box
  • (1)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (2)postbit_attachment
  • (10)postbit_onlinestatus
  • (10)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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete