MQSeries.net :: View topic - possibility of integrating mobile devices

mrmhikel890

Hey everyone,

If you?re getting this message while trying to post on the forum:

SQL Error : 1271 Illegal mix of collations for operation 'IN'
Line : 251 ? File : functions_search.php

Here?s what it means and how to fix it 👇

This error usually appears when your forum?s database tables are using different text collations ? for example, one might be using utf8_general_ci and another utf8mb4_unicode_ci. Because of this mismatch, the system can?t compare or insert words properly into the search index.

✅ Quick Fix Steps:
Log into your database (phpMyAdmin).
Run these commands to check collations:
SHOW TABLE STATUS LIKE 'phpbb_search_wordlist';
SHOW TABLE STATUS LIKE 'phpbb_search_wordmatch';

If the collations are different, make them match (recommended: utf8mb4_general_ci):
ALTER TABLE phpbb_search_wordlist CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE phpbb_search_wordmatch CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

After that, clear and rebuild the search index in the PHPBB Admin Control Panel.

This should resolve the error and allow you to post normally again ? including threads about TM SIM registration and related discussions.

If you?ve fixed this issue or found another workaround, please share your experience below so others can benefit too!

You said:
Hi All,

I am trying to explore the possibility of integrating mobile devices with Websphere process server and Websphere ESB.

Has anyone done something like this before ? is there any reading materials/ links that could help me with this ?

In my search so far, I've discovered that JSON/http webservices could be one choice and the other one being Websphere MQ everyplace.

Are there any other option(s) - please help.