Hello! I need help with one thing.
I have OpenServer on localhost with fresh versions PHP and MySQL. In phpmyadmin I created new database in utf8 encoding and imported backup database from IPB 3.4. UTF8 was selected upon import.
After import I checked collation in phpmyadmin: all tables have utf8_general_ci
Next, I uploaded files from IPS 4.4.9.1 and runned update. Converter gave me this: Your community suite data or database configuration is saved in an encoding other than UTF-8. Before your site can be upgraded, we must convert the encoding to UTF-8.
In converter, I click on Tool button
IP.Board Character Set: utf-8
Database Character Set: utf8
Original table prefix:
Converted table prefix: x_utf_
216 tables are utf8
216 tables have incorrect collations
Can use 'dump' method: false
Next, I click on Check and fix UTF-8 collations button, and after a few seconds I get an error:
Error: Specified key was too long; max key length is 1000 bytes File: \system\Db\Db.php Line: 198
/**
* Apparently, get_charset can be unavailable
*
* @param bool $read Read only connection?
* @return string
*/
public function getCharset( $read=FALSE )
{
if ( method_exists( $this, 'get_charset' ) )
{
return ( $read AND $this->connectionDetails['readDatabase'] ) ? $this->reader->get_charset()->charset : static::get_charset()->charset;
}
else
{
return ( $read AND $this->connectionDetails['readDatabase'] ) ? $this->reader->character_set_name() : static::character_set_name();
}
}
Line 198 is public function getCharset( $read=FALSE )
Please tell me what to do, thanks!