update to 5.4.2 no admin login anymore
Permalink 2 users found helpful
Hey,
i just updated my system from 5.4.1.1 to 5.4.2. if i like to login now i get the following error:
mysql error: [1054: Unknown column 'uDefaultLanguage' in 'field list'] in EXECUTE("select uID, uName, uIsActive, uIsValidated, uTimezone, uDefaultLanguage from Users where uName = 'admin' and uPassword = '9020854bd421bfb476b85a64ea4428b5'")
can someone help me? so i do not have to install it all over again...
best regards
oliver
i just updated my system from 5.4.1.1 to 5.4.2. if i like to login now i get the following error:
mysql error: [1054: Unknown column 'uDefaultLanguage' in 'field list'] in EXECUTE("select uID, uName, uIsActive, uIsValidated, uTimezone, uDefaultLanguage from Users where uName = 'admin' and uPassword = '9020854bd421bfb476b85a64ea4428b5'")
can someone help me? so i do not have to install it all over again...
best regards
oliver
Hey,
Same problem for me!
This happend after a update from 5.4.1.1 to 5.4.2
Is there someone there have a solution?
/Steen
Same problem for me!
This happend after a update from 5.4.1.1 to 5.4.2
Is there someone there have a solution?
/Steen
Same problem here, any devs aware of this issue? As a quick fix can we role back to a stable version?
Hi,
You can roll back to 5.4.1.1.
In config folder/site.php
At the end of Password_Salt line take out
You can roll back to 5.4.1.1.
In config folder/site.php
At the end of Password_Salt line take out
<?php define('DIRNAME_APP_UPDATED', 'concrete5.4.2');?>
Wont that just roleback in name rather than function? I think 5.4.2 restructures/amends other .php files too and the database doesn't it?
Thanks for your reply by the way! :)
Thanks for your reply by the way! :)
Hi,
It was suggested elsewhere in the forums.
I tried it, my site went back to 5.4.1.1 and everything worked properly.
It was suggested elsewhere in the forums.
I tried it, my site went back to 5.4.1.1 and everything worked properly.
Hi, yes seems to do the trick. It must call on and reinstall archived code I am guessing, cheers for the heads up.
It was a client of mine that upgraded. I asked why they did that, "if it aint broke dont fix it"!
It was a client of mine that upgraded. I asked why they did that, "if it aint broke dont fix it"!
thanks!!! working fine again!
I had the same problem and had to revert back to 5.4.1.1 The problem is I can now no longer access my backups and updates panel. I get this message:
Fatal error: Cannot redeclare __autoload() (previously declared in /home/example/example.com/concrete/startup/autoload.php:3) in /home/example/example.com/concrete/startup/autoload.php on line 19
Line 19 in autoload.php contains nothing but a "}".
Fatal error: Cannot redeclare __autoload() (previously declared in /home/example/example.com/concrete/startup/autoload.php:3) in /home/example/example.com/concrete/startup/autoload.php on line 19
Line 19 in autoload.php contains nothing but a "}".
thanks alot! this worked
______________________________________
beginner-proof
1. Open FTP-App (i.e. Filezilla) and go to ROOTDIRECTORX/config/site.php
2. Open site.php with Notepad and remove " <?php define('DIRNAME_APP_UPDATED', 'concrete5.4.2.1');?> " at the end
______________________________________
5.4.2.1 login wont work admin sql error
______________________________________
beginner-proof
1. Open FTP-App (i.e. Filezilla) and go to ROOTDIRECTORX/config/site.php
2. Open site.php with Notepad and remove " <?php define('DIRNAME_APP_UPDATED', 'concrete5.4.2.1');?> " at the end
______________________________________
5.4.2.1 login wont work admin sql error
How can i role back, when i can't login?
/Steen
/Steen
You don't use the interface to roleback, the code is in site.php that you can FTP
I had the same problem and this resolved it.
Thanks for the tip.
Thanks for the tip.
No response to this, so I'm reposting.
I had the same problem and had to revert back to 5.4.1.1 The problem is I can now no longer access my backups and updates panel. I get this message:
Fatal error: Cannot redeclare __autoload() (previously declared in /home/example/example.com/concrete/startup/autoload.php:3) in /home/example/example.com/concrete/startup/autoload.php on line 19
Line 19 in autoload.php contains nothing but a "}".
I had the same problem and had to revert back to 5.4.1.1 The problem is I can now no longer access my backups and updates panel. I get this message:
Fatal error: Cannot redeclare __autoload() (previously declared in /home/example/example.com/concrete/startup/autoload.php:3) in /home/example/example.com/concrete/startup/autoload.php on line 19
Line 19 in autoload.php contains nothing but a "}".
I wish I could help, but I do not have the knowledge. Only a sympathetic ear.
I rolled back a described above and I can still access the backup and update tabs. I have made backups but needless to say have stayed away from the update tab.
I show the same "}" in the autoload file on line 19.
Not sure what the difference between our installations could be?
Does anyone else have this problem?
Jerlo
I rolled back a described above and I can still access the backup and update tabs. I have made backups but needless to say have stayed away from the update tab.
I show the same "}" in the autoload file on line 19.
Not sure what the difference between our installations could be?
Does anyone else have this problem?
Jerlo
hi gumbyblue I can't say I have had that issue after a rollback, however have you got a local version of Concrete you can re-upload the core concrete folder from?
Hi I had the same problem. I commented out the "update" in the site.php file and now I can log in, but if I run the update script it gives me the same issue.
Question is, how can I update concrete yet not be stuck in a situation where I can't log into the site?
Paul
Question is, how can I update concrete yet not be stuck in a situation where I can't log into the site?
Paul
I reinstalled a clean copy of 5.4.1.1, then ran backup without encryption, only to be met with this error message:
Fatal error: Allowed memory size of 94371840 bytes exhausted (tried to allocate 39350846 bytes) in /home/example/example.com/updates/concrete5.4.2/concrete/libraries/backup.php on line 19
I contacted my service provider who informed me that my website is using too much memory. Considering my website has less than 100 pages, uses only one add-on (Google search), and is mainly text with no videos or animation, this is absurd.
I'm going to have to find a new service provider or switch to another CMS at this rate.
Fatal error: Allowed memory size of 94371840 bytes exhausted (tried to allocate 39350846 bytes) in /home/example/example.com/updates/concrete5.4.2/concrete/libraries/backup.php on line 19
I contacted my service provider who informed me that my website is using too much memory. Considering my website has less than 100 pages, uses only one add-on (Google search), and is mainly text with no videos or animation, this is absurd.
I'm going to have to find a new service provider or switch to another CMS at this rate.
Okay. Just upgraded to 5.4.2.1. Still the same problem experienced with 5.4.2 ie. Wont let me log in. Had to revert back to 5.4.1.1 by editing site.php, so obviously the bug hasn't been fixed.
Weird thing is if you comment out the line in the config.php file, you still see the new blog beta button and I imagine other new things. Does this mean I am somewhat updated but not fully?
Just ran into this issue and commented out the update in config/site.php as suggested.
If you also restore your backup mysql in dashboard > system & maintenance > backup & restore (hopefully you did a backup before you updated the system!) then everything should return to normal (eg no Composer Beta tab in your dashboard navigation).
Would love to know what's up with the upgrade from 5.4.1.1 to 5.4.2.1 not working!
Being able to login is pretty important :-)
If you also restore your backup mysql in dashboard > system & maintenance > backup & restore (hopefully you did a backup before you updated the system!) then everything should return to normal (eg no Composer Beta tab in your dashboard navigation).
Would love to know what's up with the upgrade from 5.4.1.1 to 5.4.2.1 not working!
Being able to login is pretty important :-)
Except, as I mentioned above, I can no longer access backup. I get this error message:
Fatal error: Cannot redeclare __autoload() (previously declared in /home/example/example.com/concrete/startup/autoload.php:3) in /home/example/example.com/concrete/startup/autoload.php on line 19
So even though it may have been backed up previously, I can no longer access it.
Fatal error: Cannot redeclare __autoload() (previously declared in /home/example/example.com/concrete/startup/autoload.php:3) in /home/example/example.com/concrete/startup/autoload.php on line 19
So even though it may have been backed up previously, I can no longer access it.
gumbyblue: obviously something is wacky with your installation. Bummer. That's weird about the memory problem.
At your own risk, you may want to try downloading the version of c5 you're using ( 5.4.1.1 ) from the downloads page (http://www.concrete5.org/developers/downloads/... ).
Then rename the /concrete folder in your installation to /concrete2 or something and copy over JUST the /concrete folder you just downloaded. This should leave all other folders intact (eg files, themes, etc) and you can always rename the /concrete2 folder back to /concrete to get back to where you started.
Perhaps that will refresh things?
At your own risk, you may want to try downloading the version of c5 you're using ( 5.4.1.1 ) from the downloads page (http://www.concrete5.org/developers/downloads/... ).
Then rename the /concrete folder in your installation to /concrete2 or something and copy over JUST the /concrete folder you just downloaded. This should leave all other folders intact (eg files, themes, etc) and you can always rename the /concrete2 folder back to /concrete to get back to where you started.
Perhaps that will refresh things?
I tried updating to 5.4.2.2 and had the same issue: disappearing login screen. I had set my theme to handle the login page in config/site_theme_paths.php, so I commented that out to use the default and login worked!
So, obviously it was something in my theme's view.php mucking things up.
In my case I had a jScrollPane class surrounding $innerContent and removing that fixed it. Still not sure WHY, but I'm glad to have it working and to be able to use the Composer tool in 5.4.2.
So, obviously it was something in my theme's view.php mucking things up.
In my case I had a jScrollPane class surrounding $innerContent and removing that fixed it. Still not sure WHY, but I'm glad to have it working and to be able to use the Composer tool in 5.4.2.
Ran into this problem too.
1. I edited site.php as advised in this thread. That got me back into the dashboard.
2. Once I was in the Dashboard, I tried to reapply the update. It still wouldn't take.
3. I checked the permissions on my database user, and they were missing "index". Once I updated the database user, I was able run the update again and this time, the update was successful.
May or may not be helpful to those with this issue.
1. I edited site.php as advised in this thread. That got me back into the dashboard.
2. Once I was in the Dashboard, I tried to reapply the update. It still wouldn't take.
3. I checked the permissions on my database user, and they were missing "index". Once I updated the database user, I was able run the update again and this time, the update was successful.
May or may not be helpful to those with this issue.
"permissions on my database user, and they were missing "index""
Do you mean your SQL database, or some file on concrete5? Can you be a little more specific, thanks.
Do you mean your SQL database, or some file on concrete5? Can you be a little more specific, thanks.
Sorry. MySQL database user didn't have proper permissions to interact with the MySQL tables. Once I checked what the database user could and couldn't do to the MySQL tables and added "index" to the permission set, the upgrade went as expected.
I just checked my Web panel and "Index" is already ticked for the user MySQL database, so the problem I have upgrading is probably not related.
Can i change the user rights via phpMyAdmin or do i have to ask my webhoster?
I'm not sure how it works with every host, but my CPanel has a button for "MySQL Databases". With it, I can create new databases and assign users to them. A subpage of that control is the ability to set permissions for each database user. I don't think PhpMyAdmin can modify users. Quick check. I didn't see anything like that.
thanks alot - my hoster disabled this option. i will ask the customer support.
Have the same problem with some other error before this, like problem with Sortable Fancybox Gallery, scrabbook etc. Site crash after update :(