Hi
When doing a search 'FAQ', if the option 'Search In' is set to 'Search Titles & Text' I get this SQL error, this happens on any Windows server I try running VB under (IIS, Sambar, Apache), on my Unix server this does not happen! I tried different versions of PHP including 4.2.1 up to 4.3.9 and different versions of MySQL Server.
The VB error ouput! (it's always the same thing!)
Is there something I can do to fix this!
TIA
F!
When doing a search 'FAQ', if the option 'Search In' is set to 'Search Titles & Text' I get this SQL error, this happens on any Windows server I try running VB under (IIS, Sambar, Apache), on my Unix server this does not happen! I tried different versions of PHP including 4.2.1 up to 4.3.9 and different versions of MySQL Server.
The VB error ouput! (it's always the same thing!)
Code:
Database error in vBulletin 3.0.3: Invalid SQL: SELECT faqname, faqparent, phrase.text AS title FROM bbs_faq AS faq INNER JOIN bbs_phrase AS phrase ON(phrase.phrasetypeid = 7000 AND phrase.varname = faq.faqname) WHERE phrase.languageid IN(-1, 0, 1) AND ( faqparent IN('vb_avatar_how', 'vb_calendar_how', 'vb_clear_cookies', 'vb_email_member', 'vb_email_notification', 'vb_memberlist_how', 'vb_pm_explain', 'vb_referrals_explain', 'vb_rss_syndication', 'vb_smilies_explain', 'vb_special_codes', 'vb_update_profile') OR faqname IN('vb_avatar_how', 'vb_calendar_how', 'vb_clear_cookies', 'vb_email_member', 'vb_email_notification', 'vb_memberlist_how', 'vb_pm_explain', 'vb_referrals_explain', 'vb_rss_syndication', 'vb_smilies_explain', 'vb_special_codes', 'vb_update_profile') ) mysql error: Illegal mix of collations (latin1_bin,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' mysql error number: 1267 Date: Wednesday 17th of November 2004 07:24:57 PM Script: http://......?s=&do=search&q=php&match=all&titlesonly=0 Referer: http://....../faq.php? Username: ..... IP Address: .....
TIA
F!
Comment