Illegal mix of collations for operation

Home

Forum

Remository Forum

home | post reply | threaded view | help | rules

Boardwalk :: Forum List

Glossary

Support Glossary

Paul Sellis

Karma: 0

Illegal mix of collations for operation - 2010/06/25 09:22 Hi,

I use Glossary27RCJ

For an unknown reason I get this alert at the begin of one page but the article is published after this message)

No valid database connection Illegal mix of collations for operation ' IN ' SQL=SELECT g.id, a.termalias AS tterm, g.catid FROM jos_glossary_aliases AS a INNER JOIN jos_glossary AS g ON a.termid = g.id WHERE g.published != 0 AND a.tfirst IN ('Lorem', 'ipsum') UNION SELECT s.id, s.tterm, s.catid FROM jos_glossary AS s WHERE s.published != 0 AND s.tfirst IN ('Lorem', 'ipsum') ORDER BY length(tterm) DESC

Any idea?

| | Sorry, you do not currently have permission to write here.

admin Karma: 98	Re:Illegal mix of collations for operation - 2010/06/25 10:16 There must be inconsistent collation settings within your glossary database tables. Martin Brampton aka Counterpoint http://aliro.org http://black-sheep-research.com
	\| \| Sorry, you do not currently have permission to write here.

Paul Sellis

Karma: 0

Re:Illegal mix of collations for operation - 2010/06/25 10:59 Yes thank you!

I had jos_cmsapi_configurations and jos_glossary in latin1_swedish_ci but not in utf8_general_ci like other tables...

A wrong Joomla install process as main database was also in latin1_swedish_ci?

I corrected this last point with phpMyAdmin, deleted the Glossary tables, uninstall Component and reinstalled all: it's OK now for that problem

Post edited by: Paul Sellis, at: 2010/06/25 18:05

| | Sorry, you do not currently have permission to write here.

Boardwalk :: Forum List Glossary Support Glossary

Aliroboard Forum Component 1.2
Aliro Software

Advice Notes

Login

Subscribe to Premium Support

Get priority support for Remository and Glossary, sign up now for a Premium Support monthly subscription:

Or purchase a year's support:

Recommended SEF

Who is Online

Remository welcomes guests and visitors

remository