I'm using postgresql with last stable version of phpmyfaq. I have found that when you try to modify the name of a category you get error about dupplicate key. The problem is in the sql syntax in category.main.php on line 61, in postgres you can't use " to refer a value, the correct syntax for postgres:
SELECT lang FROM '.SQLPREFIX.'faqcategories WHERE id = '.$id.' AND lang = \''.$lang.'\'
I don't know if its ok for other dbs.
Regards.
Update category in postgresql
Moderator: Thorsten
Hi,
it's fixed in CVS and will be released in 1.6.12 this month. Thanks for the hint!
bye
Thorsten
it's fixed in CVS and will be released in 1.6.12 this month. Thanks for the hint!
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist