It started an install process notifying that the upgrade would be 1.3 alpha 1, which was the first thing to catch my attention. Once complete, I get the following for content:
I overwrote the files with beta 3 and it works again, just wanted to bring both the 1.3 alpha 1 issue, as well as the error, to your attention.Query failed:
SELECT count(e.id) AS orderkey
FROM
serendipity_entries AS e
LEFT OUTER JOIN serendipity_entryproperties ep_no_frontpage
ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
LEFT OUTER JOIN serendipity_entryproperties ep_cache_extended
ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended')
LEFT OUTER JOIN serendipity_entryproperties ep_cache_body
ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body')
LEFT OUTER JOIN serendipity_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access') LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE e.timestamp >= 1183266000 AND e.timestamp <= 1185944399 AND isdraft = 'false' AND e.timestamp <= 1184606100 AND (ep_access.property IS NULL OR ep_access.value = 'public') AND (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true') AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL
)
)
ORDER BY orderkey DESC, timestamp DESC
/ Unknown column 'c.categoryid' in 'where clause'
