5.4.2 error with Composer table in MySQL
Permalink 2 users found helpful
Hello,
I updated a couple of Concrete5 sites that are fortunately in development and the sites now give me this error:
mysql error: [1146: Table 'crandal3_cnc2.ComposerTypes' doesn't exist] in EXECUTE("select * from ComposerTypes where ctID = '3'")
I'm a bit of a neophyte when it comes to MySQL databases. Any ideas what I need to do?
Thanks,
Spencer
I updated a couple of Concrete5 sites that are fortunately in development and the sites now give me this error:
mysql error: [1146: Table 'crandal3_cnc2.ComposerTypes' doesn't exist] in EXECUTE("select * from ComposerTypes where ctID = '3'")
I'm a bit of a neophyte when it comes to MySQL databases. Any ideas what I need to do?
Thanks,
Spencer
SpencerC you save my arse for the short term! thanks
Does anyone have a solution to this? I cannot edit my sites.
Thanks,
Spencer
Thanks,
Spencer
I emailed this thread's link to Franz so maybe he'll help us out. We're helping him out by using his stuff!
How did you upgrade? Did you upgrade yourself or through another process? If it's another process like SimpleScripts perhaps they haven't got the upgrade working properly.
When you upgrade through the dashboard (Dashboard > System > Update) this shouldn't happen. This should only happen if you download a new concrete5 core, replace the old concrete5 core with the new one, but don't run the upgrade script afterwards (which should create the ComposerTypes table.) If this is how you're upgrading, you'll need to visithttp://www.yoursite.com/index.php/tools/required/upgrade... and click the button to complete the upgrade.
Again, if this is an update through SimpleScripts then perhaps there's something wrong with their updater. Please let me know. But again, updating through the concrete5 dashboard shouldn't have this problem.
When you upgrade through the dashboard (Dashboard > System > Update) this shouldn't happen. This should only happen if you download a new concrete5 core, replace the old concrete5 core with the new one, but don't run the upgrade script afterwards (which should create the ComposerTypes table.) If this is how you're upgrading, you'll need to visithttp://www.yoursite.com/index.php/tools/required/upgrade... and click the button to complete the upgrade.
Again, if this is an update through SimpleScripts then perhaps there's something wrong with their updater. Please let me know. But again, updating through the concrete5 dashboard shouldn't have this problem.
Upgraded with simplescripts. But of 8 sites only two broke (deleted tables).
Just ran the update tool and it worked. Thanks much Andrew.
Glad to hear it. It sounds like the database updates required by 5.4.2 aren't being run if you update via simplescripts. I will contact them. Thanks.
While I was writing this I got an email from the simplescripts people. They are aware of the problem and are working on it.
Oh my, you are absolutely correct. I upgraded through Simplescripts. Why I did not use the Dashboard this time who knows. Perhaps this is a lesson to always use the dashboard.
If anyone else encounters this issue, downgrading in Simplescripts, then upgrading in the c5 dashboard does the trick. Just know that you will lose any data between the last time you backed up and today. And you need to update the version manually in your Simplescripts dashboard.
Thanks for your work on this Andrew. C5 continues to be awesome!
-Spencer
If anyone else encounters this issue, downgrading in Simplescripts, then upgrading in the c5 dashboard does the trick. Just know that you will lose any data between the last time you backed up and today. And you need to update the version manually in your Simplescripts dashboard.
Thanks for your work on this Andrew. C5 continues to be awesome!
-Spencer
Holy Crap!!! Thank!
I ran the SimpleScript update before reading this post. Everything fell apart. Used your link and now everything works.
Thanks!
I ran the SimpleScript update before reading this post. Everything fell apart. Used your link and now everything works.
Thanks!
Wow. Thank you Andrew for your assist on this. Updating through the dashboard was indeed the answer. You saved me time and lord knows how much frustration. I thought I had to rebuild!
Thanks again
Thanks again
Andrew, you saved me as well.
Dashboard update was indeed the fix.
Thank you!!
Dashboard update was indeed the fix.
Thank you!!
Hi,
I upgraded trough the dashboard and got the same problem
Orm
I upgraded trough the dashboard and got the same problem
Orm
I have also tried the dashboard update and the simple scripts update and both lock me out of my site and leave me with MySQL error:1054.
I am hosting with Bluehost and they helped me to reset to before the updates, but had no solution as to why the database was causing the updates to fail. I'm a designer not a developer...HELP!
I am hosting with Bluehost and they helped me to reset to before the updates, but had no solution as to why the database was causing the updates to fail. I'm a designer not a developer...HELP!
If you're seeing an upgrade error when trying to update the site, go here:
http://www.yoursite.com/index.php/tools/required/upgrade...
you will probably see a message saying you are updating from a previous version to 5.4.2. Then click the button to upgrade. This will add the missing tables to the database. This should happen automatically when using SimpleScripts but early versions of the 5.4.2 update didn't do it.
http://www.yoursite.com/index.php/tools/required/upgrade...
you will probably see a message saying you are updating from a previous version to 5.4.2. Then click the button to upgrade. This will add the missing tables to the database. This should happen automatically when using SimpleScripts but early versions of the 5.4.2 update didn't do it.
This is the message I get when I go to the link you provided.
Your site is already up to date! The current version of Concrete5 is 5.4.1.1. You should remove this file for security.
Back to Home.
Click here if you would like to re-run this script.
How do I go about removing that file?
Your site is already up to date! The current version of Concrete5 is 5.4.1.1. You should remove this file for security.
Back to Home.
Click here if you would like to re-run this script.
How do I go about removing that file?
Oh. It sounds like they reverted back to 5.4.1.1 then for you.
Andrew's answer saved my day! Experienced the same problems updating to 5.4.2 as described here and this solved the problem. Since I used Installatron for the update instead of SimpleScripts I thought it might be helpful to add this to this discussion.
Just for the record: Installatron worked fine when updating sites from 5.4.2 to 5.5.1.
Just for the record: Installatron worked fine when updating sites from 5.4.2 to 5.5.1.
Here's what I did:
1) Install the latest version of Concrete5 using SimpleScripts into a dummy domain
2) Open the new MySQL database using PHP My Admin in CPanel.
3) Look for tables with "Composer" in the name.
4) Export these tables (3) with "Dump All Rows" checked.
5) Open the MySQL databases that need repair in PHP My Admin and import the new Composer tables. Fixed!
The error I get now when trying to log-in:
mysql error: [1054: Unknown column 'uDefaultLanguage' in 'field list'] in EXECUTE("select uID, uName, uIsActive, uIsValidated, uTimezone, uDefaultLanguage from Users where uName = 'newcc' and uPassword = '76e5dc78b5c8dc9665e2b18eab53e0a9'")
Help!
-Spencer