5.4.2 error with Composer table in MySQL2 users found helpful
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?
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'")
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.
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!
I ran the SimpleScript update before reading this post. Everything fell apart. Used your link and now everything works.
Dashboard update was indeed the fix.
I upgraded trough the dashboard and got the same problem
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!
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.
Your site is already up to date! The current version of Concrete5 is 184.108.40.206. 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?
Just for the record: Installatron worked fine when updating sites from 5.4.2 to 5.5.1.