FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Consitancy check and rebuild.
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Consitancy check and rebuild. [message #19447] Wed, 21 July 2004 00:18 Go to next message
mocara is currently offline  mocara   United Kingdom
Messages: 157
Registered: January 2004
Karma: 0
Senior Member
I did a consitancy check and a rebuild and now my server returns:
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL
query log in fuddir/index.php on line 49


sql_errors file contains lines like:
[Wed Jul 21 0:18:18 GMT 2004] KC9kYXRhL3d3dy9zaXRlcy9zdG9ja2luZ3NocS5jb20vbmV3Zm9ydW0vaW5kZXgucGhwOjI4Njx iciAvPgovZGF0YS93d3cvc2l0ZXMvc3RvY2tpbmdzaHEuY29tL25ld2ZvcnVtL2luZGV4LnBocD ozNzQ8YnIgLz4KL2RhdGEvd3d3L3NpdGVzL3N0b2NraW5nc2hxLmNvbS9uZXdmb3J1bS9pbmRle C5waHA6NDQ1PGJyIC8+Ci9kYXRhL3d3dy9zaXRlcy9zdG9ja2luZ3NocS5jb20vbmV3Zm9ydW0v aW5kZXgucGhwOjExMzI8YnIgLz4KKSAxMDE2OiBDYW4ndCBvcGVuIGZpbGU6ICdmdWQyNl9zZXM uTVlJJy4gKGVycm5vOiAxNDQpPGJyIC8+ClF1ZXJ5OiBJTlNFUlQgSU5UTyBmdWQyNl9zZXMgKH Nlc19pZCwgdGltZV9zZWMsIHN5c19pZCwgdXNlcl9pZCkgVkFMVUVTICgnMTFlZWNjZDI1MjQxZ TgyMTY1YjgwY2U0OTI1ZjY1MmQnLCAxMDkwMzY5MDk4LCAnOWFmMGZiMjEyNGZiZDFmZDFmNDQ4 ODhjOTc2N2UzYjUnLCAyMDc1ODY5ODkzKTxiciAvPgpTZXJ2ZXIgVmVyc2lvbjogNC4wLjE2LWx vZzxiciAvPgo=

fud_erros file contains lines like:
[Wed Jul 21 0:01:31 GMT 2004] W0Vycm9yXSBJbnZhbGlkIGlucHV0PGJyIC8+W01lc3NhZ2UgU2VudCB0byBVc2VyXSBZb3UmIzM 5O3ZlIGZvbGxvd2VkIGFuIGludmFsaWQgbGluaywgcGxlYXNlIG5vdGlmeSB0aGUgPGEgaHJlZj 0ibWFpbHRvOmZvcnVtc0BzdG9ja2luZ3NocS5jb20iPndlYm1hc3RlcjwvYT48YnIgLz5bVXNlc iBJUF0gODEuNzYuMjI4LjE1OTxiciAvPltSZXF1ZXN0ZWQgVVJMXSBodHRwOi8vY2hhdC5pbmZv bmF1dC5uZXQvbmV3Zm9ydW0vL2luZGV4LnBocC9mLzI8YnIgLz4=


Mysql files have errors.
Checking MyISAM file: fud26_users
Data records: 0 Deleted blocks: 0
myisamchk: warning: Table is marked as crashed and last repair failed
- check file-size
myisamchk: warning: Size of indexfile is: 489472 Should be: 1024
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check data record references index: 5
- check data record references index: 6
- check data record references index: 7
- check data record references index: 8
- check data record references index: 9
- check record links
myisamchk: error: Record-count is not ok; is 4411 Should be: 0
myisamchk: warning: Found 4482 parts Should be: 0 parts
MyISAM-table 'fud26_users' is corrupted

That scares me as it implies a fix would delete all my users.



Any ideas? My forum is now offline.

Pais.

[Updated on: Wed, 21 July 2004 00:38]

Report message to a moderator

Re: Consitancy check and rebuild. [message #19448 is a reply to message #19447] Wed, 21 July 2004 00:55 Go to previous message
mocara is currently offline  mocara   United Kingdom
Messages: 157
Registered: January 2004
Karma: 0
Senior Member
Well myisamchk -r on the broke files fixed it.
I must say I was worried about running that as it looked like it would delete the records! Rolling Eyes

Dave.
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Search function doesn't work
Next Topic: Moderator Queue showing up empty
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 10 08:49:29 GMT 2024

Total time taken to generate the page: 0.02998 seconds