User List does not show special characters right

17 years 8 months ago #19632 by geeffland
In the user lists I created a simple list that shows the name and username along with a few other fields. In the name field I have some names with & which show up as &

Greg

CB3PD Developer - CB Connector (formerly phpBB Connector) plugin

Please Log in to join the conversation.

17 years 8 months ago #19646 by beat
geeffland wrote:

In the user lists I created a simple list that shows the name and username along with a few other fields. In the name field I have some names with & which show up as &

Greg


You mean & a m p ; ?

If you use "name", this is a Joomla field.

Indeed, Joomla from around version 1.0.9 added html specialcharacters treatment into their database record.

I believe this is a Joomla bug, as database records should be clear-text.

This escaping should happen at display time and not at database storage time.

Please post into joomla Q&T 1.0 forum and on Joomla 1.0 bugtracker.

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

17 years 8 months ago #19661 by geeffland
I will post over there as well..

did some quick digging...

database has & a m p ;
both Joomla user manager and detail (after selection) show it correctly as &

CB user management list is ok but detail view is still & a m p ;

So it looks like Joomla is processing it with the & a m p ; so not too sure if they will call it a bug... will report anyway though

thanks,
greg

CB3PD Developer - CB Connector (formerly phpBB Connector) plugin

Please Log in to join the conversation.

17 years 8 months ago #19667 by beat
It IS a bug, since it breaks any searches in the database.

You never want to have escaped text with & a m p ; or \ ' in a database, as it breaks searches.

This correction will be to late for Joomla 1.0.11, so it belongs to Joomla's bug tracker (maybe put URL to this thread in there, so the discussion, reasons and follow-ups are catched)

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

17 years 8 months ago #19755 by geeffland

CB3PD Developer - CB Connector (formerly phpBB Connector) plugin

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.168 seconds

Facebook Twitter LinkedIn