Hello folks,
I set up JA multiliungual on the website, and tried.
In my current hosting provider (MariaDB 10.3.38, PHP 8.0), somehow JA multilingual creates all translated items with the column "publish_down" set at "1000-01-01" instead of "NULL". This makes all translated contents invisible and I need to modify one by one or to use phpMyAdmin.
Where can I modify in source codes to make it work right?
Thank you.
Ted
Hi Ted,
Do the original items have published time set?
You can share the URL + super admin account of your site and tell me the sample item so I can check.
saguaros
Hi saguaros,
Thank you for your help. I will make DM.
What I did for this installation are;
1) install current version of Joomla using Softaculous
2) install current version of JA Multilingual
3) add a language and make translation adaptor viable
4) make translation using the component of JA Multilingual
Now I cannot see most of translations, although they were created in my database with publish_down on 1000-01-01.
You can try this tweak:
1/ Backup your site
2/ Remove translated items
3/ Install this package:
and translate again.
Dear saguaros,
Thank you for your quick tweak. It works! (as publish down 1000 years later)
It might be a different issue, but translated items will not appear on the list of articles and I cannot see them in the frontend. This could be caused by another issue, which might have been reported in this area before. (After I install Flexicontent cck, the articles disappeared can be editable.)
When the menus are translated, they are not editable, and the Joomla routing is not working for them. Although the publish_down problem is fixed now, the menus are still not working. When I try to edit the translated menu, the appearance is broken and an error appears.
I recently avoid this issue by tweaking the code to skip translating menus (and categories).
Thank you! Your tweak works for the primary issue I consulted here.
Ted
Hi Ted,
That error relates to PHP 8.2 compatibility issue, but as I can see that it notices error from core file of Joomla.
Could you switch to PHP 8.1 or 8.0 and see how it goes?
Hi saguaros,
I tried new translations using PHP 8.1 (to BG-bg) and PHP 8.0 (to NL-nl), but the errors do not stop.
PHP database extensions for PHP 8.1 are mysqli, mysqlnd, nd_pdo_mysql, and for PHP 8.0 are mysqli.
Thank you!
Ted
HI Ted,
I tested with PHP 8.1 at my end with the package I sent above but there is not error message like that.
You can go to Global configuration in backend >> enable Debug mode and set Error Reporting to Maximum, it will show the error in details and you will know which files/extensions have issue.
Regards
saguaros
Dear saguaros,
I did not specify where the erorrs were shown. They were after the Metatag heading.
Here are the messages from the system:
1 () JROOT/layouts/joomla/form/field/textarea.php:89
2 htmlspecialchars() JROOT/layouts/joomla/form/field/textarea.php:89
3 include() JROOT/libraries/src/Layout/FileLayout.php:128
4 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Form/Field/TextareaField.php:164
5 Joomla\CMS\Form\Field\TextareaField->getInput() JROOT/libraries/src/Form/FormField.php:1029
6 Joomla\CMS\Form\FormField->renderField() JROOT/layouts/joomla/edit/fieldset.php:43
7 include() JROOT/libraries/src/Layout/FileLayout.php:128
8 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:76
9 Joomla\CMS\Layout\LayoutHelper::render() JROOT/layouts/joomla/edit/params.php:170
10 include() JROOT/libraries/src/Layout/FileLayout.php:128
11 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:76
12 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_menus/tmpl/item/edit.php:140
13 include() JROOT/libraries/src/MVC/View/HtmlView.php:410
14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:203
15 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_menus/src/View/Item/HtmlView.php:116
16 Joomla\Component\Menus\Administrator\View\Item\HtmlView->display() JROOT/libraries/src/MVC/Controller/BaseController.php:645
17 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_menus/src/Controller/DisplayController.php:73
18 Joomla\Component\Menus\Administrator\Controller\DisplayController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:678
19 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/libraries/src/Dispatcher/ComponentDispatcher.php:143
20 Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361
21 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143
22 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186
23 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293
24 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61
25 require_once() JROOT/administrator/index.php:32
I guess another guy had reported the same error after my post, although he/she uses Joomla 3.10.
Thank you.
Best regards,
Ted
It reports error from core file of Joomla, not our extension: JROOT/layouts/joomla/form/field/textarea.php
How can I replicate the same error on your site?
saguaros
Hi sauaros,
I am not sure it occurs in your situation, but in my case,
1) automatically created articles are not listed in "Articles"
2) automatically created menus are broken.
The original menu is shown like this:
When I open the translated menu, it is shown like this:
The usual site top bar and the save bar are gone, and tabs are broken. And Metadata has a htmlspecialchars error.
Thank you.
Ted
I tried to run the translation in a Joomla fresh website with German and it worked properly:
You can try switch to older PHP version instead of v8.2 and disable 3rd party extensions on your site as it may cause conflict.
Otherwise, there must be something wrong with Joomla on your site.
I first tried with PHP 8.0, not with PHP 8.2.
Today I made another installation of Joomla 4.3.1 with PHP 8.0 / MariaDB 10.3.38.
And I found the same error on my new website.
Probably the error comes from the difference between MySQL and MariaDB, and their versions.
I can switch PHP versions, but cannot switch database driver with my hosting server,
saguaros
Oops. To restart the website, I had deleted everything.
I will set up another one using JA Multilingual and send you the credential.
Since I recently use PHP 8.2 in live websites and settings are applied to all of websites on the server, I might use another temporary server for this.
