Monitor Reply

Support

Error message when using composer with Internationalization package (5.6.0.2)

Permalink Browser Info Environment September 27, 2012 at 3:12 AM

When using Internationalization on 5.6.0.2 and saving pages with composer, Concrete throws following error:

mysql error: [1364: Field 'mpLocale' doesn't have a default value] in EXECUTE("insert into MultilingualPageRelations (mpRelationID, cID, mpLanguage) values (128, '277', 'en')")

The page still gets saved and is fully functional, but pagerelations aren't saved. The bug *might* be server-spesific depending on how MySQL is set to handle empty values.

Type:	Discussion
Status:	New

mkly replied on Sep 27, 2012 at 2:21 pm Permalink Reply

Thanks for letting us know about the issue.

Are you comfortable editing the source code of the addon? If so could you try changing line #241 and line #242 in

/packages/internationalization/multilingual/models/section.php

$v = array($mpRelationID, $page->getCollectionID(), $ms->getLanguage(), $ms->getLocale());
$db->Execute('insert into MultilingualPageRelations (mpRelationID, cID, mpLanguage, mpLocale) values (?, ?, ?, ?)', $v);

And let us know if this resolves the issue?

Best Wishes,
Mike

Ale replied on Sep 28, 2012 at 1:29 am Permalink Reply

Thanks for the tip, it worked.

Before you replied I just did a quick & dirty fix and altered the database column to default to en_GB, but your solution is definately better as it gives the used locale instead of a hard-coded value.

Internationalization

Support

Error message when using composer with Internationalization package (5.6.0.2)

Issue Reply

concrete5 Environment Information

Browser User-Agent String

Hide Post Content

Request Refund

Code

Delete Post