125 to Cotonti 0.0.2

donP	#16 2009-02-04 06:09
Members	1. So do I have to convert my database in UTF-8? I'm worring about the missing of italians characters... 1. Also here on cotonti.com automatic refresh doesn't go well... it's disabled or you're having the same problem as me? in [color=#729FCF][b]BLUES[/b][/color] I trust

Trustmaster	#17 2009-02-04 06:47
Administrators Thanked: 263 zaman	I think you could try contacting your hosting support, probably they can do something on default encoding of webserver output. I don't really want to force everybody moving to utf-8. Autorefresh is disabled here. But I don't exclude the possibility of bugged autorefresh in current markItUp! version if you say so. Just needs a bit testing on localhost. May the Source be with you!

donP	#18 2009-02-04 08:25
Members	I've tried markitup in localhost and online, with the latest version from author's website... problems remain... strange characters (also in local, where I can set what I want) and no autorefresh in preview... P.S. I'm doing Italian translation of main.lang and other lang files... I hope it will be usefull and nobody was already doing that... in [color=#729FCF][b]BLUES[/b][/color] I trust

Trustmaster	#19 2009-02-04 15:17
Administrators Thanked: 263 zaman	The translation would be great, thanks. May the Source be with you!

donP	#20 2009-02-05 03:58
Members	Ok, I'll do my best to complete the work quickly ...but I'm still waiting for a solution to my charset problem in [color=#729FCF][b]BLUES[/b][/color] I trust

Trustmaster	#21 2009-02-05 04:12
Administrators Thanked: 263 zaman	Basically, mixing charsets is a very bad idea. So you have to decide using one charset and converting everything into it. May the Source be with you!

donP	#22 2009-02-05 04:59
Members	So are you saying that if I'll set charset and collation in database to ISO-8859-1 (leaving untouched the datas that would be inserted in that charset by Server in these two years) and also headers in webpages to ISO-8859-1 all would go well? But some posts ago you told me: Trustmaster: You see AJAX uses UTF-8 by default, that's why previews are often messed. But sending correct header() with exact charset usually fixes the problem I'm confused... in [color=#729FCF][b]BLUES[/b][/color] I trust

donP

#22 2009-02-05 04:59

Members

So are you saying that if I'll set charset and collation in database to ISO-8859-1 (leaving untouched the datas that would be inserted in that charset by Server in these two years) and also headers in webpages to ISO-8859-1 all would go well?

But some posts ago you told me:

Trustmaster:
You see AJAX uses UTF-8 by default, that's why previews are often messed. But sending correct header() with exact charset usually fixes the problem

I'm confused...

in [color=#729FCF][b]BLUES[/b][/color] I trust

musashi9	#23 2009-02-05 13:21
Members	Cotonti sql-updater gives me an error and fails to work After I follow the other steps I get a site that looks like this cotoni site! but after I log in, the skin of my site changes back to my old skin. When I goto my profile to change it back to SED-LIGHT i get an error, this also happens when I try to edit or create new things 2009-02-05 20:11 Fatal error : Wrong parameter in the URL. And if i try to access the Admin I just get a blank white page
Bu konu musashi9 tarafından düzenlendi(2009-02-06 09:33, 15 yıllar önce)

musashi9

#23 2009-02-05 13:21

Members

Cotonti sql-updater gives me an error and fails to work

After I follow the other steps I get a site that looks like this cotoni site! but after I log in, the skin of my site changes back to my old skin. When I goto my profile to change it back to SED-LIGHT i get an error, this also happens when I try to edit or create new things
2009-02-05 20:11
Fatal error : Wrong parameter in the URL.
And if i try to access the Admin I just get a blank white page

Bu konu musashi9 tarafından düzenlendi(2009-02-06 09:33, 15 yıllar önce)

Trustmaster	#24 2009-02-06 14:18
Administrators Thanked: 263 zaman	donP, be careful. What you said should work if all your existing data is in ISO-8859-1. But mixing charsets would be quite dangerous. Generally we recommend moving to UTF-8 to add multilingual support. But in the end that is personal choice. musashi9, any details on your server? OS, MySQL and PHP version would be helpful. May the Source be with you!

musashi9	#25 2009-02-06 16:59
Members	my Admin page now works after deleting all the system php files and re uploading them but i still can't click submit on anything without getting that fatal error. details from my host Platform Type Debian MySQL Version MySQL Version 5.0.45 Perl Version Perl 5.8.8 PHP Version PHP 5.2.2 I also noticed that on my pages with downloads. The download button says "THIS DOWNLOAD IS ONLY AVAILABLE TO REGISTERED MEMBERS", even though I am logged in as Admin
Bu konu musashi9 tarafından düzenlendi(2009-02-07 08:02, 15 yıllar önce)

musashi9

#25 2009-02-06 16:59

Members

my Admin page now works after deleting all the system php files and re uploading them
but i still can't click submit on anything without getting that fatal error.

details from my host

Platform
Type Debian

MySQL Version
MySQL Version 5.0.45

Perl Version
Perl 5.8.8

PHP Version
PHP 5.2.2

I also noticed that on my pages with downloads. The download button says "THIS DOWNLOAD IS ONLY AVAILABLE TO REGISTERED MEMBERS", even though I am logged in as Admin

Bu konu musashi9 tarafından düzenlendi(2009-02-07 08:02, 15 yıllar önce)

donP	#26 2009-02-06 20:37
Members	Now I strangely solved the problem setting-up UTF-8 only for markitup prevew, like this: in markitup.ajax.php header('Content-type: text/html; charset=UTF-8'); instead of the default header('Content-type: text/html; charset='.$cfg['charset']); So, now I have my website headers declaration set to ISO-8859-1, my MySql database with collation and charser set to unicode-utf8-ci, my database datas (I think) inserted with ISO-8859-1 format... but all seems to go well The refresh problem has caused by an error (I think) in markitup.setup.php: Instead of autorefresh=01:radio::0 preview auto-refresh I put autorefresh=01:select:true,false:false:Enable preview auto-refresh Now, it seems to be in order... in [color=#729FCF][b]BLUES[/b][/color] I trust
Bu konu donP tarafından düzenlendi(2009-02-06 21:48, 15 yıllar önce)

donP

#26 2009-02-06 20:37

Members

Now I strangely solved the problem setting-up UTF-8 only for markitup prevew, like this:
in markitup.ajax.php

header('Content-type: text/html; charset=UTF-8');

instead of the default

header('Content-type: text/html; charset='.$cfg['charset']);

So, now I have my website headers declaration set to ISO-8859-1, my MySql database with collation and charser set to unicode-utf8-ci, my database datas (I think) inserted with ISO-8859-1 format...

but all seems to go well

The refresh problem has caused by an error (I think) in markitup.setup.php:

Instead of

autorefresh=01:radio::0 preview auto-refresh

I put

autorefresh=01:select:true,false:false:Enable preview auto-refresh

Now, it seems to be in order...

in [color=#729FCF][b]BLUES[/b][/color] I trust

Bu konu donP tarafından düzenlendi(2009-02-06 21:48, 15 yıllar önce)

ruben	#27 2009-03-11 05:03
Members	is there a dutch language already? or can i use my dutch seditio language here a script to convert your databse to UTF8 <html> <head> <title>Convert MySQL Database to UTF-8</title> </head> <body> <?php // Fill in your configuration below $db_server = 'localhost'; $db_user = ''; $db_password = ''; $db_name = ''; // Do not change anything below this set_time_limit(0); $connection = mysql_connect($db_server, $db_user, $db_password) or die( mysql_error() ); $db = mysql_select_db($db_name) or die( mysql_error() ); $sql = 'SHOW TABLES'; if ( !($result = mysql_query($sql)) ) { print '<span style="color: red;">SQL Error: <br>' . mysql_error() . "</span>\n"; } // Loop through all tables in this database while ( $row = mysql_fetch_row($result) ) { $table = mysql_real_escape_string($row[0]); $sql2 = "ALTER TABLE $table DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"; if ( !($result2 = mysql_query($sql2)) ) { print '<span style="color: red;">SQL Error: <br>' . mysql_error() . "</span>\n"; break; } print "$table changed to UTF-8 successfully.<br>\n"; // Now loop through all the fields within this table $sql3 = "SHOW COLUMNS FROM $table"; if ( !($result3 = mysql_query($sql3)) ) { print '<span style="color: red;">SQL Error: <br>' . mysql_error() . "</span>\n"; break; } while ( $row3 = mysql_fetch_row($result3) ) { $field_name = $row3[0]; $field_type = $row3[1]; // Change text based fields $skipped_field_types = array('char', 'text', 'blob', 'enum', 'set'); foreach ( $skipped_field_types as $type ) { if ( strpos($field_type, $type) !== false ) { $sql4 = "ALTER TABLE $table CHANGE `$field_name` `$field_name` $field_type CHARACTER SET utf8 COLLATE utf8_bin"; if ( !($result4 = mysql_query($sql4)) ) { print '<span style="color: red;">SQL Error: <br>' . mysql_error() . "</span>\n"; break 3; } print "---- $field_name changed to UTF-8 successfully.<br>\n"; } } } print "<hr>\n"; } mysql_close($connection); ?> </body> </html>

ruben

#27 2009-03-11 05:03

Members

is there a dutch language already? or can i use my dutch seditio language

here a script to convert your databse to UTF8

<html>
<head>
<title>Convert MySQL Database to UTF-8</title>
</head>
<body>

<?php
// Fill in your configuration below
$db_server      = 'localhost';
$db_user      = '';
$db_password   = '';
$db_name      = '';

// Do not change anything below this
set_time_limit(0);

$connection = mysql_connect($db_server, $db_user, $db_password) or die( mysql_error() );
$db = mysql_select_db($db_name) or die( mysql_error() );

$sql = 'SHOW TABLES';
if ( !($result = mysql_query($sql)) )
{
   print '<span style="color: red;">SQL Error: <br>' . mysql_error() . "</span>\n";
}

// Loop through all tables in this database
while ( $row = mysql_fetch_row($result) )
{
   $table = mysql_real_escape_string($row[0]);
   $sql2 = "ALTER TABLE $table DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci";
   
   if ( !($result2 = mysql_query($sql2)) )
   {
      print '<span style="color: red;">SQL Error: <br>' . mysql_error() . "</span>\n";
      
      break;
   }
   
   print "$table changed to UTF-8 successfully.<br>\n";

   // Now loop through all the fields within this table
   $sql3 = "SHOW COLUMNS FROM $table";
   if ( !($result3 = mysql_query($sql3)) )
   {
      print '<span style="color: red;">SQL Error: <br>' . mysql_error() . "</span>\n";
      
      break;
   }

   while ( $row3 = mysql_fetch_row($result3) )
   {
      $field_name = $row3[0];
      $field_type = $row3[1];
      
      // Change text based fields
      $skipped_field_types = array('char', 'text', 'blob', 'enum', 'set');
      
      foreach ( $skipped_field_types as $type )
      {
         if ( strpos($field_type, $type) !== false )
         {
            $sql4 = "ALTER TABLE $table CHANGE `$field_name` `$field_name` $field_type CHARACTER SET utf8 COLLATE utf8_bin";
            if ( !($result4 = mysql_query($sql4)) )
            {
               print '<span style="color: red;">SQL Error: <br>' . mysql_error() . "</span>\n";
               
               break 3;
            }
            print "---- $field_name changed to UTF-8 successfully.<br>\n";
         }
      }
   }
   print "<hr>\n";
}

mysql_close($connection);
?>

</body>
</html>

Kingsley	#28 2009-03-13 02:42
Donator Thanked: 7 zaman	I presume this also will work on the 0.0.3 release?

Lombi	#29 2009-03-13 03:08
Team Thanked: 1 zaman	With one extra sql that needs to be imported - 002-003.sql Will be making a tutorial on encoding in case your database needs this (most do), as well as upgrading. Soon. <a href="http://www.domenlo.com">Surreal Art</a>

Kingsley	#30 2009-03-13 04:35
Donator Thanked: 7 zaman	ok, thx Lombi.. I'll wait for that then...

<<<12