J4 on AWS Aurora: ERROR when saving article and category

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
Post Reply
CitW
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Thu Apr 12, 2018 8:24 am

J4 on AWS Aurora: ERROR when saving article and category

Post by CitW » Sun Nov 27, 2022 9:16 am

Hi

Just installed J4.2.5. Apache 2, PHP 8.1, AWS Aurora 2.10.2 (MySQL 5.7).

The problem is when I save article or category I get:
Save failed with the following error: The 'MEMORY' feature is disabled; you need MySQL built with 'MEMORY' to have it working
The data seems to be saved in some tables as e.g. when saving article '_content' and '_assets' tables are updated but the above error is still displayed and article I try to add doesn't appear under articles.

The db users has sufficient privileges to the db so it puzzles me why I get the error.

Any help would be greatly appreciated.

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 29635
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: J4 on AWS Aurora: ERROR when saving article and category

Post by Per Yngve Berg » Sun Nov 27, 2022 12:02 pm

Check that you have these two tables (#_finder_tokens, #_finder_tokens_aggregate). These are of type memory in my installation. The table type memory appears to be disabled in your datbase server.

CitW
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Thu Apr 12, 2018 8:24 am

Re: J4 on AWS Aurora: ERROR when saving article and category

Post by CitW » Sun Nov 27, 2022 12:13 pm

Hi

I do have both '#_finder_tokens' and '#_finder_tokens_aggregate' tables.

When I run:

Code: Select all

select * from information_schema.engines where engine='MEMORY';
I get:

Code: Select all

ENGINE: MEMORY
SUPPORT: YES
COMMENT: Hash based, stored in memory, useful for temporary tables
TRANSACTIONS: NO
XA: NO
SAVEPOINTS: NO
So it looks like table type memory is not disabled.

Also, on the same Apache and db servers, I have latest Joomla 3 site that works without problems and Joomla 4 (upgraded from 3, close to being launched) site that also works without these errors. That's why I'm so puzzled. The only difference between J4 sites is that the one that works was upgraded from J3 and one that doesn't work was a fresh J4 install.

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 29635
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: J4 on AWS Aurora: ERROR when saving article and category

Post by Per Yngve Berg » Sun Nov 27, 2022 12:47 pm

Articles will not show in Admin if the workflow entry is missing.

CitW
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Thu Apr 12, 2018 8:24 am

Re: J4 on AWS Aurora: ERROR when saving article and category

Post by CitW » Sun Nov 27, 2022 1:04 pm

Articles will not show in Admin if the workflow entry is missing.
Where would I find this "workflow entry"?

User avatar
ceford
Joomla! Ace
Joomla! Ace
Posts: 1496
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: J4 on AWS Aurora: ERROR when saving article and category

Post by ceford » Sun Nov 27, 2022 1:16 pm

See viewtopic.php?t=990519

A similar problem citing Google

Google Cloud does not support engine=memory which is used on two tables #__finder_tokens and #__finder_tokens_aggregate

CitW
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Thu Apr 12, 2018 8:24 am

Re: J4 on AWS Aurora: ERROR when saving article and category

Post by CitW » Sun Nov 27, 2022 2:20 pm

A similar problem citing Google
I have read that. Like I wrote in my previous post ENGINE: MEMORY is supported by AWS Aurora. I have also another J4 site on the same servers which is working.

The only difference between J4 sites is that the one that works was upgraded from J3 and one that doesn't work was a fresh J4 install.

User avatar
ceford
Joomla! Ace
Joomla! Ace
Posts: 1496
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: J4 on AWS Aurora: ERROR when saving article and category

Post by ceford » Sun Nov 27, 2022 4:02 pm

I have been looking though the code to try to understand this issue. I don't have the problem but I can trigger a stack trace that gives me a memory error totally unrelated to the problem. So I am not convinced the stated memory error is real.

I think the message you see comes from line 681 of libraries/src/MVC/Controller/FormController.php

Code: Select all

            $this->setMessage(Text::sprintf('JLIB_APPLICATION_ERROR_SAVE_FAILED', $model->getError()), 'error');
If you are game you can confirm that by adding this line before (or after):

Code: Select all

$this->setMessage('Confirm error is here!', 'error');
Then when you save an article you should see that message as well as the error message.

If the problem is there then the next task is figure out why the data is not being saved, on line 676.

CitW
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Thu Apr 12, 2018 8:24 am

Re: J4 on AWS Aurora: ERROR when saving article and category

Post by CitW » Mon Nov 28, 2022 10:39 am

Disabling Smart Search plugins sorts out the problem on AWS Aurora.


Post Reply

Return to “Installation Joomla! 4.x”