Page 1 of 1

Table 'serendipity.serendipity_access' doesn't exist

Posted: Fri Nov 18, 2005 12:47 am
by Hilde
I am trying to do the shared installation by using the .htaccess file and version 0.9, and it looked like it was going to work. Unfortunately I made the first test blog use an old SQL table - just to see if it would allow me to import the data into that particular test blog...

However, after getting the serendipity_authorgroups out of the way (thanks for posting that query info Gavin!) I get this on my test page:
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
Any ideas how to solve this anyone?

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 :wink:

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

Re: Table 'serendipity.serendipity_access' doesn't exist

Posted: Fri Nov 18, 2005 9:29 am
by garvinhicking
You cannot install Serendipity into an existing database. If you want to perform an upgrade, please read the FAQ at http://www.s9y.org/11.html about upgrading.

You will have more trouble going your way, so I suggest to either not install into an existing database, or to use the upgrade facility mentioned in the FAQ, which can also be done at the current point, if you "backgrade" your current installation by editing your serendipity_config_local.inc.php file.

You can only use shared installations across the same version numbers, so you cannot run a 0.7.1 and a 0.9 from the same database.

Best regards,
Garvin