PDA

Archiv verlassen und diese Seite im Standarddesign anzeigen : FAQ Fehlerhaft?


Professor Haase
01.04.2005, 22:25
Die Fehler bekomme ich irgendwie ständig, wo dran liegt das?


Datenbankfehler in vBulletin 3.0.7:

Ungueltige SQL-Abfrage:
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, 2)
AND (
faqparent IN('vb_avatar_how')
OR
faqname IN('vb_avatar_how')
)

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

mysql error number: 1267




-------------------------------------------------------------------------

Datenbankfehler in vBulletin 3.0.7:

Ungueltige SQL-Abfrage:
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, 2)
AND (
faqparent IN('vb_avatar_how', 'vb_calendar_how', 'vb_custom_status', 'vb_email_member', 'vb_email_notification', 'vb_memberlist_how', 'vb_pm_explain', 'vb_referrals_explain', 'vb_sig_explain', 'vb_smilies_explain', 'vb_special_codes', 'vb_update_profile', 'vb_why_register')
OR
faqname IN('vb_avatar_how', 'vb_calendar_how', 'vb_custom_status', 'vb_email_member', 'vb_email_notification', 'vb_memberlist_how', 'vb_pm_explain', 'vb_referrals_explain', 'vb_sig_explain', 'vb_smilies_explain', 'vb_special_codes', 'vb_update_profile', 'vb_why_register')
)

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

mysql error number: 1267

Mystics
01.04.2005, 23:55
Folge dem Link im sechsten Beitrag:
http://www.vbulletin-germany.com/forum/showthread.php?t=15072&highlight=Illegal+mix+collations