Update DB Topic is solved

[grezom]

Hi, so far I had DB server version 10.3, I created a copy of DB on DB server with version 10.5.

configuration.php
(I changed the data the site works)

Snímka obrazovky 2024-01-16 o 12.20.04.png

directly in the DB it tells me that I have this DB version

Snímka obrazovky 2024-01-16 o 12.20.14.png

Joomla still shows the old date

Snímka obrazovky 2024-01-16 o 12.19.37.png

What to do?

[Per Yngve Berg]

Have you checked the version of the php database client

[grezom]

Have you checked the version of the php database client

I don't understand how to do it?

[Webdongle]

live site var should not have a url in it

[leolam]

Do you run cPanel?

Leo

[grezom]

I have communicated with the hosting administrator and the database is fine. Also the connection of Joomla to the database is fine. Probably joomla is pulling information about old DB version from some cache.

I still don't know what to do to make it show the correct version. I can't update without it.

[Webdongle]

https://forumpostassistant.github.io/docs/ please

[grezom]

If you're asking about the website, here's the URL: https://www.jazykove-kurzy-nitra.sk
Here is the php info: https://www.jazykove-kurzy-nitra.sk/phpinfo.php

[Webdongle]

No
Please run the fpa https://forumpostassistant.github.io/docs/ and post the report here

[grezom]

Joomla! Instance :: Joomla! 4.4.2-Stable (Pamoja) 9-January-2024
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: true | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 60 | Session handler: database | Shared sessions: false | SSL: 2 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.4.2: Yes | Database Supports J! 4.4.2: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 5.4.0-139-generic | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 810.61 GiB |

PHP Configuration :: Version: 8.2.14 | PHP API: apache2handler | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 69 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: /nfsmnt/:/data/:/usr/php82/:/usr/bin/:/apachetmp:/tmp/:/var/tmp/:/dev/urandom:/usr/lib/x86_64-linux-gnu/ImageMagick-6.8.9/bin-Q16/:/usr/local/bin/:/etc/ssl/certs/ca-certificates.crt | Uploads: 1 | Max. Upload Size: 256M | Max. POST Size: 512M | Max. Input Time: 60 | Max. Execution Time: 600 | Memory Limit: 512M

Database Configuration :: Version: 10.3.7-MariaDB-1:10.3.7+maria~xenial-log (Client:mysqlnd 8.2.14) | Database Size: 95.94 MiB | #of Tables with config prefix:  302 | #of other Tables:  0 | User Privileges : GRANT ALL

PHP Extensions :: Core (8.2.14) | date (8.2.14) | libxml (8.2.14) | openssl (8.2.14) | pcre (8.2.14) | sqlite3 (8.2.14) | zlib (8.2.14) | bcmath (8.2.14) | bz2 (8.2.14) | calendar (8.2.14) | ctype (8.2.14) | curl (8.2.14) | dom (20031129) | enchant (8.2.14) | hash (8.2.14) | fileinfo (8.2.14) | filter (8.2.14) | ftp (8.2.14) | gd (8.2.14) | gettext (8.2.14) | gmp (8.2.14) | json (8.2.14) | iconv (8.2.14) | SPL (8.2.14) | intl (8.2.14) | session (8.2.14) | ldap (8.2.14) | mbstring (8.2.14) | standard (8.2.14) | mysqlnd (mysqlnd 8.2.14) | odbc (8.2.14) | exif (8.2.14) | mysqli (8.2.14) | PDO (8.2.14) | PDO_Firebird (8.2.14) | pdo_mysql (8.2.14) | PDO_ODBC (8.2.14) | pdo_pgsql (8.2.14) | pdo_sqlite (8.2.14) | pgsql (8.2.14) | Phar (8.2.14) | posix (8.2.14) | pspell (8.2.14) | random (8.2.14) | Reflection (8.2.14) | imap (8.2.14) | SimpleXML (8.2.14) | soap (8.2.14) | sockets (8.2.14) | tokenizer (8.2.14) | xml (8.2.14) | xmlreader (8.2.14) | xmlwriter (8.2.14) | xsl (8.2.14) | zip (1.21.1) | apache2handler (8.2.14) | apcu (5.1.22) | imagick (3.7.0) | memcache (8.2) | OAuth (2.0.8) | pdo_dblib (8.2.14) | sodium (8.2.14) | tidy (8.2.14) | uploadprogress (1.0.2) | ionCube Loader (13.0.2) | Zend OPcache (8.2.14) | Zend Engine (4.2.14) |
Potential Missing Extensions ::
Disabled Functions :: opcache_compile_file | opcache_get_configuration | opcache_invalidate | opcache_reset |

