MAX_JOIN_SIZE Error

Discussion regarding Joomla! 4.x Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Post Reply
jeddell2
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Thu Nov 09, 2023 9:43 am

MAX_JOIN_SIZE Error

Post by jeddell2 » Sat Nov 25, 2023 4:35 am

We have recently migrated a Joomla website across to a new host and we are now getting the following error.
----------------------
"The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay"
---------------------
We enquired about this with the host who basically stated the the SQL is examining more than 5 million rows. I find this hard to swallow considering the fpa text below on show a quarter of a million rows across the entire database.

basically they said we have to "Upgrade" the plan. (Raises alarm bells right there in my book).

I did some research into the comments in the error and could not find much of anything to change, or edit to remove this error, more of my own lack of understanding than anything else.

So my question is multi faceted.
1. How do I fix the Settings mentioned in the error, knowing that I am on a shared hosting service plan;
2. What's the best method to analyze the database to see if there is anything that I can do regarding the database to reduce its size and possibly remove the error?
3. Are there any know extensions or plugins that might bloat the CMS that I may have Installed? (I'll post the second part of this FPA in the first response)

Cheers All


Forum Post Assistant (v1.6.6) : 25-Nov-2023 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 4.4.0-Stable (Pamoja) 17-October-2023
Joomla! Configured :: Yes | Writable (755) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: N/A | Proxy: false | LiveSite: | Session lifetime: 240 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.4.0: Yes | Database Supports J! 4.4.0: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.10.0-962.3.2.lve1.5.81.el7.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 3730.56 GiB |

PHP Configuration :: Version: 8.1.25 | PHP API: litespeed | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 22527 | Log Errors To: /dev/null | Last Known Error: 24th October 2023 04:59:55. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 2000M | Max. POST Size: 8000M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 512M

Database Configuration :: Version: 10.6.15-MariaDB-cll-lve (Client:mysqlnd 8.1.25) | Database Size: 92.97 MiB | #of Tables with config prefix:  240 | #of other Tables:  0 | User Privileges : GRANT ALL
Detailed Environment :: wrote:PHP Extensions :: Core (8.1.25) | date (8.1.25) | libxml (8.1.25) | openssl (8.1.25) | pcre (8.1.25) | sqlite3 (8.1.25) | zlib (8.1.25) | bz2 (8.1.25) | calendar (8.1.25) | ctype (8.1.25) | curl (8.1.25) | hash (8.1.25) | filter (8.1.25) | ftp (8.1.25) | gettext (8.1.25) | json (8.1.25) | iconv (8.1.25) | SPL (8.1.25) | pcntl (8.1.25) | readline (8.1.25) | Reflection (8.1.25) | session (8.1.25) | standard (8.1.25) | mbstring (8.1.25) | shmop (8.1.25) | SimpleXML (8.1.25) | tokenizer (8.1.25) | xml (8.1.25) | litespeed () | bcmath (8.1.25) | dba (8.1.25) | dom (20031129) | enchant (8.1.25) | fileinfo (8.1.25) | gd (8.1.25) | imagick (3.7.0) | imap (8.1.25) | intl (8.1.25) | ldap (8.1.25) | exif (8.1.25) | mysqlnd (mysqlnd 8.1.25) | mysqli (8.1.25) | PDO (8.1.25) | pdo_mysql (8.1.25) | odbc (8.1.25) | PDO_ODBC (8.1.25) | pdo_pgsql (8.1.25) | Phar (8.1.25) | pspell (8.1.25) | snmp (8.1.25) | sodium (8.1.25) | sysvmsg (8.1.25) | sysvsem (8.1.25) | sysvshm (8.1.25) | xmlreader (8.1.25) | xmlrpc (1.0.0RC2) | xmlwriter (8.1.25) | zip (1.19.5) | ionCube Loader (13.0.2) | Zend OPcache (8.1.25) | SourceGuardian (14.0.2) | Zend Engine (4.1.25) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Potential Ownership Issues: No
Folder Permissions :: wrote: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 Information :: wrote:Database statistics :: Uptime: 2744477 | Threads: 264 | Questions: 1912445750 | Slow queries: 96357 | Opens: 557327 | Open tables: 20000 | Queries per second avg: 696.834 |
Extensions Discovered :: wrote:Components :: Site ::
Core ::
3rd Party:: WF_LISTS_TITLE (2.9.52) ? | WF_LINK_TITLE (2.9.52) ? | WF_TEXTCASE_TITLE (2.9.52) ? | JCE - Noneditable (1.0.0) ? | WF_HELP_TITLE (2.9.52) ? | WF_TABLE_TITLE (2.9.52) ? | WF_CLIPBOARD_TITLE (2.9.52) ? | WF_KITCHENSINK_TITLE (2.9.52) ? | WF_ATTRIBUTES_TITLE (2.9.52) ? | WF_FILEMANAGER_TITLE (2.9.52) ? | WF_MEDIA_TITLE (2.9.52) ? | WF_IMGMANAGER_EXT_TITLE (2.9.52) ? | WF_FORMATSELECT_TITLE (2.9.52) ? | WF_MICRODATA_TITLE (2.9.52) ? | WF_ARTICLE_TITLE (2.9.52) ? | WF_CONTEXTMENU_TITLE (2.9.52) ? | WF_PREVIEW_TITLE (2.9.52) ? | WF_PRINT_TITLE (2.9.52) ? | WF_FONTCOLOR_TITLE (2.9.52) ? | WF_SOURCE_TITLE (2.9.52) ? | WF_IFRAME_TITLE (2.9.52) ? | WF_TEMPLATEMANAGER_TITLE (2.9.52) ? | WF_IMGMANAGER_TITLE (2.9.52) ? | WF_SPELLCHECKER_TITLE (2.9.52) ? | WF_EMOTIONS_TITLE (2.9.52) ? | WF_REFERENCE_TITLE (2.9.52) ? | WF_VISUALCHARS_TITLE (2.9.52) ? | WF_STYLESELECT_TITLE (2.9.52) ? | WF_STYLE_TITLE (2.9.52) ? | WF_FONTSELECT_TITLE (2.9.52) ? | WF_FULLSCREEN_TITLE (2.9.52) ? | WF_CLEANUP_TITLE (2.9.52) ? | WF_MEDIAMANAGER_TITLE (2.9.52) ? | WF_AUTOSAVE_TITLE (2.9.52) ? | WF_CHARMAP_TITLE (2.9.52) ? | WF_SEARCHREPLACE_TITLE (2.9.52) ? | WF_VISUALBLOCKS_TITLE (2.9.52) ? | WF_DIRECTIONALITY_TITLE (2.9.52) ? | WF_LANGCODE_TITLE (2.9.52) ? | WF_WORDCOUNT_TITLE (2.9.52) ? | WF_CAPTION_TITLE (2.9.41) ? | WF_TEXTPATTERN_TITLE (2.9.52) ? | JCE - Columns (1.0.0) ? | WF_ANCHOR_TITLE (2.9.52) ? | WF_HR_TITLE (2.9.52) ? | WF_FONTSIZESELECT_TITLE (2.9.52) ? | WF_BROWSER_TITLE (2.9.52) ? | WF_NONBREAKING_TITLE (2.9.52) ? | WF_LINK_SEARCH_TITLE (2.9.52) ? | WF_LINKS_JOOMLALINKS_TITLE (2.9.52) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.9.52) ? | WF_AGGREGATOR_AUDIO_TITLE (2.9.52) ? | WF_AGGREGATOR_VIDEO_TITLE (2.9.52) ? | WF_AGGREGATOR_VIMEO_TITLE (2.9.52) ? | WF_AGGREGATOR_[youtube]_TITLE (2.9.52) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.9.52) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.9.52) ? |

