Page 1 of 1

Storage engine MEMORY is disabled (Table creation is disallowed).

Posted: Sun Sep 30, 2018 10:37 am
by skyfranky
Hi

I could not install joomla 3.8.12 to the RDS Mysql DB, and got this error:
Storage engine MEMORY is disabled (Table creation is disallowed)


I was tolded by the hosting that their RDS does not support "Memory & Federated" and their RDS by default will change "Memory Engine" to InnoDB

I am not familar with such issue, and wonder if anyone knows how to install and run Joomla DB without "Memory & Federated"?

Re: Storage engine MEMORY is disabled (Table creation is disallowed).

Posted: Sun Sep 30, 2018 11:17 am
by Webdongle
viewtopic.php?f=714&t=793531 please
But best change host.

Re: Storage engine MEMORY is disabled (Table creation is disallowed).

Posted: Sun Sep 30, 2018 1:49 pm
by JAVesey
What PHP version are you running under?
What DB driver are you trying to use?

As previously posted, please post the output you get after running the FPA (see link in earlier post).

Re: Storage engine MEMORY is disabled (Table creation is disallowed).

Posted: Sun Sep 30, 2018 2:25 pm
by skyfranky
thank you so much for the replies. here is the info
Forum Post Assistant (v1.4.5 (Ganymede)) : 30th September 2018 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.8.12-Stable (Amani) 28-August-2018
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Not Found

Host Configuration :: OS: Linux | OS Version: 3.10.0-693.2.2.el7.x86_64 | Technology: x86_64 | Web Server: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips mod_fcgid/2.3.9 PHP/5.4.16 mod_python/3.5.0- Python/2.7.5 | Encoding: gzip, deflate | Doc Root: --protected-- | System TMP Writable: Yes | Free Disk Space : 28.37 GiB |

PHP Configuration :: Version: 5.6.38 | PHP API: fpm-fcgi | Session Path Writable: Yes | Display Errors: | Error Reporting: 22527 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: /var/www/clients/client2/web9/web:/var/www/clients/client2/web9/private:/var/www/clients/client2/web9/tmp:/var/www/service.mydomain.com/web:/srv/www/service.mydomain.com/web:/usr/share/php5:/usr/share/php:/tmp:/usr/share/phpmyadmin:/etc/phpmyadmin:/var/lib/phpmyadmin:/dev/random:/dev/urandom | Uploads: 1 | Max. Upload Size: 2M | Max. POST Size: 8M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 128M

Database Configuration :: Database Credentials incomplete or not available Nothing to display.
Missing credentials detected: Connection Type missing | Database Name missing |MySQL Host missing | Table Prefix missing | Database Username missing | Database Password missing |
Detailed Environment :: wrote:PHP Extensions :: Core (5.6.38) | date (5.6.38) | ereg () | libxml () | openssl () | pcre () | sqlite3 (0.7-dev) | zlib (2.0) | bz2 () | calendar () | ctype () | curl () | dom (20031129) | fileinfo (1.0.5) | filter (0.11.0) | ftp () | gd () | gettext () | hash (1.0) | iconv () | SPL (0.2) | json (1.2.1) | mbstring () | mcrypt () | session () | standard (5.6.38) | mysqlnd (mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $) | pcntl () | mysqli (0.1) | PDO (1.0.4dev) | pdo_mysql (1.0.2) | pdo_pgsql (1.0.2) | pdo_sqlite (1.0.1) | pgsql () | Phar (2.0.2) | posix () | Reflection ($Id: 5f15287237d5f78d75b19c26915aa7bd83dee8b8 $) | mysql (1.0) | SimpleXML (0.1) | soap () | sockets () | imap () | sysvsem () | sysvshm () | tokenizer (0.1) | xml () | xmlreader (0.1) | xmlwriter (0.1) | zip (1.12.5) | cgi-fcgi () | SourceGuardian (11.2) | mhash () | ionCube Loader () | Zend Engine (2.6.0) |
Potential Missing Extensions ::

Switch User Environment (Experimental) :: PHP CGI: No | Server SU: No | PHP SU: No | Custom SU (LiteSpeed/Cloud/Grid): No
Potential Ownership Issues: Maybe
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) |

Elevated Permissions (First 10) ::
Extensions Discovered :: wrote:Components :: SITE ::
Core :: com_wrapper (3.0.0) | com_mailto (3.0.0) |
3rd Party::

Components :: ADMIN ::
Core :: com_joomlaupdate (3.6.2) | com_messages (3.0.0) | com_redirect (3.0.0) | com_modules (3.0.0) | com_tags (3.1.0) | com_admin (3.0.0) | com_media (3.0.0) | com_categories (3.0.0) | com_postinstall (3.2.0) | com_cache (3.0.0) | com_templates (3.0.0) | com_finder (3.0.0) | com_checkin (3.0.0) | com_cpanel (3.0.0) | com_ajax (3.2.0) | com_languages (3.0.0) | com_newsfeeds (3.0.0) | com_content (3.0.0) | com_contenthistory (3.2.0) | com_menus (3.0.0) | com_plugins (3.0.0) | com_users (3.0.0) | com_associations (3.7.0) | com_banners (3.0.0) | com_installer (3.0.0) | com_fields (3.7.0) | com_search (3.0.0) | com_config (3.0.0) | com_login (3.0.0) |
3rd Party::

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

