Blog is now empty except for titles

[suretec]

Hi all,

For some reason our blog entries are now all empty, i.e. no content. What could be the cause? I've checked our Pg db and confirmed the empty entries.

http://blog.suretecsystems.com Click any entry.

Any ideas? We're on Powered by Serendipity 1.3 and PHP 5.3.6-pl0-gentoo

Thanks,

Gavin.
http://www.suretecgroup.com

[Timbalu]

Completly white means there is some PHP error, logged in your servers log files.
Did this blog exist before? What changes produced this error?

I expect it is the advanced PHP version, which is good!, and the very old Serendipity installation.
Please upgrade to latest S9y version and see if your error is gone.

[garvinhicking]

Hi!

If the entries in the postgresql database are empty, then I only see those possibilities:

- Someone hack the server (either database, your webserver, or even serendipity) (serendipity prior to 1.5 is vulnerable to some security issues, even though such a scenario where only entries are emptied is unlikely to occur)

- The PostgreSQL server hat a failure and thus erased some tables, or maybe even there is a hardware disc error


Anyhow - if serendipity_entries database table is empty, then the only way to get this data back is to restore from a backup...

Best regards,
Garvin

[suretec]

Thanks, a restore from backup is our only option.

Cheers all.

[suretec]

The following error is printed in the postmaster.log file every time I reload blog.suretecsystems.com :

ERROR: syntax error at or near "FULL" at character 6
STATEMENT: SHOW FULL COLUMNS FROM serendipity_entrytags LIKE 'tag'

Does serendipity need a specific min/max version of postgresql? We're running 8.4 at the moment.

[garvinhicking]

Hi!

Thanks for noticing! This query is only used for mysql, I've committed an update to the freetag plugin that should fix this for you. Please check for an upgrade tomorrow.

Regards,
Garvin

[suretec]

OK, thanks.