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

SpencerC
View Replies: View Best Answer
SpencerC replied on at Permalink Reply
SpencerC
Well, the explorer in me thought I figured out a neophyte way to deal with this, but now I cannot sign in to edit, though at least I can see the sites now.

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
311Media replied on at Permalink Reply
311Media
SpencerC you save my arse for the short term! thanks
SpencerC replied on at Permalink Reply
SpencerC
Does anyone have a solution to this? I cannot edit my sites.

Thanks,
Spencer
311Media replied on at Permalink Reply
311Media
I emailed this thread's link to Franz so maybe he'll help us out. We're helping him out by using his stuff!
andrew replied on at Permalink Reply
andrew
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.
311Media replied on at Permalink Reply
311Media
Upgraded with simplescripts. But of 8 sites only two broke (deleted tables).
311Media replied on at Permalink Reply
311Media
Just ran the update tool and it worked. Thanks much Andrew.
andrew replied on at Permalink Reply
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.
andrew replied on at Permalink Reply
andrew
While I was writing this I got an email from the simplescripts people. They are aware of the problem and are working on it.
SpencerC replied on at Permalink Reply
SpencerC
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
tbock7117 replied on at Permalink Reply
Holy Crap!!! Thank!

I ran the SimpleScript update before reading this post. Everything fell apart. Used your link and now everything works.

Thanks!
KenanLegg replied on at Permalink Reply
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
KenanLegg replied on at Permalink Reply
Andrew, you saved me as well.

Dashboard update was indeed the fix.

Thank you!!
orm replied on at Permalink Reply
Hi,

I upgraded trough the dashboard and got the same problem

Orm
TinyGiant replied on at Permalink Reply
TinyGiant
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!
andrew replied on at Permalink Best Answer Reply
andrew
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.
TinyGiant replied on at Permalink Reply
TinyGiant
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?
andrew replied on at Permalink Reply
andrew
Oh. It sounds like they reverted back to 5.4.1.1 then for you.
hhockx replied on at Permalink Reply
hhockx
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.