Smart Search submenu item missing after upgrade

[deathbat87]

Hi,

After upgrade from Joomla 3 to Joomla 4, my smart search submenu items are missing from the menu.

Any guide to get it back?

Thanks.

[ceford]

Try this in phpMyAdmin SQL form:

Code: Select all

SELECT * FROM `xxxxx_menu` WHERE `link` like '%com_finder%'; 

where xxxxx is your own table prefix. You should see 5 rows and published should be 1 in each case. What do you see?

[deathbat87]

Only these 2 items. The rest of com_finder_xxxx are missing.

[ceford]

Looks like the update did not go to completion. Please run the Forum Post Assistant and post the public results here. Also open administrator/logs/joomla_update.php with a text editor and scroll down to the bottom. You should see several hundred sql queries followed by some completions messages. What do you actually see?

[deathbat87]

Here is the log from joomla update.

Here is the FPA

[ceford]

Your fpa report looks good and your update looks good. Next step is to figure out why the menu items are missing.

Try this in phpMyAdmin:

Code: Select all

SELECT * FROM `xxxxx_menu` WHERE id IN (13,18,19,20,21)

Just report what is in the title column.

PS: Please avoid links to text files. The FPA report is formatted to make it easy to read when pasted directly into the Forum issue form.

[nacc]

The FPA report does not “look good”!

[deathbat87]

Your fpa report looks good and your update looks good. Next step is to figure out why the menu items are missing.

Try this in phpMyAdmin:

Code: Select all

SELECT * FROM `xxxxx_menu` WHERE id IN (13,18,19,20,21)

Just report what is in the title column.

PS: Please avoid links to text files. The FPA report is formatted to make it easy to read when pasted directly into the Forum issue form.

Here the result from db.

[ceford]

As the FPA report came as a file I only looked at the upload and post sizes and the memory limit. So...

So livesite is not empty - it should be. Open configuration.php with a text editor (first set permissions to 644) and set it to an empty string.

Joomla! Instance :: Joomla! 4.3.4-Stable (Bora) 22-August-2023
Joomla! Configured :: Yes | Writable (644) |
Configuration Options :: Offline: true | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: Is Not Empty | Session lifetime: 45 | Session handler: database | Shared sessions: false | SSL: 2 | Error Reporting: maximum | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.3.4: Yes | Database Supports J! 4.3.4: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.10.0-714.10.2.lve1.5.17.el6h.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 138.11 GiB |

PHP Configuration :: Version: 8.1.21 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 22519 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 360M | Max. POST Size: 380M | Max. Input Time: 60 | Max. Execution Time: 660 | Memory Limit: 512M

Database Configuration :: Version: 5.7.38-cll-lve (Client:mysqlnd 8.1.21) | Database Size: 442.91 MiB | #of Tables with config prefix:  215 | #of other Tables:  78 | User Privileges : GRANT ALL

