Title: [Plugin: AmR Users] SQL errors when including fields containing '-character
Last modified: August 19, 2016

---

# [Plugin: AmR Users] SQL errors when including fields containing '-character

 *  [Alternatewords](https://wordpress.org/support/users/alternatewords/)
 * (@alternatewords)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/plugin-amr-users-sql-errors-when-including-fields-containing-character/)
 * First off, excellent plug-in, exactly what I needed for a closed, members only
   site to provide a nice members list to everyone.
 * I do have one one issue though I am running into when generating reports: I include
   the “Biographical Info” from each user’s profile. Naturally it often includes
   the ‘-character (I’m, haven’t, don’t etc.) which leads to MySQL errors when I
   generate the reports and those records being skipped. Is there a way to escape
   the ‘? It would be great to include the bios on the members list.
 * [http://wordpress.org/extend/plugins/amr-users/](http://wordpress.org/extend/plugins/amr-users/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [anmari](https://wordpress.org/support/users/anmari/)
 * (@anmari)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/plugin-amr-users-sql-errors-when-including-fields-containing-character/#post-1686715)
 * I have an update to put which I think fixed that (have been making sure it worked
   with all kinds of foreign characters, so would be stupid if it didn’t handle 
   the quotes 🙂 – let me spend some time double checking and then the update will
   go up.
 *  Thread Starter [Alternatewords](https://wordpress.org/support/users/alternatewords/)
 * (@alternatewords)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/plugin-amr-users-sql-errors-when-including-fields-containing-character/#post-1686764)
 * Excellent! Just noticed the update, installed, all’s well now with my lists.
 * I do have one more question. I am using the shortcode to output one of the lists
   on a page. I know the table’s properties are set according to my theme’s CSS.
   However, I seem unable to resize the table in any way, no mater what width I 
   define. Currently it’s spanning beyond the content column so the right most border
   is missing, even though the right list column doesn’t contain any overlong consecutive
   strings. Maybe I’m simply overlooking something? Any hint would be greatly appreciated.
 *  Plugin Author [anmari](https://wordpress.org/support/users/anmari/)
 * (@anmari)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/plugin-amr-users-sql-errors-when-including-fields-containing-character/#post-1686822)
 * Hmm – it is a general ongoing table problem i’ve not yet felt that I had a definitive
   solution for. (Too wide tables I mean).
 * If the content is too wide the browsers do different things. One the one hand
   one wants the columns to be flexible to deal with whatever content may come up,
   but then that does not always work!
 * Some notes here for my other plugin (had long urls in a table) may help
    [http://icalevents.anmari.com/2685-long-urls-in-event-content/](http://icalevents.anmari.com/2685-long-urls-in-event-content/)
 * So far I try to look at the content and see what flexibility I have in encouraging
   it to wrap by adding spaces – or not by replacing spaces with non breaking spaces

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘[Plugin: AmR Users] SQL errors when including fields containing '-character’
is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/amr-users_f6f6f4.svg)
 * [amr users](https://wordpress.org/plugins/amr-users/)
 * [Support Threads](https://wordpress.org/support/plugin/amr-users/)
 * [Active Topics](https://wordpress.org/support/plugin/amr-users/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/amr-users/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/amr-users/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [anmari](https://wordpress.org/support/users/anmari/)
 * Last activity: [15 years, 7 months ago](https://wordpress.org/support/topic/plugin-amr-users-sql-errors-when-including-fields-containing-character/#post-1686822)
 * Status: not resolved