Issue: Article in multiple categories

Issue Tools
- View Changes

July 29, 2009 3:32 AM

tscargo

Junior Member

Article in multiple categories

I tried to put an article in multiple categories.
They are all shown on the article page, but only the last category page contains a link to the article. I cannot imagine one can only add a page into one category.

I am using version 2.00 of the categories plugin. I cannot select that in the menu below.

Issue Details

Issue Number 734

Issue Type Bug

Project VaultWiki 3.x Series

Category Categories

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 2.5.0

Fixed Version 2.5.1

Milestone VaultWiki 3.0.0

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

July 29, 2009 5:57 PM

pegasus

VaultWiki Team

In vault/extensions/category/category_functions_ext.php, find:

Code:

		WHERE categoryid = " . intval($threadinfo['threadid']) . "

Replace with:

Code:

		WHERE title_lower = '" . $db->escape_string(strtolower($threadinfo['encshort'])) . "'

If needed (depending when your download was), find:

Code:

		WHERE category.title_lower = '" . $db->escape_string($threadinfo['encshort']) . "'

Replace with:

Code:

		WHERE category.title_lower = '" . $db->escape_string(strtolower($threadinfo['encshort'])) . "'

July 29, 2009 6:36 PM

tscargo

Junior Member

This does not make any difference. Had to replace both instances....

Reply
July 29, 2009 6:56 PM
pegasus

VaultWiki Team
There is currently a unique index in the database that interferes with new categories. Run the following query on your database.

Code:

ALTER TABLE vault_category DROP INDEX undupify, ADD INDEX categoryid (categoryid)
Reply

July 29, 2009 7:01 PM

tscargo

Junior Member

Get an error:

Code:

Error
SQL query:

ALTER TABLE vault_category DROP INDEX undupify,
ADD INDEX threadid( threadid ) ,
ADD INDEX categoryid( categoryid )

MySQL said: 

#1061 - Duplicate key name 'threadid'

July 29, 2009 7:09 PM

tscargo

Junior Member

I removed all categories from all articles and added them again. Now the category-links work.

Reply
July 29, 2009 7:51 PM

pegasus

VaultWiki Team

Okay, since the threadid index was already there, you can remove that line from the query as I have edited in my post above.

Reply

+ Reply

All times are GMT -4. The time now is 4:22 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Article in multiple categories

Issue Tools