Upgrade problems to IPB 4 from 3.4.8

[steel51]

On my way from vb 4.2.2 Im stuck at step 7 from the upgrade script from ipb 3 to ipb 4. Can you help?

a) requirements checker was green

b) I got several errors during the upgrade, but everytime I was able to press "continue", except for the last step (Number 7). Pressing "continue" is not possbible because I have the same result.

All other errors during the upgrade:

Errors during upgrade: 

1.
Table 'ipb.login_methods' doesn't exist
/var/www/vhosts/my.domain/httpdocs/system/Db/Select.php::390

SELECT * FROM `login_methods`

--> Continue

2.
Duplicate entry 'm-1' for key 'leader_type'
/var/www/vhosts/my.domain/httpdocs/applications/core/setup/upg_40000/upgrade.php::1659

INSERT INTO `core_leaders` ( `leader_type`, `leader_type_id`, `leader_group_id` ) VALUES ( ?, ?, ? )

--> Continue

3.
Column count doesn't match value count at row 1
/var/www/vhosts/my.domain/httpdocs/applications/core/setup/upg_100010/upgrade.php::52

INSERT INTO `core_theme_resources` SELECT `image_id` AS `resource_id`, `image_set_id` AS `resource_set_id`, `image_app` AS `resource_app`, `image_location` AS `resource_location`, `image_path` AS `resource_path`, `image_name` AS `resource_name`, `image_added` AS `resource_added`, `image_filename` AS `resource_filename`, `image_plugin` AS `resource_plugin`, `image_data` AS `resource_data` FROM `core_theme_images`

--> Continue

4.
Unknown column 'field_4' in 'where clause'
/var/www/vhosts/my.domain/httpdocs/applications/cms/setup/upg_40000/upgrade.php::415

UPDATE `cms_custom_database_1` cms_custom_database_1  SET `field_4`=? WHERE field_4 ='' OR field_4 IS NULL 

--> Continue

5.
Duplicate column name 'USD'
/var/www/vhosts/my.domain/httpdocs/applications/nexus/setup/upg_40000/upgrade.php::160


--> Continue

6.
Duplicate entry '1' for key 'PRIMARY'
/var/www/vhosts/my.domain/httpdocs/applications/nexus/setup/upg_40000/upgrade.php::611

INSERT INTO `nexus_package_base_prices` ( `id`, `USD` ) VALUES ( ?, ? )

--> Continue

7.
Invalid argument supplied for foreach()
/var/www/vhosts/my.domain/httpdocs/applications/core/sources/Setup/Upgrade.php::1192

--> Continue: Not Possible. 

c.) I executed all myswl procedures manually with success via mysqlworkbench (Screenshot)

Anyone has any Idea on this?

 

[steel51]

Find a workaround for me:

In upgrade.php (line 1192)

Find: 

foreach ( $settings as $k => $v )

Replace with:

foreach ((array) $settings as $k => $v )

 

 

 

 

 

Argh...

Now, after migration, german "umlaut" wont be displayed correctly

Any solutions for this?

Viele Informatikstudiengänge verlangen häufig Projektarbeit,

[wimg]

Did you use utf8 or utf8-mb4 for the conversion?

You probably need to use utf8-mb4 for extended characters.

HTH, kind regards, Wim