media library doesn`t show anything after re-inst [solved]

[cousin it]

Hi there!

I use this great program for quite some time now and do appreciate it back from my personal start. But right now I seem to be stuck with a little problem I hope you can help me with. Because of problems after upgrading I reinstalled s9y, which worked fine, altered the directory rights etc. .

But now the media library behaves quite strange. I can upload files an I can repeat that and it does recognize them as already there. But instead of showing the media library as before I get this kind of error.


INSERT INTO serendipity_images ( name, extension, mime, size, dimensions_width, dimensions_height, thumbnail_name, date, authorid, path, realname ) VALUES ( '027-ikea', 'gif', 'image/gif', 19219, 300, 450, 'serendipityThumb', 1179849492, 0, '', '027-ikea.gif' )

INSERT INTO serendipity_images (
name,
extension,
mime,
size,
dimensions_width,
dimensions_height,
thumbnail_name,
date,
authorid,
path,
realname
) VALUES (
'027-ikea',
'gif',
'image/gif',
19219,
300,
450,
'serendipityThumb',
1179849492,
0,
'',
'027-ikea.gif'
)

/ Unknown column 'realname' in 'field list'

I suppose I have done something obvious wrong, but what is it? Empty-ing `serendipity_images` in the sql database didn`t do though it redid the indexing afterwards for all files.

Help please!

regards,
Hendrik

[garvinhicking]

Hi!

To properly reinstall serendipity, please also drop all of its serendipity_* Database tables (or use expert installation and choose a different DB prefix). Only then the proper new DB structure of the recent version can be installed.

In your case the old DB existed, and s9y didn't want to touch it to preserve your old stuff. And the old image table does not relate to what the new serendipity version requires.

You'd also have the option of upgrading your old DB to the new format, but that involve more work than simply re-installing with an empty DB:)

Regards,
Garvin

[cousin it]

Hi there!

thanks for the fast response / help! but afterwards the entries and comments will be blanked, will they?

regards,
hendrik

[garvinhicking]

Hi!

Yes, but I thought that was your intention, to start over.

If you want to keep the stuff, please follow the steps outllined here:

http://www.s9y.org/11.html#A20

HTH,
Garvin

[cousin it]

Hi again!

no, my intention was to keep my beloved entries and comments. Starting a new database, restoring a backup and deleting anything but comments & entries finally worked out for me.

After that I did a full install and right now it works, the image-database works, spartacus does... fine. I hope it doesn`t make you shiver too much as I suppose I did recreate the old database format..

Thanks again for your help!

Regards,
Hendrik