Media Library Problems

[KangaPong]

Hello! I recently discovered that somehow my blog had disappeared. I was able to restore the database from the only backup that I had from 2 years ago…and while I was at it, I uploaded Serendipity 1.3 (fresh install) to replace an older (2 years or so) beta version. Everything looks OK, but when I go to add media I get the following: 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
)

WHERE 1=1 AND (
i.path IS NULL OR
acl_acc.groupid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY i.id
ORDER BY i.date DESC LIMIT 0, 8
/ Unknown column 'i.realname' in 'field list'
Also, the Media Library has a similar problem and contains no images. Please Help! The blog URL is: http://blog.heartscontentpetsitting.com.

[garvinhicking]

Hi!

How did you upgrade? you must have done something wrong, because you are missing the database upgrade.

Have a look at the s9y.org FAQ on how to upgrade, also on how to re-perform an upgrade.

Regards,
Garvin

[KangaPong]

Actually I did a fresh install of 1.3. I deleted everything except the database and my uploads folder. I just uploaded 1.3.1 and got to the upgrade agent screen, and it said that it appeared that no changes needed to be made to the DB; however, I am still having the Media Library problem.

[garvinhicking]

Hi!

That was a very bad way t o upgrade.

Please look at the FAQ on www.s9y.org. It tells you how to reperform the upgrade.

Regards,
Garvin

[KangaPong]

You were right…I choose the wrong way to upgrade. I followed the instructions found in the FAQ on upgrading and my blog is now 100%. Thank you very much for your help.

[garvinhicking]

Hi!

You're welcome! Hope you'll have fun with the new s9y version.

Best regards,
Garvin