PHP Extensions :: Core (8.1.21) | date (8.1.21) | libxml (8.1.21) | openssl (8.1.21) | pcre (8.1.21) | sqlite3 (8.1.21) | zlib (8.1.21) | bz2 (8.1.21) | calendar (8.1.21) | ctype (8.1.21) | curl (8.1.21) | hash (8.1.21) | filter (8.1.21) | ftp (8.1.21) | gettext (8.1.21) | json (8.1.21) | iconv (8.1.21) | SPL (8.1.21) | pcntl (8.1.21) | readline (8.1.21) | Reflection (8.1.21) | session (8.1.21) | standard (8.1.21) | mbstring (8.1.21) | shmop (8.1.21) | SimpleXML (8.1.21) | tokenizer (8.1.21) | xml (8.1.21) | cgi-fcgi (8.1.21) | bcmath (8.1.21) | dba (8.1.21) | dom (20031129) | fileinfo (8.1.21) | gd (8.1.21) | igbinary (3.2.6) | imagick (3.7.0) | imap (8.1.21) | intl (8.1.21) | ldap (8.1.21) | exif (8.1.21) | memcached (3.1.5) | mysqlnd (mysqlnd 8.1.21) | mysqli (8.1.21) | PDO (8.1.21) | pdo_mysql (8.1.21) | odbc (8.1.21) | pdo_dblib (8.1.21) | PDO_ODBC (8.1.21) | pdo_pgsql (8.1.21) | pdo_sqlite (8.1.21) | pgsql (8.1.21) | Phar (8.1.21) | snmp (8.1.21) | soap (8.1.21) | sockets (8.1.21) | tidy (8.1.21) | timezonedb (2021.5) | xmlreader (8.1.21) | xmlwriter (8.1.21) | xsl (8.1.21) | zip (1.19.5) | ionCube Loader (12.0.5) | Zend OPcache (8.1.21) | Zend Engine (4.1.21) |
Potential Missing Extensions ::
Disabled Functions :: socket_create | socket_connect | show_source | enable_dl | dl | memory_limit | socket_accept | socket_bind | socket_close | socket_create_listen | socket_create_pair | socket_listen | socket_recv | socket_recvfrom | socket_select | socket_send | socket_sendto | socket_shutdown |

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

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) ::

Database statistics :: Uptime: 14653990 | Threads: 17 | Questions: 24991820077 | Slow queries: 0 | Opens: 659655278 | Flush tables: 1 | Open tables: 2000 | Queries per second avg: 1705.461 |

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

Components :: Admin ::
Core :: com_scheduler (4.1.0) 1 | com_tags (4.0.0) 1 | com_languages (4.0.0) 1 | com_modules (4.0.0) 1 | com_associations (4.0.0) 1 | com_templates (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_content (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_installer (4.0.0) 1 | com_checkin (4.0.0) 1 | com_search (3.0.0) 1 | com_wrapper (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_redirect (4.0.0) 1 | com_actionlogs (3.9.0) 1 | com_guidedtours (4.3.0) 1 | com_finder (4.0.0) 1 | com_menus (4.0.0) 1 | com_workflow (4.0.0) 1 | com_users (4.0.0) 1 | com_mails (4.0.0) 1 | com_messages (4.0.0) 1 | com_admin (4.0.0) 1 | com_privacy (3.9.0) 1 | com_postinstall (4.0.0) 1 | com_fields (4.0.0) 1 | com_ajax (4.0.0) 1 | com_cache (4.0.0) 1 | com_categories (4.0.0) 1 | com_login (4.0.0) 1 | com_config (4.0.0) 1 | com_banners (4.0.0) 1 | com_plugins (4.0.0) 1 | com_contenthistory (4.0.0) 1 | com_media (3.0.0) 1 |
3rd Party:: AcyChecker (1.2.9) 0 | Admintools (6.1.11) 0 | HikaShop (4.7.5) 0 | com_uniterevolution2 (5.0.17) 0 | OneAll Social Login (5.6.0) ? | COM_RSTBOX (6.1.1) 0 | Akeeba (8.3.3) 0 | Acym (8.7.3) 0 | GSD (1.0) 0 | COM_CONVERTFORMS (4.2.1) 0 |

Modules :: Site ::
Core :: mod_menu (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_search (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_login (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_tags_similar (3.1.0) 1 | mod_banners (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_footer (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_related_items (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_articles_news_adv (1.4.5) 1 | mod_breadcrumbs (3.0.0) 1 | mod_feed (3.0.0) 1 |
3rd Party:: Hikashop Cart Module (4.7.5) ? | POWr Social Feed (3.0) 0 | MOD_TAGS_DROPDOWN (1.5) 1 | OneAll Social Login (2.1) ? | mod_convertforms (1.0) 0 | Hikashop Wishlist Module (4.7.5) ? | mod_emcevents_articles (1.0.0) 1 | Hikashop Filtering Module (4.7.5) ? | SP Simple [youtube] (1.7) 1 | InstAholic Plus (1.0.3) ? | Tags - Filter (1.0.3) 1 | Unite Slider 2 (4.7) 0 | Hikashop Currency Switcher Module (4.7.5) ? | Hikashop Module (4.7.5) ? | AcyMailing subscription form (8.7.3) 0 |

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

Libraries ::
Core ::
3rd Party:: file_fof30 (3.6.2) ? | file_fof40 (4.1.0) ? |

Plugins ::
Core :: plg_actionlog_joomla (3.9.0) 1 | plg_media-action_rotate (4.0.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_media-action_resize (4.0.0) 1 | plg_installer_urlinstaller (3.6.0) 1 | plg_installer_webinstaller (4.0.0) 1 | plg_installer_override (4.0.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_folderinstaller (3.6.0) 1 | plg_system_log (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_stats (3.5.0) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_shortcut (4.2.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_accessibility (4.0.0) 0 | plg_system_task_notification (4.1) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_highlight (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_actionlogs (3.9.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_redirect (3.0.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_logout (3.0.0) 1 | plg_system_httpheaders (4.0.0) 0 | plg_system_guidedtours (4.3.0) 1 | plg_system_jooa11y (4.2.0) 1 | plg_system_webauthn (4.0.0) 1 | plg_system_skipto (4.0.0) 1 | plg_system_schedulerunner (4.1) 1 | plg_webservices_menus (4.0.0) 1 | plg_webservices_installer (4.0.0) 1 | plg_webservices_modules (4.0.0) 1 | plg_webservices_languages (4.0.0) 1 | plg_webservices_messages (4.0.0) 1 | plg_webservices_banners (4.0.0) 1 | plg_webservices_config (4.0.0) 1 | plg_webservices_tags (4.0.0) 1 | plg_webservices_newsfeeds (4.0.0) 1 | plg_webservices_templates (4.0.0) 1 | plg_webservices_redirect (4.0.0) 1 | plg_webservices_privacy (4.0.0) 1 | plg_webservices_content (4.0.0) 1 | plg_webservices_media (4.1.0) 1 | plg_webservices_plugins (4.0.0) 1 | plg_webservices_users (4.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_image (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_multifactorauth_totp (3.2.0) 0 | plg_multifactorauth_email (4.2.0) 0 | plg_multifactorauth_fixed (4.2.0) 0 | plg_multifactorauth_webauthn (4.2.0) 0 | plg_multifactorauth_yubikey (3.2.0) 0 | plg_fields_calendar (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_subform (4.0.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_extension_namespacemap (4.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_extension_finder (4.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_message (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_pagebreak (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_vote (3.0.0) 0 | plg_content_emailcloak (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_finder (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_sampledata_multilang (4.0.0) 1 | plg_captcha_recaptcha_invisible (3. 0 | plg_captcha_recaptcha (3.4.0) 1 | plg_task_check_files (4.1) 1 | plg_task_demo_tasks (4.1) 1 | plg_task_requests (4.1) 1 | plg_task_site_status (4.1) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_profile (3.0.0) 0 | plg_user_terms (3.9.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_token (3.9.0) 1 | plg_api-authentication_basic (4.0.0) 0 | plg_api-authentication_token (4.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 0 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_downloadkey (4.0.0) 1 | plg_quickicon_overridecheck (4.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_categories (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_workflow_publishing (4.0.0) 1 | plg_workflow_notification (4.0.0) 1 | plg_workflow_featuring (4.0.0) 1 | plg_behaviour_versionable (4.0.0) 1 | plg_behaviour_taggable (4.0.0) 1 | plg_filesystem_local (4.0.0) 1 |
3rd Party:: PLG_ACTIONLOG_ADMINTOOLS (6.1.11) 0 | PLG_ACTIONLOG_AKEEBABACKUP (8.3.3) 0 | PLG_INSTALLER_ADMINTOOLS (6.1.11) 0 | PLG_INSTALLER_AKEEBABACKUP (8.3.3) 0 | PLG_SYSTEM_BACKUPONUPDATE (8.3.3) 0 | PLG_SYSTEM_ADMINTOOLS (6.1.11) 0 | AcyMailing - Joomla integration (8.7.3) 0 | plg_system_gsd (5.3.2) 0 | Hikashop no SSL outside checkout Pl (4.7.5) ? | Hikashop - Redshop Fallback Redirec (4.7.5) ? | PLG_SYSTEM_RSTBOX (3.0) 0 | System - HikaShop Mass Action (4.7.5) ? | Hikashop - VirtueMart Fallback Redi (4.7.5) ? | System - Joomla integration for Acy (1.2.9) ? | Hikashop Geolocation Plugin (4.7.5) ? | Hikashop Google Analytics Plugin (4.7.5) ? | PLG_SYSTEM_AKVERSIONCHECK (8.3.3) 0 | Hikashop Product Tag (4.7.5) ? | HikaShop Google Dynamic Remarketing (4.7.5) ? | System - Optimize Your Tables (1.2) 0 | System - Hikashop Social Plugin (4.7.5) ? | Hikashop Registration Redirect Plug (4.7.5) ? | HikaShop Payment Notification plugi (4.7.5) ? | HikaShopCustom Price plugin (4.7.5) ? | System - HikaShop Affiliate (4.7.5) ? | PLG_SYS_MOOTABLE (1.1.3) 0 | System - OneAll Social Login (2.1) 0 | AcyMailing - Override Joomla emails (8.7.3) 0 | HikaShop Product TAG translation (4.7.5) ? | PLG_SYSTEM_CONVERTFORMS (1.0) 0 | Hikashop - Mijoshop Fallback Redire (4.7.5) ? | User - HikaShop (4.7.5) ? | PLG_SYSTEM_CFUPLOADEDFILESCLEANER (1.0) 0 | HikaShop ReCaptcha v2 ({__PLUGIN_VER) 0 | ShipStation plugin ({__PLUGIN_VER) 0 | PLG_ENGAGEBOX_EMAILFORM (1.0) 0 | PLG_ENGAGEBOX_MODULE (1.0) 0 | PLG_ENGAGEBOX_IMAGE (1.0) 0 | PLG_ENGAGEBOX_SMARTTAGS (1.0) 0 | PLG_ENGAGEBOX_YESNO (1.0) 0 | PLG_ENGAGEBOX_SOCIAL (1.0) 0 | PLG_ENGAGEBOX_CUSTOM (1.0) 0 | PLG_ENGAGEBOX_IFRAME (1.0) 0 | PLG_ENGAGEBOX_ACTIONS (1.0) 0 | PLG_ENGAGEBOX_PHPSCRIPTS (1.0) 0 | Hikashop Google Products Plugin (4.7.5) 0 | Hikashop Massaction Category Plugin (4.7.5) 0 | HikaShop Address Auto fill plugin (1.0.0) 0 | Hikashop User account Plugin (4.7.5) ? | Hikashop Email History Plugin (4.7.5) 0 | Hikashop Massaction Address Plugin (4.7.5) 0 | Hikashop TaxCloud Plugin (1.2.3) 0 | Hikashop out of order notification (4.7.5) ? | Hikashop Massaction Order Plugin (4.7.5) 0 | Hikashop UserPoints Plugin (4.7.5) ? | Hikashop History Plugin (4.7.5) ? | Hikashop Group Plugin (4.7.5) ? | Hikashop Currency Rates Plugin (4.7.5) ? | HikaShop: Date Picker Custom Field (4.7.5) ? | Hikashop Cart notification Plugin (4.7.5) ? | Hikashop AcyMailing Plugin (4.7.5) ? | Hikashop Content Parser - Markdown (4.7.5) ? | Hikashop - Product Cron Update (4.7.5) ? | HikaShop Shipping Manual - Price pe (4.7.5) ? | Hikashop Orders Automatic Cancel Pl (4.7.5) ? | Hikashop WaitList notification Plug (4.7.5) ? | Hikashop - Kashflow invoice synchro (4.7.5) ? | Hikashop Validate free order Plugin (4.7.5) ? | Hikashop Massaction Product Plugin (4.7.5) 0 | Hikashop Massaction User Plugin (4.7.5) 0 | Hikashop Shop Close Hours Plugin (4.7.5) ? | plg_authentication_socialnetworks (1.1.3) 0 | PLG_GSD_MENUS (1.0) 0 | PLG_GSD_DJCATALOG2 (1.0) 0 | PLG_GSD_RSBLOG (1.0) 0 | PLG_GSD_J2STORE (1.0) 0 | PLG_GSD_HIKASHOP (1.0) 0 | PLG_GSD_SOBIPRO (1.0) 0 | PLG_GSD_JBUSINESSDIRECTORY (1.0) 0 | PLG_GSD_DJCLASSIFIEDS (1.0) 0 | PLG_GSD_QUIX (1.0) 0 | PLG_GSD_K2 (1.0) 0 | PLG_GSD_ESHOP (1.0) 0 | PLG_GSD_CONTENT (1.0) 0 | PLG_GSD_JEVENTS (1.0) 0 | PLG_GSD_JCALPRO (1.0) 0 | PLG_GSD_EVENTBOOKING (1.0) 0 | PLG_GSD_SPPAGEBUILDER (1.0) 0 | PLG_GSD_GRIDBOX (1.0) 0 | PLG_GSD_ZOO (1.0) 0 | PLG_GSD_EASYBLOG (1.0) 0 | PLG_GSD_DJEVENTS (1.0) 0 | PLG_GSD_VIRTUEMART (1.0) 0 | PLG_GSD_JSHOPPING (1.0) 0 | PLG_CONVERTFORMSAPPS_WEBHOOKS (1.0) 0 | PLG_CONVERTFORMSAPPS_EMAIL (1.0) 0 | PLG_CONVERTFORMSAPPS_USERACCOUNT (1.0) 0 | PLG_CONVERTFORMSAPPS_HUBSPOT (1.0) 0 | PLG_CONVERTFORMSAPPS_CONTENT (1.0) 0 | PLG_CONVERTFORMSAPPS_ACYMAILING (1.0) 0 | PLG_CONVERTFORMSAPPS_PHP (1.0) 0 | PLG_CONVERTFORMSAPPS_GETRESPONSE (1.0) 0 | PLG_CONVERTFORMSAPPS_MAILCHIMP (1.0) 0 | PLG_CONVERTFORMSTOOLS_CONDITIONALLO (1.0) ? | PLG_CONVERTFORMSTOOLS_PDF (1.0) 0 | PLG_CONVERTFORMSTOOLS_EXPORTSUBMISS (1.0) ? | PLG_CONVERTFORMSTOOLS_GATRACKER (1.0) 0 | PLG_CONVERTFORMSTOOLS_TASKS (1.0) 0 | PLG_CONVERTFORMSTOOLS_CALCULATIONS (1.0) 0 | PLG_EDITORS-XTD_ENGAGEBOX (1.0) 0 | POWr Icon (1.0) 0 | HikaShop Product TAG insertion (4.7.5) ? | PLG_EDITORS-XTD_CONVERTFORMS (1.0) 0 | Button - pdfviewer (1.3.0) 1 | plg_editors_tinymce (5.10.7) 1 | plg_editors_codemirror (5.65.12) 1 | Hikashop USPS Shipping Plugin (4.7.5) ? | Hikashop Australia Post eDeliver Sh (4.3.0) ? | Hikashop Manual Shipping Plugin (4.7.5) ? | Hikashop CANADA POST Shipping Plugi (4.3.0) ? | Hikashop CANPAR Shipping Plugin (1.0.0) ? | Hikashop FedEx Shipping Plugin (4.7.5) ? | Hikashop UPS Shipping Plugin (4.7.5) ? | Hikashop Australia Post eDeliver Sh (4.7.5) ? | plg_content_emcevents (1.0.0) 0 | POWr Shortcodes (3.0) 0 | pdfviewer (1.2.4) 1 | AcyMailing Tag : HikaShop content (4.7.5) ? | Hikashop CyberMuth CIC Payment Plug (4.7.5) ? | Hikashop Nets NETAXEPT Payment Plug (4.7.5) ? | Hikashop ePay Payment Plugin (4.7.5) ? | Hikashop Moneybookers Payment Plugi (4.7.5) ? | Hikashop Servired Payment Plugin (4.7.5) ? | Hikashop Paybox Plugin (4.7.5) ? | Hikashop Credit Card Payment Plugin (4.7.5) ? | Hikashop PayU India Payment Plugin (4.7.5) ? | Hikashop westpacapi Payment Plugin (1.0) ? | Hikashop SIPS ATOS Payment Plugin (4.7.5) ? | Hikashop Paypal Pro Payment Plugin (4.7.5) ? | Hikashop Monetico Payment Plugin (4.7.5) ? | Hikashop PayPlug payment plugin (4.7.5) ? | Hikashop Common Joomla Payment API (4.7.5) ? | Hikashop iPayDNA Payment Plugin (4.7.5) ? | Hikashop eSelect Payment Plugin (4.7.5) ? | Hikashop PaymentExpress (PxPay) Plu (4.7.5) ? | Hikashop UserPoints Payment Plugin (4.7.5) ? | Hikashop Borgun payment plugin (4.7.5) ? | Hikashop Payment Express Payment Pl (4.7.5) ? | Hikashop Paygate Payment Plugin (4.7.5) ? | Hikashop HSBC Payment Plugin (4.7.5) ? | Hikashop Collect On Delivery Paymen (4.7.5) ? | Hikashop FirstData Payment Plugin (4.7.5) ? | Hikashop PayJunction Payment Plugin (4.7.5) ? | Hikashop Bluepaid Payment Plugin (4.7.5) ? | Hikashop Check Payment Plugin (4.7.5) ? | Hikashop Paypal Checkout Payment (1.0.0) ? | Hikashop iVeri Payment Plugin (4.7.5) ? | Ogone Payment Plugin (4.7.5) ? | Hikashop Paypal Website Payments Pr (4.7.5) ? | Hikashop Purchase Order Payment Plu (4.7.5) ? | Hikashop Paypal Express Checkout Pa (4.7.5) ? | Hikashop googlewallet Payment Plugi (1.0) ? | Hikashop Bank Transfer Payment Plug (4.7.5) ? | Hikashop Beanstream Payment Plugin (4.7.5) ? | Hikashop CardSave Payment Plugin (4.7.5) ? | Hikashop Paypal (legacy) Payment Pl (4.7.5) ? | Hikashop eWAY Payment Plugin (4.7.5) ? | Hikashop Western Union Payment Plug (4.7.5) ? | Hikashop Alipay Payment Plugin (4.7.5) ? | Hikashop Payza Payment Plugin (4.7.5) ? | Hikashop payfast Payment Plugin (4.5.1) ? | Hikashop Be2Bill Payment Plugin (4.7.5) ? | Hikashop Postfinance Payment Plugin (4.7.5) ? | Hikashop WorldNetTPS Payment Plugin (4.7.5) ? | Hikashop Paypal Advanced payment pl (4.7.5) ? | Hikashop Virtual Merchant (Elavon) (4.7.5) ? | Hikashop Google Checkout Payment Pl (4.4.0) ? | Hikashop ATOS SIPS 2.0 Payment Plug (4.7.5) ? | Hikashop MasterCard Internet Gatewa (4.7.5) ? | Hikashop Authorize.net Payment Plug (4.7.5) ? | Hikashop PayPlug v2 payment plugin (4.7.5) ? | PLG_CONVERTFORMS_EMAILS (1.0) 0 | PLG_CONVERTFORMS_DRIP (1.0) 0 | PLG_CONVERTFORMS_HUBSPOT (1.0) 0 | PLG_CONVERTFORMS_ACTIVECAMPAIGN (1.0) 0 | PLG_CONVERTFORMS_CAMPAIGNMONITOR (1.0) 0 | PLG_CONVERTFORMS_ELASTICEMAIL (1.0) 0 | PLG_CONVERTFORMS_ACYMAILING (1.0) 0 | PLG_CONVERTFORMS_SENDINBLUE (1.0) 0 | PLG_CONVERTFORMS_ICONTACT (1.0) 0 | PLG_CONVERTFORMS_AWEBER (1.0) 0 | PLG_CONVERTFORMS_CONVERTKIT (1.0) 0 | PLG_CONVERTFORMS_GETRESPONSE (1.0) 0 | PLG_CONVERTFORMS_ZOHOCRM (1.0) 0 | PLG_CONVERTFORMS_ZOHO (1.0) 0 | PLG_CONVERTFORMS_SALESFORCE (1.0) 0 | PLG_CONVERTFORMS_MAILCHIMP (1.0) 0 | PLG_CONVERTFORMS_ERRORLOGGER (1.0) 0 | plg_user_socialnetworks (1.1.3) 0 | Search - Hikashop Categories/Manufa (4.7.5) ? | AcyMailing - Search emails in Jooml (8.7.3) ? | Search - Hikashop Products (4.7.5) ? | HikaShop Quick Icon (4.7.5) ? | plg_quickicon_akeebabackup (8.3.3) 0 | Smart Search - HikaShop Products (4.7.5) 0 |

Templates :: Site :: cassiopeia (1.0) 1 |
Templates :: Admin :: atum (1.0) 1 |

[deathbat87]

The site won't be loading if set empty the configuration file. May i know the reason to do that? And what i need to run after set the configuration file empty?

[ceford]

You misunderstood - it is the $live_site variable in configuration.php that should be empty"

public $live_site = '';

[deathbat87]

Ok set the live site to empty variable. Nothing different on the site i see. Or i need to run FPA again sir?

[ceford]

No need to run the FPA again. I need to think!

[ceford]

Please try this one:

SELECT * FROM `xxxxx_extensions` WHERE `name` = 'com_finder';

[deathbat87]

Please try this one:

SELECT * FROM `xxxxx_extensions` WHERE `name` = 'com_finder';

Here the result from sql.

[ceford]

Make a backup copy of your xxxx_menu table and then try this:

Code: Select all

INSERT INTO `#__menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`)
SELECT 'main', 'com_finder_index', 'Smart-Search-Index', '', 'Smart Search/Index', 'index.php?option=com_finder&view=index', 'component', 1, 18, 2, `extension_id`, 0, 0, 'class:finder', 0, '', 30, 31, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_finder';
INSERT INTO `#__menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`)
SELECT 'main', 'com_finder_maps', 'Smart-Search-Maps', '', 'Smart Search/Maps', 'index.php?option=com_finder&view=maps', 'component', 1, 18, 2, `extension_id`, 0, 0, 'class:finder-maps', 0, '', 32, 33, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_finder';
INSERT INTO `#__menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`)
SELECT 'main', 'com_finder_filters', 'Smart-Search-Filters', '', 'Smart Search/Filters', 'index.php?option=com_finder&view=filters', 'component', 1, 18, 2, `extension_id`, 0, 0, 'class:finder-filters', 0, '', 34, 35, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_finder';
INSERT INTO `#__menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`)
SELECT 'main', 'com_finder_searches', 'Smart-Search-Searches', '', 'Smart Search/Searches', 'index.php?option=com_finder&view=searches', 'component', 1, 18, 2, `extension_id`, 0, 0, 'class:finder-searches', 0, '', 36, 37, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_finder';

Change all of the instances of #__ to xxxxx_ where xxxxx is your table prefix.

Actually, I doubt whether this will work!

[deathbat87]

Make a backup copy of your xxxx_menu table and then try this:

Code: Select all

INSERT INTO `#__menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`)
SELECT 'main', 'com_finder_index', 'Smart-Search-Index', '', 'Smart Search/Index', 'index.php?option=com_finder&view=index', 'component', 1, 18, 2, `extension_id`, 0, 0, 'class:finder', 0, '', 30, 31, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_finder';
INSERT INTO `#__menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`)
SELECT 'main', 'com_finder_maps', 'Smart-Search-Maps', '', 'Smart Search/Maps', 'index.php?option=com_finder&view=maps', 'component', 1, 18, 2, `extension_id`, 0, 0, 'class:finder-maps', 0, '', 32, 33, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_finder';
INSERT INTO `#__menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`)
SELECT 'main', 'com_finder_filters', 'Smart-Search-Filters', '', 'Smart Search/Filters', 'index.php?option=com_finder&view=filters', 'component', 1, 18, 2, `extension_id`, 0, 0, 'class:finder-filters', 0, '', 34, 35, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_finder';
INSERT INTO `#__menu` (`menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`)
SELECT 'main', 'com_finder_searches', 'Smart-Search-Searches', '', 'Smart Search/Searches', 'index.php?option=com_finder&view=searches', 'component', 1, 18, 2, `extension_id`, 0, 0, 'class:finder-searches', 0, '', 36, 37, 0, '*', 1, NULL, NULL FROM `#__extensions` WHERE `name` = 'com_finder';

Change all of the instances of #__ to xxxxx_ where xxxxx is your table prefix.

Actually, I doubt whether this will work!

Yes the menu is back and the front end smart search not working even after i reindex back.
It giving an empty result. It working fine before update joomla 4.

[ceford]

Does the Smart Search appear to work normally in the backend? Do you have a multi-lingual site? What actually happens when you start typing in the front end Search field? Two characters is enough to induce a response.

[deathbat87]

Does the Smart Search appear to work normally in the backend? Do you have a multi-lingual site? What actually happens when you start typing in the front end Search field? Two characters is enough to induce a response.

On the back end and front end it work. But when you doing the search it not giving any results. It suppose to show the result like one of the attachment. That one was taken from another site. The site is not multi-lingual. Please refer to the attachment.

[ceford]

I looked at you site - it seems to be working normally to me. The search box in the top right corner does return a list of products containing coconut when that term is entered. Although it seems to me you have a custom search functionality. I could not find a Search menu item but I can bring up your search page just by appending /search to your domain. That search pages is working normally, returning 14 pages of results for coconut. Yummy!

I am not familiar with your third party extensions but it may be they have their own search mechanism and maybe that is why the Joomla Smart Search entries were missing.

[deathbat87]

I looked at you site - it seems to be working normally to me. The search box in the top right corner does return a list of products containing coconut when that term is entered. Although it seems to me you have a custom search functionality. I could not find a Search menu item but I can bring up your search page just by appending /search to your domain. That search pages is working normally, returning 14 pages of results for coconut. Yummy!

I am not familiar with your third party extensions but it may be they have their own search mechanism and maybe that is why the Joomla Smart Search entries were missing.

You may check the search function on recipe page, that one use original Joomla smart search system. The top search on the red bar are Hikashop search.

[ceford]

I don't see any problems - all works for me.

[deathbat87]

I don't see any problems - all works for me.

Thanks for the clarification and all helps above. It helps me alot with this upgrade for Joomla 4. Now the site are working back.