Upgrade Concrete5 from 5.5.2.1 to 5.6.3.2 Errors

Permalink 1 user found helpful
Upgraded to 5.5.2.1 and updated all addons and made sure site was working correctly.
Backedup DB.
Did not find anywhere to clean cache.
Put into Maintenance mode.
Checked all addons for need to upgrade, none.
Backed up DB again.
Tried upgrade from 5.5.2.1 to 5.6.3.2

Got errors.
Tried redirecting pointers to upgrade/5.5.2.1
Still fails.

Do I need to get it out of Maintenance mode? How?
Do I need to import one of my backed up db into my Concrete install?

Thanks

1 Attachment

fcgleason
 
fcgleason replied on at Permalink Reply
fcgleason
I have NEVER had success with PUSH button upgrade. It ALWAYS FAILS. This is very disappointing. My experience with Wordpress is much more favorable. I never have to get into the innards!

Do I have to reload the older database again to recover?
fcgleason replied on at Permalink Reply
fcgleason
I just went to my website phpmyadmin
https://yourwebsite.com/phpmyadmin...
and logged in and found two tables Config and config

Config
SITE_APP_VERSION 5.x.x.x 5.5.2.1
APP_VERSION_LATEST 5.x.x.x 5.6.3.2

config
SITE_APP_VERSION 5.x.x.x 5.4.1
APP_VERSION_LATEST 5.x.x.x 5.4.1

1. There are duplicate tables in the entire database. I believe the tables with all lower case are earlier and associated with transffering from Wamp? -- I am not sure about this, but I think so. --- Should I be deleting the all "lower case" tables? There must be 40 to 50 of these tables in the database.

2. In the "Config" table which I believe is being used by Concrete on our Centos Server, the "Site_app" and "App_Version_Latest" do not match because after the first upgrade failure I pointed "site.php" to the earlier version that I had working which was 5.5.2.1

3. Now do I have to import the db that I saved to get this back to working in 5.5.2.1?

4. Then if that works, how should I upgrade, the BUTTONS DO NOT WORK PROPERLY.
fcgleason replied on at Permalink Reply
fcgleason
I am trying to get access to download the 5.5.2.1 backup databases that are on my server located at mysite.com/files/backups/

I cannot download the file here because I am unable to get 777 permissions even when I rename the .htacess file in the backups/ directory to temp

The .htacess file has the following:
Order Deny,Allow
Deny from all

Would it help to comment out these two commands somehow?
Or should I delete the .htacess file.

Using SSH access with filezilla, I am not allowed to download my backup databases.
I think I've tried most everything but I do not know how to give myself access to the db files that got backed up to my server under file/backups/

Any ideas? I am trying to get back to the 5.5.2.1 db that works and I have updated from 5.4.2.1.

Thanks
fcgleason replied on at Permalink Reply
fcgleason
Ok, I finallly figured out how to download my /files/backups/ XXXXX.sql [The db files that are backed up by Concrete5] back to my local computer. I was trying to use Filezilla with the permissions (SFTP) set up for the concrete website, and this particular folder would not give me permission to read and the download always failed. I tried changing permissions to 777 and then commenting out the .htaccess folder, and then deleting the .htaccess folder (have since restored it), etc. Nothing worked!

The Problem: I did not have the required permissions to those files. I thought about that and did some reading about logging in as Superuser, then realized that I had a SFTP 'root' login that might work. I tried it and that was the answer for me, I could then download the backup db files from .../files/backups/

Now I can zip the correct backup file and then go back into phpmyadmin, open the concrete db, drop all the tables, then import the zipped db and hopefully the website will work again, after about the fourth failed upgrade!
fcgleason replied on at Permalink Reply
fcgleason
Ok, I zipped one of the db, went into PHPmyAdmin, dropped or deleted all the tables in the current "concrete" database, then imported the zipped database (zip is necessary because of file size limits for db). The db was imported and if found the following under Config table,

SITE_APP_VERSION 2014-11-06 17:03:09 5.4.2.2
APP_VERSION_LATEST 2014-11-20 20:36:52 5.5.2.1

So I checked the site.php file for site.php
define('DIRNAME_APP_UPDATED', 'concrete5.5.2.1');

Then tried to load the website and got a big database error.
Then from within PHPmyAdmin I edited the Config table so
SITE_APP_VERSION 2014-11-06 17:03:09 5.5.2.1 <--- changed this to match
APP_VERSION_LATEST 2014-11-20 20:36:52 5.5.2.1

Tried running it and still go db errors. So then I reloaded the database again and
SITE_APP_VERSION 2014-11-06 17:03:09 5.4.2.2
APP_VERSION_LATEST 2014-11-20 20:36:52 5.5.2.1

decided to try running site.php with
define('DIRNAME_APP_UPDATED', 'concrete5.4.2.2');

I called it up and it now appears to be running.... now what?
I certainly don't want to go through this again, but I would like to get this site upgraded.
WebcentricLtd replied on at Permalink Reply
Hi,
you said the upgrade to 5.5 went ok and everything was fine.
You took a backup of the upgraded 5.5 database and then attempted the upgrade to 5.6 which failed.

However, you have rolled back to 5.4.2.2 - so you must have restored the original backup.