Modules :: ADMIN ::
Core :: mod_logged (3.0.0) | mod_popular (3.0.0) | mod_feed (3.0.0) | mod_login (3.0.0) | mod_menu (3.0.0) | mod_toolbar (3.0.0) | mod_multilangstatus (3.0.0) | mod_quickicon (3.0.0) | mod_custom (3.0.0) | mod_title (3.0.0) | mod_submenu (3.0.0) | mod_status (3.0.0) | mod_latest (3.0.0) | mod_stats_admin (3.0.0) | mod_sampledata (3.8.0) | mod_version (3.0.0) |
3rd Party::

Plugins :: SITE ::
Core :: plg_twofactorauth_yubikey (3.2.0) | plg_twofactorauth_totp (3.2.0) | plg_fields_url (3.7.0) | plg_fields_checkboxes (3.7.0) | plg_fields_textarea (3.7.0) | plg_fields_text (3.7.0) | plg_fields_media (3.7.0) | plg_fields_list (3.7.0) | plg_fields_user (3.7.0) | plg_fields_editor (3.7.0) | plg_fields_integer (3.7.0) | plg_fields_radio (3.7.0) | plg_fields_color (3.7.0) | plg_fields_calendar (3.7.0) | plg_fields_sql (3.7.0) | plg_fields_imagelist (3.7.0) | plg_fields_usergrouplist (3.7.0) | plg_quickicon_phpversioncheck (3.7.0) | plg_quickicon_extensionupdate (3.0.0) | plg_quickicon_joomlaupdate (3.0.0) | plg_user_joomla (3.0.0) | plg_user_contactcreator (3.0.0) | plg_user_profile (3.0.0) | plg_extension_joomla (3.0.0) | plg_editors-xtd_fields (3.7.0) | plg_editors-xtd_pagebreak (3.0.0) | plg_editors-xtd_image (3.0.0) | plg_editors-xtd_module (3.5.0) | plg_editors-xtd_article (3.0.0) | plg_editors-xtd_menu (3.7.0) | plg_editors-xtd_readmore (3.0.0) | plg_finder_newsfeeds (3.0.0) | plg_finder_contacts (3.0.0) | plg_finder_categories (3.0.0) | plg_finder_tags (3.0.0) | plg_finder_content (3.0.0) | plg_authentication_gmail (3.0.0) | plg_authentication_ldap (3.0.0) | plg_authentication_joomla (3.0.0) | plg_authentication_cookie (3.0.0) | plg_installer_packageinstaller (3.6.0) | PLG_INSTALLER_URLINSTALLER (3.6.0) | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) | plg_system_log (3.0.0) | plg_system_redirect (3.0.0) | plg_system_p3p (3.0.0) | plg_system_fields (3.7.0) | plg_system_updatenotification (3.5.0) | plg_system_languagecode (3.0.0) | plg_system_sessiongc (3.8.6) | plg_system_debug (3.0.0) | plg_system_languagefilter (3.0.0) | plg_system_cache (3.0.0) | plg_system_logout (3.0.0) | plg_system_sef (3.0.0) | plg_system_stats (3.5.0) | plg_system_highlight (3.0.0) | plg_system_remember (3.0.0) | plg_content_fields (3.7.0) | plg_content_pagebreak (3.0.0) | plg_content_loadmodule (3.0.0) | plg_content_pagenavigation (3.0.0) | plg_content_joomla (3.0.0) | plg_content_finder (3.0.0) | plg_content_emailcloak (3.0.0) | plg_content_vote (3.0.0) | plg_captcha_recaptcha (3.4.0) | plg_search_newsfeeds (3.0.0) | plg_search_contacts (3.0.0) | plg_search_categories (3.0.0) | plg_search_tags (3.0.0) | plg_search_content (3.0.0) |
3rd Party:: plg_editors_tinymce (4.5.8) | plg_editors_codemirror (5.38.0) |
Templates Discovered :: wrote:Templates :: SITE :: protostar (1.0) | beez3 (3.1.0) |
Templates :: ADMIN :: isis (1.0) | hathor (3.0.0) |

Re: Storage engine MEMORY is disabled (Table creation is disallowed).

Posted: Sun Sep 30, 2018 3:44 pm
by Webdongle
Open Base: ... can be problematic ? No need to use it.
Upload Size: 2M | Max. POST Size: 8M ... make both 32M
Max. Execution Time: 30 ... make 300

Re: Storage engine MEMORY is disabled (Table creation is disallowed).

Posted: Sun Sep 30, 2018 4:22 pm
by skyfranky
this error showed during the DB creating process, so it should be about the DB and SQL, right?
Storage engine MEMORY is disabled (Table creation is disallowed)

Re: Storage engine MEMORY is disabled (Table creation is disallowed).

Posted: Sun Sep 30, 2018 4:23 pm
by leolam
MySQl is not supported any longer with Joomla. You need to install using MySQLi. If not available change to a host that does not utilizes MySQL or ask your host to use MySQLi

Leo 8)

Re: Storage engine MEMORY is disabled (Table creation is disallowed).

Posted: Mon Oct 01, 2018 3:42 am
by skyfranky
Hi

I am using MySQLi. I found a workaround, but not sure if this will have any potential issues.

I installed the new joomla site to my another server, then I exported and imported the DB directly in RDS DB without errors. copying back all the files, and the site starts normally.

Does Joomla uses "Storage engine MEMORY" ? If RDS not support it, will I have any issues after succssfully DB import?

Re: Storage engine MEMORY is disabled (Table creation is disallowed).

Posted: Mon Oct 01, 2018 8:18 am
by skyfranky
after installing Joomla, I checked the DB, and there is no "engine=MEMORY", so I think I correctly imported the DB into RDS. I don't know why installing from script will need "engine=MEMORY".