Announcement

Collapse
No announcement yet.

mysql error in faq search after move

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

  • mysql error in faq search after move

    We moved to a new server a couple weeks ago and I've started seeing this error get mailed to me:
    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_update_profile', 'vb_poll_explain')
    OR
    faqname IN('vb_update_profile', 'vb_poll_explain')
    )

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

    mysql error number: 1267

    Date: Saturday 14th of May 2005 03:11:37 PM
    Script: http://www.ourdomain.com/forum/faq.php?s=&do=search&q=change&match=all&titlesonly=0
    Referer: http://www.ourdomain.com/forum/faq.php?
    This hadn't been a problem on the previous server (a hosted configuration) and I am suspecting that this might be an issue with the compilation of mysql.

    mysql was compiled with:
    ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --host=i386-redhat-linux
    No idea what the previous configuration used.

    Any suggestions?

  • #2
    This is a problem with MySQL 4.1.x:

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

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

    Comment

    Loading...
    Working...
    X