However, after getting the serendipity_authorgroups out of the way (thanks for posting that query info Gavin!) I get this on my test page:
Any ideas how to solve this anyone?Query failed:
SELECT
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.email
, e.body, e.extended
FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid
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 = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE isdraft = 'false' AND e.timestamp <= '1132266484' AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL
)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Table 'serendipity.serendipity_access' doesn't exist
Since I'm currently running two S9Y (version 0.7.1) applications on my webserver and want two more, I thought the shared installation might be an idea to save some valuable hosting space
Then I tried to upgrade from v 0.7.1 to v 0.9 which turned out to be a very bad idea.... since it gave me the same problems... *tries to look intelligent and less blonde* maybe I should've installed v 0.8 first? (And would v 0.8.5 work instantly from v 0.7.1?)
OOOOOrrrrr.... would the shared instal work on v 0.7.1 (or v 0.8.5) as well? And can I use existing SQL tables to recreate the blog on the shared install? That would make my life so much easier...
Hilde