ID error + some stories not being saved in DB

[Faizan]

For a few weeks now, my installation of cutenewsru has been playing up and I have been so puzzled about it.

First off, let me give you a few details about my database and script:
I use CuteNews.RU 2.5.4
Total users 13 (1.17 KByte)
Total stories 4040 (10.66 MByte)
Total comments 9104 (18.25 MByte)
Total categories 85 (3.29 KByte)

Sometimes the Edit page shows the following error:


It's so slow, which I thought might have something to do with the amount of stories on there. When it does finally load... I add the stories for that day.

Sometimes when I add a story and go back to edit it, it disappears. The title, url and xfield are there but the short story and full story are gone.


I checked my database to see if the story was at least in the stories table and it doesn't seem to be there.


What can I do to fix this issue? It never used to happen before and I have been pretty happy with running this script for many many years.

Your help is greatly appreciated.

Thanks in advance
Faizan

[Faizan]

I just realised something.

Deleted a few useless categories in a different installation of CNR (same version) and the stories from categories that are no longer in the database were the ones that said "ID error" in red like above.

That leads me to believe that somehow the categories table is not being read on my original problem above.

Does anyone have any clue what could be going wrong?

I have a feeling that it's soemthing to do with php4 vs php5 issue. Everything worked smoothly at my previous server last year when it had php4.

Edited to add:
Sometimes I also get this error on the main page of cutenews:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /nfs/c03/h04/mnt/57601/domains/bollyspice.com/html/features/admin/inc/db/mysql.class.php on line 123

[DarkSlim]

Have you made any changes to the database lately?
Which version of PHP are you using?
Basically, it was tested with some versions of PHP 5 and it was working great
Also, here is someone who have newer version PHP 5.3 and he had just
one problem which he found a fix for it: Link
You can also try to repair the tables, running a mysql query (in your mysql admin) like this:

Code: Select all

REPAIR TABLE cute_table_name


[Faizan]

Yeah, I repair my tables everytime it crashes... doesn't really help.

I tried those, thanks. That didn't fix those strange issues so I went and found a backup of my files from 2008. Replaced the files and did a few php5 fixes like in functions file and fixed some template file... now all works as it should.

I have yet to discover the problem with disappearing stories but will see if it happens again.

Thanks a lot for your help DarkSlim.