PDA

View Full Version : Why did this happen..

jjdog2
06-03-2003, 11:29 PM
At my forum, when u go to New Thread, Reply to Post, or anything having to do with posting, after u press post, it goes to a database error. I have recently installed some hacks, but what is this cause of this? The post shows up in the forum, but when u press post it brings u to database error and not return u to the site, you must go back manually. Help appreciated, thx.
007
06-04-2003, 05:17 AM
What error? Please post it.

Chances are you messed up something (maybe very small) while installing your hacks.

One missing or out of place "}" will kill your page...
Xenon
06-04-2003, 04:09 PM
reupload an unhacked newreply.php :)
WEForums
06-04-2003, 05:28 PM
Today at 07:17 AM 006 said this in Post #2 (https://vborg.vbsupport.ru/showthread.php?postid=404225#post404225)
What error? Please post it.I don't think there is an error. Just a database error. I think this because some (and only some...pretty few actually) members get this very error (nothing to tell me what to fix) when they click the usercp link. Odd thing is only a few members complain.

Anyone know why? And it seemed to be after installing the Signature Preview hack...

Yes, remove it...but I want to know why only some get it. :ermm:
jjdog2
06-04-2003, 07:35 PM
heres the exact error:

<html><head><title>Twisted-Revolt Forums V3 Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>

<!-- Database error in vBulletin 2.2.9:

Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (3,40893,1)
mysql error: Can't open file: 'searchindex.MYD'. (errno: 145)

mysql error number: 1016

Date: Wednesday 04th of June 2003 02:37:21 PM
Script: http://www.twisted-revoltnetwork.com/vb/vb/newthread.php
Referer: http://www.twisted-revoltnetwork.com/vb/newthread.php?s=&action=newthread&forumid=4
-->

</table></td></tr></table></form>
<blockquote><p>&nbsp;</p><p><b>There seems to have been a slight problem with the Twisted-Revolt Forums V3 database.</b><br>
Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:alexy5k@hotmail.com">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head></html>
Steve Machol
06-04-2003, 07:41 PM
Your searchindex table is corrupted. Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

http://www.yourdomain.com/forum/admin/repair.php?html=1&check=1

[Of course change the exact URL as appropriate for your forums.]

If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok (except the session table which you can ignore.) See if this fixes the problem.
jjdog2
06-04-2003, 08:53 PM
think you could send me a copy of repair.php plz, im not at home right now and trying to fix this prob. asap, thx
Steve Machol
06-04-2003, 08:56 PM
You can download the zip file. It's in the extras directory.

Also you can run this query in phpMyAdmin:

REPAIR TABLE searchindex;
jjdog2
06-04-2003, 08:59 PM
I dont have my vb.zip file on this comp, i just have access and ftp an dstuff so I could fix it here. I wqould really appreciate a link, thx
Steve Machol
06-04-2003, 09:09 PM
As I said you can download the zip file. If you don't have your customer number and password you can use the lost password link.
jjdog2
06-04-2003, 09:31 PM
Got it, thx
jjdog2
06-04-2003, 09:34 PM
k, ran it, now:

Checking table searchindex
Table Operation Type Text
vbdb.searchindex check warning Table is marked as crashed
vbdb.searchindex check warning 42 clients is using or hasn't closed the table properly
vbdb.searchindex check error Key in wrong position at page 3977216
vbdb.searchindex check error Corrupt

there is warnings and errors, now how do I fix it?
jjdog2
06-04-2003, 09:38 PM
IT WORKED< THANK YOU!!!
Erwin
06-04-2003, 09:46 PM
All fixed now... :)