Categories field grayed out

[mvergara]

Hi: I installed the Phoca Download plugin 5.0.10 on a J5.2 site, but the category field looks grayed out and uneditable.
That behavior makes the system unable to upload files.
Anyone have some thougts about how allow the enable category field?

[Benno]

Hi,

That behavior makes the system unable to upload files.
Anyone have some thougts about how allow the enable category field?

You need to install Phoca Download Component.

Kind regards,
Benno

[mvergara]

Thanks for your prompt answer.
Even it was installed, I tried that again, but got this error:
JInstaller: :Install: Error SQL Duplicate column name 'token'

[Benno]

Hi,
Uninstall the component and install it once more:
backend --> Extensions --> Manage --> Manage

Kind regards,
Benno

[mvergara]

Benno: I tried that, but when I do that and reinstall the plugin I loss the categories and files I have from J3.

[Benno]

Hi,
You should have mentioned in your first post that this is a migration from J3 to J4. Do you have a backup of the J3 page that you can restore?
Then please follow these instructions for the migration:
https://www.phoca.cz/documentation/86-j ... o-joomla-4

Kind regards,
Benno

[mvergara]

You are right. I apologize for that missing.
I am working over a J5 test internal lab. Could I backup and restore from same j5 version after reinstall the plugin?

[mvergara]

I got this error:
Must tell you I am not a DB expert, so Im not sure how proceed:

-- Dumping data for table `u2wxr_phocadownload_logging`
--

INSERT INTO `u2wxr_phocadownload_logging` (`id`, `fileid`, `catid`, `userid`, `ip`, `page`, `date`, `type`, `params`) VALUES
(1, 245, 0, 93, '190.145.73.94', 'https://intraconte.org.co/index.php?opt ... Itemid=566', '2021-04-21 17:39:08', 1, ''),
(2, 446, 0, 99, '181.236.176.52', 'https://intraconte.org.co/index.php?opt ... Itemid=566', '2021-04-26 16:50:07', 1, ''),
(3, 296, 0, 93, '190.145.73.94', 'https://intraconte.org.co/index.php?opt ... Itemid=566', '2021-05-04 14:44:34', 1, ''),
(4, 485, 0, 93, '190.145.73.94', 'https://intraconte.org.co/index.php?opt ... gi5-ce0002[...]

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'PRIMARY'

[Jan]

Hi, the error message says that you are adding value 1 into database table where the value exist yet.

Jan

[mvergara]

Yes. I resolved that, but now I am getting a new error in the front-end. The plugin seem to be not finding the documents path:
"Ha ocurrido un error mientras se descargaba el archivo Archivo no encontrado en el servidor"
In english says "file not found on the server"