close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

£ sign being changed on the live page

Thread began 9/10/2014 8:18 am by Jamie | Last modified 9/11/2014 11:13 am by Jason Byrnes | 2338 views | 15 replies |

Jamie

£ sign being changed on the live page

Hey Jason

On this live article pagehttp://bit.ly/1osfCpL, the £ sign is being rendered with £ both in the title area as well as the actual srticle content itself.

In the backend, the title is added using a text field whilst the article content is added using an html editor but both are causing this issue but have checked the unicode signature of the ckeditor.js nonetheless and it is checked. In the backend _results and _update pages the £ is being shown as it should be.

thanks for any pointers.....

Jamie

Sign in to reply to this post

Jason ByrnesWebAssist

I'll need to troubleshoot directly, see the private message section.

Sign in to reply to this post

Jamie

see PM

Sign in to reply to this post

Jason ByrnesWebAssist

looks like you are using a MySQLi connection to return the news article.

edit the MySQLi, and set the character set to UTF-8

Sign in to reply to this post

Jamie

thanks for taking a look....the character is set to utf-8 (on line 60) - do I need to do it specifically with the RS as well? if so, how do I do that? have done a quick search and not turned anything up....

Sign in to reply to this post

Jason ByrnesWebAssist

The FTP Login is failing now?

Response: 530 Login authentication failed
Error: Critical error
Error: Could not connect to server

Sign in to reply to this post

Jamie

sorry, try again

Sign in to reply to this post

Jason ByrnesWebAssist

I asked ray to have a look at this. He fixed it by updating the Connections/DBConnection.php and removing the line to set the character set to UTF 8.

It looks like your database table is not set to use UTF 8 encoding, so setting the character set in the connection to UTF 8 is causing the problem.

if the table does not use UTF 8 encoding, you cant use UTF 8 as the character set for the connection.

Sign in to reply to this post

Jamie

thanks to you both - how would i go about making a table UTF 8 'friendly'?

Also, not sure what has been done but 2 things are now a problem on the site that werent there before:

1. homepage slideshow image resizer is throwing up errors
2. more importantly, the navigation point 'cleaning products' should not be visible. In the back end if there are no entries or all entries in the cleaning products section are set to 'invisible' then the front end shouldnt show the navigation point... could you let me know what has been changed to stop this from working so I can go back in and fix please

cheers

jamie

Sign in to reply to this post

Jason ByrnesWebAssist

you would need to edit the table in the database and set the encoding to use UTF 8

1) the if statement for hiding the image if there is no file name was in the wrong lace, i updated that to correct the problem

2) Ray updated the recordset object to fix the no rows problem

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...