Go Back   Novahq.net Forum > Computers > Tech Support

Tech Support Have a problem? Maybe we can help!

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 07-19-2003, 02:52 AM
G.I.JOE*MFA* is offline G.I.JOE*MFA*
Registered User

Join Date: Feb 2002
Posts: 437

Send a message via ICQ to G.I.JOE*MFA* Send a message via Yahoo to G.I.JOE*MFA*
mysql help

on my forums i posted then went back and posted again with in the time limit (dont know y i got around it) and because of that the forums thought the 2 posts had the same number (post id) and it screwed up my "thread table" in the database


i need to rebuild that table but dont know where to start...i havent backed up the database yet (stupid mistake i make too often)...can any1 send me the table contents so i can rebuild it - i use vBulletin 2.3.0 and vBPortal 3.0b

Code:
Database error in vBulletin 2.3.0:

Invalid SQL: 
SELECT thread.threadid
	FROM thread,subscribethread
	WHERE subscribethread.threadid=thread.threadid
	AND subscribethread.userid='1'
	AND thread.visible=1
	AND lastpost>1058591671

mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

Date: Saturday 19th of July 2003 12:21:33 AM
Script: http://www.dfmafia.net/forums/forums/usercp.php?s=
Referer: http://dfmafia.net/index.php?s=
above is the error message i get and when i went to myphpadmin i found that thread table corupted the rest of the tables r fine...notice the script: http://dfmafia.net/forums/forums/usercp.php?s= is incorrect as well...

i would like to get this fixed asap

any assistance would be great - email me at dflw_mafia@yahoo.com
__________________
DON'T LOOK AT MY SPELLING CAUSE IT SUCKS AND I DON'T CARE
__________________




*MaFiA*...Trust...Respect . . . Family

BF *MaFiA* - CoD *MaFiA* - DF *MaFiA* - JO *MaFiA* - RvS ¤MaFiA¤ - SW *MaFiA* - Capo Crimini
The Site



Reply With Quote
  #2  
Old 07-20-2003, 09:22 PM
G.I.JOE*MFA* is offline G.I.JOE*MFA*
Registered User

Join Date: Feb 2002
Posts: 437

Send a message via ICQ to G.I.JOE*MFA* Send a message via Yahoo to G.I.JOE*MFA*
nm its back up...thnx to SilentTrigger for the mysql help

http://dfmafia.net
__________________
DON'T LOOK AT MY SPELLING CAUSE IT SUCKS AND I DON'T CARE
__________________




*MaFiA*...Trust...Respect . . . Family

BF *MaFiA* - CoD *MaFiA* - DF *MaFiA* - JO *MaFiA* - RvS ¤MaFiA¤ - SW *MaFiA* - Capo Crimini
The Site



Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL 5.0 is out! DevilDog#1 Web design and Programming 4 01-14-2006 07:16 PM
mysql 4.1 King Web design and Programming 6 02-06-2005 12:49 PM
MySql help Stu Web design and Programming 5 11-28-2004 05:25 AM
MySql Help -DFO-Ironic Web design and Programming 6 08-01-2004 10:16 PM
MySQL Kip Kilagan Web design and Programming 3 04-05-2003 10:34 AM


All times are GMT -5. The time now is 04:42 PM.




Powered by vBulletin®