search

solspace / craft-express-forms

Express Forms for Craft: Intuitive and lightweight form builder that gets the job done but doesn’t get in your way.
https://docs.solspace.com/craft/express-forms/v2/
Other
13 stars 4 forks source link

Export CSV error #78

Closed DaveRayner closed 2 years ago

DaveRayner commented 3 years ago

When we click on a forms 'Export > CSV' button on the 'Forms' index page we get an SQL error. There is no error when we use the Export function at the bottom of a form's submissions page.

Craft Pro 3.7.14 Express Forms Lite 1.1.1

This is the error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'c.field_name' in 'field list' The SQL being executed was: SELECT s.id, s.dateCreated, c.title, c.field_name, c.field_email, c.field_message, c.field_dogma FROM expressforms_submissions s INNER JOIN expressforms_submissions_emailTestc ON c.elementId = s.id INNER JOIN expressforms_forms f ON f.id = s.formId INNER JOIN elements e ON e.id = s.id AND e.dateDeleted IS NULL WHERE (s.formId=6) AND (c.siteId=1) Error Info: Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'c.field_name' in 'field list' ) ↵ Caused by: PDOException SQLSTATE[42S22]: Column not found: 1054 Unknown column 'c.field_name' in 'field list' in /home/c9f9ui3ssu32/vendor/yiisoft/yii2/db/Command.php at line 1302

Thanks.

promediastyle commented 3 years ago

I have the same thing. The Excel upload does not work yet

kjmartens commented 2 years ago

Sorry for the delay... just to confirm @DaveRayner, is the field_name column present in your expressforms_submissions_yourformname database table? And which versions of PHP and MySQL are you using? :)

DaveRayner commented 2 years ago

All good - here are the answers:

1) The field_name column is labeled 'field_name_kviwwmtq' in the DB (the other Expressforms also have a random set after each field name)

2) PHP 7.4.22 MySQL 5.6.51

And just again - the 'Export' function at the bottom of the form's submissions page works - it's the 'Exports > CSV' function that doesn't play ball.

Thanks!

kjmartens commented 2 years ago

Would you be able to provide me with a copy of your database for review? You can send it to support@solspace.com. 🙂

kjmartens commented 2 years ago

We can now duplicate this issue as well. It seems that a recent Craft update is causing this. We'll check into this and get a fix out probably this week.

angelokeirsebilck commented 2 years ago

Any updates on this?

kjmartens commented 2 years ago

I'm very sorry for the delay. We're going to have a developer look into this and address it early next week (Monday or Tuesday). Thank you for your patience. :)

kjmartens commented 2 years ago

This is now fixed in v1.1.2. 🙂