Forums SQL Error

[doublek]

trying to post to the forum with no results keep getting an error.


SQL Error : 1271 Illegal mix of collations for operation ' IN '

INSERT INTO search_wordmatch (post_id, word_id, title_match) SELECT 74745

[doublek]

this is the coplete error:



SQL Error : 1271 Illegal mix of collations for operation ' IN '

INSERT INTO search_wordmatch (post_id, word_id, title_match) SELECT 74750, word_id, 0 FROM search_wordlist WHERE word_text IN ('reindex', 'options', 'ways', 'getting', 'completed', 'first', 'according', 'post', '14942', 'done', 'running', 'pollerreindexhosts', 'php', 'poller', 'shut', 'second', '13318', 'accomplished', 'clicking', 'green', 'button', 'real', 'issue', 'i', 'keep', 'network', 'devices', 'such', 'date', 'creating', 'cron', 'script', 'cause', 'issues', 'past', 'experiences', 'click', 'index', 'while', 'run', 'ok', 'able', 'create', 'causing', 'give', 'quick', 'rundown', 'include', 'break', 'system', 'maintain', 'it

[lungs71]

I am getting the same error. Did you figure out why?

Thanks!

[rony]

This is in the forums, right?

[turtleman]

i am getting same SQL error (SQL Error : 1271 Illegal mix of collations for operation ' IN ' ) when trying to start the new topic,
does anyone know how to go around this ? i can see people putting new posts so it does not affect everyone, i am just lost with that...

[NWA Cacti Admin]

I had the same problem. I had copied my post from MS Word and the Forum software got all confused with special characters like appostrophes (') and the like. I fixed all these and it posted fine.

[IT-Services-SMA]

I had the same error and now I know from my collegue that we germans often use the false symbol for "I've" also me.

I used the symbol near the "?" on my german keyboard but this isn't the right one for "I've" - we german guys have to use the " ' " from the cap "shift" + "#".

Best regards,

Peter

[kerry582]

For the last 2 days I've been getting this

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE forum_id = 21' at line 3

UPDATE forums SET forum_posts = forum_posts + 1, forum_last_post_id = WHERE forum_id = 21

Line : 423
File : functions_post.php

If I copy the text, back out to the index and try again it works, not the end of the world just a PITA

Kerry

[rony]

All these issues have been resolved.

Please PM me if you are still having issues posting.