2.6.7 tagging gives php errors

[squeedo]

When I view a FAQ that has tags, the following errors are displayed on the page:
phpMyFAQ notice [8]: Undefined property: stdClass::$tagging_id in Tags.php on line 154
phpMyFAQ notice [8]: Undefined property: stdClass::$tagging_name in Tags.php on line 154

The line in questions says:

Code: Select all

$tags[$row->tagging_id] = $row->tagging_name;

[squeedo]

I'm using SQLite as the database.

When I suppress the errors with a @ (bad, I know), a link is displayed in the place where the tags should be.
The link is:

Code: Select all

index.php?sid=8&lang=en&action=search&tagging_id=0

When I click on the link, I get a sqlite error:
phpMyFAQ warning [2]: sqlite_query() [function.sqlite-query]: ambiguous column name: id in Sqlite.php on line 89

[Thorsten]

Hi,

I'll take a look at it.

bye
Thorsten

[Thorsten]

Hi,

here's the bugfix: http://github.com/thorsten/phpMyFAQ/com ... 79e4e4541d

Thanks for the hint!

bye
Thorsten

[squeedo]

Thank you. That was fast! Tags now show up fine in the front end and also when editing question/answers.

But I found another related bug
Now, when I click on a tag name (in the front end), I get another sqlite error:

Code: Select all

phpMyFAQ warning [2]: sqlite_query() [function.sqlite-query]: ambiguous column name: id in Sqlite.php on line 89

[Thorsten]

Hi,

okay.... I'll check it.

bye
Thorsten

[Thorsten]

Hi,

this is a fix: http://github.com/thorsten/phpMyFAQ/com ... 21ff65e3da

Thanks for the hint!

bye
Thorsten