HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


language characters after upgrading

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#79523 (In Topic #16188)
Avatar

Well-settled

language characters are damaged

  1. I have upgraded my ocportal version from 5,03 to 7,15 and have now problem with Lithuanian language characters.
    We need UTF-8  coding.What I could do to not correct every file, menu and so on
  2. By adding a new pagežcomcode I am getting an error in every step:

    An error occurred when loading this screen onto the web browser. You are being notified of this as you are staff. If you believe this is a bug in the website software, please contact ocProducts with full details. More details are available in your browser's error console. The error was:

    28: form_cat_selector is null
    http://www.audrone.serveriai.lt/ocp/themes/default/templates_cached/LT/javascript_validation.js
PLEASE HELP


Last edit: by Beata

My trial to learn ocPortal
~~~~~~~~~~~~~~~~~
http://audrone.serveriai.lt/straipsniai/
Back to the top
 
Posted
Rating:
#79525
Avatar

1- Please read the note on the upgrade announcement:
ocPortal 7.1.5 released - ocPortal

2- I'm not sure, my guess is you might have the FORM_SCREEN template overridden, which has changed a bit. (particularly, it contains id="main_form"now)


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#79539
Avatar

Well-settled

Hello Chris,
thank you for answer

I have read many times. My Mysql tables has utf8_unicode_ci

I have now 2 problems

1. All text in whole website is damaged

2. I can't even to correct it because file manager don't work: I can't correct text, I can't add new pages

I have updated through FTP manually, because automatically didn't work: the system didn't extract patch file from 5,03 to 7,15

What to do now? I don't understand about your answer in 2.
Here is link how looks my website now: 
http://audrone.serveriai.lt/ocp/, but important that I can nothing to do...

My trial to learn ocPortal
~~~~~~~~~~~~~~~~~
http://audrone.serveriai.lt/straipsniai/
Back to the top
 
Posted
Rating:
#79542
Avatar

Well-settled

Today I have exceeded to update again, this time automatically, but I have the same result.
Can't work on pages - the same error.

As for text, the main text is normal on pages, but all menus should to be overwriten because af Lithuanian characters.

My trial to learn ocPortal
~~~~~~~~~~~~~~~~~
http://audrone.serveriai.lt/straipsniai/
Back to the top
 
Posted
Rating:
#79557
Avatar

It's very difficult to explain how MySQL character sets work. About 5 different things affect them.

However the change we made in 7.1.5 fixes an inconsistency: ocPortal did not specify the database community character set, even when it was specified inside ocPortal. So often people had databases with a different character set to the website.

This is probably what your situation is.

The 7.0.1 changed it so that the database is communicated (and originally created when you install) with the same character set of the language pack, by default.

But you can change it back to communicating with what it was using before. You just need to find out what it was using before and change info.php. It's hard for me to say, but if it was latin1, this line needs to be in info.php:

Code

$SITE_INFO['database_charset']='latin1';

It is important to understand that this is the communication character set, which may be different to the character set the database itself uses, and may be different to the character set that ocPortal itself uses. So don't think about those two things. Even if your database is utf-8 and ocPortal is utf-8, it may have been communicating in latin1, in which case the data in your database is also in latin1 even if the database is set to utf-8.

Also if you do change info.php, you need to clear the caches by logging into /upgrader.php and clicking the "Clear caches" button.

I know this is extremely confusing. It's MySQL's fault really for being so complex here.

This is about all I can do via the forum. With a support ticket I could probably solve it in half an hour by looking exactly how your MySQL server is set up, but that would require support credits.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#79560
Avatar

Maybe I can explain this a different way…

MySQL has 4 character sets set on 4 levels:
  1. Communication
  2. The database
  3. Each table (if different to database)
  4. Each field (if different to table and database)
'1' is something you probably were never aware of, and I was not until recently. The MySQL server itself specifies what communications it expects.

ocPortal also has it's character set.

Before ocPortal 7.1.5, ocPortal assumed that the MySQL server received communications according to the database character set. But this was a bug, so we fixed it.

In 7.1.5 ocPortal tells the MySQL server it is sending/receiving data according to the ocPortal character set, unless you override this via the database_charset setting. MySQL will then convert that to the database/table/field character set.




So data is communicated as follows:
a) In ocPortal it is in character set X
b) It is sent to MySQL and MySQL interprets it as in character set Y
c) MySQL then converts it for saving to character set Z

If X is not the same as Y, the conversion to Z will also be wrong, so the data won't actually be saved correctly. This is probably how your database is now. It does not matter a whole lot, it only causes some small issues.

In 7.1.5 we make X and Y the same, by default. But that means databases that are already wrong will not continue to work, unless you set the 'database_charset' in info.php to force ocPortal to use the old value of 'Y'.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#79588
Avatar

Well-settled

Hello Chris,

Thank you very much for large explanation and for your time.
I am very sorry, I am simple user, even not programmer, so it is dificult me to understand everything.

I have now
$SITE_INFO['default_lang']='LT'; in my info.php.
I think, I had the same before updating of version,
because I don't see a file info.php in my patch packet

My SQl tables are and was in the same utf8_unicode_ci coding, although you say that can be also different...
What is interesting that the first
mvpm3_properties table show latin1_swedish_ci, but when I open structure I see utf8_unicode_ci ???? and I can't something to do



