SQL error on posting

This area is for the discussion of what's new, what's on your mind, and general photographic topics. A place to meet, make comments on this site, and get the latest community news.

Moderators: ChrisR, Chris S., Pau, rjlittlefield

Post Reply
Posts: 0
Joined: Sun Mar 16, 2014 2:23 pm
Location: Gothenburg, Sweden

SQL error on posting

Post by monocultured »


I'm getting an error when I try to post. Not sure how to resolve it, suggestions?

Code: Select all

Could not insert new word matches


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

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 213300, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('following', 'post', 'couple', 'years', 'lull', 'ive', 'taken', 'again', 'read', 'bit', 'curious', 'epi', 'illumination', 'tube', 'mounted', 'wrong', 'order', 'image', 'below', 'quot', 'part', 'aperture', 'sure', 'shouldnt', 'closest', 'light', 'right', 'thoughts', 'both', 'symbols', 'apertures', 'perhaps', 'everything', 'reviewed', 'professional', 'options', 'mounting', 'slr', 'trying', 'reputable', 'ebay', 'vendor', 'started', 'pro', 'solution', '?1000€', 'lens', 'ill', 'poke', 'forum', 'wondering', 'sellers', 'care', 'reccomend')

Line : 251
File : functions_search.php

Post Reply