Error on post-new.php & Elementor after WHM migration
Budget: $30 – $250 USD
Getting critical error after migrating to another hosting.
Tried everything from deactivating all plugins, default theme, database cleanup, increasing memorylimit, changing php version...
This bug happens with only Elementor plugin active (and Elementor Pro).
This bug happens with a default WordPress theme active.
this is maybe the fix:
I found out that for some reason, after exporting and importing the database manually by PHPMyAdmin, some tables missed their primary keys and/or auto increase attribute, which leads to a lot of records have 0 as the value for the ID column. As a result, WP and Elementor did not work properly.
Solution:
go through very tables to check whether they have primary key and auto increase or not. If not, set primary key for them, most likely the ID column.
*NOTE: you might need to remove the auto increase value first if that column has an auto increase attribute but not a primary key. Next, drop the index and after that set primary key then is auto increase.
I cant share access, can provide anydesk
Tried everything from deactivating all plugins, default theme, database cleanup, increasing memorylimit, changing php version...
This bug happens with only Elementor plugin active (and Elementor Pro).
This bug happens with a default WordPress theme active.
this is maybe the fix:
I found out that for some reason, after exporting and importing the database manually by PHPMyAdmin, some tables missed their primary keys and/or auto increase attribute, which leads to a lot of records have 0 as the value for the ID column. As a result, WP and Elementor did not work properly.
Solution:
go through very tables to check whether they have primary key and auto increase or not. If not, set primary key for them, most likely the ID column.
*NOTE: you might need to remove the auto increase value first if that column has an auto increase attribute but not a primary key. Next, drop the index and after that set primary key then is auto increase.
I cant share access, can provide anydesk