Fatal error when activating plugin

Hi Michael!

Can you run this query in your database and show us output?

show create table olp_t_computed_variables;

Also run this query and show us the results:

select @@version, @@innodb_version, @@innodb_large_prefix;

Possible workaround is here: https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_large_prefix

Same problem here, there is another option without change global MySQL server variables?

Thanks!

@vguerrero can you tell your’s SQL results?

show create table olp_t_computed_variables;
select @@version, @@innodb_version, @@innodb_large_prefix;

To solve the issue I need to repeat it. Currently I can’t repeat it locally.

Sure:

1) show create table olp_t_computed_variables;

#1146 – Table ‘atrevete_bd.olp_t_computed_variables’ doesn’t exists

2) select @@version, @@innodb_version, @@innodb_large_prefix

If you need more info, tell me!

Regards

• This reply was modified 7 years, 9 months ago by vguerrero.

@vguerrero try them something like

show tables like '%computed_variables';

It will show you it with correct name.

Your name could be like “wp_”?

So something like show create table wp_t_computed_variables; could show more.

Also run something like show variables; and send me to email [email protected] — I will try to download same DB version to repeat the issue.

Hi Alex,

That did the trick, this is the info dumped when query show create table wp_t_computed_variables;

Original size: 384

I’m going to send you the show variables dump in some minutes by email.

Regards

• This reply was modified 7 years, 9 months ago by vguerrero.

@vguerrero pls show the content of “Create Table” cell.

This is:

@vguerrero I see charset utf8mb4! May be it’s our issue cause. Anyway it helps more.

It’s the default charset when you add a new database from Plesk Panel, dude! :S

Pls upgrade to 0.20.1.

I think I fixed the issue.

Same problem here. The update did fix the issue ??

• This reply was modified 7 years, 9 months ago by Enis.

@enistrevisi did update fixed the issue? Sorry for incovinience ((

Yes, it did ??

Thank you!