MAC OS 15.6.1
MAMP PRO 7.2.11
Joomla! 6
PhP 8.4.1
MySQL 8 (8.0.40 for macos12.7 on arm64)
If I try to modify one of the jux_timeline_pro modules using the Joomla! admin interface, it fails. The module does not check in on "Save" or "Save and Close". Reopening the module shows the change was not saved.
If I alter the SQL directly (in the video I use phpMyAdmin5), that change shows up in the module component in the Joomla! admin.
Evidently there is something going on here, but I am not getting any errors displayed for this.
I turned on debug and error reporting to maximum, but all I am seeing in the browser are the warnings about
```
Warning
: Undefined property: stdClass::$autostart in
/Applications/MAMP/htdocs/joomla6/plugins/system/guidedtours/src/Extension/GuidedTours.php
on line
199
```
I fished around for other logs in the installation. The only ones that look relevant are the php_error logs in the MAMP log directory. Have a look ...
Hi.
Thank you for the video.
As I see, you also changed the params field data type to longtext. I think the issue is when you have a lot of timeline data. Can you tell me your timeline data? You can try when reducing the timeline data.
Regards.
OK, I confirmed that the module updates fine when I create a new module with only a small amount of data.
I gather that the query you issue uses 'text' or some predefined varchar length? What should the datatype be?
It is odd, though, because I did nothing specific to modify the database table schema, which is indeed longtext.
All I did was copy the old params json from my original installation into an editor (to be precise, only the timeline_items), make sure it was valid, and then insert it into the params json for the module.
It would be much more convenient if you could support longtext or blob types. But if this is not something you can or wish to do, then I will just live with modifying the modules through myPhpAdmin or direct sql operations, because breaking up any further would make it all very cumbersome (as you can see, I already have 9 modules, which originally I must have split up because of similar data constraints). Currently, with the modules at the size they are, I see no real performance degradation on read ... the page/menu item loads them all in a blink without issue.
The default of the type of the field name "Params" is Text. Maybe it has changed when you import the data.
prnt.sc/Qmq_a7GgEcTm
When the module have a lot data, it will can't save to the params. We can't control the way data to store in the #_modules table. It is default of the Joomla core.