News:

Support for jDownloads 3 has been ended
Since 17 August 2023 Joomla.org has discontinued support for Joomla 3.x. Therefore, we will no longer offer official support for our Joomla 3 jDownloads version 3.9.x from January 2024.
Please update your website to the latest Joomla version (Joomla 4 or Joomla 5) as soon as possible. Afterwards, please update jDownloads to the latest published version. The longer you delay, the more difficult the upgrade process for your website is likely to be.

Main Menu
Support-Forum

Permission on Assets table [solved]

Started by drilippi, 14.01.2017 21:54:22

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

drilippi

Hello,

(I searched on the forum and didn't find any topic similar.)

I have a J!2.5  (with jD 2.5.27) site and I'm exporting all categories and files to a J!3.6.5 with jD 3.2.

Almost everything went fine (I just had to edit the jD 2.5 files table - removed 'tags' collumn and added 'featuring' collumn, then the restoration worked).  ;D

Now I noticed that most of the permissions of the files and categories are stored at #__assets table (joomls core table) and did not go on the restoration. I made some juggling with the database to set the categories permissions on this assets tables (I just located where were the entries on the table for each categorie and update them via sql importing) :D

But I'm having a hard time to set the files permissions, because, not all files have an entry on the assets table.
I really need a help, because I have more than 3,000 files  :o

I already replaced the permissions for the files that have an entry on assets table, just need to understand how I could add new entries for those 1000 files that are not on #__assets table.

Could help me understand how to populate the collumns "lft', 'right','level' on the assets table?

Thanks!
  •  

ColinM

Hi
Changing the Joomla! assets table directly is not a good idea! Setting up 'lft', 'right','level' is most 'challenging' and borders on the impossible without the right software.
If you go back to the stage where you have just imported successfully then use the jD Tools Reset Categories Permissions and Reset Downloads Permissions.  This will hopefully set up the basic permissions entries.
If there is still a problem please let us know.

Colin
Colin M
  •  

drilippi

Thanks Colin!

I didn't think about that alternative!
I will try this way and let you know how it went.

Best Regards ;D
  •  

drilippi

Hi Colin,

I did the reset for the downloads and got this message: "548 dataset(s) changed". It's not an error but it did not create entries for the missing downloads (circa 3,000).

What bugs is why this 500 entries where created during the export, but not the other 3000?
Any ideas?

Thanks!!
  •  

ColinM

Hi
The basic reason for the message is probably that your server ran out of time.  The way Joomla! setup the permissions and the propagation is that it requires a Save to put them in the database on the assumption not many are being changed at one time.

I suspect if we had known as much as we do now about Joomla! privileges the "conversion" might have been done in "stages" to mitigate the problem.  With 3000 or so files it usually works with the 'tools'.  My next advice to you would have  that you could do the conversion on say XAMPP where you can set much higher or unlimited resource limits.  And in some very rarely occuring circumstances Arno has been able to use a dump of the jD tables and send back a revised version.

Colin
Colin M
  •  

Arno

#5
PLease note that manually database actions are very risky. 

But you could use the free ACL Manager to add easy the missing assets data sets.  He can also check whether the data sets are valid.

Should you have a jDownloads backup file from the original data so I could try to convert it for you here locally.
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!
  •  

drilippi

Hi Arno and Colin,

I'm aware of the risks of messing with the database, so I'm doing everything on a localhost, if it goes really wrong I could start again with no big loss.
I sent to you, Arno, my jD backup, and trying to change my localhost configs, maybe this is not helping now.

Thanks a lot!
  •  

drilippi

Hello Arno and Colin,

I just set my php.ini configurations for higher limits: max_execution_time = 3000
Then it worked fine :), it created entries on the assets table.

Now I just updated via phpmyadmin the rules with the previous permissions and it seems that everything is ok!

Thanks for your support (it was simpler than i thought),
Best regards
  •