XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. 2.4.x Support 
  4.  / upgrade problem with Croatian characters
Register
1
Ganga
upgrade problem with Croatian characters

  • 2009/11/24 10:58

  • Ganga

  • Just popping in

  • Posts: 24

  • Since: 2007/10/22


Hello Everyone,
I made upgrade from 2.18.2 to 2.4.1 and it worked all ...
Croatian XOOPS 2.4.1 UTF-8
Croatian language modules, all UTF-8
Page works great Croatian characters (??žš?) are there.
Now I have but the problem is that in the forum / NewBB and converts it into news with the Croatian characters in? um. (only in old posts on nine everything is ok)

In the database are properly displayed:
le="color: #000000"><?php -- phpMyAdmin SQL Dump -- version 2.11.8.1deb1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 24. November 2009 um 10:55 -- Server Version: 5.0.67 -- PHP-Version: 5.2.6-2ubuntu4.2 SET FOREIGN_KEY_CHECKS=0; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT=0; START TRANSACTION; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Datenbank: `h24` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `xoops_bb_categories` -- -- Erzeugt am: 22. November 2009 um 18:46 -- Aktualisiert am: 22. November 2009 um 18:46 -- Letzter Check am: 22. November 2009 um 18:46 -- DROP TABLE IF EXISTS `xoops_bb_categories`; CREATE TABLE IF NOT EXISTS `xoops_bb_categories` ( `cat_id` smallint(3) unsigned NOT NULL auto_increment, `cat_image` varchar(50) default NULL, `cat_title` varchar(100) NOT NULL default '', `cat_description` text NOT NULL, `cat_order` smallint(3) unsigned NOT NULL default '0', PRIMARY KEY (`cat_id`), KEY `cat_order` (`cat_order`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; -- -- Daten für Tabelle `xoops_bb_categories` -- INSERT INTO `xoops_bb_categories` (`cat_id`, `cat_image`, `cat_title`, `cat_description`, `cat_order`) VALUES (1, NULL, 'Bosna i Hercegovina Regionalno(Županijski)', '', 0), (2, NULL, 'Društvo Kultura i Zabava', '', 4), (3, NULL, 'Hrvatska Regionalno', '', 5), (4, NULL, 'Ljubav,sex,erotika na hercegova?ki na?in', '', 3), (5, NULL, 'Sport', '', 7), (6, NULL, 'Ra?unala, Internet i Mobitel(export-import)', '', 8), (7, NULL, 'Hercegovina24.de/Hercegovina24.com', '', 9), (8, NULL, 'Politika i Povjest', '', 1), (9, NULL, 'Dijaspora Regionalno', '', 6), (10, NULL, 'Free Zone', '', 2), (11, NULL, 'Muški-Ženski kutak', '', 2); SET FOREIGN_KEY_CHECKS=1; COMMIT;


but if I play backup to new XOOPS because looks like this:

Resized Image

I charged everything but I have not found help ...

who can help please

p.s.sorry for my english:(
2
ghia
Re: upgrade problem with Croatian characters

  • 2009/11/24 12:01

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Your database seems to be latin1. The collation is not reported.
Change mainfile.php and global.php to use latin1 and ISO-....
You need also ansi language files for your core and modules.

Conversion of your database to UTF-8 is also possible, but not easy or strait forward. You could attempt by converting the format of your backup SQL file from ansi to UTF-8 without BOM by Notepad++. (Also changing character sets and collation directives in this file)
3
deka87
Re: upgrade problem with Croatian characters

  • 2009/11/24 12:13

  • deka87

  • Friend of XOOPS

  • Posts: 1125

  • Since: 2007/10/5


there is a great tool for XOOPS upgrade encoding conversion on xoops2.ru by andrey3761. some well scripts that will do the work for you plus the manual. it's being tested now. once it's prepared, it should be up at xoops.org.
4
Mamba
Re: upgrade problem with Croatian characters

  • 2009/11/24 12:33

  • Mamba

  • Moderator

  • Posts: 11521

  • Since: 2004/4/23


Quote:
there is a great tool for XOOPS upgrade encoding conversion on xoops2.ru by andrey3761.

WOW!!! Fantastic News!!!
5
Ganga
Re: upgrade problem with Croatian characters

  • 2009/11/24 15:48

  • Ganga

  • Just popping in

  • Posts: 24

  • Since: 2007/10/22


Quote:
Your database seems to be latin1. The collation is not reported.
Change mainfile.php and global.php to use latin1 and ISO-....
You need also ansi language files for your core and modules.

Conversion of your database to UTF-8 is also possible, but not easy or strait forward. You could attempt by converting the format of your backup SQL file from ansi to UTF-8 without BOM by Notepad++. (Also changing character sets and collation directives in this file)


Thanks for your reply

My complete database is already in utf8_general_ci

Resized Image


and if I open the edditor is already UTF-8 without BOM...

Quote:
by deka87
there is a great tool for XOOPS upgrade encoding conversion on xoops2.ru by andrey3761. some well scripts that will do the work for you plus the manual. it's being tested now. once it's prepared, it should be up at xoops.org.

I already tried all the functions

6
bjuti
Re: upgrade problem with Croatian characters

  • 2009/11/24 16:28

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


I have similar problem. The letter "š" is written like "scaron" o something.
7
ghia
Re: upgrade problem with Croatian characters

  • 2009/11/24 18:16

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Was your database from the beginning always in UTF-8?
8
Ganga
Re: upgrade problem with Croatian characters

  • 2009/11/24 19:15

  • Ganga

  • Just popping in

  • Posts: 24

  • Since: 2007/10/22


Quote:
Was your database from the beginning always in UTF-8?


was in latin1
--------

bjuti koja je kod tebe prije verzija xoopsa bila(pre 2.4) 2.33?
9
ghia
Re: upgrade problem with Croatian characters

  • 2009/11/24 21:16

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


That is what I tought. And how did you make the conversion?
10
Ganga
Re: upgrade problem with Croatian characters

  • 2009/11/24 21:48

  • Ganga

  • Just popping in

  • Posts: 24

  • Since: 2007/10/22


Quote:
by ghia That is what I tought. And how did you make the conversion?
with this convert.php 
<?php // convert tvoj xoops ini_set ('max_execution_time', '6000'); include_once 'mainfile.php'; // ??????????? ?????? if( ! empty( $_POST['convert'] ) ) { include XOOPS_ROOT_PATH.'/header.php'; $old_prefix = XOOPS_DB_PREFIX; $srs = $xoopsDB->queryF( 'SHOW TABLE STATUS FROM `'.XOOPS_DB_NAME.'`' ) ; if( ! $xoopsDB->getRowsNum( $srs ) ) die( "You are not allowed to copy tables" ) ; $count = 0; while( $row_table = $xoopsDB->fetchArray( $srs ) ) { $count ++ ; $old_table = $row_table['Name'] ; // ???? ?????? ??????? ?? ???????? ???????? ??????, ?? ??????????... if( substr( $old_table , 0 , strlen( $old_prefix ) + 1 ) !== $old_prefix . '_' ) continue ; // ???????????? ??????? ? utf8 $sql = 'ALTER TABLE `'.$old_table.'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci'; if($xoopsDB->queryF($sql)) { echo 'ok - '.$sql.'<br />'; } else { echo $xoopsDB->error().' - '.$sql.'<br />'; } // ????????????? ????????? ????????????? ?????? $sql = 'ALTER TABLE `'.$old_table.'` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci'; if($xoopsDB->queryF($sql)) { echo 'ok - '.$sql.'<br />'; } else { echo $xoopsDB->error().' - '.$sql.'<br />'; } } // ????????????? ????????? ???? ?????? $sql = 'ALTER DATABASE `'.XOOPS_DB_NAME.'` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci'; if($xoopsDB->queryF($sql)) { echo 'ok - '.$sql.'<br />'; } else { echo $xoopsDB->error().' - '.$sql.'<br />'; } include XOOPS_ROOT_PATH.'/footer.php'; // ????? ????? } else { include XOOPS_ROOT_PATH.'/header.php'; xoops_confirm(array('convert' => 1), 'convert.php', 'Convert in utf8?'); include XOOPS_ROOT_PATH.'/footer.php'; } ?>
(1) 2 3 »

Post Reply

      
1 + 1 = ?  
Input the result from the expression
Maximum attempts you can try: 10
* = Required

Search

Advanced Search

Recent Posts

Who's Online

247 user(s) are online (174 user(s) are browsing Support Forums)

Members: 0

Guests: 247

more...

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!

Latest GitHub Commits