Fatal error when logging in

Hi,

The error you get indicates that one of the database tables that Groups creates – and requires – is missing. This table stores information about groups that the plugin handles and is essential.

This table should not be missing and must have been deleted by accident. Or if you have moved the site to another server, maybe the table was not imported.

I would recommend to recover from a backup to make sure your database is consistent.

Regarding the extension, yes, it requires Groups to be active. The table that is missing is essential for Groups, thus it is also essential for the extension to work properly.

Hi, thanks for the quick response,

I haven‘t moved the site or changed anything besides updating WP.
Will it be enough to recover the backup of just the plugin as there are a couple of customers and purchases and I don‘t know exactly when this issue occured.

You’re very welcome, I hope this will help, I would recommend to following steps:

First make a backup of the site and database as it currently is.

From your previous backup, look at the database backup and find the CREATE TABLE v4x_groups_group ... statement for the table that is missing. Use that statement to create the table. Locate the INSERT INTO v4x_groups_group ... statement that will insert the group data into the table.

If that table is the only one missing, then this could solve the issue for you.

If your database has been corrupted further than just this missing table, you will need to consider the decision to revert to a previous backup and insert the new data after that.

Hi, thanks for the detailed instruction.
As I had to find a quick solution, I run the backup completely yesterday.
It worked again, means, no fatal error and a customer when purchasing a certain product got registered immediately.
Today morning I tried it again and after several attempts to get in as testuser (not getting logged in – without any message!), suddenly the fatal error came back!

Turning off the plugin the login works again (without the register function though!)

So something must be causing the database malfunction.

My login form is created by elementor.

I‘m not very comfortable with editing the database.

Any further advice please?

regards

Hi, I think I got it fixed.

The strong database caching caused the issue!

I compared some old and new (malfunctioned) databases, but didn‘t find something missing.
So there must have been some other trigger. … it was the W3 total cache plugin with the strong database caching activated.
After turning this off, everything works fine.

thanks, best regards

Nice plugin, btw, works perfect for our usecase

Thank you very much for posting your findings, would you mind letting us know which exact settings in W3TC you were using when this happened? It would be interesting to research it on our side.

Hi, sure, where can I upload the json file of the settings (with database cache enabled)

I think it’s better not to share your exported settings in case it contains any sensitive data. If you recall which settings were used in the database caching section, that would already be helpful. I was asking because you mentioned “strong database caching activated” and I’m not sure what settings that would involve in W3TC.

Ok, so I simply activated/deactivated “database cache” in the general settings in W3TC. No advanced settings. With “strong” I meant it had a strong effect ??

regards

Thank you very much, that is very helpful! The effect was strong indeed ??

Cheers!