Possible multilanguage bug

[trix87]

Hello,

I am using the new 8.1.0 version of concrete and i may have encountered a possible bug when switching locales. I had an en_US locale this is how the site was installed in the first place but i wanted to change it to de_DE since the final product would have been a german site. I created a new locale besides the en_US and after doing so i copied the whole sitemap tree from the en_US to the de_DE tree. Then i set the default locale to the newly created de_DE and deleted the old en_US. After this when i tried to open the home page i got this error :

An exception occurred while executing 'insert into Pages (cID, siteTreeID, ptID, cParentID, uID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cDisplayOrder, pkgID, cIsActive) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["479", null, "1", null, "1", "TEMPLATE", null, null, 0, 0, 1]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cParentID' cannot be null

Every time i hit a reload the part where its says params ["479", gets autoinceremented by one. Other pages do load some of them are missing the blocks others are intact but the home page is dead.

Some help or a fix would be great since i did not make a backup i would need to rebuild the whole site and that would take very long.

Thanks.

[typoman76]

This is related to this bugtracker entry: https://www.concrete5.org/developers/bugs/8-1-0/changing-site-default-locale-in-multilingual-settings-breaks-glo/
You are getting several problems on the actual version by changing the default language. Even worse after deleting the original language as you mentioned here.

[ZiP76]

Hi, was anyone able to fix this issue? I'm currently using version 8.3.2 and the problem still occurs...

Hope someone has a fix. Unfortunately the original language has been removed so switching back is not an option.

[mlocati]

This issue is caused by #6447

[ZiP76]

So, no solution for this issue?

[mlocati]

This issue will be fixed when that issue is fixed

[ideasc]

A lot in late, but in my situation, Concrete8.5.2 updated from old version, maybe 5.7, solution was to set "siteTreeID" of my default language from "SiteLocales" table, to "Pages" table, column "siteTreeID", where "cFilename" column is "/!drafts/view.php"

After doing that, if you have fixed correctly, following query should return an id, mine was 129

select p.cID from PagePaths pp inner join Pages p on pp.cID = p.cID inner join SiteLocales sl on p.siteTreeID = sl.siteTreeID where cPath = '/!drafts' and sl.siteID = 1