Upgrading 2.3.10 to 3.6.1 - Step 27 Error

[Dredflee]

Hello,
I've run for a long time 2.3.10 and now I want to install 3.6.1. I don't want any problems (nor with the design or functionality), so I've made a copy of my old db, and I'm getting an error at Step 27:
Warning: Invalid argument supplied for foreach() in /home/httpd/vhosts/xf.ro/httpdocs/forum3/install/upgrade_300b3.php on line 3230
Warning: in_array(): Wrong datatype for second argument in /home/httpd/vhosts/xf.ro/httpdocs/forum3/install/upgrade_300b3.php on line 3251
Warning: in_array(): Wrong datatype for second argument in /home/httpd/vhosts/xf.ro/httpdocs/forum3/install/upgrade_300b3.php on line 3251
Warning: in_array(): Wrong datatype for second argument in /home/httpd/vhosts/xf.ro/httpdocs/forum3/install/upgrade_300b3.php on line 3251
Warning: in_array(): Wrong datatype for second argument in /home/httpd/vhosts/xf.ro/httpdocs/forum3/install/upgrade_300b3.php on line 3251
Warning in_array(): Wrong datatype for second argument in /home/httpd/vhosts/xf.ro/httpdocs/forum3/install/upgrade_300b3.php on line 3251
Warning: in_array(): Wrong datatype for second argument in /home/httpd/vhosts/xf.ro/httpdocs/forum3/install/upgrade_300b3.php on line 3251
Warning: in_array(): Wrong datatype for second argument in /home/httpd/vhosts/xf.ro/httpdocs/forum3/install/upgrade_300b3.php on line 3251
Warning: in_array(): Wrong datatype for second argument in /home/httpd/vhosts/xf.ro/httpdocs/forum3/install/upgrade_300b3.php on line 3251
Warning: in_array(): Wrong datatype for second argument in /home/httpd/vhosts/xf.ro/httpdocs/forum3/install/upgrade_300b3.php on line 3251
Warning: in_array(): Wrong datatype for second argument in /home/httpd/vhosts/xf.ro/httpdocs/forum3/install/upgrade_300b3.php on line 3251
Warning: in_array(): Wrong datatype for second argument in /home/httpd/vhosts/xf.ro/httpdocs/forum3/install/upgrade_300b3.php on line 3251Do you have any clue? Thank you!

[Zachery]

Step 27 of what upgrade file?

[Dredflee]

The first upgrade file that runs, upgrade_300b3.php, I guess.
Thanks!

[Dredflee]

So what's seems to be the solution here? It's step 27/42 from the first upgrade from 2.3.10 to 3.6.1.
Thank you in advance!

[Steve Machol]

Which versions of PHP and MySQL are you running? Have you installed any hacks to your vB?

[Dredflee]

PHP version: 4.4.2.
MySQL version: 4.1.20.
I have some hacks installed. Should I provide additional info about the hacks?

[Steve Machol]

Do you have any hacks that affect the vB settings? That appears to be the source of this problem.

[Dredflee]

Yes, I do. I have two-three rows added in the `setting` table. Where can I find a "clean" table? :) (if this is the solution, of course).
Very fast feedback. Thank you once again.

[Steve Machol]

You could manually remove the changes made by your hacks to this table. If you use a 'clean' table, all your settings will disappear.

[Dredflee]

The problem is that not all the hacks were installed by me and I don't know for sure how many records the table should have (and wich ones). Right now, I have 179 records.

[Steve Machol]

You could install a test copy of 2.3.10 and see what the table is supposed to look like.

[Dredflee]

I've 'normalized' both `setting` and `settinggroup` with no result. Any other tables I should look at?
Thanks.

[harmor]

I suggest installing a clean version of 2.3.10 on a test site. Then compare your current database with the new one, see what tables and fields do not belong and delete them.

[Dredflee]

I've did this, and no result.
I've imported clean setting and settinggroup tables and still no results.
Any other ideas?
Thank you.

Later edit: The same error is encountered with a clean database from a fresh local installation of the 2.3.10 version. Could it be a hosting problem?

[Dredflee]

I've tried upgrading to 3.6.2 and it worked until step 37 where I recieve the following error:
Fatal error: Cannot create references to/from string offsets nor overloaded objects in /home/httpd/vhosts/xf.ro/httpdocs/forum3/includes/class_core.php on line 1274Do you have any idea of this error?
Thank you.

[Steve Machol]

Which script is running when you get this error?

[Dredflee]

It's about the same upgrade_300b3.php script.
Thanks!

[Adi211]

It's about the same upgrade_300b3.php script.
Thanks!
i have the same problem :(

i've solved the problem :)
http://www.vbulletin.com/forum/showpost.php?p=1194991&postcount=4
thx

[Steve Machol]

Fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.

[Dredflee]

Steve, as you can read in the first posts I am using a copy of the original database, so an assisted install may not be very helpful as I want first of all to configure and customize the appereance before going live.
What do you think?
Thank you.

[Steve Machol]

I think you should open a support ticket so we can help. That's why I made that suggestion. :)

If you don't want to do that then I don't know how to fix this problem without the access I requested.

[Dredflee]

Steve, thank you very much for the support. Can you tell me what was wrong? Because I will have to repeat the operation one more time on the original database :)
Great job!

[Steve Machol]

I handle 50-70 tickets a day and unfortunately I cannot remember this one specifically. I believe it was just a matter of editing the database manually for a few steps to get this going without errors.

[UserName]

I've tried upgrading to 3.6.2 and it worked until step 37 where I recieve the following error:
Do you have any idea of this error?
Thank you.

I have had the same error. Can someone please post the solution? Why make everyone fill out a support ticket if we are all having the same problem? :)

[Zachery]

Because most issues are not the same, either start your own ticket or thread.

Thank you/.

[Steve Machol]

And because the solutions are not only different but each one is very complicated and requires an expert to go through the database and upgrade prrocess to fix. Most people actually appreciate this level of support but if you don't, that's ok. Good luck. :)