Announcement

Collapse
No announcement yet.

FAQ.php MySQL errors... weird.

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

  • FAQ.php MySQL errors... weird.

    The only MySQL errors I ever receive are from URLs like this:
    Script: http://swdf.smashsworld.com/faq.php?...l&titlesonly=0

    And it always says like "Invalid Query" or what not.

    Database error in vBulletin 3.0.7:

    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_referrals_explain')
    OR
    faqname IN('vb_referrals_explain')
    )

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

    mysql error number: 1267

    Date: Monday 21st of March 2005 03:12:39 AM
    Script: http://swdf.smashsworld.com/faq.php?...l&titlesonly=0
    Referer:
    Username: Unregistered
    IP Address: (not posted)
    Anybody know how to fix this?

  • #2
    This is a bug in MySQL 4.1.x. Please see these threads:

    Bug report:
    http://www.vbulletin.com/forum/bugs...view&bugid=3627

    Workaround:
    http://www.vbulletin.com/forum/showthread.php?t=125929

    Comment


    • #3
      So should I use a previous version of MySQL instead?

      Comment

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