1 Topic by frankpeng (edited by frankpeng 2011-11-18 01:50)

  • Registered: 2009-10-15
  • Posts: 55

Topic: Cannot delete a topic neither by admin or by the author.

An error was encountered

The error occurred on line 139 in /usr/local/www/frank/extensions/pun_tags/functions.php

Database reported: ERROR: column "cnt" does not exist LINE 1: ..._tags AS tt ON t.id = tt.tag_id GROUP BY t.id HAVING cnt = 0 ^ .

Failed query: SELECT t.*, COUNT(tt.tag_id) AS cnt FROM p1_tags AS t LEFT JOIN p1_topic_tags AS tt ON t.id = tt.tag_id GROUP BY t.id HAVING cnt = 0
  • From: Ukraine
  • Registered: 2008-10-31
  • Posts: 762

Re: Cannot delete a topic neither by admin or by the author.

Please, specify forum version and pun_tags version.

  • Registered: 2009-10-15
  • Posts: 55

Re: Cannot delete a topic neither by admin or by the author.

PunBB version

    PunBB 1.4



pun_tags

Version 1.7.4

Uninstall then re-install won't help.

  • From: Ukraine
  • Registered: 2008-10-31
  • Posts: 762

Re: Cannot delete a topic neither by admin or by the author.

What databse you use?

  • Registered: 2009-10-15
  • Posts: 55

Re: Cannot delete a topic neither by admin or by the author.

Environment

    Operating system: FreeBSD
    PHP: 5.2.17 - Show info
    Accelerator: N/A

Database

    PostgreSQL 9.1.0

  • From: Ukraine
  • Registered: 2008-10-31
  • Posts: 762

Re: Cannot delete a topic neither by admin or by the author.

Try version 1.8.1.

  • Registered: 2009-10-15
  • Posts: 55

Re: Cannot delete a topic neither by admin or by the author.

Yes! It works! Thank you!