From what I've read (and I may have misunderstood) you should have a 5.5 backup from directly after your successful first upgrade.

That being the case you should be able to restore that 5.5 database and change your config file to point at the 5.5 codebase (you should not need to change anything in the config table).

At that point (so long as you didn't change any of the 5.5 files subsequently) you should be back at the point where you have a working instance of 5.5.

If then you decide to attempt the upgrade to 5.6 and it fails make a full note of the database error or other errors that you see and post it back on here -chances are someone may have seen it and know how to resolve but without the error messages it is all down to guesswork.
fcgleason replied on at Permalink Reply
fcgleason
Thanks Andy,

You are right I did have a db saved from the most recent version 5.5.2.1 and I could have used that but I did not know if the "Maintenance mode" setting was in the db. I was also having troubles because it was stuck in maintenance mode, so I don''t think I am going to use that when upgrading as it just creates more trouble.

I now understand I can undo the maintenance mode setting at this path
To Get out of maintenance mode
=========================
dashboard/system/permissions/maintenance

So, what I did was go back to the earlier version and this time for some reason, I could upgrade all the addons easily, then upgrade to 5.5.2.1 from within the dashboard after saving the db several times and turning off caching etc.

So now I am at 5.5.2.1 again (and very nervous about upgrading straight to 5.6.2.2 or whatever. So I am going to do the following:
1. Go back to the dashboard. Make sure all addons are up to date. Turn of caching, clear cache and get ready to save the db.
2. Load Phpmyadmin and save my db to my local hard drive several times.
3. Go into the dashboard and save the db several times.
4. Go into filezilla sftp loggin not just for the site but as 'superuser' for the whole VPS because otherwise I do not get permissions to download the db directory files at this location because it is protected and I cannot change the permissions with the website loggin.
..concrete/files/backups/ Download the recent backups to my local computer in case I need them.
5. Download the best next version Concrete5 - is that 5.6.3.2?
6. After backing up the db try to drop all the duplicate tables in my db that are all lowercase and see if it is still working correctly. If it is, save those db with phpmyadmin and dashboard and use those db.
7. If it is not working at that point i will have to reload the db that I saved, not too hard now.

8. After download of the next version upload it into the upgrades directory. And try the upgrade from the dashboard again.
WebcentricLtd replied on at Permalink Reply
hi,
post back with any issues you have upgrading to 5.6.3.2 and make sure you capture any error messages. I think you can just likely ignore the duplicate lower case tables if you want.

I would be a little worried that you might have some mismatched database schema - the fact you have both camel and lower cased table names might mean that single word named tables weren't upgraded (config for example). But I guess that'll come out in the wash - I'd test the 5.5 instance rigorously before upgrading to 5.6.

Like I said, any issues - post them here with mesages / screenshots etc.

thanks,
Andy
fcgleason replied on at Permalink Reply
fcgleason
Did as said I would above, results following:

Update from 5.5.2.1to 5.6.2.1

Fatal error: Call to undefined method AddBlockBlockTypePermissionAccess::isPermissionKeyInUse() in /home/shyc-cc.org/public_html/updates/concrete5.6.1.2/concrete/helpers/concrete/upgrade/version_560.php on line 284

----
Then logged back in
Still on 5.5.2.1 picked upgrade to 5.6.2.1

An Unexpected Error occurred while upgrading: #0 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(641): adodb_throw('mysqlt', 'DOQUOTE', -9999, 'Numeric field t...', '', false, Object(ADODB_mysqlt)) #1 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/core/libraries/model.php(44): ADOConnection->outp_throw('Numeric field t...', 'DOQUOTE') #2 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/libraries/3rdparty/adodb/adodb-active-record.inc.php(845): Concrete5_Library_Model->doquote(Object(ADODB_mysqlt), true, 'I') #3 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/core/models/block_types.php(763): ADODB_Active_Record->Replace() #4 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/core/models/block_types.php(671): Concrete5_Model_BlockType->doInstallBlockType('core_scrapbook_...', Object(BlockType), '/home/shyc-cc.o...', '27', '/home/shyc-cc.o...') #5 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/core/models/block_types.php(632): Concrete5_Model_BlockType->installBlockType('core_scrapbook_...', '27') #6 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/helpers/concrete/upgrade/version_560.php(102): Concrete5_Model_BlockType->refresh() #7 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/core/controllers/single_pages/upgrade.php(272): ConcreteUpgradeVersion560Helper->run() #8 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/core/controllers/single_pages/upgrade.php(44): Concrete5_Controller_Upgrade->do_upgrade() #9 [internal function]: Concrete5_Controller_Upgrade->view('tools', 'required', 'upgrade') #10 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/core/libraries/controller.php(267): call_user_func_array(Array, Array) #11 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/core/libraries/controller.php(237): Concrete5_Library_Controller->runTask('view', Array) #12 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/core/libraries/view.php(787): Concrete5_Library_Controller->setupAndRun() #13 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/tools/upgrade.php(6): Concrete5_Library_View->render('/upgrade') #14 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/startup/tools_upgrade_check.php(9): include('/home/shyc-cc.o...') #15 /home/shyc-cc.org/public_html/updates/concrete5.6.3.2/concrete/dispatcher.php(105): require('/home/shyc-cc.o...') #16 /home/shyc-cc.org/public_html/concrete/startup/updated_core_check.php(6): require('/home/shyc-cc.o...') #17 /home/shyc-cc.org/public_html/concrete/dispatcher.php(14): require('/home/shyc-cc.o...') #18 /home/shyc-cc.org/public_html/index.php(2): require('/home/shyc-cc.o...') #19 {main}

=======
Reloaded DB and pointed site.php back to 5.5.2.1 and it works again.

--------------
This is the current environment:
# concrete5 Version
5.5.2.1

# concrete5 Packages
Galleria image gallery (2.0), Gallery (1.8.1), Google Map (Premium) (2.1), Login (1.1.1), MindNet Optimize MySQL database (1.11), Sortable Fancybox Gallery (1.17), Superfish (1.1.4), Thumbview Template (1.1.1).

# concrete5 Overrides
jobs/si_mysql_optimize.php, themes/theme_solutions, themes/SHYCcruise

# Server Software
Apache/2.2.15

# Server API
apache2handler

# PHP Version
5.3.3

# PHP Extensions
apache2handler, bz2, calendar, Core, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, libxml, mbstring, mcrypt, mysql, mysqli, odbc, openssl, pcre, PDO, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, Reflection, session, shmop, SimpleXML, snmp, sockets, SPL, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib.

# PHP Settings
log_errors_max_len - 1024
max_execution_time - 5
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 32M
post_max_size - 21M
safe_mode - Off
safe_mode_exec_dir - <i>no value</i>
safe_mode_gid - Off
safe_mode_include_dir - <i>no value</i>
sql.safe_mode - Off
upload_max_filesize - 20M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 100000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
safe_mode_allowed_env_vars - PHP_
safe_mode_protected_env_vars - LD_LIBRARY_PATH

===================

Is there a Log file somewhere that I could attach?
rge replied on at Permalink Reply
I am busy with a update as well. It seems that we cannot update to the latest version immediately. This is the updates I used after each other

5.5.2.1 (start point)
5.6.0
5.6.2.1
5.6.3
5.6.3.1
5.6.3.2


I copied the concrete core folder. On my local environment I rename the concrete core folder (so i have a backup). In the root I placed the new concrete core folder.

In the browser I used the following url http://sitename/index.php/tools/required/upgrade...

You will receive a message that the update is successful or not. After this I renamed the core folder again an copied the folder of the next version. I repeated this till 5.6.3.2.

Although this worked I have one issue. The action bar seems not to work. In the console I can see the error:

Call to undefined method Page::getPendingAction() in


So I suggest you start with updating to 5.6.0 first.
fcgleason replied on at Permalink Reply
fcgleason
RGE
Thank you for responding. I am going to step through upgrades as you suggest.
I also think one gallery slideshow or one photo set is not working properly in 5.5.2.1 and I have upgraded and I am considering options:
1. Identify exactly which slideshow / gallery
2. Change any pages that use it to another slideshow / gallery
3. Remove the slideshow / gallery
4. Make the change suggested by Andy.
5. Then go through the update preparation and process, stepping through versions.
We'll see how it goes.
fcgleason replied on at Permalink Reply
fcgleason
5.6.4 ?? <--- is this out of order or inccorrect one?
5.6.3.1

Thanks.
rge replied on at Permalink Reply
sorry should be 5.6.3
WebcentricLtd replied on at Permalink Reply
fcgleason replied on at Permalink Reply
fcgleason
I cannot reply to Andy's reply I think because I marked it "Best Answer"
it says "invalid token ..." --I had to refresh the thread, and it worked.

Andy, yes it did help, but I am still not there yet. Working on it though.

--- a/concrete/core/controllers/blocks/guestbook.php
+++ b/concrete/core/controllers/blocks/guestbook.php
@@ -17,7 +17,7 @@  defined('C5_EXECUTE') or die("Access Denied.");

The change from 'true' to '1' is in line 17, but I don't know about the rest of the line.
Did not include that. Of course I take the + off too.

Is this how it is supposed to look?
protected $btInterfaceHeight = "480";
         protected $btWrapperClass = 'ccm-ui';
         protected $btExportPageColumns = array('cID');
+        protected $btIncludeAll = 1; // This has to be on otherwise duplicate() kills the entries.
         protected $btExportTables = array('btGuestBook', 'btGuestBookEntries');
fcgleason replied on at Permalink Reply
fcgleason
Tried to upgrade to 5.6.1.2
This message was received:
Fatal error: Call to undefined method AddBlockBlockTypePermissionAccess::isPermissionKeyInUse() in 
/home/shyc-cc.org/public_html/updates/concrete5.6.1.2/concrete/helpers/concrete/upgrade/version_560.php on line 284


So I guess I do need to go step by step. I will restore the db and do it again.

===
---No actually I realized I changed the "true" to "1" in my concrete/updates/5.6.3.2 folder
so I went back to my conrete/updates/5.6.1.2 folder and made the same change.
--Then tried loading the page and it seemed to work.

When I go to
http://shyc-cc.org/index.php/tools/required/upgrade?source=dashboar...
Fatal error: Call to undefined method AddBlockBlockTypePermissionAccess::isPermissionKeyInUse() in /home/shyc-cc.org/public_html/updates/concrete5.6.1.2/concrete/helpers/concrete/upgrade/version_560.php on line 284


Still happens, but I can load the site and enter permissions and get into edit mode.
Line 284 is the last line in this code:
      $r = $db->Execute('select * from PagePermissions where cID = 1');   
         while ($row = $r->FetchRow()) {
            $pe = $this->migrateAccessEntity($row);
            if (!$pe) {
               continue;
            }
            $permissions = $this->getPermissionsArray($row['cgPermissions']);
            foreach($permissions as $p) {
               $permissionsToApply = $permissionMap[$p];
               if (is_array($permissionsToApply)) {
                  foreach($permissionsToApply as $pko) {
                     $pt = $pko->getPermissionAssignmentObject();
                     $pa = $pko->getPermissionAccessObject();
                     if (!is_object($pa)) {


====
After messing around with this 5.6.2.1 version the Dashboard seems to be ok, but the website is missing the main pages and not reading blocks of content etc.
====
Should I go back to 5.5.2.1 now?
Ok I went back by using phpmyadmin to load the db from before and edited the site.php to point to the updates/concrete5.5.2.1
fcgleason replied on at Permalink Reply
fcgleason
Ok I went back to Concrete 5.5.2.1.
1. Then cleaned up my addons and uninstalled Thumbview Templates.
2. I got all the slides shows working properly using Galleria and the other addons, by not selecting "Sets" of Photos but selecting individual photos.
3. Made sure that all of the site was working properly.
5. Made sure the cache was off, and cleaned the cache anyway.
6. Uploaded 5.6.0, 5.6.3, 5.6.3.1 and 5.6.3.2 to uploads directory.
7. Ran file permissions 777 on each folder above.
8. Then I backed up the db with Phpmyadmin and the Concrete5 backup.
9. Then went into the upgrade section of Dashboard and selected upgrade to 5.6.3

The screen went blank. So with Filezilla I checked what had happened to site.php
and the last line pointing to 'concrete5.6.0' was commented out
<? php define('DIRNAME_APP_UPDATED', 'concrete5.6.0'); etc.

I took the comments off, saved it back to the website with filezillla and tried to bring up the website. This time the entire header seemed to work, but there was not way of logging in and the rest of the page does not show. So I tried other pages and the header was there, but nothing else. The menus worked properly but there was literally no content. The bottom footer shows where there is a place to log in.

I logged in and brought up the dashboard, and moved around that, and it seemed complete.

Why isn't the content of the pages being found? What should I do now?

Environment says:
# concrete5 Version
5.6.0

# concrete5 Packages
Galleria image gallery (2.0), Gallery (1.8.1), Google Map (Premium) (2.1), Login (1.1.1), MindNet Optimize MySQL database (1.11), Sortable Fancybox Gallery (1.17), Superfish (1.1.4).

# concrete5 Overrides
jobs/si_mysql_optimize.php, themes/theme_solutions, themes/SHYCcruise

# Server Software
Apache/2.2.15

# Server API
apache2handler

# PHP Version
5.3.3

# PHP Extensions
apache2handler, bz2, calendar, Core, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, libxml, mbstring, mcrypt, mysql, mysqli, odbc, openssl, pcre, PDO, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, Reflection, session, shmop, SimpleXML, snmp, sockets, SPL, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib.

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 32M
post_max_size - 21M
safe_mode - Off
safe_mode_exec_dir - <i>no value</i>
safe_mode_gid - Off
safe_mode_include_dir - <i>no value</i>
sql.safe_mode - Off
upload_max_filesize - 20M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 100000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
safe_mode_allowed_env_vars - PHP_
safe_mode_protected_env_vars - LD_LIBRARY_PATH


But Upgrades shows me as still being on 5.5.2.1!

Also
http://shyc-cc.org/index.php/dashboard/settings/...
is not found.

http://shyc-cc.org/index.php/login...
allows me to log in and then I see the dashboard bar at the top and the header with the menus but no content.

The Update Concrete5 still shows me at Concrete5 5.5.2.1 with a suggestion radio button to upgrade to 5.6.3 and there is no longer a selection to upgrade to Concrete5.6.0 even though the directory exists on the website and I have pointed concrete/config/site.php to the
/public_html/updates/concrete5.6.0 directory!

What should I do now?

It may be surprising that loading the concrete db with phpmyadmin
the config table shows
SITE_APP_VERSION 2014-11-22 22:48:22 5.5.2.1
APP_VERSION_LATEST 2014-12-01 18:19:06 5.6.3.2
Mnkras replied on at Permalink Best Answer Reply
Mnkras
I would also suggest increasing your memory limit.
fcgleason replied on at Permalink Reply
fcgleason
Hi Mnkras, you were very helpful with wamp several years ago. Thanks for that.

ok... you mean for php? memory_limit - 32M --how?

Is that going to solve the problem I have described with the website?
1. No content other than the Header and Menu.
2.http://shyc-cc.org/index.php/dashboard/settings/... "not found"
fcgleason replied on at Permalink Reply
fcgleason
On some other threads regarding update to 5.6.0 and later there are some notes about the need to download the file JSON.php from:
../public_html/updates/concrete5.6.0/concrete/libraries/3rdparty/JSON
rename it to json.php and upload to
../public_html/updates/concrete5.6.0/concrete/models
which I did.

Nothing really change but Environment is this now.
I need to increase PHP memory as suggested...need to figure that out.
The Top Dashboard, headers with menus that work and footers are all present, but content does not exist in any page. I can log into the dashboard through the login in the footer....

# concrete5 Version  5.6.0
# concrete5 Packages
Galleria image gallery (2.0), Gallery (1.8.1), Google Map (Premium) (2.1), Login (1.1.1), MindNet Optimize MySQL database (1.11), Sortable Fancybox Gallery (1.17), Superfish (1.1.4).
# concrete5 Overrides
jobs/si_mysql_optimize.php, themes/theme_solutions, themes/SHYCcruise
# Server Software
Apache/2.2.15
# Server API
apache2handler
# PHP Version
5.3.3
# PHP Extensions
apache2handler, bz2, calendar, Core, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, libxml, mbstring, mcrypt, mysql, mysqli, odbc, openssl, pcre, PDO, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, Reflection, session, shmop, SimpleXML, snmp, sockets, SPL, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib.
# PHP Settings
max_execution_time - 30


Later
==============

Ok I right clicked on a web page and picked "Show Page Source Code" [Firefox]
The html source shows concrete5.6.0 and also all the header and menu script
and although it does not show in the page, there is a Slideshow script, for example...
which is content that should be showing...but possibly there is not enough memory to show it. So I had better increase memory for PHP somehow....

I went to etc/php.ini and found this line...
memory_limit - 32M
do I just modify it?
I have a VPS using centos with a number of websites (6) and the server has 1024mb.
fcgleason replied on at Permalink Reply
fcgleason
After increasing the memory limit to 64mb in the etc/php/php.ini folder
I logged into the site and checked the environment, it was still showing as 32mb.
Also I still cannot see the content below the menus (except the footers show.)

Also in Dashboard "Update Concrete"
it shows as "Version 5.5.2.1"
and suggests an update to "Version 5.6.3" with a selected radio button,
but "Version 5.6.0" does not show in this list, although it does exist!

I have NOT rolled back to 5.5.2.1 yet.
in /home/shyc-cc.org/public_html/config/site.php
we are pointed to
define('DIRNAME_APP_UPDATED', 'concrete5.6.0');
fcgleason replied on at Permalink Reply
fcgleason
I decided to try to force an update for several reasons using

http://yoursite/index.php/tools/required/upgrade?force=1...
then hit 'enter'
wait, wait, wait, wait, still a blank screen....
http://yoursite/index.php/tools/required/upgrade?force=1...
then hit 'enter'

and quickly this comes up
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 86 bytes) in /home/shyc-cc.org/public_html/updates/concrete5.6.0/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php on line 625
fcgleason replied on at Permalink Reply
fcgleason
Then I went back to the normal URL for the site and did get the headers for the website up and the menus work, but not content or blocks.

I can log into the dashboard and get around that too.

http://shyc-cc.org
Mnkras replied on at Permalink Reply
Mnkras
Did you restart Apache?
fcgleason replied on at Permalink Reply
fcgleason
No, I did not think of that. Thanks. Will report back.

-- Rebooted and there was no change. The contents and blocks do not show, yet I can see the html in the page source.

Also I believe there is still good content in files.
fcgleason replied on at Permalink Reply
fcgleason
I'm starting to feel as if I am living with a bad roomate, this problem has been around too long.

Using PhpMyAdmin with current db
SITE_APP_VERSION 2014-11-22 22:48:22 5.5.2.1
APP_VERSION_LATEST 2014-12-01 18:19:06 5.6.3.2

What exactly, does this mean? I don't believe I upgraded to 5.6.3.2 intentionally, however I do have these uploaded to ../public_html/updates I am trying to go step by step, and this step was to concrete5.6.0.

Using Filezillla ../public_html/config/site.php view/edit

I find
define('DIRNAME_APP_UPDATED', 'concrete5.6.0');

Currently I can log into the Dashboard and get around, however the CONTENT of the pages does not exist. The MENUS do. I can actually see the html for the content of these page under "View Page Source" but it not reading for some reason.

../public_html/files is permissions 777

The web page is here http://shyc-cc.org/
any ideas for what to do?

Should I go back to 5.5.2.1 yet again?
fcgleason replied on at Permalink Reply 1 Attachment
fcgleason
Now when I log in to the website successfully, the screen grays over, I can see the Dashboard and Edit button, and the menu and slideshow are running, but I am locked out of doing anything.... I can't even log out. What should I do now?

I was hoping to get to the environment and copy that to see how much memory PHP has because the server was rebooted.

Attached is the Page Source Html.
I cannot seem to get out of the "GRAYED" locked page so that I can go to the Dashboard or even Log out.

When I put the url shyc-cc.org in hit enter
the page now comes up with the Dashboard as if I am logged in, a message pops up
"Checking updates" and disappears and the the page turns "Gray" and locked. I can't click on anything.

Found a note that folder permissions should be
/files 777
/packages 755
/updates 755
Have used Filezilla to make sure they are as above.

Screen still goes grey directly after going to the URL and the "Checking for Updates" pops up and disapppears.

http://shyc-cc.org/index.php/dashboard/system/...
http://shyc-cc.org/index.php/login... --after login
the same message "Checking for updates" then the screen greys and I cant do anything.
fcgleason replied on at Permalink Reply
fcgleason
I've applied these and the "checking for updates" has stopped:
/config/site.php
define('ENABLE_MARKETPLACE_SUPPORT', false);
define('ENABLE_NEWSFLOW_OVERLAY', false);

See this thread
http://www.concrete5.org/index.php?cID=270297&editmode=1...

I am now able to log into the website and access the Dashboard and Environment
-----

memory_limit - 32M <---- increased from 24m

# concrete5 Version
5.6.0
# concrete5 Packages
Galleria image gallery (2.0), Gallery (1.8.1), Google Map (Premium) (2.1), Login (1.1.1), MindNet Optimize MySQL database (1.11), Sortable Fancybox Gallery (1.17), Superfish (1.1.4).
# concrete5 Overrides
jobs/si_mysql_optimize.php, themes/theme_solutions, themes/SHYCcruise
# Server Software
Apache/2.2.15
# Server API
apache2handler
# PHP Version
5.3.3
# PHP Extensions
apache2handler, bz2, calendar, Core, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, libxml, mbstring, mcrypt, mysql, mysqli, odbc, openssl, pcre, PDO, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, Reflection, session, shmop, SimpleXML, snmp, sockets, SPL, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib.
# PHP Settings
fcgleason replied on at Permalink Reply
fcgleason
When I go to
Update Concrete5
"Install Local Update"
It shows in Dark Grey "Current Version 5.5.2.1"
With selections for
5.6.3
5.6.3.1
5.6.1.2
5.6.3.3

(This is showing in the wrong order and also does not list 5.6.0 which I also have in the upgrades directory!)

So that is all the information on the current state of this website which I tried to upgrade to
5.6.0
---
Using PhpMyAdmin with current db
SITE_APP_VERSION 2014-11-22 22:48:22 5.5.2.1
APP_VERSION_LATEST 2014-12-01 18:19:06 5.6.3.2

Using Filezillla ../public_html/config/site.php view/edit
define('DIRNAME_APP_UPDATED', 'concrete5.6.0');

So what do I do now?
I still cannot see any content!!!
Content does not show either logged in or not.
I am reluctant to "Edit" a page because it may inadvertantly wipe out blocks that should be there.
fcgleason replied on at Permalink Reply
fcgleason
I decided to repoint to Concrete5.5..2.1
so in site.php I changed define to 5.5.2.1
and my website content appeared just fine!

phpMyAdmin wwithout changing the db, says
SITE_APP_VERSION 2014-11-22 22:48:22 5.5.2.1
APP_VERSION_LATEST 2014-12-01 18:19:06 5.6.3.2

# concrete5 Version
5.5.2.1
# concrete5 Packages
Galleria image gallery (2.0), Gallery (1.8.1), Google Map (Premium) (2.1), Login (1.1.1), MindNet Optimize MySQL database (1.11), Sortable Fancybox Gallery (1.17), Superfish (1.1.4).
# concrete5 Overrides
jobs/si_mysql_optimize.php, themes/theme_solutions, themes/SHYCcruise
# Server Software
Apache/2.2.15
# Server API
apache2handler
# PHP Version
5.3.3


So how the devil am I going to update to Version 5.6.0 or even 5.6.3?
Nothing seems to work.
fcgleason replied on at Permalink Reply
fcgleason
UPGRADE TO VERSION 5.6.3 Successful

I finally just decided to upgrade from the Dashboard to 5.6.3 as it suggested, and it worked!
Perhaps I should have done that a long time ago witthout worrying about it.

After a first check of the site everything seems to be working fine. I am sure there will be some little things to fix, but for the most part it appears to be working.

I don't know If I should be upgrading to 5.6.3.1 and 5.6.3.2 immediately without testing.
I also don't know if I should remove these from the site.php now

/config/site.php
define('ENABLE_MARKETPLACE_SUPPORT', false);
define('ENABLE_NEWSFLOW_OVERLAY', false);
Which stopped the "checking for updates" locked screen?
fcgleason replied on at Permalink Reply
fcgleason
UPGRADE TO 5.6.3.1 Successful
Backed up db in Dashboard and using PhpMyadmin.
and then upgraded from the dashboard.
It worked!
Awesome.
fcgleason replied on at Permalink Reply
fcgleason
UPGRADE to Version 5.6.3.2 successful
after backing up the db of course.

Now the next challenge will be 5.7 sometime in the near future.
fcgleason replied on at Permalink Reply
fcgleason
I took out the two defines in the site.php and tried the website and get this now.

An unexpected error occurred.
mysql error: [1054: Unknown column 'cPendingAction' in 'field list'] in EXECUTE("select Pages.cID, Pages.pkgID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cIsActive, Pages.cIsSystemPage, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cPendingAction, cPendingActionUID, cPendingActionTargetCID, cPendingActionDatetime, cCheckedOutUID, cIsTemplate, uID, cPath, Pages.ctID, ctHandle, ctIcon, ptID, cParentID, cChildren, ctName, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PageTypes on (PageTypes.ctID = Pages.ctID) left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = 1")


Tried putting these back in site.php did not fix it. Damn

define('ENABLE_MARKETPLACE_SUPPORT', false);
define('ENABLE_NEWSFLOW_OVERLAY', false);
fcgleason replied on at Permalink Reply
fcgleason
I have been receiving some very good coaching from mhawke. Thank you Mike!

He is concerned about my 32mb memory limit and believes that the database may be getting too large with the additional tables added by each update. He advises that he uses 128mb memory limit for PHP.

Mike:
"At this point, you have no choice but to move back to a working version. My biggest concern is that the server is running out of time during the upgrade process. 32M is too small and will cause the site to take too long to upgrade. I have my hosting set at 128M"

I have the websites on a VPS running Centos with Virtualmin/Webmin. I have changed the memory limits in Virtualmin under Virtualmin > [Select the website from dropdown] > Services > PHP 5 Configuration > Resource Limits > Maximum Memory Resolution
I set it to 128M and then checked the php.ini file here /home/yourwebsite.com/etc/php5/php.ini

I was told that Virtualmin would reboot the apache server for this website when I changed the max memory limit. So I checked the website's Concrete5 Environment and it remained at 32m. So then I went back and manually rebooted the server and checked the Concrete5 environment again it still was 32m.

So I made a phpini.php file in the root directory with
<?php
phpinfo();
in it and set permissions to 777

Then opened it yoursite.com/phpinfo.php
and found
memory_limit 32M local
memory_limit 128M maiin

So there is a local php.ini file somewhere that is restricting the size unnecessarily.
I am unable to find it, so far.
Does Concrete5 have some setting inside the Dashboard - no I don't think so.

Any help would be appreciated.
fcgleason replied on at Permalink Reply
fcgleason
Found these paths to php.ini files in the listing:
. -Configuration File (php.ini) Path /etc
. -Loaded Configuration File /etc/php.ini
. -Scan this dir for additional .ini files /etc/php.d

Have found php.ini under /etc/php.ini and under etc/php5/php.ini
Have checked both files and both show memory_limit 128m
fcgleason replied on at Permalink Reply
fcgleason
Again check Concrete5 > Dashboard > Environment

# PHP Settings
memory_limit - 32M <--- This should be 128mb !!!

======
Yet the going to url shyc-cc.org/php.ini shows

memory_limit 32m (Local) 128m (Main)

I cannot seem to find the local file.
fcgleason replied on at Permalink Reply
fcgleason
I forgot to say that I am using FastCGI

I created a little file to tell me where the php.ini that is being loaded is located using this
script http://php.net/manual/en/function.php-ini-loaded-file.php...

The result
"Loaded php.ini: /etc/php.ini "

and that file does have memory_limit = 128m
fcgleason replied on at Permalink Reply
fcgleason
OK just found two possibilities for where the memory_limit is being set :

Index.php file, you can add the following line just after the PHP starting tag:
.    ini_set("memory_limit","128M");
Alternatively, you can add the following line to your
.htaccess:
 .    php_value memory_limit 128M
concrete5 requires at least 64MB of memory to run properly.

I've looked and have not been able to find any of these files that have limits on memory lines.

OK I am going to say the devil with it and try this.
http://www.concrete5.org/community/forums/customizing_c5/5_3_-_allo...
fcgleason replied on at Permalink Reply
fcgleason
In the index.php
enter
<?php
ini_set('memory_limit','256M');
require('concrete/dispatcher.php');

Ok, that works, now Dashboard > Environment shows 128m

Many thanks to
mhawke Mike http://www.concrete5.org/profile/-/view/64712/...

and my old friend and sage advisor
Mnkras http://www.concrete5.org/profile/-/781/...
fcgleason replied on at Permalink Reply
fcgleason
Ok with help from Peter Knowles of TPNSolutions http://www.tpnsolutions.com/ our website pro, we found that the site had mod_php turned on which basically does not allow setting of PHP setttings individually. So he turned that off and fcgi on in Virtualmin and reset the ownership of all the files under shyc-cc.org to be for the site itself. Now the settings I had put into shyc-cc.org/phpinfo.php are now recognized (the local settings!)
I think Peter should also get an award for helping solve this memory problem.

Therefore I have removed the line setting memory_limit in the index.php file because it is no longer needed (I believe).

However now when I try to log into the site I get this error:
Catchable fatal error: Argument 1 passed to ConfigStore::__construct() must be an instance of Database, boolean given, called in
 /home/shyc-cc.org/public_html/concrete/models/config.php on line 48
and defined in
/home/shyc-cc.org/public_html/concrete/models/config.php on line 136

NOTE: The site was working fine until we changed from mod_php to fcgi and changed all the "ownerships" of the files to "shyc-cc" rather than "apache"

NOTE: I have a problem with this path, because we are using the
config/site.php line
define('DIRNAME_APP_UPDATED', 'concrete5.6.3');
which is using this path
.../updates/concrete5.6.0
So the paths above do not make sense.

LIne 48
/**
    * @return ConfigStore
    */
   private static function getStore()
   {
      if (!self::$store) {
         self::$store = new ConfigStore(Loader::db());    <--Line 48
      }
      return self::$store;
   }



Line 136
class ConfigStore {
   /**
    * @var Database
    */
   private $db;
   /**
    * @var array
    */
   private $rows;
   public function __construct(Database $db) {       <---LINE 136
      $this->db = $db;
      $this->load();
   }
   private function load() {
      if (defined('ENABLE_CACHE') && (!ENABLE_CACHE)) {


This post
http://www.concrete5.org/community/forums/chat/internal-500-error-w...
relates to fcgi

And this post from Mnkras
http://www.concrete5.org/community/forums/usage/an-unexpected-error...
There is currently a bug with 5.6.3.2, to work around this you can edit 1 file
in /updates/concrete5.6.3.2/concrete/core/libraries/model.php
delete everything and replace it with the following:
https://raw.githubusercontent.com/concrete5/concrete5/master/web/concrete/core/libraries/model.php


have some relevance I think.
Can anyone help with this problem? I am in version 5.6.3 now.
fcgleason replied on at Permalink Reply
fcgleason
mhawke Mike Hawke
"I see the site is dead. Make sure your info is right in the config/site.php file. It looks like a database connection issue. Mike "

Well Mike, you are right, about that. I had site.php pointing to
define('DIRNAME_APP_UPDATED', 'concrete5.6.0');
rather than
define('DIRNAME_APP_UPDATED', 'concrete5.6.3');

Now the public part of the website comes up ok, but I seem to be locked out of signing in which is pretty serious business. Not responding to any logins. Ever since changing the file owner permissions so that the fcgi worked and PHP memory_limits would show in php.ini as 128M , this login has not been working right.

I guess I'll go back to 5.5.2.1 or 5.6.0! and start up again!
fcgleason replied on at Permalink Reply
fcgleason
To fix the login problem
Mike suggested a couple of things to try:

1. Try deleting all the files in '[root]/files/cache' folder (leaving an empty 'cache' folder)
2. Did you have Pretty URLs turned on before? If so, you might need to turn them off to log in but because you can't get to the Dashboard to turn it off you can edit the database's 'Config' table and set 'URL_REWRITING' to 0 to turn it off. --Did not have them on.

For some reason the DB got corrupted enough during an upgrade that the login was not possible, ..probably because I did not have enough memory.

For some reason this website was on 'mod_php' and all the others were on fcgid (as set up originally). It may have been something I did, perhaps installing phpmyadmin, perhaps accessing mysql via command line a long time ago....I don't remember. Anyway my VPS expert Peter, changed the site back to fcgid in Virtualmin, and I was able to get the 128mb modification to the local php.ini to actually work. Then we immediately had access issues with the db. After trying everything, I decided to delete the db in Virtualmin and reestablish it with a backup. It would not delete. Nor could I make a new db. I was at wits end. At that point Peter got involved again and fixed the db by getting it deleted, and creating a new one with the correct ownership and permissions. With some changes to permissions, and config/site.php the public website was accessible and I could log into the Dashboard and we are at 5.6.3 now and everything is running!
---
Below is the current environment. Before I push any button to upgrade... or should I simply change the site.php to point to the next version 5.6.3.1? What should I do to prepare?
--
I have a couple of questions about permissions of files and folders:
How should I have permissions set? I mean really.

concrete
files
config
controllers, etc.
updates
concrete5.6.3
concrete5.6.3.1
concrete5.6.3.2

the folder public_html is set to 750

======================
# concrete5 Version
5.6.3
# concrete5 Packages
Galleria image gallery (2.0), Gallery (1.8.1), Google Map (Premium) (2.1), Login (1.1.1), MindNet Optimize MySQL database (1.11), Sortable Fancybox Gallery (1.17), Superfish (1.1.4).
# concrete5 Overrides
jobs/si_mysql_optimize.php, themes/theme_solutions, themes/SHYCcruise
# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off
# Server Software
Apache/2.2.15
# Server API
cgi-fcgi
# PHP Version
fcgleason replied on at Permalink Reply
fcgleason
After using the site and getting comfortable with its operation, I decided to update it.
1. Deleted files and directories under tmp folder (60mb)
2. Deleted files and directories under "trash" (80 mb)
3. Website went from about 1.14gb to 1.04 gb Still need to chase down file use.
4. Cleaned cache from within Dashboard, even though it is turned off.
5. Backed up the database from Dashboard. Just once this time.
6. Then clicked Dashboard button to update from 5.6.3 to 5.6.3.1, success.
7. Tested and then did #4 & #5 again.
8. Then clicked Dashboard update from 5.6.3.1 to 5.6.3.2, success.

These last two upgrades were quite easy once I had enough memory!!! - 128 mb

So the next challenge with be to upgrade to 5.7!! When?

Thanks to RGe AndyJ, Mike Mhawke and Mnkras and Peter Knowles of TPNS for all their help.

My short version advice.
Backup, backup.
Make certain you have enough memory at least 128mb!!! <---this makes a huge difference
because the database gets corrupted during upgrade if there is not enough memory
Use the updates folder and point your site.php to the appropriate version.
Learn how to determine what version of the database is being used.
Learn how to go back to previous website version.
Follow the upgrade versions listed above.
Download newer versions, modify and then upload or zip, upload and unzip to the updates folder.
Clear cache.
Upgrade and be prepared to go back to previous website.
Search the Concrete5 forum for the errors found there are usually solutions.