delete event plugin bug?

[tshcomm]

hi. i've had no issues until yesterday. here's what happened:

groovyornot.com

1. i installed the backup event plugin.
2. i changed my mind and ticked the box to delete it.
3. event plugin was still there, so i ticked it again and tried to delete again.
4. plugin was still there, so i went into plugins and deleted via ftp.
5. my site is now inoperable.

i'm not a programmer, so please talk to me like i'm stupid

thanks!

allen

[garvinhicking]

Hi!

Actually your site did not became inoperable by what you did.

The blog error tells me that the Database file 'serendipity_entryproperties' is missing. Did you accidentaly delete/drop this database table? Or did your server crash, or did your provider delete something?

This entryproperties table is vital for serendipity, if it is unrecoverably missing and you don't have a backup, you might need to reinstall serendipity.

When you deleted the backup plugin, did you not only check the box, but also clicked on the button "Remove ticked plugins"?

Deleting a plugin directory via FTP is no problem, you can do that without affecting your blog - so this is not what caused the error!

Best regards,
Garvin

[tshcomm]

hi garvin,
thanks for trying to help me solve this.
no, i never touched the database. my site and server have been working flawlessly. the only variable that changed (and at the exact same time) was when i deleted that backup event plugin. could be coincidence, but logic makes me question it of course
i see there is a different error message here: http://groovyornot.com/archives/25-NOT- ... -Farm.html so there are two different issues so far.
i hope someone can help.

thanks!

[garvinhicking]

Hi!

Actually that error also happens because of the missing entryproperties DB table.

What you need to do now is to restore the 'serendipity_entryproperties' database table.

Use a tool like phpMyAdmin to check if the table is still there and you can access it. If you can, try to repair it.

If the table is no longer there, check if you have a backup of your DB and re-upload that part where serendipity_entryproperties is created and filled.

If you don't have a backup, you will need to create a new, empty entryproperties DB table. You will loose any properties you assigned to your entries in the past, like sticky attributes, custom properties or read/write permissions per-entry. You can re-create the empty table with this SQL:

Code: Select all

CREATE TABLE `serendipity_entryproperties` (
  `entryid` int(11) NOT NULL default '0',
  `property` varchar(255) NOT NULL default '',
  `value` text ,
  UNIQUE KEY `prop_idx` (`entryid`,`property`),
  KEY `entrypropid_idx` (`entryid`),
  FULLTEXT KEY `fulltext_idx` (`value`)
);

HTH,
Garvin