Serendipity Forums

I've unzipped everything, and configured everything properly (I think) and no longer get "Could not connect to database; check your settings" errors, but now when it gives me the

Attemping to setup database...
Checking to see if the database is already in place. If you see a database query error here, ignore it...

page, it stops there. Viewing source, nothing else appears after the last "ignore it...". Something seems to be crashing somewhere. Any ideas? I'm trying this on Debian Stable (Woody) with the php4 and php4-pgsql packages installed.

It seems that PHP/Serendipity times out on your database.

Did you try to use another pgsql PHP programm on your host and made sure that PHP+PGSql properly work?

Regards,
Garvin

No, I didn't. Any suggestions on such an application? I'm inclined to think they work properly together (they're packages built to work together in the stable distribution of Debian), but I could, of course, be missing some important package or somesuch.

Would the fact that I'm running PHP4.1.2 instead of 4.2.1 cause me problems? The documentation says any version of PHP4 would be fine, but when I get to the configuration page, it warns that I'm using an older version of PHP.

Actually you shouldn't use any PHP version below 4.3.10 because of some serious bugs.

I am no pgsql user, so I don't know many applications. One you should try is phpPgAdmin, a database administration tool with which you can see if pgsql properly works (which I suspect doesn't...)

Good luck ,
Garvin

Thanks, that took care of it. I'm sad because now I'm running S9Y on Windows XP (Apache/MySQL), but my department's kind of happy about it, since I work in a Windows/Microsoft based department.

One last question before I go: How do I get the quicksearch working? Do I have to define an index on the entries MySQL table, or something?

The quicksearch needs fulltext indices, which are set during installation. But they only work if your mysql user has privileges to create keys.

See this thread: http://www.s9y.org/forums/viewtopic.php ... ch+working

(CREATE FULLTEXT INDEX entry_idx on serendipity_entries (title,body,extended);)