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

Need help installing Joomla! 3.x? For all Joomla! 3.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.
Post Reply
skyfranky
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Wed May 10, 2006 4:35 am

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

Post by skyfranky » Sun Sep 30, 2018 10:37 am

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"?

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 36156
Joined: Sat Apr 05, 2008 9:58 pm

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

Post by Webdongle » Sun Sep 30, 2018 11:17 am

viewtopic.php?f=714&t=793531 please
But best change host.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein

User avatar
JAVesey
Joomla! Ace
Joomla! Ace
Posts: 1845
Joined: Tue May 14, 2013 1:21 pm
Location: Cardiff, Wales, UK
Contact:

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

Post by JAVesey » Sun Sep 30, 2018 1:49 pm

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).
John V
Cardiff, Wales, UK
Uses Joomla 3.9.1

skyfranky
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Wed May 10, 2006 4:35 am

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

Post by skyfranky » Sun Sep 30, 2018 2:25 pm

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

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 36156
Joined: Sat Apr 05, 2008 9:58 pm

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

Post by Webdongle » Sun Sep 30, 2018 3:44 pm

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
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein

skyfranky
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Wed May 10, 2006 4:35 am

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

Post by skyfranky » Sun Sep 30, 2018 4:22 pm

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)

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

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

Post by leolam » Sun Sep 30, 2018 4:23 pm

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)
Joomla's #1 Professional Support Provider:
-> Joomla Professional Support: https://gws-desk.com -
-> Joomla Specialized Hosting Solutions: https://gws-host.com -
Member Joomla Bug Squad & Joomla CMS Release Team

skyfranky
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Wed May 10, 2006 4:35 am

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

Post by skyfranky » Mon Oct 01, 2018 3:42 am

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?

skyfranky
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Wed May 10, 2006 4:35 am

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

Post by skyfranky » Mon Oct 01, 2018 8:18 am

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".


Post Reply

Return to “Installation Joomla! 3.x”