Switch User Environment :: PHP CGI: No | Server SU: No | PHP SU: No | Potential Ownership Issues: No

Apache Modules :: core | mod_so | http_core | prefork | mod_rewrite | mod_access_compat | mod_actions | mod_alias | mod_allowmethods | mod_auth_basic | mod_auth_digest | mod_auth_form | mod_authn_anon | mod_authn_core | mod_authn_dbd | mod_authn_dbm | mod_authn_file | mod_authn_socache | mod_authz_core | mod_authz_dbd | mod_authz_dbm | mod_authz_groupfile | mod_authz_host | mod_authz_owner | mod_authz_user | mod_autoindex | mod_buffer | mod_cache | mod_cache_disk | mod_cache_socache | mod_dav | mod_dav_fs | mod_dbd | mod_deflate | mod_dir | mod_dumpio | mod_env | mod_expires | mod_ext_filter | mod_fakessl | mod_file_cache | mod_filter | mod_geoip | mod_ignorepython | mod_include | mod_info | mod_lbmethod_bybusyness | mod_lbmethod_byrequests | mod_lbmethod_bytraffic | mod_lbmethod_heartbeat | mod_log_config | mod_log_debug | mod_logio | mod_macro | mod_mime | mod_negotiation | mod_php | mod_proxy | mod_proxy_ajp | mod_proxy_balancer | mod_proxy_connect | mod_proxy_express | mod_proxy_fcgi | mod_proxy_ftp | mod_proxy_http | mod_proxy_scgi | mod_proxy_wstunnel | mod_ratelimit | mod_remoteip | mod_reqtimeout | mod_request | mod_rpaf | mod_ruid | mod_sed | mod_session | mod_session_cookie | mod_session_dbd | mod_setenvif | mod_slotmem_shm | mod_socache_dbm | mod_socache_memcache | mod_socache_shmcb | mod_speling | mod_status | mod_substitute | mod_unique_id | mod_unixd | mod_userdir | mod_version | mod_vhost_alias | mod_vhost_cdb_php82 | mod_vhost_rusage | Apache |
Potential Missing Modules :: mod_ssl |

Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (---) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) | api/ (755) |

Elevated Permissions (First 10) :: images/igallery/ (777) | images/igallery/original/ (777) | images/igallery/original/1101-1200/ (777) | images/igallery/original/1401-1500/ (777) | images/igallery/original/2001-2100/ (777) | images/igallery/original/201-300/ (777) | images/igallery/original/2501-2600/ (777) | images/igallery/original/401-500/ (777) | images/igallery/original/501-600/ (777) | images/igallery/original/901-1000/ (777) |

Database statistics :: Uptime: 5562437 | Threads: 49 | Questions: 2800695007 | Slow queries: 1141 | Opens: 22240953 | Open tables: 4000 | Queries per second avg: 503.501 |

Components :: Site ::
Core ::
3rd Party::

