Posted May 30, 201510 yr Hi,i´m testing an upgrade from 3.4.7 to 4.0.6.1 on a testsiteit is a 1:1 copy from my live-site on another server from the same webhosti followed the instructions for preperations from here: http://community.inv...updated/?page=1i run in an error i can´t skip,here is my "log"###pre-check = PHP is Version 5.5upgraded to 5.6pre-check = okError = Field 'sfsMemInfo' doesn't have a default value - 1364retryError = Can't find file: './7743706db1/members.frm' (errno: 2) - 1017retry = same messagecontinueError = Unknown column 'pp_cover_photo' in 'where clause' - 1054/home/.sites/447/site7743706/web/test/system/Db/Select.php::377SELECT MAX(member_id) FROM `core_members` WHERE NULLIF(pp_cover_photo, '') IS NOT NULL OR NULLIF(pp_main_photo, '') IS NOT NULLretry = same messagecontinue = same message###IPS Support "is not able to provide support for test sites" so i´m stuck at the moment.Help please :-)thank youMcLouis
May 30, 201510 yr Error = Field 'sfsMemInfo' doesn't have a default value - 1364That 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.
June 1, 201510 yr Author sfs = Stop Forum Spamif this is the initial issue, what can i do? i deactivated all 3rd party apps / hooks prior upgradewhy is this triggering a question for "pp_cover_photo" in `core_members`?thanksMcLouis
June 1, 201510 yr Author cleared the testsite and restored the 3.4.7 database and filesthe 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!
Archived
This topic is now archived and is closed to further replies.