Loading...
 
Features / Usability

Features / Usability


Yikes.. help appreciated

posts: 10 United States

Hi, my tiki install, which has been working happily for the past month or so, now just returns the following when I go to the site:


Warning: mysql error: Can't open file: 'tiki_pages.MYI'. (errno: 145) in query:
select `pageName`,`lastModif`,`user` from `tiki_pages` order by `lastModif` desc
in /home/indymed/public_html/dc/lib/tikidblib.php on line 125
Values:
Array ( )
$result is false
$result is empty



Any and all suggestions on next steps for fixing this would be very, very appreciated.

Thanks,
John

posts: 2881 United Kingdom

Hi There

Sounds like your MySQL database has got corrupt.

Id try and seek documentation on http://www.mysql.com or your hosting provider to attempt to run repairs on it. Or restore from a recent backup

Damian

posts: 1

Hello I have just encountered the same problem, luckily I have regular backups, I restored from backup and then the site looks and feels fine until I try to edit a tiki page and then I get

$result is false
$result is empty

this only havppens on tiki-editpage.php I can edit blogs tetc no problem any help gladly received


posts: 3

cry don't panik... in my case it is "happy end" (for the moment...)lol

I have just encountered the same situation! It is a bit hard to make an idea of what can provoke the corruption... I have just finished to migrate my Debian Woody server to "testing" (sarge). I update mysql from 3.2x to 4.0. After observing the tiki working without any problems (just restarting services, no reboot), I conclude everything OK! (and I let down my databases backup... :-()

a few after, I tried to create a backup in tikiwiki, that FAILED!
After that I have been logging a few on the server and ... CRASH evil

I have no idea of a tool that can analyse back the .MYI, .MYD files. because in my case the files are still there and seems to be OK (maybe too small because the wiki part have been filled reasonably and the files still only :
76K tiki_pages.MYD
44K tiki_pages.MYI
is it possible to store ~20-30 "normal" pages in such a size?
(instead of 4K for an empty table)

neither the site was not filled a lot, I am feeling very sad and bored at the idea to start again...
I tried to dump my tiki database to check if other tables are also corrupted and only tiki_pages seems bad. in the worst case, can I try to start the system as it is and with an empty tiki_pages table. I am afraid the system need at least the HomePage and maybe some more...

found that reference that I start to readeek
http://dev.mysql.com/doc/mysql/en/Repair.html


useful: shell> perrno ###

errno 145 = Table was marked as crashed and should be repaired rolleyes (I hope they are so optimist not just to look fine...)

hormigaga:/var/lib/mysql/tiki# myisamchk tiki_pages.MYI

Checking MyISAM file: tiki_pages.MYI
Data records: 15 Deleted blocks: 0
myisamchk: warning: Table is marked as crashed
myisamchk: warning: 1 clients is using or hasn't closed the table properly
- check file-size
- check record delete-chain
- check key 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 record links
MyISAM-table 'tiki_pages.MYI' is usable but should be fixed

vamos un poco mejor... yes it worked for me !!!

here the log:

  • myisamchk -e *.MYI

//actually the result was the bad for all tables (ver. 3 --> ver. 4 ?)

MyISAM-table 'name_of_table.MYI' is usable but should be fixed
  • backup the data: cp -r /var/lib/mysql/tiki somewhere
  • myisamchk -r *.MYI


everything is very well explained and illustrated in the page I linked above.


posts: 1

Hello I have just encountered the same problem, luckily I have regular backups, I restored from backup and then the site looks and feels fine until I try to edit a tiki page and then I get

$result is false
$result is empty

this only havppens on tiki-editpage.php I can edit blogs tetc no problem any help gladly received


posts: 12 Canada

For the record, here if you get an error like this...

Notice: Undefined variable: ADODB_LASTDB in /home/sierra/public_html/sustainable/lib/tikidblib.php on line 134

Warning: error: Can't open file: 'tiki_pages.MYI' (errno: 145) in query:

select `page_ref_id` from `tiki_structures` ts, `tiki_pages` tp where ts.`page_id`=tp.`page_id` and (`parent_id` is null or `parent_id`=0) and `pageName`=?



It means your table 'tiki_pages' is corrupted and needs to be repaired. With some luck you can easily repair the table using phpMyAdmin > Operations > Repair Table

Hope that helps

-jd -