Components :: Admin ::
Core :: com_contenthistory (4.0.0) 1 | com_associations (4.0.0) 1 | com_templates (4.0.0) 1 | com_mails (4.0.0) 1 | com_media (3.0.0) 1 | com_cache (4.0.0) 1 | com_tags (4.0.0) 1 | com_categories (4.0.0) 1 | com_languages (4.0.0) 1 | com_users (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_installer (4.0.0) 1 | com_wrapper (4.0.0) 1 | com_config (4.0.0) 1 | com_workflow (4.0.0) 1 | com_actionlogs (3.9.0) 1 | com_content (4.0.0) 1 | com_banners (4.0.0) 1 | com_scheduler (4.1.0) 1 | com_finder (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_redirect (4.0.0) 1 | com_menus (4.0.0) 1 | com_fields (4.0.0) 1 | com_guidedtours (4.3.0) 1 | com_plugins (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_privacy (3.9.0) 1 | com_checkin (4.0.0) 1 | com_admin (4.0.0) 1 | com_messages (4.0.0) 1 | com_login (4.0.0) 1 | com_modules (4.0.0) 1 | com_ajax (4.0.0) 1 | com_newsfeeds (4.0.0) 1 |
3rd Party:: COM_NICEPAGE (5.21.3) 1 | Helpdesk Pro (5.3.1) 1 | com_rsfiles (1.17.2) 1 | HikaShop (5.0.0) 1 | COM_JCE (2.9.52) 1 | COM_JLEXHELPFUL (1.7.3) 1 | com_akeebabackup (9.8.3) 1 | COM_FFEXPLORER (1.0.7) 1 | com_rsfeedback (1.8.8) 1 | com_rsform (3.2.2) 1 | Library - dompdf v2.x (2.0.3) ? | Library - dompdf v1.x (1.2.2) ? | Library - mPDF (8.2.0) ? | com_rsmail (1.22.24) 1 |

Modules :: Site ::
Core :: mod_articles_popular (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_banners (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_login (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_articles_archive (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_users_latest (3.0.0) 1 |
3rd Party:: RSFeedback! Button Module (1.0.3) 1 | mod_phocacart_product (4.0.2) 1 | mod_phocacart_cart (4.0.2) 1 | mod_rsfiles_folder_content_viewer (1.6) 1 | Hikashop Module (5.0.0) ? | mod_phocacart_product_scroller (4.0.2) 1 | mod_phocacart_brands (4.0.2) 1 | Hikashop Currency Switcher Module (5.0.0) ? | mod_phocacart_category (4.0.2) 1 | RSForm! Pro Module List (3.0.5) 1 | RSFeedback! Category Module (1.0.1) 1 | mod_phocacart_currency (4.0.2) 1 | mod_phocacart_search (4.0.2) 1 | RSMail Newsletter (1.6) 1 | mod_phocacart_compare (4.0.2) 1 | mod_phocacart_wishlist (4.0.2) 1 | Hikashop Cart Module (5.0.0) ? | mod_phocacart_filter (4.0.2) 1 |

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

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

Templates Discovered :: wrote:Templates :: Site :: clearth_9 (1.0) 1 | cassiopeia (1.0) 1 | clearth_9a (1.0) 1 |
Templates :: Admin :: atum (1.0) 1 |

jeddell2
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Thu Nov 09, 2023 9:43 am

Re: MAX_JOIN_SIZE Error

Post by jeddell2 » Sat Nov 25, 2023 4:40 am

Forum Post Assistant (v1.6.6) : 25-Nov-2023 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 4.4.0-Stable (Pamoja) 17-October-2023
Joomla! Configured :: Yes | Writable (755) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: N/A | Proxy: false | LiveSite: | Session lifetime: 240 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.4.0: Yes | Database Supports J! 4.4.0: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.10.0-962.3.2.lve1.5.81.el7.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 3730.41 GiB |

PHP Configuration :: Version: 8.1.25 | PHP API: litespeed | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 22527 | Log Errors To: /dev/null | Last Known Error: 24th October 2023 04:59:55. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 2000M | Max. POST Size: 8000M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 512M

Database Configuration :: Version: 10.6.15-MariaDB-cll-lve (Client:mysqlnd 8.1.25) | Database Size: 92.97 MiB | #of Tables with config prefix:  240 | #of other Tables:  0 | User Privileges : GRANT ALL
Detailed Environment :: wrote:PHP Extensions :: Core (8.1.25) | date (8.1.25) | libxml (8.1.25) | openssl (8.1.25) | pcre (8.1.25) | sqlite3 (8.1.25) | zlib (8.1.25) | bz2 (8.1.25) | calendar (8.1.25) | ctype (8.1.25) | curl (8.1.25) | hash (8.1.25) | filter (8.1.25) | ftp (8.1.25) | gettext (8.1.25) | json (8.1.25) | iconv (8.1.25) | SPL (8.1.25) | pcntl (8.1.25) | readline (8.1.25) | Reflection (8.1.25) | session (8.1.25) | standard (8.1.25) | mbstring (8.1.25) | shmop (8.1.25) | SimpleXML (8.1.25) | tokenizer (8.1.25) | xml (8.1.25) | litespeed () | bcmath (8.1.25) | dba (8.1.25) | dom (20031129) | enchant (8.1.25) | fileinfo (8.1.25) | gd (8.1.25) | imagick (3.7.0) | imap (8.1.25) | intl (8.1.25) | ldap (8.1.25) | exif (8.1.25) | mysqlnd (mysqlnd 8.1.25) | mysqli (8.1.25) | PDO (8.1.25) | pdo_mysql (8.1.25) | odbc (8.1.25) | PDO_ODBC (8.1.25) | pdo_pgsql (8.1.25) | Phar (8.1.25) | pspell (8.1.25) | snmp (8.1.25) | sodium (8.1.25) | sysvmsg (8.1.25) | sysvsem (8.1.25) | sysvshm (8.1.25) | xmlreader (8.1.25) | xmlrpc (1.0.0RC2) | xmlwriter (8.1.25) | zip (1.19.5) | ionCube Loader (13.0.2) | Zend OPcache (8.1.25) | SourceGuardian (14.0.2) | Zend Engine (4.1.25) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Potential Ownership Issues: No
Folder Permissions :: wrote: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) |
Extensions Discovered :: wrote:





Plugins ::
3rd Party:: Hikashop Collect On Delivery Paymen (5.0.0) ? | Hikashop eWAY Payment Plugin (5.0.0) ? | Hikashop PayU India Payment Plugin (5.0.0) ? | Hikashop eSelect Payment Plugin (5.0.0) ? | Hikashop Beanstream Payment Plugin (5.0.0) ? | Hikashop Authorize.net Payment Plug (5.0.0) ? | Hikashop Postfinance Payment Plugin (5.0.0) ? | Hikashop Paybox Plugin (5.0.0) ? | Hikashop Monetico Payment Plugin (5.0.0) ? | Hikashop PayPlug v2 payment plugin (5.0.0) ? | Hikashop Western Union Payment Plug (5.0.0) ? | Hikashop Paypal (legacy) Payment Pl (5.0.0) ? | Hikashop PayJunction Payment Plugin (5.0.0) ? | Hikashop Bank Transfer Payment Plug (5.0.0) ? | Hikashop Paypal Website Payments Pr (5.0.0) ? | Hikashop Paygate Payment Plugin (5.0.0) ? | Hikashop SIPS ATOS Payment Plugin (5.0.0) ? | Hikashop Alipay Payment Plugin (5.0.0) ? | Hikashop ATOS SIPS 2.0 Payment Plug (5.0.0) ? | Hikashop Nets NETAXEPT Payment Plug (5.0.0) ? | Hikashop westpacapi Payment Plugin (1.0) ? | Hikashop Borgun payment plugin (5.0.0) ? | Hikashop CyberMuth CIC Payment Plug (5.0.0) ? | Hikashop HSBC Payment Plugin (5.0.0) ? | Hikashop PaymentExpress (PxPay) Plu (5.0.0) ? | Hikashop CardSave Payment Plugin (5.0.0) ? | Hikashop MasterCard Internet Gatewa (5.0.0) ? | Ogone Payment Plugin (5.0.0) ? | Hikashop Credit Card Payment Plugin (5.0.0) ? | Hikashop Check Payment Plugin (5.0.0) ? | Hikashop Stripe Connect Payment Plu (1.2.1) ? | Hikashop Be2Bill Payment Plugin (5.0.0) ? | Hikashop Virtual Merchant (Elavon) (5.0.0) ? | Hikashop Payza Payment Plugin (5.0.0) ? | Hikashop Bluepaid Payment Plugin (5.0.0) ? | Hikashop WorldNetTPS Payment Plugin (5.0.0) ? | Hikashop Paypal Advanced payment pl (5.0.0) ? | Hikashop Paypal Checkout Payment (1.0.0) ? | Hikashop Paypal Pro Payment Plugin (5.0.0) ? | Hikashop Moneybookers Payment Plugi (5.0.0) ? | Hikashop PayPlug payment plugin (5.0.0) ? | Hikashop Common Joomla Payment API (5.0.0) ? | Hikashop Purchase Order Payment Plu (5.0.0) ? | Hikashop FirstData Payment Plugin (5.0.0) ? | Hikashop Servired Payment Plugin (5.0.0) ? | Hikashop Paypal Express Checkout Pa (5.0.0) ? | Hikashop iVeri Payment Plugin (5.0.0) ? | Hikashop iPayDNA Payment Plugin (5.0.0) ? | Hikashop ePay Payment Plugin (5.0.0) ? | Hikashop Payment Express Payment Pl (5.0.0) ? | Helpdesk Pro - Pre-reply messages (5.3.1) 0 | Helpdesk Pro - Ticket Attachments (5.3.1) 0 | Helpdesk Pro - Assign Ticket (5.3.1) 0 | Helpdesk Pro - Ticket History (5.3.1) 0 | Search - Hikashop Products (5.0.0) ? | Search - Hikashop Categories/Manufa (5.0.0) ? | User - RSMail Joomla Registration (1.1) 1 | PLG_EDITORS-XTD_NICEPAGE (1.0.0) 1 | PLG_EDITORS-XTD_SOURCERER (10.0.1) 0 | HikaShop Product TAG insertion (5.0.0) ? | plg_editors-xtd_rsfiles (1.0.1) 1 | plg_extension_jce (2.9.52) 1 | Installer - Helpdesk Pro (5.3.1) 1 | plg_installer_jce (2.9.52) 1 | plg_installer_rsfeedback (1.0) 1 | plg_installer_rsmail (1.1) 1 | plg_installer_rsfiles (1.0) 1 | plg_installer_rsform (1.0.0) 1 | Page Cache - RSForm! Pro (1.0.0) 1 | Hikashop Validate free order Plugin (5.0.0) ? | Hikashop - Kashflow invoice synchro (5.0.0) ? | Hikashop Massaction Product Plugin (5.0.0) 1 | Hikashop TaxCloud Plugin (1.2.3) 0 | Hikashop Massaction Category Plugin (5.0.0) 1 | HikaShop Shipping Manual - Price pe (5.0.0) ? | Hikashop Cart notification Plugin (5.0.0) ? | Hikashop Content Parser - Markdown (5.0.0) ? | Hikashop Email History Plugin (5.0.0) 1 | Hikashop History Plugin (5.0.0) ? | HikaShop: Date Picker Custom Field (5.0.0) ? | Hikashop Massaction Address Plugin (5.0.0) 1 | Hikashop User account Plugin (5.0.0) ? | Hikashop Massaction User Plugin (5.0.0) 1 | Hikashop Massaction Order Plugin (5.0.0) 1 | HikaMarket - StripeConnect integrat (1.0.1) ? | Content - Helpdesk Pro (5.3.1) 0 | PLG_CONTENT_TTMENUSTYLE (1.0.0) 1 | plg_content_jce (2.9.52) 1 | PLG_CONTENT_NICEPAGE (1.0.0) 1 | Content - RSForm! Pro (3.0.0) 1 | plg_privacy_rsfeedback (1.0) 1 | plg_privacy_rsmail (1.1) 1 | HikaShop Payment Notification plugi (5.0.0) ? | plg_system_jcemediabox (2.1.5) 1 | System - Helpdesk Pro Ticket From C (5.3.1) ? | PLG_SYSTEM_CLEANEDIT (1.0.5) 0 | System - Hikashop Social Plugin (5.0.0) ? | plg_system_jce (2.9.52) 1 | System - RSForm! Pro mailchimp (3.0.2) 1 | Hikashop - VirtueMart Fallback Redi (5.0.0) ? | System - RSFeedback! (1.0) 1 | AMAZON (4.0.0) ? | HikaShop Google Dynamic Remarketing (5.0.0) ? | PLG_SYSTEM_NICEPAGE (1.0.0) 1 | PLG_SYSTEM_SKELETONKEY (1.0.6) 0 | PLG_SYSTEM_SOURCERER (10.0.1) 1 | System - RSForm! Pro Vtiger CRM (3.0.0) 1 | System - Helpdeskpro Reply Via Emai (5.1.2) ? | Hikashop no SSL outside checkout Pl (5.0.0) ? | System - RSForm! Pro Delete Submiss (1.0.0) ? | HikaShop Product TAG translation (5.0.0) ? | System - RSForm! Pro - RSMail! (3.0.0) 1 | System - RSForm! Pro Signature (3.1.2) 1 | System - HikaShop Mass Action (5.0.0) ? | PLG_SYSTEM_RSFORMCONSOLE (1.0.0) 0 | plg_system_osmylicensesmanager (2.0.15) 1 | User - HikaShop (5.0.0) ? | System - RSForm! Pro Registration F (3.0.7) ? | PLG_SYSTEM_REGULARLABS (23.10.17780) 1 | System - RSForm! Pro PDF (3.0.5) 1 | Hikashop Registration Redirect Plug (5.0.0) ? | System - Helpdeskpro Auto Close Tic (5.3.1) ? | Hikashop - Mijoshop Fallback Redire (5.0.0) ? | Hikashop - Redshop Fallback Redirec (5.0.0) ? | Hikashop Product Tag (5.0.0) ? | plg_system_rsfiles (1.0.3) 1 | System - RSForm! Pro (3.0.0) 1 | plg_fields_mediajce (2.9.52) 1 | Hikashop Manual Shipping Plugin (5.0.0) ? | Hikashop CANPAR Shipping Plugin (1.0.0) ? | Hikashop UPS OAuth Shipping Plugin (5.0.0) ? | Hikashop FedEx Shipping Plugin (5.0.0) ? | Hikashop UPS (legacy) Shipping Plug (5.0.0) ? | Hikashop USPS Shipping Plugin (5.0.0) ? | Hikashop Australia Post eDeliver Sh (5.0.0) ? | Smart Search - HikaShop Products (5.0.0) 1 | RSmail! Subscription (1.1) 1 | Joomla! Content - RSmail! (1.1) 1 | PLG_AUTHENTICATION_SKELETONKEY (1.0.6) 0 | PLG_AUTHENTICATION_SHACKUSERSWITCHI (2.0.3) ? | plg_editors_jce (2.9.52) 1 | plg_editors_tinymce (5.10.7) 1 | plg_editors_codemirror (5.65.15) 1 | PLG_QUICKICON_AKEEBABACKUP (9.8.3) 1 | plg_quickicon_jce (2.9.52) 1 | HikaShop Quick Icon (5.0.0) ? |
Templates Discovered :: wrote:Templates :: Site :: clearth_9 (1.0) 1 | clearth_9a (1.0) 1 |
Templates :: Admin ::
Last edited by toivo on Sat Nov 25, 2023 6:17 am, edited 1 time in total.
Reason: mod note: enabled BBCode to fix FPA

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20628
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: MAX_JOIN_SIZE Error

Post by leolam » Tue Jan 02, 2024 5:05 pm

Joomla should not be "writable" Change permissions. Next do you have access to server root? i.e MySQLi config?

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20628
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: MAX_JOIN_SIZE Error

Post by leolam » Tue Jan 02, 2024 5:15 pm

If you have access yo Mysql (root) change

Code: Select all

$> mysqld --max_allowed_packet=128M
This should work

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -


Post Reply

Return to “Performance - Joomla! 4.x”