' is coming through as ' via feed source

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Paddy Murphy
    Member
    • Jun 2014
    • 33
    • 4.2.x

    [Forum] ' is coming through as ' via feed source

    The character ' is coming through as ' in thread titles.

    This is what I'm doing;

    1. Using this feed from Google Alerts (https://www.google.ie/alerts/feeds/0...58734532630058).
    2. I'm then putting it through feedburner because I'm using vBulletins' (4.2.2) RSS Feed manager to post threads this forum section and I was getting this error - XML Error: not well-formed (invalid token) at Line 1 - and I don't get that error now with feedburner.

    How can I stop this from happening?

    Thank you

    Last edited by Paddy Murphy; Wed 14 Jan '15, 3:51pm. Reason: update info
  • Paddy Murphy
    Member
    • Jun 2014
    • 33
    • 4.2.x

    #2
    Please Help!!!

    Comment

    • Zachery
      Former vBulletin Support
      • Jul 2002
      • 59097

      #3
      The characters are still being encoded wrong?

      Comment

      • Paddy Murphy
        Member
        • Jun 2014
        • 33
        • 4.2.x

        #4
        Originally posted by Zachery
        The characters are still being encoded wrong?
        Yes.

        Please see my screenshot. Click image for larger version

Name:	'.JPG
Views:	62
Size:	176.4 KB
ID:	4262146

        Comment

        • Zachery
          Former vBulletin Support
          • Jul 2002
          • 59097

          #5
          Probably, the easiest way to fix it is to use a replacement var. Does your server have iconv installed? mbstring? What is the encoding on the database?

          Comment

          • Paddy Murphy
            Member
            • Jun 2014
            • 33
            • 4.2.x

            #6
            Originally posted by Zachery
            Probably, the easiest way to fix it is to use a replacement var.
            I tried that already. I doesn't work on ' it doesn't change it.

            Originally posted by Zachery
            Does your server have iconv installed? mbstring?
            I don't know. I didn't install those on the server anyway.

            Originally posted by Zachery
            What is the encoding on the database?
            • Server charset: UTF-8 Unicode (utf8) I think ?;

            Database server

            • Server: Localhost via UNIX socket
            • Server type: MySQL
            • Server version: 5.5.40-cll - MySQL Community Server (GPL)
            • Protocol version: 10
            • Server charset: UTF-8 Unicode (utf8)

            Web server

            • cpsrvd 11.46.0.17
            • Database client version: libmysql - 5.1.73
            • PHP extension: mysqli

            Comment

            • Zachery
              Former vBulletin Support
              • Jul 2002
              • 59097

              #7
              Ask your webhost if mbstring and iconv are available in PHP. Check the post, and thread tables, see what their character encoding are set to.

              Are you sure you added ' to the right style for the stylevar replacements?

              Comment

              • Paddy Murphy
                Member
                • Jun 2014
                • 33
                • 4.2.x

                #8
                Hi Zachery,

                I opened a support ticket with my host. They said;

                Please check the encoding set up for your database - this is most likely to be the cause of this issue.

                You can check and change this in the phpmyadmin and mySQL database sections of your cPanel.

                You may need to search/replace existing items in the database to change them to the correct character.

                I've gone into phpmyadmin and indeed, all the table were/are latin1_swedish_ci

                I've changed two tables (post & thread) to utf8_general_ci but I still have the same issue. I think it would be best to change all 248 tables to utf8_general_ci ?

                Is there a query for that?

                Please advise

                Regards,

                Paddy

                Comment

                • Paddy Murphy
                  Member
                  • Jun 2014
                  • 33
                  • 4.2.x

                  #9
                  Hi,

                  Here's more information that I have gathered into the issue I'm having. Apparently iconv & mbstring are enabled on the server I'm on. I've gone into phpmyadmin and my vBulletin database is latin1_swedish_ci

                  I've changed two tables (post & thread) to utf8_general_ci but I still have the same issue.

                  Where can I go from here?

                  Comment

                  • Paddy Murphy
                    Member
                    • Jun 2014
                    • 33
                    • 4.2.x

                    #10
                    Originally posted by Zachery
                    Are you sure you added ' to the right style for the stylevar replacements?
                    Yes, I'm 100% positive. It doesn't work.

                    Where can I go from here?

                    Regards,

                    Paddy

                    Comment

                    • Zachery
                      Former vBulletin Support
                      • Jul 2002
                      • 59097

                      #11
                      Not much else we can do, its a problem with the data coming in. vBulletin.org is probably where you need to go next.

                      However, you might need to do ' instead in your stylevar replacement.

                      Comment

                      • Paddy Murphy
                        Member
                        • Jun 2014
                        • 33
                        • 4.2.x

                        #12
                        Originally posted by Zachery
                        However, you might need to do ' instead in your stylevar replacement.
                        That worked!

                        Thanks

                        Comment

                        • Zachery
                          Former vBulletin Support
                          • Jul 2002
                          • 59097

                          #13
                          Well, at least we've got a work around now

                          Comment

                          • mradlin
                            New Member
                            • Jul 2008
                            • 13
                            • 4.2.X

                            #14
                            Originally posted by Zachery
                            Not much else we can do, its a problem with the data coming in. vBulletin.org is probably where you need to go next.

                            However, you might need to do ' instead in your stylevar replacement.
                            I'm having the same issue Paddy. what exactly did you enter in the replacement variable?
                            Thanks

                            Comment

                            • Paddy Murphy
                              Member
                              • Jun 2014
                              • 33
                              • 4.2.x

                              #15
                              Originally posted by mradlin

                              I'm having the same issue Paddy. what exactly did you enter in the replacement variable?
                              Thanks
                              ...
                              Attached Files

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...