1
crackerboy
cannot edit or delete ONE specific new item!
  • 2004/10/14 2:12

  • crackerboy

  • Just popping in

  • Posts: 16

  • Since: 2004/9/29


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!

2
hervet
Re: cannot edit or delete ONE specific new item!
  • 2004/10/14 4:37

  • hervet

  • Friend of XOOPS

  • Posts: 2267

  • Since: 2003/11/4


With phpmyadmin could you laucnh a repair on your database ?

3
crackerboy
Re: cannot edit or delete ONE specific new item!
  • 2004/10/14 13:42

  • crackerboy

  • Just popping in

  • Posts: 16

  • Since: 2004/9/29


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?

4
crackerboy
Re: cannot edit or delete ONE specific new item!
  • 2004/10/14 14:15

  • crackerboy

  • Just popping in

  • Posts: 16

  • Since: 2004/9/29


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.

5
hervet
Re:cannot edit or delete ONE specific new item!
  • 2004/10/14 18:43

  • hervet

  • Friend of XOOPS

  • Posts: 2267

  • Since: 2003/11/4


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

Login

Who's Online

202 user(s) are online (115 user(s) are browsing Support Forums)


Members: 0


Guests: 202


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits