[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.

    https://www.ads-software.com/extend/plugins/amr-users/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author anmari

    (@anmari)

    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

    (@alternatewords)

    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

    (@anmari)

    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
    https://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.