Components :: Admin ::
Core :: com_actionlogs (3.9.0) 1 | com_users (4.0.0) 1 | com_search (4.0.0-dev) 1 | com_associations (4.0.0) 1 | com_modules (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_installer (4.0.0) 1 | com_content (4.0.0) 1 | com_fields (4.0.0) 1 | com_ajax (4.0.0) 1 | com_workflow (4.0.0) 1 | com_mails (4.0.0) 1 | com_config (4.0.0) 1 | com_cache (4.0.0) 1 | com_finder (4.0.0) 1 | com_wrapper (4.0.0) 1 | com_guidedtours (4.3.0) 1 | com_languages (4.0.0) 1 | com_login (4.0.0) 1 | com_templates (4.0.0) 1 | com_media (3.0.0) 1 | com_contenthistory (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_checkin (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_scheduler (4.1.0) 1 | com_plugins (4.0.0) 1 | com_redirect (4.0.0) 1 | com_banners (4.0.0) 1 | com_privacy (3.9.0) 1 | com_admin (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_messages (4.0.0) 1 | com_categories (4.0.0) 1 | com_menus (4.0.0) 1 | com_tags (4.0.0) 1 |
3rd Party:: jshopping (5.3.0) 1 | COM_JLSITEMAP (1.12.0) 1 | GD Image Library For Joomla (1.0 Beta Buil) ? | com_igallery (5.0.4) 1 | COM_FOXCONTACT (3.9.8) 0 | com_tagz (5.0.1 FREE) 1 | com_admintools (7.4.8) 1 | com_moreform (4.0.1) 1 | AcyMailing - JCE integration (9.1.0) 1 | AcyMailing subscription form (9.1.0) 1 | AcyMailing - Search emails in Jooml (9.1.0) ? | AcyMailing - Joomla integration (9.1.0) 1 | AcyMailing - Override Joomla emails (9.1.0) 0 | Acym (9.1.0) 1 |

Modules :: Site ::
Core :: mod_breadcrumbs (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_tags_similar (3.1.0) 1 | mod_banners (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_articles_archive (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_search (4.0.0-dev) 1 | mod_articles_categories (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_login (3.0.0) 1 |
3rd Party:: Bootstrap4Toast (1.1.0) 1 | Jshopping Cart Ext. (4.0.2) 1 | JoomShopping Recent Comments (4.0.2) ? | Jshopping top hits products (4.0.4) ? | Jshopping Manufacturers (4.0.1) ? | Ignite Gallery Module (5.0.3) 1 | MOD_YOOTHEME_BUILDER (4.2.11) 1 | Smartlook (1.0.0) 1 | GTranslate (4.0.3) 1 | AcyMailing subscription form (9.0.2) 1 | Jshopping Categories (4.0.1) 1 | Jshopping Wishlist (4.0.1) ? | Jshopping Currencies (4.0.1) ? | Jshopping Last Products (4.1.3) ? | Jshopping Search (4.1.2) ? | Jshopping Label Products (4.0.4) 1 | Jshopping Top Rating (4.0.4) ? | Jshopping Bestseller Products (4.0.3) ? |

Modules :: Admin ::
Core :: mod_popular (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_title (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_login (3.0.0) 1 | mod_privacy_status (4.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_messages (4.0.0) 1 | mod_submenu (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_guidedtours (4.3.0) 1 | mod_sampledata (3.8.0) 1 | mod_quickicon (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_version (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_post_installation_messages (4.0.0) 1 | mod_user (4.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_loginsupport (4.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_frontend (4.0.0) 1 |
3rd Party:: MOD_YOOTHEME_LINK (4.2.11) 1 |

Libraries ::
Core ::
3rd Party:: Regular Labs Library (23.9.16805) 1 |

Plugins ::
Core :: plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_eos (4.4.0) 0 | plg_quickicon_overridecheck (4.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_downloadkey (4.0.0) 1 | plg_system_redirect (3.0.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_webauthn (4.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_httpheaders (4.0.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_skipto (4.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_actionlogs (3.9.0) 0 | plg_system_cache (3.0.0) 0 | plg_system_log (3.0.0) 1 | plg_system_guidedtours (4.3.0) 1 | plg_system_task_notification (4.1) 1 | plg_system_sef (3.0.0) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_accessibility (4.0.0) 0 | plg_system_schedulerunner (4.1) 1 | plg_system_shortcut (4.2.0) 1 | plg_system_jooa11y (4.2.0) 1 | plg_system_fields (3.7.0) 1 | plg_media-action_rotate (4.0.0) 1 | plg_media-action_resize (4.0.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_multifactorauth_email (4.2.0) 1 | plg_multifactorauth_fixed (4.2.0) 0 | plg_multifactorauth_yubikey (3.2.0) 1 | plg_multifactorauth_totp (3.2.0) 1 | plg_multifactorauth_webauthn (4.2.0) 1 | plg_workflow_featuring (4.0.0) 1 | plg_workflow_notification (4.0.0) 1 | plg_workflow_publishing (4.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_webservices_templates (4.0.0) 1 | plg_webservices_newsfeeds (4.0.0) 1 | plg_webservices_plugins (4.0.0) 1 | plg_webservices_privacy (4.0.0) 1 | plg_webservices_banners (4.0.0) 1 | plg_webservices_config (4.0.0) 1 | plg_webservices_users (4.0.0) 1 | plg_webservices_menus (4.0.0) 1 | plg_webservices_redirect (4.0.0) 1 | plg_webservices_modules (4.0.0) 1 | plg_webservices_installer (4.0.0) 1 | plg_webservices_content (4.0.0) 1 | plg_webservices_media (4.1.0) 1 | plg_webservices_tags (4.0.0) 1 | plg_webservices_languages (4.0.0) 1 | plg_webservices_messages (4.0.0) 1 | plg_user_joomla (3.0.0) 1 | plg_user_token (3.9.0) 1 | plg_user_terms (3.9.0) 0 | plg_user_profile (3.0.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_behaviour_compat (4.4.0) 0 | plg_behaviour_versionable (4.0.0) 1 | plg_behaviour_taggable (4.0.0) 1 | plg_search_categories (4.0.0-dev) 1 | plg_search_content (4.0.0-dev) 1 | plg_search_newsfeeds (4.0.0-dev) 1 | plg_search_contacts (4.0.0-dev) 1 | plg_search_tags (4.0.0-dev) 1 | plg_extension_namespacemap (4.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_extension_finder (4.0.0) 1 | plg_captcha_recaptcha (3.4.0) 1 | plg_captcha_recaptcha_invisible (3.8) 1 | plg_content_fields (3.7.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_vote (3.0.0) 0 | plg_content_finder (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_installer_urlinstaller (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_override (4.0.0) 1 | plg_installer_webinstaller (4.0.0) 1 | plg_installer_folderinstaller (3.6.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_subform (4.0.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_task_check_files (4.1) 1 | plg_task_site_status (4.1) 1 | plg_task_requests (4.1) 1 | plg_task_demo_tasks (4.1) 1 | plg_sampledata_multilang (4.0.0) 1 | plg_actionlog_joomla (3.9.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_filesystem_local (4.0.0) 1 | plg_api-authentication_token (4.0.0) 1 | plg_api-authentication_basic (4.0.0) 0 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_message (3.9.0) 1 |
3rd Party:: PLG_JLSITEMAP_VIRTUEMART (1.12.0) 0 | PLG_JLSITEMAP_TAGS (1.12.0) 0 | PLG_JLSITEMAP_KUNENA (1.12.0) 0 | PLG_JLSITEMAP_CONTENT (1.12.0) 1 | PLG_JLSITEMAP_K2 (1.12.0) 0 | YOOtheme Pro builder element more F (2.3.50) ? | PLG_SYSTEM_ADMINTOOLS (7.4.8) 1 | System - YOOtheme Framework (4.2.11) 1 | YOOtheme Pro builder element more M (2.3.23) ? | PLG_SYSTEM_REGULARLABS (23.9.16805) 1 | AcyMailing - JCE integration (9.0.2) 1 | AcyMailing - Joomla integration (9.0.2) 1 | plg_system_nrframework (4.10.7) 1 | PLG_SYSTEM_JLSITEMAP_CRON (1.12.0) 1 | System - TAGZ Open Graph (5.0.1 FREE) 1 | System - Essentials YOOtheme Pro (2.1.5) 1 | AcyMailing - Override Joomla emails (9.0.2) 0 | AcyMailing - Search emails in Jooml (9.0.2) ? | plg_captcha_turnstile (1.3.0) 1 | Content - Ignite Gallery (5.0.2) 1 | Installer - moreJoomla (2.3.14) 1 | Installer - YOOtheme (1.0.7) 1 | PLG_INSTALLER_ZOOLANDERS (1.0.0) 1 | Fields - YOOtheme Location (4.2.11) 1 | PLG_ACTIONLOG_ADMINTOOLS (7.4.8) 0 | Button - Ignite Gallery (5.0) 1 | plg_editors_codemirror (5.65.15) 1 | plg_editors_tinymce (5.10.9) 1 |

Templates :: Site :: TPL_FOO (1.0) ? | YOOtheme (4.2.11) 1 | cassiopeia (1.0) 1 |
Templates :: Admin :: atum (1.0) 1 |

[grezom]

The problem has been solved. The problem was in the configuration file in the database server port.

[toivo]

Thank you for the update!

BTW, the FPA results a number of folders with elevated permissions 777, which is a security risk. Change them to 755.