4.0.10 does not show my categories - [Fixed in 4.0.11]

[MikaelBjors]

The newest version installs without errors, but it doesn't show anything. The menu choice of all categories shows only the error message shown in attachment. The module document tree doesn't show anything eighteen, but the module latest file actually showing files
If I choose menu choice all files I get an PHP-error!

[svherpen]

That's weird as my version does show the categories!

At the other hand I'm not seeing any download or files. Those database tables remain empty. As well as my templates.

[Arno]

'No valid layout found' is the message when the requested template type can not be found or the template table is empty.

This happens when in the update process it was not possible to create the new table format in a temp table with _40x at the end from the table name.
This should be listed in your installation log. Please check it.

Your update is also still not complete as it is missing all layouts now.

[Arno]

Hi Mikael,
would it be possible to get an akeeba backup from your website where you want to run the upgrade to jD 4? 

At best, with the status after Joomla 4 upgrade but before you have tried the jD upgrade.

[MikaelBjors]

Am actually think I have backups from the process. 3-4 backups i have.
So you mean I start try again, from that point. I will try it...

[Arno]

Please wait, I think I have found the reason for this problem and will fix it tomorrow. 

[MikaelBjors]

OK, Arno. I'll wait... (I was just up to do it

[Arno]

Hi Mikael,
please could you check this in your database:
- does the _jdownloads_files table have 60 data fields?
- is the field featured in position 56?
- does the table _jdownloads_usergroups_limits have 118 data fields?

Thank you.

[MikaelBjors]

Yes. Table _jdownloads_files has 60 fields
And Yes, featured is field no 56.
And yes, _jdownloads_usergroups_limits has 118 fields

[Arno]

Okay, this looks good but it seems for me to be the new tables after the update?
I meant in your original version 3.9.x tables before you started the update process.

And a last question: Can it be that in your old template table the field 'preview' is not at the end?

[MikaelBjors]

I can see that the new template table is empty but the backup template table has data in it. Se screen dumps...
Has the table changed or can I just rename the old one?

[Arno]

You cannot simple rename it!

But I need at first an answer on this:

Yes. Table _jdownloads_files has 60 fields
And Yes, featured is field no 56.
And yes, _jdownloads_usergroups_limits has 118 fields

I meant in your original version 3.9.x tables before you started the update process.
And a last question: Can it be that in your old template table the field 'preview' is not at the end?

Please check this again.

Or is it possible to get a database backup from your old 3.9.x tables?
So the state before you started the update to jD 4.0.

[MikaelBjors]

Am sorry, I dont have SQL dumps, only Akeeba backup jpa files! I assume a SQL dump is inside them jpa files.
With these files I could restore the site to before jDownload upgrade!

Is it possible to extract them from jpa!?

Am at wrong place right now, don't have access to my files during workday...

[Arno]

Hi,
an akeeba backup would be wonderful. 

[MikaelBjors]

Here is two jpa archives in one zip-file. I would try the latest one first, I hope that one is Joomla 4 with our new jDownloads. The oldest is probably J3 before start of migrate...

I suspect the file will be too big to upload. If so, do you have an email that I could "Sprend" the file instead?

That was the case. The file was to big!

Best regards
Mike