ERRORS, upgrade issues
Permalink 1 user found helpful
Hi I am helping a non profit organization by editing their site.
I think the host and domain are through godaddy but even the board isn't sure.
I went to install the update due to repeated errors..couldn't load pics, or access the file manager to name a few. So I thought I would update. I got this message andnow can't access the site. HELP please.
I think the host and domain are through godaddy but even the board isn't sure.
I went to install the update due to repeated errors..couldn't load pics, or access the file manager to name a few. So I thought I would update. I got this message andnow can't access the site. HELP please.
This is what I get. mysqli error: [1054: Unknown column 'Blocks.btCachedBlockRecord' in 'field list'] in EXECUTE("select CollectionVersionBlocks.isOriginal, Blocks.btCachedBlockRecord, BlockTypes.pkgID, CollectionVersionBlocks.cbOverrideAreaPermissions, CollectionVersionBlocks.cbDisplayOrder, Blocks.bIsActive, Blocks.bID, Blocks.btID, bName, bDateAdded, bDateModified, bFilename, btHandle, Blocks.uID from CollectionVersionBlocks inner join Blocks on (CollectionVersionBlocks.bID = Blocks.bID) inner join BlockTypes on (Blocks.btID = BlockTypes.btID) where CollectionVersionBlocks.arHandle = 'Header' and CollectionVersionBlocks.cID = '1' and (CollectionVersionBlocks.cvID = '103' or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = '24'")
This looks like maybe your upgrade didn't get finished properly. If you go to /login are you able to login to the site?
If so try re-running the upgrade here: /index.php/tools/required/upgrade
If so try re-running the upgrade here: /index.php/tools/required/upgrade
Yes, that is probably correct. There were 2 upgrades and I should have probably upgraded the first one then the most recent. But I went right to the latest version. I took over this site recently so not used to this format.
Oh and no, I can't log in at all. Go to:http://curlyrescue.com - and you will see what I see.
I did what you suggested and got this:http://curlyrescue.com/index.php/tools/required/upgrade?force=1...
Your hosting company appears to behttp://www.aiso.net/
and Godaddy is your registrar.
You can check both here:http://network-tools.com/
and Godaddy is your registrar.
You can check both here:http://network-tools.com/
Yes, I do understand that. I think I am going to try to restore the site, somehow some way and then try upgrading again maybe. Prior to this I would get this error when trying to upload pics.
just modify your site.php file in the config folder. Remove the upgrade mention on the bottom of the file and your site should reappear.
You sure make that sound easy! LOL I'll try!
tallacman, Ok so I finally was able to get into the file manager via the host co. WHEW. the organization had no records of any of the website logs ins etc. I deleted the latest upgrade from Nov 21st, however it is still showing this error. I see a file called site.php but I would have to delete the whole thing. I can't go in and find just 1 file. would I be better off just hitting restore backup? Go tohttp://curlyrescue.com and you will see the error.
OH update...I just hit "edit" and saw this. Do I remove the last line??
OH update...I just hit "edit" and saw this. Do I remove the last line??
Here is what I have. So remove all of the last line? SEE BELOW.
(This is what the site says when I go tohttp://curlyrescue.com: Invalid "DIRNAME_APP_UPDATED" defined. Please remove it from /var/www/vhtdocs/userweb63126/html/config/site.php. )
<?php
define('DB_SERVER', '127.0.0.1');
define('DB_USERNAME', 'userweb63126');
define('DB_PASSWORD', '0b9nGJr2o2');
define('DB_DATABASE', 'db63126_aps79');
define('BASE_URL', 'http://curlyrescue.com');
define('DIR_REL', '');
define('PASSWORD_SALT', 'QFGuO2tKf2Fam1CRIbzHyvlOoPxWzzVzSTDVFE3C3PZofDqWnK06WWVX5hA9Tkvb');?><?php define('DIRNAME_APP_UPDATED', 'concrete5.6.3.5_remote_updater');?>
(This is what the site says when I go tohttp://curlyrescue.com: Invalid "DIRNAME_APP_UPDATED" defined. Please remove it from /var/www/vhtdocs/userweb63126/html/config/site.php. )
<?php
define('DB_SERVER', '127.0.0.1');
define('DB_USERNAME', 'userweb63126');
define('DB_PASSWORD', '0b9nGJr2o2');
define('DB_DATABASE', 'db63126_aps79');
define('BASE_URL', 'http://curlyrescue.com');
define('DIR_REL', '');
define('PASSWORD_SALT', 'QFGuO2tKf2Fam1CRIbzHyvlOoPxWzzVzSTDVFE3C3PZofDqWnK06WWVX5hA9Tkvb');?><?php define('DIRNAME_APP_UPDATED', 'concrete5.6.3.5_remote_updater');?>
I GOT IT FIXED!!!!!!!!!!!!!!!!!!!!!!!!! THANK YOU THANK YOU! The site is restored!
Ok...so now my question is this: The reason I wanted to upgrade (which caused this problem) was because whenever I try to upload a pic, or go into my file manager through the site editor, I get this error.
If it is an upgrade I need to do. I have 2 upgrades they suggest. Do I try to upgrade using the older version, then the newer one? Because the last time, I went right to the newest one. Maybe that is why I had a problem. Can you help? You have been an amazing help to me. I so much appreciate it!!!!
mysql error: [3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'db63126_aps79.f.fDateAdded' which is not in SELECT list; this is incompatible with DISTINCT] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fv.fvType = '1' and fvIsApproved = '1' order by fDateAdded desc limit 0,10 ")
Ok...so now my question is this: The reason I wanted to upgrade (which caused this problem) was because whenever I try to upload a pic, or go into my file manager through the site editor, I get this error.
If it is an upgrade I need to do. I have 2 upgrades they suggest. Do I try to upgrade using the older version, then the newer one? Because the last time, I went right to the newest one. Maybe that is why I had a problem. Can you help? You have been an amazing help to me. I so much appreciate it!!!!
mysql error: [3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'db63126_aps79.f.fDateAdded' which is not in SELECT list; this is incompatible with DISTINCT] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fv.fvType = '1' and fvIsApproved = '1' order by fDateAdded desc limit 0,10 ")
What version of C5 are you on right now? You should be able to update to 5.6.3.5 but you might need to do it in steps depending on your current version.
It looks like I am up to date with that latest version now. BUT I am still get this error when trying to access the file manager or upload a photo to the site.
mysql error: [3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'db63126_aps79.f.fDateAdded' which is not in SELECT list; this is incompatible with DISTINCT] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fvIsApproved = '1' order by fDateAdded desc limit 0,10 ")
mysql error: [3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'db63126_aps79.f.fDateAdded' which is not in SELECT list; this is incompatible with DISTINCT] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fvIsApproved = '1' order by fDateAdded desc limit 0,10 ")
