Jump to content

Kinkl

Snow
  • Posts

    12
  • Joined

  • Last visited

About Kinkl

  • Birthday April 1

Profile Information

  • Language
    English
  • Software
    IPS4
  • Version
    4.4

Recent Profile Visitors

813 profile views

Kinkl's Achievements

Rookie

Rookie (2/14)

  • First Post
  • Collaborator Rare
  • Conversation Starter Rare
  • Reacting Well
  • Week One Done

Recent Badges

1

Reputation

  1. Hello! ? Is there a modification so that before sending a message in a particular topic, the users is presented with a message that they must accept it to send a message in topic? Something like this, but for a new post, not a topic. https://invisioncommunity.com/files/file/7973-new-topic-rules/ Thanks!
  2. Thanks for help, seems problem was solved. Manual conversion of the database to utf8_unicode_ci using the HeidiSQL helped. After that I launched /upgrade/ and step with converter was skipped!
  3. I running on localhost (OpenServer). Checked mysql config file: [client] port = %mysqlport% character_sets_dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" [mysql] no-auto-rehash no-beep character_sets_dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" [mysqld] # Required Settings basedir = "%dprogdir%\\modules\\database\\%mysql_driver%" bind-address = %ip% character_sets_dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" character_set_server = utf8mb4 collation_server = utf8mb4_unicode_ci datadir = "%dprogdir%\\userdata\\%mysql_driver%" default_storage_engine = InnoDB explicit_defaults_for_timestamp = 1 ft_min_word_len = 3 local_infile = 0 lower_case_table_names = 1 max_allowed_packet = 256M pid_file = "%dprogdir%\\userdata\\temp\\mysql.pid" port = %mysqlport% secure-file-priv = "%dprogdir%\\userdata\\php_upload" #skip_name_resolve = 1 ssl = 0 tmpdir = "%dprogdir%\\userdata\\temp" character_set_server = utf8mb4 collation_server = utf8mb4_unicode_ci Perhaps the problem is here? What encoding should the tables have in 4.4?
  4. First command: SQL query: ALTER TABLE core_applications CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci MySQL said: Documentation #1253 - COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8' Second command: MySQL returned an empty result set (i.e. zero rows). (Query took 0.0270 seconds.) This is really insane, year ago I upgrading from this 3.4 database to 4.3 without any problem with encoding
  5. Trying, no result MySQL returned an empty result set (i.e. zero rows). (Query took 0.0010 seconds.) I found an interesting thing, this is screen from phpmyadmin. Looks like some tables (in the red rectangle) have been converted through ConvertUTF8 ?
  6. 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!
  7. @Cookie Monster logfile with error is empty... Also, I look for errors in Admin CP journals, empty too. I have seen this solution for IPS 4, but I compared facebook file from IPS 4 with the file from 3.4 on my server, they are very different. Also, in IPB 3.4 facebook file location is: admin/sources/classes/facebook/connect.php
  8. @Cookie Monster if user trying to login using account with Facebook profile, getting blank page with error 500.
  9. Facebook Login error Hello! Facebook upgraded API to new version, and Facebook Connect gives an error message when user tries to login. Solution for IPS 4 is available, but not for 3.4... I tried to find any info on web, but failed Can anybody help me please? Thanks!
  10. @Unconnect, thanks. It seems that the problem was solved. I have 3.4.6 version. I took the "connect.php" file (admin/sources/classes/facebook/connect.php) from 3.4.8, and it works! :)
  11. @Unconnect, can you give screenshot of items in Status & Review tab please? I have only: LOGIN PERMISSIONS email public_profile user_friends Or am I looking in the wrong place?
×
×
  • Create New...