No Layouts available after upgrade - [Fixed in 4.0.11]

[Stephan]

I upgraded from Joomla 3.10.11 to 4.2.6. Installed jDownloads Version Beta 4.0.6. Server PHP version 8.0.

When checking Components / jDownloads / Layouts, there are no layouts available. Not even the default layouts. Should the default layouts not be listed in this Beta version?
Attached Screenshots: Joomla 3 jDownloads Layouts UI vs Joomla 4 jDownloads 4.0.6 Layouts UI.

I tried importing a default layout but it gives an error: 0 syntax error, unexpected token "<", expecting end of file. (Attached image)

Find attached an export of updated jDownloads options: Universal _options__jD_v4.0.6_pre_beta_date_2022-12-20_06-22-04.txt

PS: I do have template overrides for com_jdownloads, but they don't affect this case of missing layout files.

[Arno]

Hi,
nobody else has posted a problem like this after the upgrade to jD 4.
It is possible to get access data via PM to this backend?

Could you check what is stored in the jdownloads_template DB table?
Had you see the succesful jDownloads upgrade message at the end from the upgrade process?

[Arno]

Hi,
thanks for the access data.

I have see this in your jDownloads upgrade log:

2022-12-19 13:53:06 INFO Upgrade: Delete all old folders, files and extensions.
2022-12-19 13:53:07 INFO Upgrade: The existing data of the database tables are transferred to new tables with changed data definitions.
2022-12-19 13:53:07 INFO Incorrect integer value: '*' for column `dev_universalcoal`.`swlzb_jdownloads_templates_40x`.`checked_out` at row 1
2022-12-19 13:53:12 INFO Upgrade: Convert now fields with old datetime values '0000-00-00 00:00:00' to 'NULL'.
2022-12-19 13:53:12 INFO Upgrade: DB table fields update finished!

So as result, the old data was not copied to the new templates database. And the backup tables were therefore not deleted either.
I will check tonight what could be the cause of this error message.

[Arno]

Please check your old template table. The definitions for checked_out_time and his values.
Could be here a '*'? Normally should be this impossible.

And your:
Memory limit (memory_limit):   96M
could be more. Maybe 256MB?

[thilo2621]

Just did an upgrade on a joomla3 (latest version) with the latest version op jdownload 4.0.8 - everything went quiet smooth, only one error message:
Incorrect integer value: '*' for column '[name-of-site].[name-of-db_jdownloads_templates_40x'.'checked_out' at row 1
Result : no layouts to choose from and the menu give me this message: No valid layout found for Categories!
A reinstall does not help

[thilo2621]

Ok - just read the post from Stephan - seams to be the same problem

[thilo2621]

I noticed a "*" in Filed "language" - is that the problem? Should I replace it with a "0"?

[Arno]

Yes, is the same problem.
Have you a lot of log data sets? Stephan had more as 300.000 so maybe could this be the reason (timeout?)

But I will later check again this part from the upgrade process.

Edit:
I see that you have also an old database backup table from 3.2.69. This ist the same also at Stephan. Maybe could also this be the reason?

You could try this:
- You restore the old status from before the upgrade with the help of your backup
- Delete the old 3_2_69 tables
- Start the upgrade again

[thilo2621]

Total Number of listed Logged Actions: 45850
The files from the download area have been downloaded 105.598 times.
Categories: 245
Downloads: 3046

that's for the statistics - will now try to recover my backup and delete the old table before updating

[thilo2621]

did as you suggested - that did not helped - same as before:
Incorrect integer value: '*' for column `intranet03`.`intr1_jdownloads_templates_40x`.`checked_out` at row 1

[Arno]

Okay, thanks for the test.
Seems not to be so easy. 

I'll get back to you shortly, after further attempts with the upgrade. As long as I can't reproduce the error, it remains difficult to solve.

[thilo2621]

Ok thanks for your time - can I meanwhile somehow import the layouts?

[svherpen]

I think I have the same problem, see my recent topic.

[Arno]

Hm, strange. The problem seems only to exist when we will upgrade from a 3.9 version.
I will try to find the reason. 

[Arno]

See here:
https://www.jdownloads.com/forum/index.php?topic=13826.msg49127#msg49127