Storage engine MEMORY is disabled (Table creation is disallowed).
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
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
-
- Joomla! Enthusiast
- Posts: 102
- Joined: Wed May 10, 2006 4:35 am
Storage engine MEMORY is disabled (Table creation is disallowed).
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"?
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"?
- Webdongle
- Joomla! Master
- Posts: 44038
- Joined: Sat Apr 05, 2008 9:58 pm
Re: Storage engine MEMORY is disabled (Table creation is disallowed).
viewtopic.php?f=714&t=793531 please
But best change host.
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".
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".
- JAVesey
- 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).
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).
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
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
-
- Joomla! Enthusiast
- Posts: 102
- Joined: Wed May 10, 2006 4:35 am
Re: Storage engine MEMORY is disabled (Table creation is disallowed).
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: MaybeFolder 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) |
- Webdongle
- Joomla! Master
- Posts: 44038
- Joined: Sat Apr 05, 2008 9:58 pm
Re: Storage engine MEMORY is disabled (Table creation is disallowed).
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
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".
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".
-
- Joomla! Enthusiast
- Posts: 102
- Joined: Wed May 10, 2006 4:35 am
Re: Storage engine MEMORY is disabled (Table creation is disallowed).
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)
Storage engine MEMORY is disabled (Table creation is disallowed)
- leolam
- 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).
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
Leo
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
-
- Joomla! Enthusiast
- Posts: 102
- Joined: Wed May 10, 2006 4:35 am
Re: Storage engine MEMORY is disabled (Table creation is disallowed).
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?
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?
-
- Joomla! Enthusiast
- Posts: 102
- Joined: Wed May 10, 2006 4:35 am
Re: Storage engine MEMORY is disabled (Table creation is disallowed).
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".