Hello !

[eightgr]

I'm using serendipity 1.0 and got this error when going in the media library : any Idea how to fix it ? I can use it



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 = 3
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'

[garvinhicking]

Hi!

It seems you did not properly upgrade your serendipity installation from 0.9 to 1.0: The 'i.realname' column is missing.

How did you do the upgrade? Have a look at the sql/db_update_0.9-1.0_mysql.sql files and apply them manually? The other way is to downgrade to 0.9 by restoring your backup and then properly running the upgrade as documented on www.s9y.org?

HTH,
Garvin