Installation crashed, no entry was shown

[lillebror]

Hey everybody,

when I today logged in into my blogadmin, I was totally shocked! No entry was shown, neither in the normal blogview nor in the admin interface (except one entry that was marked as draft).

I tried to update to version 1.1.1 because I still used v. 1.0.4. During updating I got the following error message:

Code: Select all

CREATE INDEX pluginretr_idx ON serendipity_plugins (placement, sort_order);

/ Duplicate key name 'pluginretr_idx'

create table serendipity_mediaproperties (
  mediaid int(11) not null,
  property varchar(128) not null,
  property_group varchar(50) not null default '',
  property_subgroup varchar(50) not null default '',
  value text
) /*!40100 CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

/ Table 'serendipity_mediaproperties' already exists

CREATE INDEX mediapropid_idx ON serendipity_mediaproperties (mediaid);

/ Duplicate key name 'mediapropid_idx'

CREATE UNIQUE INDEX media_idx ON serendipity_mediaproperties (mediaid, property, property_group, property_subgroup);

/ Duplicate key name 'media_idx'

create table serendipity_options (
  name varchar(255) not null,
  value text not null,
  okey varchar(64) not null default ''
) /*!40100 CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

/ Table 'serendipity_options' already exists

CREATE INDEX options_idx ON serendipity_options (okey);

/ Duplicate key name 'options_idx'

ALTER TABLE serendipity_images ADD COLUMN realname varchar(255) not null default '';

/ Duplicate column name 'realname'

ALTER TABLE serendipity_references ADD COLUMN type varchar(128) not null default '';

/ Duplicate column name 'type'

CREATE INDEX reftype_idx ON serendipity_references (type);

/ Duplicate key name 'reftype_idx'

I guessed it must have something to do with the SQL database, so I looked into MySQL. I tried to repair, but I got another error message:

Code: Select all

serendipity_entries  	repair  	info  	Key 1 - Found wrong stored record at 40736
serendipity_entries 	repair 	error 	sort_buffer_size is to small
serendipity_entries 	repair 	error 	Can't copy datafile-header to tempfile, error 9
serendipity_entries 	repair 	status 	Operation failed

Please help me! I get weird!

Lillebror

[garvinhicking]

Hi!

There are two different things going on.

First, about your upgrade: It seemed you already had the DB tables 'serendipity_options' and 'Serendipity_mediaproperties' on your database. That can only happen if you already installed/upgraded to 1.1 at some point, because those tables only exist since 1.1!

The other thing is your missing entries: Your database seems to have crashed. Please contact your server provider to ask him to either restore a backup or to tell you what happened with the server. He might also be helpful in repairing the table, since it seems the usual 'repair' sql command does not work for you. MyISAMChk on the console might help, if you or your provider can directly access the MySQL data files.

Best regards,
Garvin