Tags plugin bugs with postgresql

[lendulado]

When I "manage tags" and I click on
* "Manage 'Leaf' Tags" the bug showed is

Code: Select all

Warning: pg_query(): Query failed: ERROR: no existe la columna «total» in /usr/local/www/htdocs/lendulado/include/db/postgres.inc.php on line 107
Error in SELECT tag, count(tag) as total FROM lendulado_entrytags GROUP BY tag HAVING total <= 1 ORDER BY tag
ERROR: no existe la columna «total»

SELECT tag, count(tag) as total FROM lendulado_entrytags GROUP BY tag HAVING total <= 1 ORDER BY tag
Warning: Invalid argument supplied for foreach() in /usr/local/www/htdocs/lendulado/plugins/serendipity_event_freetag/serendipity_event_freetag.php on line 761

Warning: Invalid argument supplied for foreach() in /usr/local/www/htdocs/lendulado/plugins/serendipity_event_freetag/serendipity_event_freetag.php on line 937
Tag 	Weight 	Action

* List Untagged Entries the bug is...

Code: Select all

Warning: pg_query(): Query failed: ERROR: no existe la función isnull(integer) HINT: Ninguna función coincide en el nombre y tipos de argumentos. Puede desear agregar conversión explícita de tipos. in /usr/local/www/htdocs/lendulado/include/db/postgres.inc.php on line 107
Error in SELECT e.id as id, e.title as title FROM lendulado_entries AS e LEFT OUTER JOIN lendulado_entrytags AS t ON e.id = t.entryid WHERE isnull(entryid) GROUP BY e.id
ERROR: no existe la función isnull(integer) HINT: Ninguna función coincide en el nombre y tipos de argumentos. Puede desear agregar conversión explícita de tipos.

* List 'leaf' tagged entries

Code: Select all

Warning: pg_query(): Query failed: ERROR: no existe la columna «total» in /usr/local/www/htdocs/lendulado/include/db/postgres.inc.php on line 107
Error in SELECT e.id as id, e.title as title, count(*) as total FROM lendulado_entries AS e LEFT JOIN lendulado_entrytags AS t ON e.id = t.entryid GROUP BY e.id HAVING total = 1
ERROR: no existe la columna «total»

[garvinhicking]

Yes, managing leaf tags via postgreSQL is currently not possible due to the large difference postgresql makes with SQL joins compared to SQLite and MySQL.

I'm afraid a possible solution to this would have many other affects on the serendipity core, so it would take a skilled developer to fully think this over and implement this. As I am not using postgresql, this will not be me.

I'm awfully sorry for this. :-/

Regards,
Garvin