Page 1 of 1

After migration to 2.5: "You have no right to access ..."

Posted: 29 Mar 2012, 22:00
by darganfyddwr
Hello Phoca Team,
I have been a very happy user of the phocadownload component for almost 2 years now,
and now that we had to migrate from Joomla 1.5.x to 2.5 I can't seem to get it to work right.

When trying to follow a downloadlink (Menu or Text) all I get is the message:
You have no rights to access this category :shock:

All files are declared published, all (but one) categories are declared public
I have searched the forum and have not found the link to the right answer.
(I have found some similar topics though relating to 1.7)
If someone could point me to the right FAQ section I would very much appreciate it. :)

This is not an urgent request,
as we will probably need some more time to migrate all the other stuff,
but I would really really like to continue using PhocaDownload. :twisted:

Thank you in advance
Darganfyddwr

Re: After migration to 2.5: "You have no right to access ...

Posted: 02 Apr 2012, 22:16
by navidweb
https://www.phoca.cz/documents/50-phoca/ ... -joomla-25
If access was not set in Phoca Download in Joomla! 1.5 and all files and categories are public, likely, you need to run the following queries:

UPDATE `jos_phocadownload` SET `access` = '1';
UPDATE `jos_phocadownload_categories` SET `access` = '1';


Be aware, queries above set access of all Phoca Download categories and files to public.

In Phoca Download, there are no more sections. So if your Joomla! 1.5 included Phoca Download sections and you want to use such structure in new Joomla! 2.5 (1.7, 1.6) site, you need to create new categories (parent categories) and assign existing categories to such parent categories (in Joomla! administration, in Phoca Download Categories View).

Re: After migration to 2.5: "You have no right to access ...

Posted: 02 Apr 2012, 23:24
by darganfyddwr
:twisted:
THANK YOU SO MUCH !!!
That did it!
:twisted:

seems like my saved version of the migrating instructions had been missing this information...
thanks for linking me to the appropriate source.

very happy now :)

.

Re: After migration to 2.5: "You have no right to access ...

Posted: 05 Apr 2012, 23:01
by darganfyddwr
just in case, there might be someone else with the same problem,
I share the screenshot, where to insert the query:
  • First go to your PHP MyAdmin
  • Then click on "SQL" or "Query" or whatever your language may provide

    Image
    .
  • insert the commandlines as provided by Jan and Navidweb
    .
    UPDATE `jos_phocadownload` SET `access` = '1';
    UPDATE `jos_phocadownload_categories` SET `access` = '1';
    .
  • make sure you use your own database prefix.
    It might not be "jos_" depending on how you defined it when installing joomla.
Image
  • Then click OK
  • That solved the problem for me, thanks to Jan and Navidweb

Re: After migration to 2.5: "You have no right to access ...

Posted: 10 Apr 2012, 23:19
by Jan
Hi, thank you for the guide.

Jan