Update category in postgresql

Please report bugs here!

Moderator: Thorsten

Post Reply
An-tonio
Posts: 3
Joined: Thu Apr 12, 2007 6:00 pm

Update category in postgresql

Post by An-tonio »

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.
Thorsten
Posts: 15725
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

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
Post Reply