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.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Locked
skyfranky
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 102
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: 44038
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
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
JAVesey
Joomla! Hero
Joomla! Hero
Posts: 2623
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
Joomla 5.0.3 "live" site on PHP 8.2.15 and MariaDB 10.11.7
Joomla 5.0.3 on XAMMP for OSX with PHP 8.2.4 and MariaDB 10.4.28

skyfranky
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 102
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: 44038
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
"When I'm right no one remembers but when I'm wrong no one forgets".

skyfranky
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 102
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: 20652
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ 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 Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -

skyfranky
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 102
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! Enthusiast
Joomla! Enthusiast
Posts: 102
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".


Locked

Return to “Installation Joomla! 3.x”