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 03-19-2010, 05:13 AM
sabahor sabahor is offline
 
Join Date: Sep 2007
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default database erreor

look this a huge problem i cant delet posts !!!
pic:


the error
Code:
Database error in vBulletin 4.0.1:

Invalid SQL:

		 	DELETE searchcore, searchcore_text 
			FROM searchcore AS searchcore JOIN 
				searchcore_text AS searchcore_text ON 
					searchcore.searchcoreid = searchcore_text.searchcoreid 
			WHERE searchcore.groupcontenttypeid = 2 AND 
				searchcore.groupid = 28;

MySQL Error   : Table './sabahor_drz/searchcore_text' is marked as crashed and should be repaired
Error Number  : 145
Request Date  : Friday, March 19th 2010 @ 08:07:29 AM
Error Date    : Friday, March 19th 2010 @ 08:07:29 AM
Script        : http://www.drz.co.il/inlinemod.php?do=dodeletethreads&threadids=29,28,262
Referrer      : http://www.drz.co.il/inlinemod.php?forumid=2
IP Address    : 109.65.108.56
Username      : sabahor
Classname     : vB_Database
MySQL Version : 5.1.41
Reply With Quote
  #2  
Old 03-19-2010, 11:44 AM
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Posts: 2,559
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by sabahor View Post
look this a huge problem i cant delet posts !!!
pic:


the error
Code:
Database error in vBulletin 4.0.1:

Invalid SQL:

		 	DELETE searchcore, searchcore_text 
			FROM searchcore AS searchcore JOIN 
				searchcore_text AS searchcore_text ON 
					searchcore.searchcoreid = searchcore_text.searchcoreid 
			WHERE searchcore.groupcontenttypeid = 2 AND 
				searchcore.groupid = 28;

MySQL Error   : Table './sabahor_drz/searchcore_text' is marked as crashed and should be repaired
Error Number  : 145
Request Date  : Friday, March 19th 2010 @ 08:07:29 AM
Error Date    : Friday, March 19th 2010 @ 08:07:29 AM
Script        : http://www.drz.co.il/inlinemod.php?do=dodeletethreads&threadids=29,28,262
Referrer      : http://www.drz.co.il/inlinemod.php?forumid=2
IP Address    : 109.65.108.56
Username      : sabahor
Classname     : vB_Database
MySQL Version : 5.1.41

Try to repair the searchcore_text table.
Reply With Quote
  #3  
Old 03-20-2010, 07:38 AM
sabahor sabahor is offline
 
Join Date: Sep 2007
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

how i repair it?
Reply With Quote
  #4  
Old 03-20-2010, 09:55 AM
shozy shozy is offline
 
Join Date: Mar 2010
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i have the same prob dear
Reply With Quote
  #5  
Old 03-20-2010, 02:42 PM
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Posts: 2,559
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by sabahor View Post
how i repair it?
You can repair it at phpmyadmin in the cp of your host. Select the db that your forum resides on, select the table in question and all the way to the bottom where it says: With selected choose the Repair option.
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:52 PM.


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.11113 seconds
  • Memory Usage 2,200KB
  • Queries Executed 13 (?)
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
  • (2)bbcode_code
  • (2)bbcode_quote
  • (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_postinfo_query
  • fetch_postinfo
  • 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