Announcement

Collapse
No announcement yet.

Database Error

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

  • PeterA
    replied
    Thanks for the very quick response, the database is being run on a third party webhost. I will read over the link again, but if I cant get them to fix it will just accept fixing it myself when I move to my own server next month.

    Leave a comment:


  • Steve Machol
    replied
    This is a bug in MySQL 4.1.x. Please see these threads:

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

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

    Also MySQL 4.1.12 has fixed this problem so you could upgrade to this version.

    http://www.vbulletin.com/forum/showt...464#post866464

    Leave a comment:


  • PeterA
    started a topic Database Error

    Database Error

    I am getting emailed this Database error

    Code:
     
    Invalid SQL: 
    SELECT faqname, faqparent, phrase.text AS title
    FROM vb3_faq AS faq
    INNER JOIN vb3_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_calendar_how', 'vb_edit_posts', 'vb_email_member',
    'vb_email_notification', 'vb_lost_password', 'vb_memberlist_how', 'vb_pm_explain',
    'vb_referrals_explain', 'vb_sig_explain', 'vb_update_profile', 'vb_use_cookies')
    OR
    faqname IN('vb_why_register', 'vb_calendar_how', 'vb_edit_posts', 'vb_email_member',
    'vb_email_notification', 'vb_lost_password', 'vb_memberlist_how', 'vb_pm_explain',
    'vb_referrals_explain', 'vb_sig_explain', 'vb_update_profile', 'vb_use_cookies')
    )
    
    mysql error: Illegal mix of collations (latin1_bin,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for
    operation '='
    The URL in question is /faq.php?s=&do=search&q=register&match=all&titlesonly=0

    I went to the url and just got the same response, another DB error. Have I misconfigured something?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X