SQL Problem?

[s9y_user]

I'm having a problem when I upload version 1.1.2. It asks me to update from 1.1 to 1.1.2 and then it says all of this stuff.

First it says:


DIRECTORY_WRITE_ERROR


And I say yeah, I understand! It's a CHMOD problem. So I change the folders to 777.

So I go back and refesh and it says:

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.username AS loginname,
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 = 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 isdraft = 'false' AND e.timestamp <= 1174743300 AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Table '********_mysql.serendipity_entries' doesn't exist



It almost seems as if it thinks it's already installed. It didn't do it before until I moved to a new server. Could that be the issue? Maybe my host forgot to move a file over?

I don't know, so please, if you know the answer, reply.

PS: I BLOCKED OUT MY SQL NAME

[garvinhicking]

Hi!

Hm, the message to me says that your serendipity database table does not exist? Did you check if "serendipity_entries" exists in your configured table? It sounds starnge that it says "_mysql." before that?!

When yuo uploaded 1.1.2 over your 1.1, did you delete files that existed in your installation? For an upgrade, s9y requires the file serendipity_config_local.inc.php to be existing!

Best regards,
Garvin

[s9y_user]

Sorry for the wait, I forgot I posted here. It seems that I cannot upload anything over to my site (I use FlashFXP) because it doesn't do it properly. Anywho, theres another problem:

So I get it all working right and when I log in it says
Page Cannot Be Found

blah blah blah

It does it everytime I try! Anything you might know that can fix this (I've already tried moving to a new server)

[garvinhicking]

Hi!

IF you give us the URL to that page, we could have a look. But "Page not found" can mean that you installed s9y and enabled "URL Rewriting" which your server might not support.

Login to the backend via http://yourblog/serendipity_admin.php, go to the configuration and there change "URL Rewriting" to "None".

Best regards,
Garvin