Got an error:

Table 'd35392sd51583.convert_logs' doesn't exist
#0 /system/Db/Db.php(2169): IPS\Db->query('ALTER TABLE `co...') #1 /system/Application/Application.php(1765): IPS\Db->changeColumnsAndIndexes('convert_logs', Array) #2 /applications/core/sources/Setup/Upgrade.php(565): IPS\Application->installDatabaseUpdates(106100, 0, 10, true) #3 /applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1(Array) #4 /applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process(Array) #5 /system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->{closure:IPS\core\modules\setup\upgrade\upgrade::manage():47}(Array) #6 /applications/core/modules/setup/upgrade/upgrade.php(45): IPS\Helpers\MultipleRedirect->__construct(Object(IPS\Http\Url), Object(Closure), Object(Closure)) #7 /system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() #8 /system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() #9 /admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #10 {main}
/applications/convert/setup/upg_106100/queries.json - query #0

ALTER TABLE `convert_logs` CHANGE COLUMN `log_message` `log_message` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'Log Message';

Okay, I made a table convert_logs but now have another error:

Column count doesn't match value count at row 1
/../

INSERT IGNORE INTO `convert_logs_new` SELECT * FROM `convert_logs`;

Theres no convert_logs in my testinstall, which upgraded successfully on first time.

You need to revery to your backup and start the process again there, as something has clearly gone wrong in the creation of tables there. At this point, you could be losing data when recreating tables

Are those tables only for Converter app? Can I uninstall it? My testinstall does not have Converter app installed and it works fine.

As of yesterdays database errors, do i need to revert back from backup if i did like this:

I had an error "Table convert_logs doesn't exist":

ALTER TABLE `convert_logs` CHANGE COLUMN `log_message` `log_message` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'Log Message';

Then I made convert_logs table:

CREATE TABLE `convert_logs` (
  `log_message` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'Log Message'
);

after that I got a new error "Column count doesn't match value count at row 1":

INSERT IGNORE INTO `convert_logs_new` SELECT * FROM `convert_logs`;

and I copied all convert_logs_new scheme to convert_logs and upgrader finished successfully.

Actually I'm not very keen on restoring from backup because I already went live and theres new content already. Will it be enough?

21 minutes ago, hmikko said:

after that I got a new error "Column count doesn't match value count at row 1":

INSERT IGNORE INTO `convert_logs_new` SELECT * FROM `convert_logs`;

and I copied all convert_logs_new scheme to convert_logs and upgrader finished successfully.

This error means that the query doesn't have as much values as the table in question does contain columns.

24 minutes ago, hmikko said:

and I copied all convert_logs_new scheme to convert_logs and upgrader finished successfully.

Actually I'm not very keen on restoring from backup because I already went live and theres new content already. Will it be enough?

If that was the only error that you got and the upgrade is finished successfully then that would be enough imo.

You can remove that application if you havent previously done a conversion

I did conversion in 3.3 from phpBB. Does it count? All 14 convert database tables are empty, only one (conv_link) has 33K entries.

And one dumb question more - how do i uninstall Converters? 🤭

1 minute ago, hmikko said:

I did conversion in 3.3 from phpBB. Does it count? All 14 convert database tables are empty, only one (conv_link) has 33K entries.

Do you mean you converted to Ipb 3? In that case I think that it's safe to uninstall the Converters app, but first make a backup of the table(s) that have content in them, just in case.

3 minutes ago, hmikko said:

how do i uninstall Converters? 🤭

You can uninstall it from the Application area of your Admin Panel.

3 minutes ago, hmikko said:

And one dumb question more

There's no such thing as a stupid/dumb question.

Edited February 17Feb 17 by Miss_B

If you have items in conv_link you shouldnt really uninstall, unless you are happy to lose conversion data. This holds things like links from old URLs to new URLs. I guess it really depends on how long ago it was you converted, as to how much difference it will make.

8 hours ago, Miss_B said:

There's no such thing as a stupid/dumb question.

I sure feel like one because I just can't find "Delete" or "Uninstall" button anywhere 😆

Clicking on Converters won't open any submenus, don't know why theres arrow like theres something.

8 hours ago, Marc said:

If you have items in conv_link you shouldnt really uninstall, unless you are happy to lose conversion data. This holds things like links from old URLs to new URLs. I guess it really depends on how long ago it was you converted, as to how much difference it will make.

Links did never work as we could not got them working with support. So this should not be a problem ☺️

Edited February 17Feb 17 by hmikko

Ah, it would not let you uninstall, as syou have a conversion present. What issue are you actually having, as you appear to be on the 5.0.1 release

I had an upgrade errors before I did some database tables myself and could not get site upgraded. But as it seems I don't need Conversions anymore, I think it's better to get rid of them because it might cause problems in the future.

Afraid to upgrade to 5.0.2 because of database errors again.

Edited February 18Feb 18 by hmikko

9 minutes ago, hmikko said:

I had an upgrade errors before I did some database tables myself and could not get site upgraded. But as it seems I don't need Conversions anymore, I think it's better to get rid of them because it might cause problems in the future.

Afraid to upgrade to 5.0.2 because of database errors again.

What database errors were you getting? It would help if you posted the full error message(s).

The ones in my first and second post 😁

Table 'd35392sd51583.convert_logs' doesn't exist

ALTER TABLE `convert_logs` CHANGE COLUMN `log_message` `log_message` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'Log Message';

Column count doesn't match value count at row 1

INSERT IGNORE INTO `convert_logs_new` SELECT * FROM `convert_logs`;

How did you get the site upgraded previously?

Before v5? Like upgrading to v5 but never got any errors.

You are now on version 5, however you said you had those issues when upgrading to version 5. So Im asking how you managed to get upgraded

It seems I have been a bit confusing 😁

Well when I got those errors while upgrading, I manually created table in database. Then upgrader run a bit and I got another error. Then I copied new error database schema to table I created previuosly and upgrader run successfully.

On 2/17/2025 at 12:25 PM, hmikko said:

As of yesterdays database errors, do i need to revert back from backup if i did like this:

I had an error "Table convert_logs doesn't exist":

ALTER TABLE `convert_logs` CHANGE COLUMN `log_message` `log_message` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'Log Message';

Then I made convert_logs table:

CREATE TABLE `convert_logs` (
  `log_message` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'Log Message'
);

after that I got a new error "Column count doesn't match value count at row 1":

INSERT IGNORE INTO `convert_logs_new` SELECT * FROM `convert_logs`;

and I copied all convert_logs_new scheme to convert_logs and upgrader finished successfully.

Glad to see that the issues have been solved and you were able to upgrade your forum successfully.