On the verge of blowing up!!!!
Permalink
Ok, second post in two days, but I am about to deliver a web site that does not work!! Here is my error:
An exception occurred while executing 'select cID from Stacks where stName = ? and (stMultilingualSection = ? or stMultilingualSection = 0) and siteTreeID = ? order by stMultilingualSection desc limit 1' with params ["Header Site Title", "377", 2]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'siteTreeID' in 'where clause'
No idea what is causing this. I don't have a front end at all. Sitemap is gone. All I did was tried to transfer files over to another web site and I end up in this mess. I am assuming some kind of upgrade got triggered which is causing this great big headache. If anyone has an easy fix for this, I would be very grateful. I know others had this same issue because I have seen it. How did you fix this? Someone out there has to know what do to here. Once you provide the solution, I will post on here how I resolved this.
An exception occurred while executing 'select cID from Stacks where stName = ? and (stMultilingualSection = ? or stMultilingualSection = 0) and siteTreeID = ? order by stMultilingualSection desc limit 1' with params ["Header Site Title", "377", 2]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'siteTreeID' in 'where clause'
No idea what is causing this. I don't have a front end at all. Sitemap is gone. All I did was tried to transfer files over to another web site and I end up in this mess. I am assuming some kind of upgrade got triggered which is causing this great big headache. If anyone has an easy fix for this, I would be very grateful. I know others had this same issue because I have seen it. How did you fix this? Someone out there has to know what do to here. Once you provide the solution, I will post on here how I resolved this.
Hey Stew,
Thanks for the reply. To answer your questions, yes this happened when I was transferring files from my site (8.1) to another site (8.4). Different servers, same computer. I did follow the instructions on the link you sent, but I am thinking my site was upgraded and that's why it's not connecting with the database. In any event, I upgraded my site to 8.4 today. But now I am getting this message:
An exception occurred while executing 'insert into Pages (cID, siteTreeID, ptID, cParentID, uID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cDisplayOrder, pkgID, cIsActive, cIsDraft) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["413", null, "1", null, "1", "TEMPLATE", null, 0, 0, 0, 1, 0]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cParentID' cannot be null
Which I hear is related to the multilingual setup. Everything is in place as far as files, members, etc. so the web site and database are connecting, I don't have a front end and a sitemap. The web site was supposed to be live and now I have been troubleshooting for the past four days. Any idea what to do?
Thanks for the reply. To answer your questions, yes this happened when I was transferring files from my site (8.1) to another site (8.4). Different servers, same computer. I did follow the instructions on the link you sent, but I am thinking my site was upgraded and that's why it's not connecting with the database. In any event, I upgraded my site to 8.4 today. But now I am getting this message:
An exception occurred while executing 'insert into Pages (cID, siteTreeID, ptID, cParentID, uID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cDisplayOrder, pkgID, cIsActive, cIsDraft) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["413", null, "1", null, "1", "TEMPLATE", null, 0, 0, 0, 1, 0]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cParentID' cannot be null
Which I hear is related to the multilingual setup. Everything is in place as far as files, members, etc. so the web site and database are connecting, I don't have a front end and a sitemap. The web site was supposed to be live and now I have been troubleshooting for the past four days. Any idea what to do?
You cannot just copy over from 8.1 to 8.4 this will produce errors for sure.
You should go the upgrade path either before or after moving to another host. Moving a site is not the same as upgrading.
And newer versions of concrete5 will look for database tables that will not exist if the database was used with an older version of c5.
You should go the upgrade path either before or after moving to another host. Moving a site is not the same as upgrading.
And newer versions of concrete5 will look for database tables that will not exist if the database was used with an older version of c5.
Hey Steve6090
Cahueya is correct. You can not just move 8.1 files to 8.4 and not update the database and expect it to work. Your best course of action would have been to setup the new instance of 8.4 on your new site and manually move the content over.
If you need help with that let me know.
Cahueya is correct. You can not just move 8.1 files to 8.4 and not update the database and expect it to work. Your best course of action would have been to setup the new instance of 8.4 on your new site and manually move the content over.
If you need help with that let me know.
Ok, so how do I get my current site back up? I am still seeing this error:
Doctrine \ DBAL \ Exception \ NotNullConstraintViolationException
An exception occurred while executing 'insert into Pages (cID, siteTreeID, ptID, cParentID, uID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cDisplayOrder, pkgID, cIsActive, cIsDraft) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["427", null, "12", null, "1", "TEMPLATE", null, 210, 0, 0, 0, 1]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cParentID' cannot be null
I just want my site to be back up and running.
Doctrine \ DBAL \ Exception \ NotNullConstraintViolationException
An exception occurred while executing 'insert into Pages (cID, siteTreeID, ptID, cParentID, uID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cDisplayOrder, pkgID, cIsActive, cIsDraft) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["427", null, "12", null, "1", "TEMPLATE", null, 210, 0, 0, 0, 1]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cParentID' cannot be null
I just want my site to be back up and running.
Well, you just need to put the original Database and the original (v.8.4.1) File Structure back together.
You said you moved it on the same server so move it back to its old space. If there were any changes to the database in between you should use the latest backup.
After you got it all back running you can go with clean updates.
You said you moved it on the same server so move it back to its old space. If there were any changes to the database in between you should use the latest backup.
After you got it all back running you can go with clean updates.
First, what version of C5 are you using? Second, just so I understand. Your moved the site file and database from web hosting to a new web hosting right? Looking at the error I'm pretty sure the database is missing some of the tables.
Make sure you are following these instruction in the link provided below.https://documentation.concrete5.org/developers/installation/moving-a...
If you still have issue. Find me on Slack and I can help further. My user name is stewblack23.