Forum Replies Created

Viewing 1 replies (of 1 total)
  • Thread Starter raptorz

    (@raptorz)

    I fixed it.

    Replace the line 40-41:

    // SHOW INDEX emulation
    		if( 0 === strpos( $sql, 'SHOW INDEX'))

    to:

    if ( 0 == strpos( $sql, 'SHOW FULL COLUMNS')) {
    			$logto = 'SHOWCOLUMN';
    			$pattern = '/SHOW FULL COLUMNS.+ [<code>]?(\w+)[</code>]?$/';
    			preg_match($pattern, $sql, $matches);
    			$table = $matches[1];
    $sql = 'SELECT column_name as Field, data_type as Type, NULL as Collation, is_nullable as Null,
                \'\' as Key, \'\' as Default, \'\' as Extra, \'\' as Privileges, \'\' as Comment
                FROM information_schema.columns WHERE table_name =\''.$table.'\';';
            }
    		// SHOW INDEX emulation
    		elseif( 0 === strpos( $sql, 'SHOW INDEX'))

    Now database upgraded successful.

Viewing 1 replies (of 1 total)