Storage engine MEMORY is disabled Topic is solved

Need help installing Joomla! 4.x? For all Joomla! 4.x installation issues please use this forum.

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
Locked
ski8706
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sun Jan 10, 2010 12:17 am

Storage engine MEMORY is disabled

Post by ski8706 » Thu Dec 09, 2021 7:19 pm

I have a new installation of Joomla 4.0 and the following error is shown whenever I create a new article:

Save failed with the following error: Storage engine MEMORY is disabled (Table creation is disallowed).

I've narrowed down the culprit to the Google MySQL instance, but I'm unable to understand why Joomla is throwing this error. Everything works fine if I connect to a local MySQL instance on the webserver.

The tables are all Innodb and the database user has full schema privileges to the database as well as all database administrative roles except FILE and SUPER. I was hoping someone may be able to confirm that the the lack of these rights is the cause of my issue and I can go from there.. the weird thing is, this only occurs if it's a new article or the title changes. Changes made to the body are saved and visible on the site.

Here are the FPA details:
Forum Post Assistant (v1.6.3) : 9-Dec-2021 wrote:
Last PHP Error(s) Reported :: wrote:[09-Dec-2021 10:46:00 America/New_York] PHP Warning: Attempt to read property
Basic Environment :: wrote:Joomla! Instance :: Joomla! 4.0.5-rc3-Release Candidate (Furaha) 6-December-2021
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: No | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: N/A | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: default | Site Debug: true | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.0.5-rc3: Yes | Database Supports J! 4.0.5-rc3: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Windows NT | OS Version: 10.0 | Technology: i586 | Web Server: Microsoft-IIS/10.0 | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 44.46 GiB |

PHP Configuration :: Version: 8.0.12 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 22527 | Log Errors To: C:\Windows\Temp\php-8.0.12_errors.log | Last Known Error: 09th December 2021 10:46:00. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 50M | Max. POST Size: 50M | Max. Input Time: 60 | Max. Execution Time: 300 | Memory Limit: 128M

Database Configuration :: Version: 8.0.18-google (Client:mysqlnd 8.0.12) | Database Size: 4.80 MiB | #of Tables with config prefix:  72 | #of other Tables:  0 | User Privileges : GRANT `cloudsqlsuperuser`@`%` TO `dbuser`@`%`
Detailed Environment :: wrote:PHP Extensions :: Core (8.0.12) | bcmath (8.0.12) | calendar (8.0.12) | ctype (8.0.12) | date (8.0.12) | filter (8.0.12) | hash (8.0.12) | iconv (8.0.12) | json (8.0.12) | SPL (8.0.12) | pcre (8.0.12) | readline (8.0.12) | Reflection (8.0.12) | session (8.0.12) | standard (8.0.12) | mysqlnd (mysqlnd 8.0.12) | tokenizer (8.0.12) | zip (1.19.4) | zlib (8.0.12) | libxml (8.0.12) | dom (20031129) | PDO (8.0.12) | openssl (8.0.12) | SimpleXML (8.0.12) | xml (8.0.12) | xmlreader (8.0.12) | xmlwriter (8.0.12) | cgi-fcgi (8.0.12) | curl (8.0.12) | gettext (8.0.12) | mysqli (8.0.12) | mbstring (8.0.12) | Phar (8.0.12) | soap (8.0.12) | pdo_sqlite (8.0.12) | Zend Engine (4.0.12) |
Potential Missing Extensions :: pdo_mysql |

Switch User Environment :: PHP CGI: Yes | Server SU: No | PHP SU: Yes | Potential Ownership Issues: No
Folder Permissions :: wrote:Core Folders :: images/ (777) | components/ (777) | modules/ (777) | plugins/ (777) | language/ (777) | templates/ (777) | cache/ (777) | logs/ (---) | tmp/ (777) | administrator/components/ (777) | administrator/modules/ (777) | administrator/language/ (777) | administrator/templates/ (777) | administrator/logs/ (777) |

Elevated Permissions (First 10) :: administrator/ (777) | administrator/cache/ (777) | administrator/cache/plg_system_debug_administrator/ (777) | administrator/cache/plg_system_debug_site/ (777) | administrator/cache/t4/ (777) | administrator/components/ (777) | administrator/components/com_actionlogs/ (777) | administrator/components/com_actionlogs/forms/ (777) | administrator/components/com_actionlogs/services/ (777) | administrator/components/com_actionlogs/src/ (777) |
Database Information :: wrote:Database statistics :: Uptime: 9311 | Threads: 10 | Questions: 21541 | Slow queries: 0 | Opens: 630 | Flush tables: 3 | Open tables: 551 | Queries per second avg: 2.313 |
Extensions Discovered :: wrote:Components :: Site ::
Core ::
3rd Party::

