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.
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!!
**Cuando el Alumno esta listo, el Maestro Aparece **
::Geeklog support in Spanish::
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!!
**Cuando el Alumno esta listo, el Maestro Aparece **
::Geeklog support in Spanish::
6
7
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
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
10
7
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!!
**Cuando el Alumno esta listo, el Maestro Aparece **
::Geeklog support in Spanish::
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!!
**Cuando el Alumno esta listo, el Maestro Aparece **
::Geeklog support in Spanish::
10
5
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