jDownloads Support Forum

jDownloads for Joomla 4.x and 5.x => jDownloads 4.0 => Bugs! => Topic started by: MikaelBjors on 30.12.2022 12:58:46

Title: 4.0.10 does not show my categories - [Fixed in 4.0.11]
Post by: MikaelBjors on 30.12.2022 12:58:46
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!
Title: Re: 4.0.10 does not show my categories
Post by: svherpen on 30.12.2022 18:46:34
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.
Title: Re: 4.0.10 does not show my categories
Post by: Arno on 30.12.2022 18:58:31
'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.
Title: Re: 4.0.10 does not show my categories
Post by: Arno on 30.12.2022 19:01:14
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.

Title: Re: 4.0.10 does not show my categories
Post by: MikaelBjors on 30.12.2022 22:36:07
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...
Title: Re: 4.0.10 does not show my categories
Post by: Arno on 31.12.2022 00:47:28
Please wait, I think I have found the reason for this problem and will fix it tomorrow.  ;)
Title: Re: 4.0.10 does not show my categories
Post by: MikaelBjors on 31.12.2022 10:46:13
OK, Arno. I'll wait... (I was just up to do it ;)
Title: Re: 4.0.10 does not show my categories
Post by: Arno on 02.01.2023 12:24:52
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.
Title: Re: 4.0.10 does not show my categories
Post by: MikaelBjors on 02.01.2023 20:11:16
Yes. Table _jdownloads_files has 60 fields
And Yes, featured is field no 56.
And yes, _jdownloads_usergroups_limits has 118 fields
Title: Re: 4.0.10 does not show my categories
Post by: Arno on 02.01.2023 21:29:41
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?
Title: Re: 4.0.10 does not show my categories
Post by: MikaelBjors on 02.01.2023 23:46:52
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?
Title: Re: 4.0.10 does not show my categories
Post by: Arno on 03.01.2023 09:22:41
You cannot simple rename it!

But I need at first an answer on this:
Quote
Yes. Table _jdownloads_files has 60 fields
And Yes, featured is field no 56.
And yes, _jdownloads_usergroups_limits has 118 fields

QuoteI 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.
Title: Re: 4.0.10 does not show my categories
Post by: MikaelBjors on 03.01.2023 10:04:25
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...
Title: Re: 4.0.10 does not show my categories
Post by: Arno on 03.01.2023 12:36:54
Hi,
an akeeba backup would be wonderful.  :)
Title: Re: 4.0.10 does not show my categories
Post by: MikaelBjors on 03.01.2023 16:37:45
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
Title: Re: 4.0.10 does not show my categories
Post by: MikaelBjors on 03.01.2023 21:02:38
My email is mikael@xxxxx
Title: Re: 4.0.10 does not show my categories
Post by: Arno on 03.01.2023 21:54:08
Quote from: MikaelBjors on 03.01.2023 21:02:38
My email is mikael@xxxxx
I know your e-mail address.  ;)
Title: Re: 4.0.10 does not show my categories
Post by: Arno on 03.01.2023 21:55:33
Quote from: MikaelBjors on 03.01.2023 16:37:45
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

I will send you a PM.
Title: Re: 4.0.10 does not show my categories
Post by: Arno on 05.01.2023 12:07:06
Hi,
also in your case occurs your problems from a wrong position from the data field 'preview_id' in the 'templates' table.

But this seems to affect only a few users. nevertheless, i have now added a check to this effect to the update function. If this case is detected during the check, the table is corrected and the update is continued successfully.

If other irregularities are detected in the tables, these are displayed to the user and the update is then cancelled.

The new version 4.0.11 will be released later today.  :)