Components :: Admin ::
Core :: com_actionlogs (3.9.0) 1 | com_admin (4.0.0) 1 | com_ajax (4.0.0) 1 | com_associations (4.0.0) 1 | com_banners (4.0.0) 1 | com_cache (4.0.0) 1 | com_categories (4.0.0) 1 | com_checkin (4.0.0) 1 | com_config (4.0.0) 1 | com_content (4.0.0) 1 | com_contenthistory (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_fields (4.0.0) 1 | com_finder (4.0.0) 1 | com_installer (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_languages (4.0.0) 1 | com_login (4.0.0) 1 | com_mails (4.0.0) 1 | com_media (3.0.0) 1 | com_menus (4.0.0) 1 | com_messages (4.0.0) 1 | com_modules (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_plugins (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_privacy (3.9.0) 1 | com_redirect (4.0.0) 1 | com_tags (4.0.0) 1 | com_templates (4.0.0) 1 | com_users (4.0.0) 1 | com_workflow (4.0.0) 1 | com_wrapper (4.0.0) 1 |
3rd Party:: com_jaextmanager (2.5.3) ? | com_jaextmanager (2.7.1) ? |

Modules :: Site ::
Core :: mod_articles_archive (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_login (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_tags_similar (3.1.0) 1 | mod_users_latest (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_wrapper (3.0.0) 1 |
3rd Party::

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

Libraries ::
Core ::
3rd Party::

Plugins ::
Core :: plg_actionlog_joomla (3.9.0) 1 | plg_api-authentication_basic (4.0.0) 0 | plg_api-authentication_token (4.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_behaviour_taggable (4.0.0) 1 | plg_behaviour_versionable (4.0.0) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.8) 1 | plg_content_confirmconsent (3.9.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_finder (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_extension_finder (4.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_extension_namespacemap (4.0.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_subform (4.0.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_filesystem_local (4.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_installer_folderinstaller (3.6.0) 1 | plg_installer_override (4.0.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_urlinstaller (3.6.0) 1 | plg_installer_webinstaller (4.0.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_media-action_resize (4.0.0) 1 | plg_media-action_rotate (4.0.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_consents (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_quickicon_downloadkey (4.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_overridecheck (4.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_sampledata_multilang (4.0.0) 1 | plg_system_accessibility (4.0.0) 0 | plg_system_actionlogs (3.9.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_httpheaders (4.0.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_languagefilter (3.0.0) 0 | plg_system_log (3.0.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_privacyconsent (3.9.0) 1 | plg_system_redirect (3.0.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_skipto (4.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_webauthn (4.0.0) 1 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_profile (3.0.0) 1 | plg_user_terms (3.9.0) 1 | plg_user_token (3.9.0) 1 | plg_webservices_banners (4.0.0) 1 | plg_webservices_config (4.0.0) 1 | plg_webservices_content (4.0.0) 1 | plg_webservices_installer (4.0.0) 1 | plg_webservices_languages (4.0.0) 1 | plg_webservices_menus (4.0.0) 1 | plg_webservices_messages (4.0.0) 1 | plg_webservices_modules (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_redirect (4.0.0) 1 | plg_webservices_tags (4.0.0) 1 | plg_webservices_templates (4.0.0) 1 | plg_webservices_users (4.0.0) 1 | plg_workflow_featuring (4.0.0) 1 | plg_workflow_notification (4.0.0) 1 | plg_workflow_publishing (4.0.0) 1 |
3rd Party:: plg_editors_codemirror (5.64.0) 1 | plg_editors_tinymce (5.10.2) 1 | plg_system_t4 (2.0.9) 1 |
Templates Discovered :: wrote:Templates :: Site :: cassiopeia (1.0) 1 | t4_bs5_blank (1.1.2) 1 |
Templates :: Admin :: atum (1.0) 1 |
Thank you!

User avatar
brian
Joomla! Master
Joomla! Master
Posts: 12773
Joined: Fri Aug 12, 2005 7:19 am
Location: Leeds, UK
Contact:

Re: Storage engine MEMORY is disabled

Post by brian » Thu Dec 09, 2021 7:49 pm

https://cloud.google.com/sql/faq#innodb

Google Cloud does not support engine=memory which is used on two tables #__finder_tokens and #__finder_tokens_aggregate
"Exploited yesterday... Hacked tomorrow"
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/

ski8706
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sun Jan 10, 2010 12:17 am

Re: Storage engine MEMORY is disabled

Post by ski8706 » Thu Dec 09, 2021 8:09 pm

Bummer! I saw that documentation as well and I looked at the table and the engine is set as innodb so I thought I was in the clear. Thank you for the clarification!


Locked

Return to “Installation Joomla! 4.x”