Jurij

Convertion is a part of upgrade process so... Will have to validate in PhpMyAdmin after convertion and before upgrade that database is not damaged. This is tricky, because there was no issues during convertion and the database got corrupted anyway 🤔 Anyway working on reverting backup now 🙂

Ok. I have to focus on getting back working database first, then i will think about upgrading it again.

So basically this backup made by IPS Converter is useless and we can't use it to repair database?

And i still need to revert back to previous version using my FTP and SQL database backup? Just making sure before i will get back to previous IPB and will have to start upgrade from the very beginning, sorry if it's stupid question 😉

I know it's not supported anymore, that's why i'm doing upgrade.

Quote

The issue you have is that there is a problem with the character set somewhere prior to you upgrading

Yes and if i will restore my backup how to determine what is wrong with the database or what to do to prevent IPS converter from damaging database again during upgrade?

From a very old release 3.4.8.

So there is no way to run convertion from original tables again?

Let's say i will revert my backup. I will land on previous version of IPB. How to determine if there is no problem with database or how to fix it before forum upgrade / conversion?

Hello,

After upgrade to IPS 4.7.10 i've noticed that database has been damaged. Instead of polish letters like ęąźćś i have question marks ?????. I've checked inside of the database and discovered it's database trashed by itself. Example:

Here is the screenshot from original forums table containing forum topics:

Here is the very same table after conversion by IPS converter:

Is there any way to fix that other than uploading backup and getting back to previous version?

Thanks for any advice and best regards,

Jurij

Hello,

Problem is now solved by Invision Community Team. It appeared to be a bug in update process. They have a fix but they don't know in which version it will be implemented yet.

Thank you very much for help and best regards,

Jurij

Hello,

Thanks for quick reply. I've updated "stored access information" section. Please let me know if you will have any troubles with logging to FTP / ACP.

Best regards,

Jurij

Hello,

I'm upgrading forum to the latest 4.7.10 version and upgrade process has stuck on the error:
 

Unknown column 'forums_topics.publish_date' in 'where clause' :

/public_html/system/Db/Select.php::446

SELECT * FROM `sonyforums_topics` AS `forums_topics` WHERE forums_topics.forum_id=? AND forums_topics.approved=1 AND forums_topics.state != ? AND forums_topics.last_post<=? AND forums_topics.publish_date <=? ORDER BY forums_topics.last_post DESC LIMIT 1

Retry and continue buttons do not work and i can't proceed with the upgrade. Is there any way to solve this problem?

Thanks,

Jurij