Welcome to Geeklog, Anonymous Monday, December 23 2024 @ 03:06 am EST

Geeklog Forums

Problem in module Search


Status: offline

koalasoft

Forum User
Full Member
Registered: 03/09/05
Posts: 242
Location:Mexico
I have a problem when trying to search, when I use the form on geeklog ara find the word "style" I get the following message.
Text Formatted Code

256 - 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '=' @ /home/myuser/htdocs/geeklog/system/databases/mysql.class.php line 260

array(3) {
  ["sql"]=>
  string(309) "SELECT COUNT(*) FROM gl_users AS u, gl_comments AS c LEFT JOIN gl_staticpage AS s ON ((s.sp_id = c.sid)  AND (s.perm_anon >= 2)) WHERE (u.uid = c.uid) AND (s.draft_flag = 0) AND (s.template_flag = 0) AND (s.commentcode >= 0) AND (s.created <= NOW()) AND ((c.title LIKE '%estilo%' OR comment LIKE '%estilo%')) "
  ["ignore_errors"]=>
  int(0)
  ["result"]=>
  bool(false)
}

 

Defauld the language of my site is in Spanish, which could be to correct this error?

Greetings!! Mr. Green
**Cuando el Alumno esta listo, el Maestro Aparece **
::Geeklog support in Spanish::
 Quote

Status: offline

::Ben

Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
Hi,

As the message tell you, it seems to be a Illegal mix of collations (latin1_swedish_ci and latin1_general_ci) in your db.
You can google "How to change database or server collation" to see some ways to solve this.

::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
 Quote

Status: offline

koalasoft

Forum User
Full Member
Registered: 03/09/05
Posts: 242
Location:Mexico
Thanks ..

This manual I have to repair my db an collage problem.

http://blog.webhostingdiscussion.net/cpanel-hosting-tutorials/how-to-change-mysql-database-collation-from-phpmyadmin-in-cpanel.htm

Greetings!! Mr. Green
**Cuando el Alumno esta listo, el Maestro Aparece **
::Geeklog support in Spanish::
 Quote

All times are EST. The time is now 03:06 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content