i am suddenly not able to edit or delete one specific news item (the rest i do not have this problem with). after i try to delete it, it seems to execute correctly but the item remains. when you click on it is says


Sorry, the selected story does not exist.

If the page does not automatically reload, please click here


if i flip on php debug mode i see this error flash while trying to delete.

Warning: Invalid argument supplied for foreach() in /home/offmke/public_html/v1/class/xoopsstory.php on line 222


the item (ironically ID 1) still shows up on the front page and in the backend.

the only thing different about this news item is that it was created form the "admin" account. yet, when logged in as admin i still cannot delete it.

help!

With phpmyadmin could you laucnh a repair on your database ?

this morning i want to my site again to try to fix this and noticed ALL the news items were gone!

so, i went to myphpadmin into "xoops_stories" and it spit out this error


Can't open file: 'xoops_stories.MYI'. (errno: 145)
Error

SQL-query: Edit

SHOW KEYS FROM `xoops_stories` ;

MySQL said: Documentation
#1016 - Can't open file: 'xoops_stories.MYI'. (errno: 145)


help!
i can now no longer add news.


PS how do i attempt to repair a database in myphpadmin?

ok, i was able to fix this. as per the recommendation, i went into myphpadmin and ran a repair to the database. this fixed all the above problems.

thanks.

If you can, use cron jobs to backup your datas.