search

WormBase / ACKnowledge

Author Curation to Knowledgebases
MIT License
1 stars 1 forks source link

Can't add single quotes to final comments #208

Closed valearna closed 2 years ago

valearna commented 2 years ago

Adding quotes brakes the SQL query to insert comments

valearna commented 2 years ago

The issue affects most of the free text fields. Fixed by using psycopg2 functions to manage strings in SQL queries

valearna commented 2 years ago

It seems that the author form is ok but there are issues with the dashboard: http://textpressocentral.org:3001/paper?paper_id=00059442

valearna commented 2 years ago

I had to changed the escape function in the dashboard API to deal with quotes. Now everything looks good to me. You can continue testing the dashboard @draciti @vanaukenk

vanaukenk commented 2 years ago

I tested adding quotes and other special characters in the final comment of this paper: http://textpressocentral.org:3001/paper?paper_id=00059413 Things look okay in the dashboard.

draciti commented 2 years ago

copy that. Closing