Serendipity Forums

This can't be right, it doesn't look like the picture in the docs, and there's no way for me to get to my admin-pane. You can see what I mean if you go to the blog's URL:

http://choronzon.org/blogs/333

Any idea what I ought to do?

I'm using the latest version of S9y (what does the 9 stand for?!) and Apache with PostgresQL. PHP version is something relatively recent, I think 5 point something-or-other.

Would appreciate help and if none can be given, how do I hose out my database so I can try it again? The tool I use to do it is a command line prog called psql.

Thanks,
Mesila.

Hi!

Looks to me as if you did not upload all files that are contained in the s9y release? Could it be you're missing a "content.tpl" template file, plus some others? Re-upload all files via FTP, please.

(what does the 9 stand for?!)

For "indipit" (9 characters between 's' and 'y').

and Apache with PostgresQL. PHP version is something relatively recent, I think 5 point something-or-other.

Which pgsql are you using? Were all DB tables properly created? Does something show up in your pgsql error logs? s9y requires PGSql to have sequencing enabled, that sometimes causes issues.

Sadly I don'T use pgsql on my own, so I can't help you with the exact lines. Did you try "DROP DATABASE xxx"?

Regards,
Garvin

First off, just checked and content.tpl is there - took me a while to find it, but it's there, and complete.

I don't know what pgsql is. I guess it's a prog that does the same or similar to psql? Or a MySQL form of this tool? I don't have MySQL, I have PostgreSQL...I knew that was going to be a problem, it always is, with every blogsoftware.

I am not familiar with databases. My server's in New Zealand and the guy who runs it is someone who is really busy and he's been so helpful with this I hate to bother him yet again. Does anyone use Serendipity on PostgreSQL that can suggest how I ought to go about hosing my database yet still leave it open for S to install to? Does the user name have to be Serendipity? Maybe that is the problem, he configured it to be my name instead. And I did follow that in the config because he said it would work. Any ideas?

Thank you,
M.

Hi!

Yes, with pgsql I mean postgresql. It's not a problem with s9y, but you need to be familiar with postgresql to use it, because postgresql has all sorts of configuration options (like automatic sequence building) and fails much more easier than mysql. Thus it's important to watch the postgresql error console output.

I am not familiar with databases. My server's in New Zealand and the guy who runs it is someone who is really busy and he's been so helpful with this I hate to bother him yet again.

Sadly, you have to.

I'm afraid not many people use postgresql as their webserver DB. the s9y users that do this are not online here in the forums very often.

Regards,
Garvin

Before I do bug my host can you tell me whether or not the database needs to be named 'serendipity' (as it's shown in default) or can it be called something else? I need to know whether to tell him to hose the database and create a new one called 'serendipity' or not. Since he already created one with the name being the same as my login, and when I asked him about that he said it should work, but I don't know how familiar with s9y he is - although he did suggest it to me as the one blogware he knew of that will deal with postgresql. I'm not sure why he nsists on using postgres - probably something security related,

So if I can find this out, I'll know what to tell him to do and not have to come back later yet again with more changes...

M.

Hi!

Mesila wrote:Before I do bug my host can you tell me whether or not the database needs to be named 'serendipity' (as it's shown in default) or can it be called something else?

It can be named as you like. You should only avoid special characters like underscores, spaces. Best to only use A-z and 0-9.

And your DB user account needs to have full privileges on that DB.

Postgresql isn't bad, not that you think that. It simply requires more administration than the common MySQL, and less people are experienced with it (like myself).

Regards,
Garvin