vb.org Archive - database erreor

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - database erreor (https://vborg.vbsupport.ru/showthread.php?t=238603)

sabahor

03-19-2010 05:13 AM

database erreor

look this a huge problem i cant delet posts !!!
pic:
https://vborg.vbsupport.ru/

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

borbole

03-19-2010 11:44 AM

Quote:

Originally Posted by sabahor (Post 2006284)

look this a huge problem i cant delet posts !!!
pic:
http://up202.siz.co.il/up2/fjzzouyt1gqi.jpg

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.

sabahor

03-20-2010 07:38 AM

how i repair it?

shozy

03-20-2010 09:55 AM

i have the same prob dear :(

borbole

03-20-2010 02:42 PM

Quote:

Originally Posted by sabahor (Post 2006921)

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.

All times are GMT. The time now is 07:03 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00951 seconds Memory Usage 1,724KB 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_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: