Blank screen instead of the SQL statements

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 6 years, 6 months ago by mll.

Well, this is at the very limit of my limited skills.

I tried :

	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 ) ); 

But the page doesn’t display anything more, and the html code still finishes as such :

<textarea cols=”100″ rows=”20″>

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’

Thanks you. So I disabled Utf8ize and then I saw that it doesn’t seem to go very far : it looks like mysql_connect( DB_HOST, DB_USER, DB_PASSWORD ) or die( 'Could not connect: ' . mysql_error() ); is the culprit :

Output is : “The function mysql_connect does not exists! mysqli_connect function exists! “