Continue to article article, since I upgraded mysql to 4.1.8, my VBB has a new question:
When the FAQ search is sent from time to time, the database error will be encountered, and the description is as follows:
Database error in vBulletin 3.0.1: 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_custom_status', 'vb_update_profile', 'vb_calendar_how', 'vb_referrals_explain', 'vb_sig_explain', 'vb_user_maintain') OR faqname IN ( 'vb_custom_status', 'vb_update_profile' , 'vb_calendar_how', 'vb_referrals_explain', 'vb_sig_explain', 'vb_user_maintain')) mysql error: Illegal mix of collations (latin1_bin, IMPLICIT) and (latin1_swedish_ci, IMPLICIT) for operation '=' mysql error number: 1267 date: Thursday 06th Of january 2005 11:43:59 AM scripts:
http://club.zsnet.com/faq.php?s==do=search&q=
