FUDforum: FUDforum Installation Issues » Mysql charset changer ( admin control panel)

Home » FUDforum » FUDforum Installation Issues » Mysql charset changer ( admin control panel)

Show: Today's Messages :: Polls :: Message Navigator

Mysql charset changer ( admin control panel) [message #31117]

Mon, 03 April 2006 11:05

allanlee

Messages: 3
Registered: March 2006
Location: malaysia

Karma: 0

Junior Member

Everthing works ok on my PC. I am now installing into my Hosting server. I am using chinese UTF-8, and I need to change the mysql charset mentioned above and the option does not show the drop-down lists and straight perform the 'change charset' update, while I press the 'mysql charset cnager'.
What's wrong?
Thanks.

Try hard and always ASK.

Report message to a moderator

Re: Mysql charset changer ( admin control panel) [message #31122 is a reply to message #31117]

Mon, 03 April 2006 13:53

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

The list of available character sets is determined by running the "SHOW CHARACTER SET" query. The forum shows all supported character sets according to the DB and allows you to pick one. If you see an empty list this means that the query returned no results.

FUDforum Core Developer

Report message to a moderator

Re: Mysql charset changer ( admin control panel) [message #31130 is a reply to message #31122]

Tue, 04 April 2006 04:33

allanlee

Messages: 3
Registered: March 2006
Location: malaysia

Karma: 0

Junior Member

I encounter this error message:
(/home/dbwing/FUDforum/include/theme/default/db.inc:78
/home/dbwing/FUDforum/include/theme/default/db.inc:209
/home/dbwing/public_html/FUDforum/adm/admmysql.php:20
) 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET' at line 1
Query: SHOW CHARACTER SET
_GET: array ( 'S' => 'b9378084ede93da919fbaee1cb794e09', 'SQ' => '5bf776535440cf06603edc842ba5bcdc', )
Server Version: 4.0.25-standard
[Referring Page] http://www.dbwing.com/FUDforum/adm/admglobal.php?S=b9378084ede93da919fbaee1 cb794e09&SQ=5bf776535440cf06603edc842ba5bcdc

Does it mean mysql does not support the language I intend to use?
I am using 'phpmyadmin'.How to run 'Show character set' in monitor mode? Under my own PC(monitor mode), typing this returns the charsets. Under myphpadmin in my hosting server, I encounter error:

SQL query:
SHOW CHARACTER SET
MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'character set' at line 1

I spend whole day trying to solve this problem. Please help.
Thanks

Try hard and always ASK.

[Updated on: Tue, 04 April 2006 05:18]

Report message to a moderator