mll

Thanks for your detailed instructions.

So, I put the following in the debug console :

<?php

echo 'hello world '.time();

function utf8ize_generator() {
	return 'message:'.time();
	mysql_connect( DB_HOST, DB_USER, DB_PASSWORD ) or die( 'Could not connect: ' . mysql_error() );
	mysql_set_charset( DB_CHARSET ) or die( 'Could not set charset: ' . mysql_error() );
	mysql_select_db( DB_NAME ) or die( 'Could not select database: ' . mysql_error() );

	$db_collate = ( ! defined( 'DB_COLLATE' ) || '' == DB_COLLATE ? 'utf8_unicode_ci' : DB_COLLATE );

	function mysql_get_results( $query, $die_on_error = true ) { die( print_r( $db_collate, true ) ); 
		$result = mysql_query( $query ); die( print_r( $query, true ) ); die( print_r( $result, true ) ); 
		if ( false === $result ) {
			echo "Error on query: $query\n";
			echo "\t" . mysql_error();
			echo "\n";
			if ( $die_on_error ) {
				exit(1);
			}
		}
		if ( true === $result ) {
			return true;
		}
		$_ret = array();
		while ( $row = mysql_fetch_assoc( $result ) ) {
			$_ret[] = $row;
		}

		return $_ret;
	}

	$statements = array( 'ALTER DATABASE ' . DB_NAME . ' CHARACTER SET utf8 COLLATE ' . $db_collate );
	$statements[] = 'USE <code>' . DB_NAME . '</code>';

	$tables = array();
	$results = mysql_get_results( 'SHOW TABLE STATUS' );
	foreach ( $results as $row ) {
		$tables[] = $row['Name'];
		if ( ! preg_match( '/utf8_/', $row['Collation'] ) ) {
			$statements[] = 'ALTER TABLE <code>' . $row['Name'] . '</code> DEFAULT CHARACTER SET utf8 COLLATE ' . $db_collate;
		}
	}

	$_types = array(
		'VARCHAR'  => 'VARBINARY',
		'LONGTEXT' => 'LONGBLOB',
		'TINYTEXT' => 'TINYBLOB',
		'CHAR'     => 'BINARY',
		'TEXT'     => 'BLOB',
	);

	foreach ( $tables as $table ) {
		$columns  = mysql_get_results( 'SHOW FULL COLUMNS FROM <code>' . $table . '</code>' );
		$indexes  = mysql_get_results( 'SHOW INDEX FROM <code>' . $table . '</code>' );
		$fulltext = array();
		foreach ( $indexes as $index ) {
			if ( $index['Index_type'] != 'FULLTEXT' ) {
				continue;
			}
			if ( ! isset( $fulltext[ $index['Key_name'] ] ) ) {
				$fulltext[ $index['Key_name'] ] = array();
				$fulltext[ $index['Key_name'] ][ $index['Seq_in_index'] ] = $index['Column_name'];
			}
		}
		$_fulltext = array();

		foreach ( $columns as $column ) {
			if ( ! preg_match( '/utf8_/', $column['Collation'] ) ) {
				foreach ( $fulltext as $index_name => $index ) {
					if ( in_array( $column['Field'], $index ) ) {
						$statements[] = "ALTER TABLE <code>$table</code> DROP INDEX <code>$index_name</code>";
						$_fulltext[]  = "ALTER TABLE <code>$table</code> ADD FULLTEXT <code>$index_name</code> (" . join(', ', array_map( create_function( '$s' , 'return "<code>$s</code>";' ), $index ) ) .")";
						unset( $fulltext[ $index_name ] );
					}
				}
			}
		}

		foreach ( $columns as $column ) {
			if ( $column['Collation'] == '' ) {
				continue;
			}
			if ( ! preg_match( '/utf8_/', $column['Collation'] ) ) {
				$c    = '';
				$type = strtoupper( $column['Type'] );
				if ( preg_match( '/^(ENUM|SET)/', $type ) ) {
					$null         = ( $column['Null'] == 'NO' ? 'NOT NULL' : 'NULL' );
					$default      = ( $column['Default'] ? 'DEFAULT \'' . mysql_real_escape_string( $column['Default'] ) . '\'' : '' );
					$statements[] = trim( "ALTER TABLE <code>$table</code> CHANGE $column[Field] $column[Field] $type CHARACTER SET utf8 $null $default" );
				} else {
					$btype = str_replace( array_keys( $_types ), $_types, $type );
					if ( $type != $btype ) {
						$statements[] = "ALTER TABLE <code>$table</code> CHANGE <code>$column[Field]</code> <code>$column[Field]</code> $btype";
						$statements[] = "ALTER TABLE <code>$table</code> CHANGE <code>$column[Field]</code> <code>$column[Field]</code> $type CHARACTER SET utf8 COLLATE $db_collate";
					} else {
						fprintf( STDERR, "WARNING: No binary equivalent for $type. Data scrambling is likely to occur.\n" );
						$statements[] = "ALTER TABLE <code>$table</code> CHANGE <code>$column[Field]</code> <code>$column[Field]</code> $type CHARACTER SET utf8 COLLATE $db_collate";
					}
				}
			}
		}

		foreach ( $_fulltext as $index ) {
			$statements[] = $index;
		}
	}
	echo join( ";\n", $statements );
	echo ";\n";
}

echo utf8ize_generator();

And I didnt even get the string ‘hello world’

Sure, but what error log file ? Apache’s ? I’m on a shared host so I’m afaraid I don’t have access to this.

• This reply was modified 9 years, 8 months ago by mll.

Will try. Thanks, Christian.

OK, done, Thank you !

Well, this is a bit hacky (I avoid using iframes), but it gets teh job done. Thank you !

However, I’d love to have something like [wysija_archive list_id=”X” issue_id=”Y”] in the future. Let me know if this happens! 🙂

(rated & reviewed 🙂 )

Is there any workaround to make it work even if a static page is set as home ?

Further : most of the websites I make rely mainly on static pages, with few or even no blog posts. So Could it be that the carousel and jumbotron show some specific static pages (at the moment, the “What to display ?” selector only allows to chose “posts”) ?

Thank you