re-installation after loss of pics

[carolus47]

Hi
Unfortunately I deleted all php scripts and only saved the mysql database. Ic ould re-install s9y without pictures. Now, the media database tells me the pictures are missing. What can I do do remove this warnings?
carolus

[garvinhicking]

Hi!

To remove that warning, you can simple truncate (delete all content, not the table it self) of your serendipity_images database table.

Best regards,
Garvin

[carolus47]

Thank you for answering. I truncated serendipity_images, but still have the following message (shortened), when I push the button media database :
SELECT i.id, '' AS orderkey, i.name, i.extension, i.mime, i.size, i.dimensions_width, i.dimensions_height, i.date, i.thumbnail_name, i.authorid, i.path, i.hotlink, i.realname,
a.realname AS authorname
FROM serendipity_images AS i
LEFT OUTER JOIN serendipity_authors AS a
ON i.authorid = a.authorid
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'directory'
AND acl_acc.artifact_index = i.path

carolus47

[garvinhicking]

Hi!

Is that allyou get? I thinkyou are missing a statement after the query, usually there should be an error message, and not just the query.

I could onlyimagine the DB structure is not the same structure of the s9y version you installed,like when you performed an s9y upgrade without executing the DB upgrade script...

regards,
garvin

[carolus47]

Hi, yes that is right. I updated s9y and imported the mysql database.

How should I do now?
carolus

[garvinhicking]

Hi!

You will need to re-execute the update, please have a look at the FAQ on www.s9y.org, it tells you how to reset version numbers.

When you install s9y, you always need to use the same version like you previously run. Only then can you properly upgrade to a new version, else your database scheme will mismatch. Once you change your locally installed version to the old version you had before (through our FAQ) you will be able to re-execute the missing update.

Regards,
Garvin