FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Mysql charset changer ( admin control panel)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Mysql charset changer ( admin control panel) [message #31117] Mon, 03 April 2006 07:05 Go to next message
allanlee is currently offline  allanlee   Malaysia
Messages: 3
Registered: March 2006
Location: malaysia
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user

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.
Re: Mysql charset changer ( admin control panel) [message #31122 is a reply to message #31117] Mon, 03 April 2006 09:53 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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
Re: Mysql charset changer ( admin control panel) [message #31130 is a reply to message #31122] Tue, 04 April 2006 00:33 Go to previous messageGo to next message
allanlee is currently offline  allanlee   Malaysia
Messages: 3
Registered: March 2006
Location: malaysia
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user

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 01:18]

Report message to a moderator

Re: Mysql charset changer ( admin control panel) [message #31134 is a reply to message #31130] Tue, 04 April 2006 09:42 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Looks like your version of MySQL does not support this feature. I believe you need MySQL 4.1 or higher to do this.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Install help
Next Topic: Updated MySql 4->5
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 19 11:13:47 EDT 2018

Total time taken to generate the page: 0.00744 seconds