phpMyFAQ

Good suggestion!

But it could be som problems with comparisons and free text search. I don't know exactly how for example tsearch2 in postgres will handle & and ;, probably as non-word characters. Maybe similar problems in mysql also.

Another solution migth be to have a funtion to translate ...

Ok, I see!

So, an additional variation with an alternate Swedish language encoded as utf-8 might solve my problem?

But isn't this a problem if I need to support several languages with different encodings. At least Postgresql will not accept to store characters outside the current encoding in the ...

Unicode in postgres

Don't know if I have some misconfiguration, but I get problems with Swedish characters in my unicode (utf8) database.

When I try to add a category with e.g. "ä" I get the following message:
ERROR: invalid byte sequence for encoding "UNICODE": 0xe46b74

I think that the ...

Thanks, seems to work ok now

Just another minor postgres bug in the generated backup sql script. The comments must begin with "--" and not "#".

After an update (step 5) I got the following:

OPTIMIZE TABLE faqadminlog, faqadminsessions, faqcategories, faqcategoryrelations, faqchanges, faqcomments, faqdata, faqfragen, faqnews, faqsessions, faquser, faqvisits, faqvoting
I guess postgresql will need something like "VACUUM ANALYZE ...

...
Warning: pg_result() [function.pg-result]: Unable to jump to row 1 on PostgreSQL result index 20 in P:\www\virtualhosts\phpmyfaq\inc\pgsql.php on line 377
...

Solution

Line 377 in inc\pgsql.php:
$currentID = pg_result($result, 1, 'current_id');
change to:
$currentID = pg_result($result ...

Fatal error: Call to undefined function m55() in P:\www\virtualhosts\phpmyfaq\admin\user.addsave.php on line 25

Latest CVS, 2005-01-02

Yes, this seems to fix the reassign $this problem :-)

A few other problems (not related to php5) :
- I get doble linefeeds i all files. In some cases this will lead to problems when ther ins an extra empty line at the end, after "?>", e.g. in db.php and category.php. Maybe this could have something ...

Still problems with php5... (CVS version from 2004-12-31)

I think the reassign of $this in the db class is illegal, in php5 $this is readonly.

This is my error message:
Fatal error: Cannot re-assign $this in P:\www\virtualhosts\phpmyfaq\inc\db.php on line 59

The only workaround I can think of is ...

Just downloaded CVS version to test the Postgres implementation, but I didn't get too far.

I found a couple of problems i the db class:

1. I had to insert a str_replace to replace backslashes to be able to include correct database class.

2 More fatal, the reassign of $this is not allowed in php5 ...