This issue describes the upgrade process itself. Any post-upgrade issues are covered in other separate issues.
Procedure:
Localhost install
Copy of live v1 website, working properly.
Copied and overwrote v2 files over the v1 files.
Other notes:
Advice to rename .htaccess file (make non-functional), before updating. (to avoid redirecting issues in my case).
Issues overview (see details below):
$1- Invalid controller 'index'
$2- Error: moving historic members counts
$3- Update required in update_routines.php on line 1240 (Add Media-Manager Categories and Import existing images.)
$4- Forum update, step 1, query error
$5- Forum update, step 4, showing data above heading
$6- Forum update, step 4, php errors (possibly related to $5)
$7- Possible bug in 'thread move' steps
$8- Forum update, step 8, query errors
$9- Forum update button is still showing => query errors.
=> 1 - Visit website$1 First thing after overwriting the files. The index page shows:
index/index/index - Invalid controller 'index'
Probably due to not updating anything in admin area yet.
Suggestion: implement some catch that redirects to admin area after updating files. Prevent user from viewing website till after the database updates.
=> 2 - 'pre'-Database update
Entering admin area, update notification is showing. Going to e107_update.php to update DB:
.
Suggestion: Make the ""Update from 1.x to 2.0 (Must be run first)" row more prominent? Currently located second row. Maybe move it to the first row and make text bold for example?
Pete's suggestion: gray the other ones out, until this one has ran.
=> 3 - Database updates
Running "Update from 1.x to 2.0 (Must be run first)".
Results: all good, except:
"Error
moving historic member counts" $2
Then: "Add additional/missing core settings" => succes
Now: Update from 1.x to 2.0 (Must be run first) shows again. Running. Success, but still showing the update required message => debugging to see which update line is causing issues. ==> "Update required in update_routines.php on line 1240 (Add Media-Manager Categories and Import existing images.)" keeps returning... $3
Running PDF update => Succes
Running Calendar update => Succes
=> 4 - Forum update$4
Step 1: Query error:
13 SELECT f.forum_id, f.forum_parent FROM e107_forum AS f LEFT JOIN e107_forum AS fp ON f.forum_parent = fp.forum_id AND fp.forum_threadclass IN (2,3,4,1,5,253,254,250,251,0) WHERE f.forum_threadclass IN (2,3,4,1,5,253,254,250,251,0) AND f.forum_parent != 0 AND fp.forum_id IS NOT NULL
Unknown column 'f.forum_threadclass' in 'where clause'
$5
Step 4: Showing data above the 'Step 4' title
Converting forum_show_topics to show_topics
Converting forum_postfix to postfix
Converting forum_poll to poll
etc. is showing above the "Step 4: Move user specific forum data and forum prefs" heading.
Suggestion: Either move to the success/info box or hide completely.
$6
Possibly related:
Warning: mysql_query() [function.mysql-query]: Unable to save result set, Line 140 of e107_handlers\db_debug_class.php
Warning: in_array() expects parameter 2 to be array, null given, Line 191 of e107_handlers\message_handler.php
$7
Not sure if this is a bug. On step 6 it shows "There are 653 forum threads to convert, we will be doing it in steps of:".
Only option to select in the dropdown is 653. Is this correct?
$8
Step 8: query errors
545 UPDATE e107_forum SET forum_lastpost_user = 0, forum_lastpost_anon = 'Unknown', forum_lastpost_info = '1321436236.4642' WHERE forum_id=34
Unknown column 'forum_lastpost_anon' in 'field list'
669 UPDATE e107_forum SET forum_lastpost_user = 0, forum_lastpost_anon = 'Unknown', forum_lastpost_info = '1320236590.4549' WHERE forum_id=61
Unknown column 'forum_lastpost_anon' in 'field list'
678 UPDATE e107_forum SET forum_lastpost_user = 0, forum_lastpost_anon = 'Unknown', forum_lastpost_info = '1332795411.5694' WHERE forum_id=62
Unknown column 'forum_lastpost_anon' in 'field list'
Step 11: Delete old attachments.
Suggestion: Only option is to delete old attachments. Maybe add a button to skip delete but continue with update process?
Done with forum update.
Suggestion: Possibly add a button to go to the 'home' of admin area. Users might be confused as to where to click next.
=> 5 - Back to the admin area home
Back on admin area. Showing I need to update again:
"Update required in update_routines.php on line 237 (Missing pref: email_notify)" => Done, succes.
"Update from 1.x to 2.0 (Must be run first)" is still there (see $3)
$9
Forum update button is still showing. It removed the old forum table from the database (checked with phpMyAdmin) but it still wants to update.
Trying to click "Remove old forum tables" button again (step 12)
16 DROP TABLE e107_forum_old
Unknown table 'e107_forum_old'
17 DROP TABLE #forum_t Unknown table '#forum_t' 18 DELETE * FROMe107_genericWHERE gen_type = 'forumUpgrade' You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROMe107_generic` WHERE gen_type = 'forumUpgrade'' at line 1
This issue describes the upgrade process itself. Any post-upgrade issues are covered in other separate issues.
Procedure:
Other notes:
Issues overview (see details below): $1- Invalid controller 'index' $2- Error: moving historic members counts $3- Update required in update_routines.php on line 1240 (Add Media-Manager Categories and Import existing images.) $4- Forum update, step 1, query error $5- Forum update, step 4, showing data above heading $6- Forum update, step 4, php errors (possibly related to $5) $7- Possible bug in 'thread move' steps $8- Forum update, step 8, query errors $9- Forum update button is still showing => query errors.
=> 1 - Visit website $1 First thing after overwriting the files. The index page shows: index/index/index - Invalid controller 'index' Probably due to not updating anything in admin area yet. Suggestion: implement some catch that redirects to admin area after updating files. Prevent user from viewing website till after the database updates.
=> 2 - 'pre'-Database update Entering admin area, update notification is showing. Going to e107_update.php to update DB: . Suggestion: Make the ""Update from 1.x to 2.0 (Must be run first)" row more prominent? Currently located second row. Maybe move it to the first row and make text bold for example? Pete's suggestion: gray the other ones out, until this one has ran.
=> 3 - Database updates Running "Update from 1.x to 2.0 (Must be run first)". Results: all good, except: "Error moving historic member counts" $2
Then: "Add additional/missing core settings" => succes Now: Update from 1.x to 2.0 (Must be run first) shows again. Running. Success, but still showing the update required message => debugging to see which update line is causing issues. ==> "Update required in update_routines.php on line 1240 (Add Media-Manager Categories and Import existing images.)" keeps returning... $3
Running PDF update => Succes Running Calendar update => Succes
=> 4 - Forum update $4 Step 1: Query error: 13 SELECT f.forum_id, f.forum_parent FROM
e107_forum
AS f LEFT JOINe107_forum
AS fp ON f.forum_parent = fp.forum_id AND fp.forum_threadclass IN (2,3,4,1,5,253,254,250,251,0) WHERE f.forum_threadclass IN (2,3,4,1,5,253,254,250,251,0) AND f.forum_parent != 0 AND fp.forum_id IS NOT NULL Unknown column 'f.forum_threadclass' in 'where clause'$5 Step 4: Showing data above the 'Step 4' title Converting forum_show_topics to show_topics Converting forum_postfix to postfix Converting forum_poll to poll etc. is showing above the "Step 4: Move user specific forum data and forum prefs" heading. Suggestion: Either move to the success/info box or hide completely.
$6 Possibly related: Warning: mysql_query() [function.mysql-query]: Unable to save result set, Line 140 of e107_handlers\db_debug_class.php Warning: in_array() expects parameter 2 to be array, null given, Line 191 of e107_handlers\message_handler.php
$7 Not sure if this is a bug. On step 6 it shows "There are 653 forum threads to convert, we will be doing it in steps of:". Only option to select in the dropdown is 653. Is this correct?
$8 Step 8: query errors 545 UPDATE e107_forum SET forum_lastpost_user = 0, forum_lastpost_anon = 'Unknown', forum_lastpost_info = '1321436236.4642' WHERE forum_id=34 Unknown column 'forum_lastpost_anon' in 'field list' 669 UPDATE e107_forum SET forum_lastpost_user = 0, forum_lastpost_anon = 'Unknown', forum_lastpost_info = '1320236590.4549' WHERE forum_id=61 Unknown column 'forum_lastpost_anon' in 'field list' 678 UPDATE e107_forum SET forum_lastpost_user = 0, forum_lastpost_anon = 'Unknown', forum_lastpost_info = '1332795411.5694' WHERE forum_id=62 Unknown column 'forum_lastpost_anon' in 'field list'
Step 11: Delete old attachments. Suggestion: Only option is to delete old attachments. Maybe add a button to skip delete but continue with update process?
Done with forum update. Suggestion: Possibly add a button to go to the 'home' of admin area. Users might be confused as to where to click next.
=> 5 - Back to the admin area home Back on admin area. Showing I need to update again: "Update required in update_routines.php on line 237 (Missing pref: email_notify)" => Done, succes. "Update from 1.x to 2.0 (Must be run first)" is still there (see $3)
$9 Forum update button is still showing. It removed the old forum table from the database (checked with phpMyAdmin) but it still wants to update. Trying to click "Remove old forum tables" button again (step 12) 16 DROP TABLE
e107_forum_old
Unknown table 'e107_forum_old' 17 DROP TABLE#forum_t Unknown table '#forum_t' 18 DELETE * FROM
e107_genericWHERE gen_type = 'forumUpgrade' You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM
e107_generic` WHERE gen_type = 'forumUpgrade'' at line 1