Announcement

Collapse
No announcement yet.

Problem when searching FAQs

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem when searching FAQs

    I went to search the FAQs on my own system and got this:

    Database error in vBulletin 3.0.3:

    Invalid SQL:
    SELECT faqname, faqparent, phrase.text AS title
    FROM faq AS faq
    INNER JOIN phrase AS phrase ON(phrase.phrasetypeid = 7000 AND phrase.varname = faq.faqname)
    WHERE phrase.languageid IN(-1, 0, 1)
    AND (
    faqparent IN('vb_why_register', 'vb_referrals_explain')
    OR
    faqname IN('vb_why_register', 'vb_referrals_explain')
    )

    mysql error: Illegal mix of collations (latin1_bin,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

    SWEDISH? Does anyone know where this is coming from or how to fix it? Maybe it will fix my other problems....thanks in advance.

  • #2
    Hello,

    Apologies for the late reply.

    I believe this is due to an issue with MySQL. Upgrade MySQL to the latest version and this issue should be resolved.

    Comment


    • #3
      As i understand it, this is a problem with MySQL 4.1.7. See this thread http://www.vbulletin.com/forum/showthread.php?t=121120 - there is a fix at the bottom which worked for me.

      Comment


      • #4
        Brilliant!

        Instant fix...thank you!!!

        Comment


        • #5
          Originally posted by Dragon
          Instant fix...thank you!!!
          Happy to hear that worked out for you and nice to see it fixed so soon. Enjoy the FAQ engine from vBulletin! And please let me know if you require any further assistance.

          Comment

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