Template fields have disappeared

Hi there!

We discovered two bugs today.
1) All input fields have disappeared on forms that were generated via autoform from PDF
2) All templates generated from an existing Formidable form have moved/squished all first-page content overlapping the second page (creating a blank first page).

Please advise!

Hi,

Unfortunately, we can't replicate an issue on our side and it does not look like a common issue. Was it any global changes on the website? New filters / actions added, restoring, etc. It looks like something is wrong with the database. If it's acceptable for you, can you please submit a support ticket with access details to WP Admin Dashboard here: https://e2pdf.com/support/request.

If you can include the details to access PHPMyAdmin it could speed up the issue investigation.

We remain at your service.

---

We would really appreciate your feedback at WordPress.org!

Hi,

Yes, indeed, some of the tables don't use Primary Keys as they are not required. We are currently checking if we can add a compatibility fix for it.

Was it some action before the error appeared like DB restoration / migration / upgrade etc? So we can understand what caused the error and at which stage.

---

We would really appreciate your feedback at WordPress.org!

We released a hot-fix to the RC version and working on preparing an update to the "Stable" version to make all tables have "Primary Key", however, we are not sure if the tables were not broken upon migration so updating to the RC version maybe could not resolve the issue.

You can try to complete SQL commands to be compatible with future updates:

ALTER TABLE `{our prefix}_e2pdf_pages` ADD COLUMN `PID` bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE `{our prefix}_e2pdf_elements` ADD COLUMN `PID` bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE `{our prefix}_e2pdf_revisions` ADD COLUMN `PID` bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

But, we are not sure that it will resolve the issue on the already migrated tables. In case it will not resolve, it would need to "import" backup to the SQL server that can hold data without "primary" keys, add "primary" keys with the command above and migrate these 3 tables to the DO.

If the issue still will appear, submit please support ticket. We would require access to PHPMyAdmin so we can see what else can be wrong with the structure.

P.S. Before doing any actions with MYSQL we highly recommend creating "backups".

---

We would really appreciate your feedback at WordPress.org!