Re: mysql 4.1.7 and utf8 problem [Installation Troubleshooting]

11

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.

12

Re: mysql 4.1.7 and utf8 problem

2005/1/18 4:10
m0nty
XOOPS is my life!
Posts: 3337
Since: 2003/10/24

Quote:

franfran wrote:
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.

yes using the default utf-8_general_ci didn't work, but i changed to latin1_swedish_ci and it then worked..

from global.php >


//%%%%%        LANGUAGE SPECIFIC SETTINGS   %%%%%

define('_CHARSET', 'UTF-8');

define('_LANGCODE', 'en');



// change 0 to 1 if this language is a multi-bytes language

define("XOOPS_USE_MULTIBYTES", "1");

and from MySQL data/test2092/db.opt (test2092 is the database name)


default-character-set=latin1

default-collation=latin1_swedish_ci

and i set MySQL using syl administrator to set default collation to latin1 instead of utf-8

to be honest tho i never tried utf-8_bin.. i might try that later and do another test install..

13

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?

14

Re: mysql 4.1.7 and utf8 problem

2005/1/18 4:41
m0nty
XOOPS is my life!
Posts: 3337
Since: 2003/10/24

thats right :)

15

Re: mysql 4.1.7 and utf8 problem

2005/1/18 5:40
irmtfan
Module Developer
Posts: 3419
Since: 2003/12/7

Quote:

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.

do you have any error with MySQL debug?
as i wrote before i install and test in local with xampp and i have not seen any problem.i dont know your problem but i nearlly sure there is something in server config.
do you try and test it with xampp in local?

16

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.

17

Re: mysql 4.1.7 and utf8 problem

2005/1/18 6:53
irmtfan
Module Developer
Posts: 3419
Since: 2003/12/7

i ask for a software to test MySQL 4.1+ in local and i get this response from Dave_L. realy usefull for test MySQL 4.1+ and php 4.3.10 and 5.0.3
Quote:

Dave_L wrote :
An easy way would be to use XAMPP 1.4.11 fromhttp://www.apachefriends.org/

18

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!!

19

Re: mysql 4.1.7 and utf8 problem

2005/1/18 19:08
irmtfan
Module Developer
Posts: 3419
Since: 2003/12/7

i dont think there is a bug in MySQL 4.1.7 and it seems XOOPS is not compatible with it in multi-bytes charset.
do you try to install another cms and see the result e.g. mambo or xaraya?

20

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.

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

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 }}