Support Forums - All Posts - XOOPS Web Application System

1

Re: mysql 4.1.7 and utf8 problem

2005/1/19 7:40
franfran
Just popping in
Posts: 21
Since: 2004/2/10

irmtfan,

FINALLY! I opened xoops/class/database/mysqldatabase.php

under the function connect:

+ mysql_query("SET CHARACTER SET utf8", $this->conn);

There is no need to do table charset convertion as I was using utf8 previously in 4.1.0.

Once again, Thank you!!!

The only thing left is why 4.1.7 not working with the smarty code? I really don't know, but I think XOOPS core dev. should look into it(if they are interested to dig)

2

Re: mysql 4.1.7 and utf8 problem

2005/1/19 7:28
franfran
Just popping in
Posts: 21
Since: 2004/2/10

I was using utf8 in 4.1.0 already. I need to do the convertion again after moved to 4.1.9?

May I ask you irmtfan, you are using 4.1.x with utf8 currently?

3

Re: mysql 4.1.7 and utf8 problem

2005/1/19 5:27
franfran
Just popping in
Posts: 21
Since: 2004/2/10

Just some update:

XOOPS + 4.1.7(utf8 charset/utf8_general_ci collation):
Result: all modules(blocks) content will become blank. Don't know reason why.

XOOPS + 4.1.8/9(utf8 charset/utf8_general_ci collation):
Result: XOOPS working normally. It is NOT a matter of either using XAMMP or install MYSQL/PHP individually, i.e. not config files related problem.

Thanks irmtfan, you gave me a clue on upgrading the MYSQL.
And somehow it was my fault, since I upgrade to 4.1.7 in Dec. I don't expect they will release up to 4.1.9 in Jan.(so quick), so I didn't go to mysql.com. If I notice 4.1.8/9 was released, I should have try this upgrade route at the very beginning.

Thanks m0nty and irmtfan.

p.s.
I tried to move my db(utf8) from 4.1.0 to 4.1.9 now. The blocks are working fine now, however, all charactes become ???. But anyways, it maybe another issue. I will figure out later on.

4

Re: mysql 4.1.7 and utf8 problem

2005/1/18 11:14
franfran
Just popping in
Posts: 21
Since: 2004/2/10

irmtfan:
I downloaded XAMPP 1.4.11. The packaged MySQL is using latin as default. I changed my.cnf so all tables will use utf8. The result is, it works. The only difference is they are using 4.1.8 and I am using 4.1.7. I wonder this may cause the problem?

I will try to upgrade my server using 4.1.9 and see if the problem still exist. I really wanna know, WHAT IS THEIR DIFFERENT??

And I just look over mysql.com and find out that 4.1.9 released. Maybe there are lots of bugs? It is unreasonalbly the release date for new version is so close now.

m0nty:
I suggest you either try out 4.1.9 or XAMPP and see if it works in your server.

I don't have much time today... Will let you guys know later on.

Thanks!!

5

Re: mysql 4.1.7 and utf8 problem

2005/1/18 6:18
franfran
Just popping in
Posts: 21
Since: 2004/2/10

irmtfan:

I don't see any error in my log files.
Previously I have posted a topic in here:
https://xoops.org/modules/newbb/viewtopic.php?topic_id=29446
As it was very quiet in that forum, that's why I moved my question to this forum.

A short desc. for the above thread:
I tried to var_dump the content, it is fine. I can see the query get the content from DB(so no OLD_PASSWORD issue here). However, once it passed to tpl->assign function, all contents become blank.

And what is xampp?
For testing, I didn't test it in local. I just installed the XOOPS scripts, config everything as I post previously, use my browser point to my server:
www.domain.com/install/ and did the rest.

6

Re: mysql 4.1.7 and utf8 problem

2005/1/18 4:27
franfran
Just popping in
Posts: 21
Since: 2004/2/10

m0nty:

Thanks for your info.
One thing, in your config, if default-character-set=latin1, all tables created by XOOPS install script will become latin1 chraset.
In this case, your XOOPS should works perfectly, right?

7

Re: mysql 4.1.7 and utf8 problem

2005/1/18 3:52
franfran
Just popping in
Posts: 21
Since: 2004/2/10

irmtfan:

I have tried utf8_bin, however, it gave me the same result, blank modules. I hope I could find a way to let you reproduce my result.

m0nty:

Would you please give us your config in details? As it is very hard to investigate the problem if they cannot reproduce it in their testing enviornment.

8

Re: mysql 4.1.7 and utf8 problem

2005/1/15 8:25
franfran
Just popping in
Posts: 21
Since: 2004/2/10

um.. I am using utf8_general_ci, haven't try utf8_bin before.. I may try it out tomorrow.
however, as m0nty got the same result. what charset you used? utf8_general_ci??

For those interested, I have another thread in here:
https://xoops.org/modules/newbb/viewtopic.php?topic_id=29446

The problem should occured in tpl->assign function.
However, I cannot find out what is the problem, as I am not core/technical enough to understand it.

btw, thank you very much. hope more member will mention this thread.

9

Re: mysql 4.1.7 and utf8 problem

2005/1/14 10:11
franfran
Just popping in
Posts: 21
Since: 2004/2/10

To reproduce it:

Mysql 4.1.7
XOOPS 2.0.9
APACHE 2.0.X

under my.cnf:
[client]
set-variable = default-character-set=utf8
set-variable = character_set_client=utf8
set-variable = character_set_connection=utf8
set-variable = character_set_results=utf8

[mysqld]
set-variable = default-character-set=utf8

under xoops->global.php:
define('_CHARSET', 'utf-8');
define("XOOPS_USE_MULTIBYTES", "1");

under httpd.conf:
AddDefaultCharset UTF-8

under xoops-site/class/database/mysqldatabase.php, function: connect, add the following before 'return true':

+ mysql_query("SET CHARACTER SET utf8", $this->conn);

1. create XOOPS database
2. grant permission and make sure PHP can connect to it.
3. install XOOPS as normal
4. after the installation, verify all tables are in UTF8, you should see the collation is utf8_general_ci
5. check your homepage, all modules are blank

e.g.(copy and paste the link in your browser):
http://www.angelfire.com/linux/franfran/xoopsblank.gif

Thank you.

10

Re: mysql 4.1.7 and utf8 problem

2005/1/12 9:58
franfran
Just popping in
Posts: 21
Since: 2004/2/10

I am hoping someone could answer my question..
What I am looking for is an official confirmation.. at least I want to know I did right or wrong..

please somebody confirm with me:

XOOPS on MySQL 4.1.7 with utf8 is NOT supported.

thank you..

Stats
Goal:	$100.00
Due Date:	Apr 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

Re: mysql 4.1.7 and utf8 problem

Re: mysql 4.1.7 and utf8 problem

Re: mysql 4.1.7 and utf8 problem

Re: mysql 4.1.7 and utf8 problem

Re: mysql 4.1.7 and utf8 problem

Re: mysql 4.1.7 and utf8 problem

Re: mysql 4.1.7 and utf8 problem

Re: mysql 4.1.7 and utf8 problem

Re: mysql 4.1.7 and utf8 problem

Re: mysql 4.1.7 and utf8 problem

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}