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

Reply
 
Thread Tools Display Modes
  #1  
Old 07-15-2011, 07:28 AM
ales2cv ales2cv is offline
 
Join Date: Feb 2007
Posts: 25
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default DB error when delete user

When in administration choise user and go deletit first get confirm then after delete get that error.

Database error in vBulletin 4.1.4:

Invalid SQL:

DELETE FROM vb_blog_usercss
WHERE userid = 5590;

MySQL Error : Incorrect key file for table 'vb_blog_usercss'; try to repair it
Error Number : 1034
Request Date : Friday, July 15th 2011 @ 03:28:23 AM
Error Date : Friday, July 15th 2011 @ 03:28:23 AM
Script : http://www.cxxcom/forum/admincp/user.php?do=kill
Referrer : http://www.cxx.com/forum/admincp/use...=remove&u=5590
IP Address : 88.200.92.236
Username : 2cv
Classname : vB_Database
MySQL Version : 5.1.56


How could i fix that
Reply With Quote
  #2  
Old 07-15-2011, 08:21 AM
y2ksw's Avatar
y2ksw y2ksw is offline
 
Join Date: Aug 2003
Location: Italy
Posts: 1,418
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

MySQL Error : Incorrect key file for table 'vb_blog_usercss'; try to repair it
Reply With Quote
  #3  
Old 07-15-2011, 05:25 PM
ales2cv ales2cv is offline
 
Join Date: Feb 2007
Posts: 25
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes i try to do that, but i am not mysql guru. The problem i guess start after i upgrade on server mysql on version 5. I dont find any good instrction how is posibel to repair some record in tabel that now not work after upgrade. I run repair chek and otimize over mysql admin and situatin is the same. Alsoo repair from vbulletin menu run uniq index and situatin is same. Any sugest were i find solution for that problem.
Reply With Quote
  #4  
Old 07-16-2011, 08:00 PM
y2ksw's Avatar
y2ksw y2ksw is offline
 
Join Date: Aug 2003
Location: Italy
Posts: 1,418
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ok if the standard repair doesn't work, you will have to ask your hosting provider to do it. There are some situations where the indexes are to be rebuilt. Like a full server crash.
Reply With Quote
  #5  
Old 10-08-2011, 10:16 PM
ales2cv ales2cv is offline
 
Join Date: Feb 2007
Posts: 25
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

no way to repair that two record
so my forum and portal must live with out that vb_blog_usercss
nad blog_usercss ---
But i stil think if some one could drop me that record i coud repier it and live it blank and at last dont ahve errro whem do base optimasition so if some oen could dorp and send me sql record for all _usercss tabel i be wery happy
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 02:38 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.03340 seconds
  • Memory Usage 2,192KB
  • Queries Executed 11 (?)
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
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete