r1 - 31 Oct 2006 - 15:23:29 - CharinyaKlakhangYou are here: SETEC Wiki >  Knowledge Web  > WebTechnologyCategory > CMS > Drupal > DrupalFAQ

คำถาม-คำตอบ การใช้งาน drupal

คำถาม 1. ทำไมเกิด Error แบบนี้


Warning: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'like' query: SELECT * FROM access WHERE status = 1 AND type = 'host' AND LOWER('192.168.11.1') LIKE LOWER(mask) in /home/rumplestiltskin/mzilikazix/includes/database.mysql.inc on line 120

คำตอบ : แก้ไขแบบนี้

Just comment the line in /drupal_folder/includes/database.mysql.inc

mysql_query('SET NAMES "utf8"', $connection);


Edit | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r1 | More topic actions
 
Powered by SETEC Wiki
Copyright ©2012 by National Electronics and Computer Technology Center, NECTEC.
Ideas, requests, problems regarding SETEC Wiki? Send feedback