Content disappears - Failed to get content for valid content

[almustone]

Hi!

I have a very mysterious problem. My content started to disappear suddenly. It gives me error "Failed to get content for valid content id: XXX"

Everything looks working normaly and website have been up for a year now. This isn't first time when this happened. I can create and edit content normaly, but then suddenly content just dissappears and I must recovery it from previous backup. This happens now about once a couple of days and I must stop this.

Here is my system info:



----------------------------------------------

Cms Version: 1.12.1

Installed Modules:

CMSMailer: 5.2.2
CMSPrinting: 1.0.5
FileManager: 1.4.5
MenuManager: 1.8.7
MicroTiny: 1.2.9
ModuleManager: 1.5.8
News: 2.15.2
Search: 1.7.13
ThemeManager: 1.1.8
Gallery: 2.0.2
TinyMCE: 2.9.12
Showtime: 3.4
CGSimpleSmarty: 1.9.1
JQueryTools: 1.3.7
FormBuilder: 0.8.1.1


Config Information:

php_memory_limit:
process_whole_template:
max_upload_size: 32000000
url_rewriting: mod_rewrite
page_extension:
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale:
default_encoding: utf-8
admin_encoding: utf-8
set_names: true


Php Information:

phpversion: 5.4.41
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 0
E_DEPRECATED: 0
memory_limit: 128M
max_execution_time: 120
output_buffering: 4096
safe_mode: Off (False)
file_uploads: On (True)
post_max_size: 32M
upload_max_filesize: 32M
session_save_path: /tmp (0777)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)


Server Information:

Server Api: cgi-fcgi
Server Db Type: MySQL (mysqli)
Server Db Version: 5.5.45
Server Db Grants: Could not find a suitable "GRANT ALL" permission. This may mean you could have problems installing or removing modules. Or even adding and deleting items, including pages
Server Time Diff: No filesystem time difference found


----------------------------------------------

Any suggestions why this happens and how to fix this?

[Rolf]

Go to System Maintenance in the Admin and perform all actions. Might help...

[almustone]

Hi! I try that tonight and let you know if that helped.

- Aleksi

[calguy1000]

Yes I think your database is corrupted.. though restoring from backup should fix that (as it involves dropping and recreating each table).

This issue is related to having content types in the content list that cannot be loaded for some reason.

i.e: I see this when I create protected pages with FEU and then disable the FEU module.

I would start by dumping out, and looking at the contents of your cms_contents table. Particularly the 'type' column to see if there are some non-standard items in there.

[almustone]

Hi!

I did that: Go to System Maintenance in the Admin and perform all actions.

and my website worked about a week, but now content disappeared again. Also my Log In accounts stopped working so now I'm not able to log in and see what happened there.

You said that I need to look for non standard items at my database. Can you give me example of those items?

Best regards

Aleksi

[calguy1000]

and my website worked about a week, but now content disappeared again. Also my Log In accounts stopped working so now I'm not able to log in and see what happened there.

Unfortunately, that does not help us to help you.

CMSMS websites do not just 'stop' working unless something changes. You will need to dig into your error and access logs and find out what is happening... do a system verification to make sure your site isn't hacked... and if it is, restore to a known good backup.

[almustone]

Hi!

I now restored my website to todays morning backup and I checked admin log before todays crash and its nothing there. It have only written up log in errors which I have made when trying to log in after the crash and second newest log mark was from editing content yesterday.

During this week after System maintenance there have been done normal content managering. Editing pages, news, files ect.. And no errors at admin log.

Now i regonize, that disappeared content was edited lately.

Here are my database settings:

Server type: MySQL
Server version: 5.5.45-log - MySQL Community Server (GPL)
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)

I regonize that there have been difference between charset. Some of my tables are utf8_general_ci and some are latin1_swedish_ci. latin1_swedish_ci is my database default. Any help for that?

Thanks for a fast reply and all the help so far! I really hope you guys can help me with this because I have a lack of knowledge with editing databases.

Edit: No errors at checksum

- Aleksi

[almustone]

Do you guys have any suggestions how to fix this? I really need your help, because I can't repair this by myself.

Now my website has been running smoothly a couple of days, but I believe it will crash again soon.

- Aleksi