...
Nope... still same error; I will revert the change in the php.ini file... as that had no impact it seems!
...
Try #5: This time, with Views caching disabled, because upon inspecting the import, it turns out that it has error'd out on the caching table each time:
So on the live site, we will not only disable Views caching, but also clear out the cache overall and then export the DB:
As can be seen, Views caching is not disabled... so let's disable it...
Alright, let's re-export and then import again, and see how it fares this time...
Prior to importing, need to drop the half-imported DB:
Alright... we get confirmation that prep DB been dropped... let's import the database again...
Let's check where it stopped...
Yep... it's the same table that is causing the import problem... each failed import has stopped at cache_menu — more research time!
I noticed that there is an option to flush all caches...
so let's try that:
And we export from RHEL6.... and then try importing it to RHEL7........ ......... again
So the file sizes between the previous try and the current one are definitely different... let's see what happens on import:
SAME ERROR... checking the progress (i.e. how much was it able to import...)—
Again, it stopped at cache_menu... so apparently, Flush all caches didn't do what I thought it would do...
There is a sub-sub-menu item "Menu"----let's see if clearing that has any effect?
Prior to clicking that option, here's the cache_menu table on RHEL6—
Clearing menu cache:
cache_menu table on RHEL6 now....
No change :-/
More research....
...
Try #? — Import using the SQL tab?
Let's drop the DB first--
Interesting:
The details didn't help... running the pasted SQL—this is with the hope that if it errors out, we have a detailed (which line in the script it failed on error) info:
Yea... no dice:
Looking at the SQL file, we know that the import always fails on cache_menu after inserting 7 records and so what's the 8th record? Check this out:
Yea... I am sure that is above the max setting... getting rid of that insert and trying the import again:
Note: removing that one query alone dropped the file size by a good chunk... Also note, we are not too worried about that one record — because it's a cache record anyways... so the system should be able to rebuild it.
AND..... .SUCCESSSSSS! We have the DB imported:
Now, comes the code....
rsync -av PREP rjb03001admin@phptst1.its.uconn.edu:/apps
Nice! The code has been moved off of RHEL6 and onto RHEL7—
Change the settings file, same as with other portals:
vim /apps/PREP/sites/default/settings.php
→ Change $update_free_access to TRUE
→ Add (for troubleshooting purposes)---
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
$conf['error_level'] = 2;
Save and quit; let's navigate to the portal and see what's up:
Nice! we are not going to login... instead, we will do the Drupal update process:
And we get:
Something is wrong........... must be the conf file....
So prior to making any changes to the conf file, let's back it up:
Let's open-up the prep conf file...
Sure enough... the AuthType is there and it shouldn't...
Here's how it should be:
Save and quit and then give Apache a boot...
Let's access the Drupal's update process—
Much better:
Let's create a user using phpMyAdmin---
Look at the settings file for the needed info—
Let's refresh Firefox and see what we get...
MUCH BETTER! Before following-through with the update process, let's update CAS and LDAP related modules and then re-load the Drupal's update process...
Okay...
We have encountered rules module related error before... so before we move onto the Front page, let's update the rules module and then re-run the Drupal's update process...
Let's update the rules_conditional module too... On the live site, go to Available updates and download from the provided link:
Upload the tar.gz file directly onto the server
Remove the rules_conditional folder (do it either via FileZilla GUI or command line) and then extract the archive
Remove the archive... and let's re-run the Drupal's update process...
Awesome! Let's hit the Front page — we should be greeted with a CAS login page!
AWESOME!!! After logging in... ... ...
Huh!? Let's try a completely fresh browser session...
After logging-in, same:
Hmmm.... onto Research!
The following Q/A helped resolve this problem:
https://drupal.stackexchange.com/q/166358/72255
Visiting PREP2 now greets with a CAS login instead!
Upon authenticating, we get to the landing page of the PREP tool!
We do have a module that seems to be out of date: admin_menu — let's update it!
Get the downloaded tar.gz file onto RHEL7 and extract and then run the Drupal's update process as before...
