User login fails through the Login or Sign Up (but admin login through /admincp link is fine). Always with error:
You have entered an invalid username or password. Please enter the correct details and try again. Don't forget that the password is case sensitive. Forgotten your password? Click here!
Site language: Arabic (right-to-left).
As I sometimes see some strange characters and symbols (as the screenshot bellow), though not in final page display, I thought it might be related to the following things:
1. There is (arabic) language in the site, but maybe the vbulletin.com technician imported it from the previous 3.8.9 version of the site. I am not sure whether encoding has something to do with this!
2. I have converted tables character sets and collations, but the following tables failed:
alter table convert to character set utf8mb4 collate utf8mb4_unicode_ci;
Tables failed:
Table1: user
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes
(Table: Character Set: latin1 Collation: latin1_swedish_ci)
Note: This is also the only table that failed convert from MYISAM to INNODB, with error:
mysql> alter table user engine=innodb;
ERROR 1292 (22007): Incorrect date value: '0000-00-00' for column 'birthday_search' at row 1
Table2: userchangelog
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes
(Table: Character Set: latin1 Collation: latin1_swedish_ci)
Table3: phrase
ERROR 1062 (23000): Duplicate entry 'common.langDirRTL--1' for key 'name_lang_type'
(Table: Character Set: latin1 Collation: latin1_swedish_ci)
Table4: tag
ERROR 1062 (23000): Duplicate entry 'ÃÓØæÇäÉ' for key 'tagtext'
(Table: Character Set: latin1 Collation: latin1_swedish_ci)
Table5: words
ERROR 1062 (23000): Duplicate entry 'ÇáÓáÇã' for key 'word'
(Table: Character Set: latin1 Collation: latin1_swedish_ci)
Any idea what is the best way to check what causes the problem?
Thank you in advance.
Devami...