Jump to content

jnikola

Clients
  • Joined

  • Last visited

  1. Hi again. To summit it up, the script that regenerates the caches helped a lot. Thanks Kiril! But there is a problem with non-latin characters and UTF8 encoding. Please let me know if you have any suggestions as I was able to make it work but I'm not sure how this might affect the upcoming upgrade to V4. - All tables and columns are already "utf8_general_ci" - MySQL server config by default sets the character set to utf8 for "mysql", "mysqld" - php.ini has the default_character_set as utf8 - ACP document encoding value is UTF8 - conf_global.php had the character-set value as "" After migrating the DB to a new server, that should be identical to the old, with these settings I am having issues with non-latin characters in posts and templates. When setting $INFO['sql_charset'] = 'utf8' in conf_global.php problems persist. When setting $INFO['sql_charset'] = 'latin1' in conf_global.php it works good. I'm confused as I believed that after conversion from phpBB the IPB forum is UTF8 encoded but it seems that it is Latin1. If leaving as $INFO['sql_charset'] = 'latin1' while everything else is set to utf8, might that in any way negatively affect the upgrade to V4?
  2. I tried to replicate everything as it was on the old server. A community member helped me out with a script that rebuilds the caches and that resolved the problem partly as the forum started working again. It's just that I lost many non-ascii characters in the templates and posts. So yes, it's some issue related to db migration and character encodings,.. maybe because it was initially converted from phpBB. I hoped that specifying UTF8 during export/import would help with that.. I'll try to export the DB using Percona Xtrabackup as that one is done on binary level I believe, but I was hoping that I can do a simple mysql dump and importing that.
  3. This seems to be some issue with deserializing caches stored in the database, especially the long "settings" value.. I'll see if I can figure it out..
  4. Hi Marc, The database connection works good, as when I change the details to bad login credentials, it returns a different error about not being able to connect to the database. I also successfully tested those credentials against queries. Ok, I'll see if I can figure this out, ...but is there any way to get some logs or clear the cache without having access to the ACP ? Thanks.
  5. .. or at least how to debug this. I cannot find any error logs. Thanks
  6. Hi, I'm in the process of upgrading an old IP.Board v3.4.6 to the current version. As my current server will be shut down soon, as the first step I need to migrate the v3 forum to a new server and then install the latest php + mysql and do the upgrade. The new server has the same PHP5.5 and MySQL 5.5. versions. 10+ years ago the forum was migrated from phpBB. After moving all the files and doing a database export/import I am getting the following error: The original database has utf8_general_ci collation set for all tables. The HTML has <meta charset="UTF-8" /> set. There are non-ascii characters used as it's a non-english forum. I did the export/import using the following commands, specifying the character set. $ mysqldump -u forum_user -p --default-character-set=utf8 -r /home/user/forum.sql forum_db $ mysql -u forum_user -p --default-character-set=utf8 forum_db < forum.sql Any ideas on how to resolve this?