Upgrade Error (Test to 4.0.6.1)

[McLouis]

Hi,

i´m testing an upgrade from 3.4.7 to 4.0.6.1 on a testsite
it is a 1:1 copy from my live-site on another server from the same webhost
i followed the instructions for preperations from here: http://community.inv...updated/?page=1

i run in an error i can´t skip,
here is my "log"

###

pre-check = PHP is Version 5.5
upgraded to 5.6
pre-check = ok

Error = Field 'sfsMemInfo' doesn't have a default value - 1364
retry
Error = Can't find file: './7743706db1/members.frm' (errno: 2) - 1017
retry = same message
continue

Error = Unknown column 'pp_cover_photo' in 'where clause' - 1054
/home/.sites/447/site7743706/web/test/system/Db/Select.php::377
SELECT MAX(member_id) FROM `core_members` WHERE NULLIF(pp_cover_photo, '') IS NOT NULL OR NULLIF(pp_main_photo, '') IS NOT NULL
retry = same message
continue = same message
###

IPS Support "is not able to provide support for test sites" so i´m stuck at the moment.

Help please :-)
thank you
McLouis

[stoo2000]

Error = Field 'sfsMemInfo' doesn't have a default value - 1364

That looks like the initial issue, it's also not a default column, it's one that's been added by a 3rd party app/hook.

[McLouis]

sfs = Stop Forum Spam
if this is the initial issue, what can i do? i deactivated all 3rd party apps / hooks prior upgrade

why is this triggering a question for "pp_cover_photo" in `core_members`?

thanks
McLouis

[McLouis]

cleared the testsite and restored the 3.4.7 database and files
the testsite is working fine again...

i looked in the DB, there is no column "pp_cover_photo" or "pp_main_photo" in `core_members` ?!
how is this possible? i didn´t modify the database in any way!