CATEGORY ACCESS GREATER THAN 255

Phoca Download - download manager
lorenzo74
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 04 Oct 2011, 11:36

CATEGORY ACCESS GREATER THAN 255

Post by lorenzo74 »

Hi,
first of all this component is smart and useful.
I only find an issue setting access to a category when the IDentification of the Access is greater than 255.
In developing phase, (with many deletion an ID greater than 255 is not so weird).
To fix this problem i suggest to change the file install.bak.sql row 23:

`access` tinyint(3) unsigned NOT NULL default '0',
(you can define access id from the JOOMLA table viewlevels, only if ID is less than 255)

TO

`access` int(11) unsigned NOT NULL default '0',

(now you can define any access id from the JOOMLA table viewlevels)

Best regards

Lorenzo Frigerio
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: CATEGORY ACCESS GREATER THAN 255

Post by Jan »

Hi, thank you for the guide, I will chang it (it comes from historical talbes, where access in Joomla had only 3 numbers)

Thank you, Jan
If you find Phoca extensions useful, please support the project
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: CATEGORY ACCESS GREATER THAN 255

Post by Jan »

Changed in 2.1.2

Jan
If you find Phoca extensions useful, please support the project
Post Reply