Text Area in Data Project Edit

Hi Charles,

Any database column defined as TEXT should be shown as a textarea on your data entry forms. Can you confirm your column has datatype TEXT?

Best regards,
Peter

I’m not at my machine right now but I checked earlier. There were three fields identified as text in the back end definition dialogue. I am using this project in a front end form. All fields show as single line. I defined it before 3.0.

Hi Charles,

Textareas should work in a Data Project as well. Not sure what you mean with “as text in the back end definition dialogue”, these column need to be text column in the database.

Best regards,
Peter

When defining the project, in the back end, there is a set up page for what columns/fields to include and the order. That is the page that shows the type as text. But I was able to look at the MySQL schema and the columns are defined as mediumtext.could that be the problem?

That is the problem Charles! I’ll add the other TEXT alternatives tonight and let you know. You’ll need to reinstall te plugin, but you’ll have it working tomorrow.

Best regards,
Peter

Thanks

Hi Charles,

I added textarea support for all text columns (tinytext, text, mediumtext, longtext).

I patched the current version (3.0.1) so you need to reinstall it. Make sure you do this before you delete the plugin:
– Go to menu Settings > WP Data Access
– Click tab Uninstall
– Unselect the checkboxes for “Delete plugin tables (all data will be lost)” and
“Delete plugin settings (all settings will be lost)”

If you don’t do this your repository will be deleted and you lose all your publications, projects and so on!

Best regards,
Peter

Thanks. I’ll do it first thing tomorrow, eastern time zone

I can’t get to a machine at the moment

I’m always nervous about the potential finality of “uninstall/delete” so forgive my caution.

We are a multi site setup. The WPDA Settings -> uninstall menu selection is available in individual site dashboards but not the network admin menu. I have super admin role. What do you suggest?

This is NOT urgent so I’d rather wait and get it right.

Thanks for your patience.

Charles Godwin

I’m always nervous about the potential finality of “uninstall/delete”… ?? Me too!

There is another possibility! Only file WPDA_Simple_Form.php needs to be replaced. You can upload just that file. It needs to be in folder:
plugins/wp-data-access/WPDataAccess/Simple_Form/

Only thing…how can I transfer that file to you?

Best regards,
Peter

I’ll grab the file from your repository at https://bitbucket.org/wpdataaccess/wp-data-access/src/master/

Thanks

That fixed it. Thanks.

Great! ??

A follow up bug. This is NOT urgent, put it on your someday list.

In both the back-end and front end use of Data project, selecting view give you read only for all fields except textarea fields. The ‘readonly’ attribute is missing in the textarea tag.

Thank you for reporting Charles! I fixed it right away. If you want to update, it’s in the same file… ??

Best regards,
Peter