SQL error v4.2.1 importing example design

I have just installed a new installation of Matrix from the virtual image v4.2.1, after the installation I attempted to import the localise.tar.gz design file as a new design resource, however this failed with the following error:




Fatal error: Uncaught exception 'Exception' with message 'Unable to insert new attribute values for asset "localise" (#70) due to database error: SQLSTATE[22021]: Character not in repertoire: 7 ERROR: invalid byte sequence for encoding "UTF8": 0x8b HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".' in /var/www/matrix/core/include/asset.inc:3198 Stack trace: #0 /var/www/matrix/core/assets/designs/design/design_edit_fns.inc(764): Asset->saveAttributes() #1 /var/www/matrix/core/assets/designs/design/design_edit_fns.inc(106): Design_Edit_Fns->parseAndProcessFile(Object(Design)) #2 /var/www/matrix/core/include/asset_edit_interface.inc(2079): Design_Edit_Fns->processParseFile(Object(Design), Object(Backend_Outputter), 'design_70') #3 /var/www/matrix/core/include/asset_edit_interface.inc(1819): Asset_Edit_Interface->processInline(Object(Design), Object(Backend_Outputter), false, 'details') #4 /var/www/matrix/core/include/asset.inc in /var/www/matrix/core/include/asset.inc on line 3198



Anyone come accross this issue?

Is version 4.2.1 backwardly compatible with these example designs?

[quote]
I have just installed a new installation of Matrix from the virtual image v4.2.1, after the installation I attempted to import the localise.tar.gz design file as a new design resource, however this failed with the following error:





Fatal error: Uncaught exception 'Exception' with message 'Unable to insert new attribute values for asset "localise" (#70) due to database error: SQLSTATE[22021]: Character not in repertoire: 7 ERROR: invalid byte sequence for encoding "UTF8": 0x8b HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".' in /var/www/matrix/core/include/asset.inc:3198 Stack trace: #0 /var/www/matrix/core/assets/designs/design/design_edit_fns.inc(764): Asset->saveAttributes() #1 /var/www/matrix/core/assets/designs/design/design_edit_fns.inc(106): Design_Edit_Fns->parseAndProcessFile(Object(Design)) #2 /var/www/matrix/core/include/asset_edit_interface.inc(2079): Design_Edit_Fns->processParseFile(Object(Design), Object(Backend_Outputter), 'design_70') #3 /var/www/matrix/core/include/asset_edit_interface.inc(1819): Asset_Edit_Interface->processInline(Object(Design), Object(Backend_Outputter), false, 'details') #4 /var/www/matrix/core/include/asset.inc in /var/www/matrix/core/include/asset.inc on line 3198



Anyone come accross this issue?

Is version 4.2.1 backwardly compatible with these example designs?

[/quote]





Hi,



Looks like you are trying to add the tar.gz for the example file from wrong field. It should be added from field under Section "Associated Files" rather than the field under Section "Parse File". The same can be done from Import/Export Screen for Designs too.

I too get the same error when i try to pick a tar.gz file from the field under Section "Parse File".



Hope that Helps.



Ash

Hi Ash,
Thanks for the response, you were spot on