Permission on Assets table [solved]

[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). 

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)

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 

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

[drilippi]

Thanks Colin!

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

Best Regards

[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

[Arno]

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.

[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