Project Nami with Elementor - Form Submissions Not Working

[Aprilsou]

Hi folks,

I'm using the latest versions of Project Nami and Elementor Pro and the site I'm admining doesn't seem to be storing Elementor form submissions (all forms on the website use the Collect Submissions action). I can't find them stored anywhere in the database and when I look in the Submissions tab, it says "Loading..." but never loads

I'm not very experienced with PHP and the Wordpress infrastructure, but I know other people have used Elementor and Project Nami so hoping I can get some advice - just knowing where the submissions are meant to be stored would help!

[Aprilsou]

I've been doing some digging into this and I'm posting my findings here in case anyone else finds them useful.

Elementor Pro Forms store data in three tables - their names are e_submissions, e_submissions_values, and e_submissions_actions_log, defined in wp-content/plugins/elementor-pro/modules/forms/submissions/database/query.php. These are then saved alongside the table prefix (e.g. "wp_") as table_submissions, table_submissions_values, and table_submissions_actions_log

The tables themselves are created in wp-content/plugins/elementor-pro/modules/forms/submissions/database/migrations/initial.php in a function named create_tables. This function contains three CREATE TABLE statements which it stores as variables then executes using the dbDelta command.

Someone who knows more T-SQL than me has pointed out that these statements use MySQL-specific syntax such as auto_increment rather than IDENTITY(1,1), which is why these tables haven't been created and submissions cannot be stored - I'm planning to try and create these tables directly and will post another update with how that goes.

[StevybSC]

I've been doing some digging into this and I'm posting my findings here in case anyone else finds them useful.

Elementor Pro Forms store data in three tables - their names are e_submissions, e_submissions_values, and e_submissions_actions_log, defined in wp-content/plugins/elementor-pro/modules/forms/submissions/database/query.php. These are then saved alongside the table prefix (e.g. "wp_") as table_submissions, table_submissions_values, and table_submissions_actions_log

The tables themselves are created in wp-content/plugins/elementor-pro/modules/forms/submissions/database/migrations/initial.php in a function named create_tables. This function contains three CREATE TABLE statements which it stores as variables then executes using the dbDelta command.

Someone who knows more T-SQL than me has pointed out that these statements use MySQL-specific syntax such as auto_increment rather than IDENTITY(1,1), which is why these tables haven't been created and submissions cannot be stored - I'm planning to try and create these tables directly and will post another update with how that goes.

We're seeing the same type of issue, did you get any success with manually creating the tables?

[Aprilsou]

We're seeing the same type of issue, did you get any success with manually creating the tables?

Unfortunately it wasn't as simple as just making the tables, I also had to change some of the INSERT queries written into the Elementor plugin files. I did manage to get it to the point where entries were being added, but it still wasn't being read and displayed properly elsewhere in the application.

I ended up creating a log of all SQL commands run against the database - I'm fairly sure the method I used was the one in this stack overflow thread - and having seen the output of that, I think to comprehensively fix it would require a fair amount of time and better knowledge of SQL vs MySQL syntax than I currently have. If someone did make a version of Elementor compatible with Project Nami, I believe they should be free to distribute it, as Elementor's Terms of Service say their software is under a GPLv3 license.

I've ultimately switched to a standard Wordpress install as it seems like most plugins just aren't built to be MS SQL compatible, and not all bugs they cause are obvious straight away (I previously caught Elementor's auto-updater writing hundreds of lines to the wp_options table). Hope you have better luck than I did!