Could you say me, can I do something myself for me:
  1. Maybe come back to previuos version? HOW?
  2. To reinstall ocportal? But how to not loose what was already done?
  3. Or I need to do new latest installiation and work again from first step? This website is my personal, so I can do it step by step. Simple I wanted to learn new and interesting for me CMC, so diferent from other CMS.
  4. Can I do a new clear latest installation and import my Sql?

    What you suggest ?

My trial to learn ocPortal
~~~~~~~~~~~~~~~~~
http://audrone.serveriai.lt/straipsniai/
Back to the top
 
Posted
Rating:
#79589
Avatar

Well-settled

1. I checked your site and noticed that it contains:

Code

<meta http-equiv="Content-Type" content="application/xhtml+xml; charset=ISO-8859-1" />
ISO-8859-1 doesn't support your letters so it should be replaced with UTF-8 in theme file, e.g.:

Code

<meta http-equiv="Content-Type" content="application/xhtml+xml; charset=UTF-8" />

FeminaPortal - Female Internet Portal (powered by ocPortal)
INFORBIRO - Information Technology Agency
BlicKlik - Internet Marketing and Advertising
Back to the top
 
Posted
Rating:
#79590
Avatar

Well-settled

Thank you, this happenned after updating.
I think this isn't worth to do;

I need reinstallation, admin tools  don't work at all

B.T.W. which file is main in theme? I see index.html?- this can't be

My trial to learn ocPortal
~~~~~~~~~~~~~~~~~
http://audrone.serveriai.lt/straipsniai/
Back to the top
 
Posted
Rating:
#79591
Avatar

Well-settled

MitraX said

1. I checked your site and noticed that it contains:

Code

<meta http-equiv="Content-Type" content="application/xhtml+xml; charset=ISO-8859-1" />

Where you see it 8859?
It is




Last edit: by Beata

My trial to learn ocPortal
~~~~~~~~~~~~~~~~~
http://audrone.serveriai.lt/straipsniai/
Back to the top
 
Posted
Rating:
#79592
Avatar

Well-settled

Where you see it 8859?

Go to http://audrone.serveriai.lt/ocp/ > right click on the page > View source and you can see that the charset is ISO-8859-1

FeminaPortal - Female Internet Portal (powered by ocPortal)
INFORBIRO - Information Technology Agency
BlicKlik - Internet Marketing and Advertising
Back to the top
 
Posted
Rating:
#79603
Avatar

Well-settled

Sorry,

1. but I don't find 8859 in my sourses. I am atacching text file what is in head, because the whole ocupies 2 thous. rows

2. And I wonder the beginning of sourses :
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

I have cahnged many times in my code_editor.php fileEN to LT
Attachment
» Download: sourses.txt (6 Kb, 345 downloads so far)

as the

But I am getting the same and the same, it seems FTP don't send this file

3. You didn't answer  which file and where it is - main file in the theme? I see index.html?- this can't be


Last edit: by Beata

My trial to learn ocPortal
~~~~~~~~~~~~~~~~~
http://audrone.serveriai.lt/straipsniai/
Back to the top
 
Posted
Rating:
#79604
Avatar

Open up a support ticket with FTP details if you like, and I'll do a super-fast check over things, in the most unprofessional way - but we'll let you do it as a free ticket ;).


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#79606
Avatar

Fixed.

I confirmed the communication charset used to be 'latin1', so added:

Code

$SITE_INFO['database_charset']='latin1';
to your info.php.
As this is how your data is stored (it's very hard to understand I know).

Then I had to clear the caches to force all the caching to update right again.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#79607
Avatar

Well-settled

Is this really fixed?

Thank you very much.
I appreciate it !


Jus one question:
1. Why I can't  change
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
to this to:
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//LT" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
Is this needed to change in code_editor.php ?

2. Which file is main file in the theme?

My trial to learn ocPortal
~~~~~~~~~~~~~~~~~
http://audrone.serveriai.lt/straipsniai/
Back to the top
 
Posted
Rating:
#79608
Avatar

Yes, it didn't take me long.

1- You shouldn't. The "EN" refers to the XHTML 1.0 specification being written in English, not the actual page. These doctype lines are ridiculously over-complex, which is why they have been shortened in HTML5.

2- I think you may mean HEADER.tpl.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#79609
Avatar

Well-settled

Chris Graham said


2- I think you may mean HEADER.tpl.

I mean it should be index.php as in other CMC
Where it is?

My trial to learn ocPortal
~~~~~~~~~~~~~~~~~
http://audrone.serveriai.lt/straipsniai/
Back to the top
 
Posted
Rating:
#79611
Avatar

Well-settled

ocPortal is not like many other CMS ;) In short, it has separated logic for presentation layer (i.e. not mixed with php code)

Template files are located in folder /themes/default/templates/ or /themes/%theme_name%/templates/. But if you want to make any changes copy particular file into /themes/default/templates_custom/ and after that change the file. This will prevent overriding the changes when you upgrade ocPortal

FeminaPortal - Female Internet Portal (powered by ocPortal)
INFORBIRO - Information Technology Agency
BlicKlik - Internet Marketing and Advertising
Back to the top
 
Posted
Rating:
#79612
Avatar

Well-settled

Thank you.

Yes, I see that ocPortal is quite diferent in all things

My trial to learn ocPortal
~~~~~~~~~~~~~~~~~
http://audrone.serveriai.lt/straipsniai/
Back to the top
 
There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: