Author Topic: Solved: Dianemo S: error installing update  (Read 3032 times)

murcel

  • Guru
  • ****
  • Posts: 198
    • View Profile
Solved: Dianemo S: error installing update
« on: October 11, 2012, 10:02:07 pm »
With the latest update from today, there seems to be a problem:

Code: [Select]
***Warning*** While importing into table: Text_LS pscid: 1630
You modified the row that is being re-imported.
No prompts specified.  Not overwriting changes
01      10/11/12 21:53:50.454           While importing into table: Text_LS pscid: 1630 was modified.  Skipping <0x406b54c0>
01      10/11/12 21:53:50.455           Query failed (Duplicate entry '321-3' for key 'PRIMARY'): UPDATE `Text_LS` SET  `FK_Text`='321', `FK_Language`='3', `Description`='Zum AB umleiten', `psc_id`='1632', `psc_batch`='1355', `psc_user`=NULL, `psc_frozen`='0', `psc_mod`='0', `psc_restrict`=NULL WHERE psc_id=1632 AND (psc_batch is NULL OR psc_batch=0 OR (psc_batch>0 AND psc_batch<=1355)) (1) <0x406b54c0>
05      10/11/12 21:53:50.455           Resetting mysql connection <0x406b54c0>
01      10/11/12 21:53:50.456           Query failed (Duplicate entry '321-3' for key 'PRIMARY'): UPDATE `Text_LS` SET  `FK_Text`='321', `FK_Language`='3', `Description`='Zum AB umleiten', `psc_id`='1632', `psc_batch`='1355', `psc_user`=NULL, `psc_frozen`='0', `psc_mod`='0', `psc_restrict`=NULL WHERE psc_id=1632 AND (psc_batch is NULL OR psc_batch=0 OR (psc_batch>0 AND psc_batch<=1355)) (1) <0x406b54c0>
05      10/11/12 21:53:50.456           Resetting mysql connection <0x406b54c0>
01      10/11/12 21:53:50.456           Query failed (): UPDATE `Text_LS` SET  `FK_Text`='321', `FK_Language`='3', `Description`='Zum AB umleiten', `psc_id`='1632', `psc_batch`='1355', `psc_user`=NULL, `psc_frozen`='0', `psc_mod`='0', `psc_restrict`=NULL WHERE psc_id=1632 AND (psc_batch is NULL OR psc_batch=0 OR (psc_batch>0 AND psc_batch<=1355)) retry: -1 <0x406b54c0>
SQL Failed: UPDATE `Text_LS` SET  `FK_Text`='321', `FK_Language`='3', `Description`='Zum AB umleiten', `psc_id`='1632', `psc_batch`='1355', `psc_user`=NULL, `psc_frozen`='0', `psc_mod`='0', `psc_restrict`=NULL WHERE psc_id=1632 AND (psc_batch is NULL OR psc_batch=0 OR (psc_batch>0 AND psc_batch<=1355))
Caught exception: Database error
dpkg: error processing pluto-system-database (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 pluto-system-database
E: Sub-process /usr/bin/dpkg returned an error code (1)

« Last Edit: October 14, 2012, 07:20:08 pm by murcel »

totallymaxed

  • LinuxMCE God
  • ****
  • Posts: 4660
  • Smart Home Consulting
    • View Profile
    • Dianemo - at home with technology
Re: Dianemo S: error installing update
« Reply #1 on: October 12, 2012, 04:56:29 pm »
With the latest update from today, there seems to be a problem:

Code: [Select]
***Warning*** While importing into table: Text_LS pscid: 1630
You modified the row that is being re-imported.
No prompts specified.  Not overwriting changes
01      10/11/12 21:53:50.454           While importing into table: Text_LS pscid: 1630 was modified.  Skipping <0x406b54c0>
01      10/11/12 21:53:50.455           Query failed (Duplicate entry '321-3' for key 'PRIMARY'): UPDATE `Text_LS` SET  `FK_Text`='321', `FK_Language`='3', `Description`='Zum AB umleiten', `psc_id`='1632', `psc_batch`='1355', `psc_user`=NULL, `psc_frozen`='0', `psc_mod`='0', `psc_restrict`=NULL WHERE psc_id=1632 AND (psc_batch is NULL OR psc_batch=0 OR (psc_batch>0 AND psc_batch<=1355)) (1) <0x406b54c0>
05      10/11/12 21:53:50.455           Resetting mysql connection <0x406b54c0>
01      10/11/12 21:53:50.456           Query failed (Duplicate entry '321-3' for key 'PRIMARY'): UPDATE `Text_LS` SET  `FK_Text`='321', `FK_Language`='3', `Description`='Zum AB umleiten', `psc_id`='1632', `psc_batch`='1355', `psc_user`=NULL, `psc_frozen`='0', `psc_mod`='0', `psc_restrict`=NULL WHERE psc_id=1632 AND (psc_batch is NULL OR psc_batch=0 OR (psc_batch>0 AND psc_batch<=1355)) (1) <0x406b54c0>
05      10/11/12 21:53:50.456           Resetting mysql connection <0x406b54c0>
01      10/11/12 21:53:50.456           Query failed (): UPDATE `Text_LS` SET  `FK_Text`='321', `FK_Language`='3', `Description`='Zum AB umleiten', `psc_id`='1632', `psc_batch`='1355', `psc_user`=NULL, `psc_frozen`='0', `psc_mod`='0', `psc_restrict`=NULL WHERE psc_id=1632 AND (psc_batch is NULL OR psc_batch=0 OR (psc_batch>0 AND psc_batch<=1355)) retry: -1 <0x406b54c0>
SQL Failed: UPDATE `Text_LS` SET  `FK_Text`='321', `FK_Language`='3', `Description`='Zum AB umleiten', `psc_id`='1632', `psc_batch`='1355', `psc_user`=NULL, `psc_frozen`='0', `psc_mod`='0', `psc_restrict`=NULL WHERE psc_id=1632 AND (psc_batch is NULL OR psc_batch=0 OR (psc_batch>0 AND psc_batch<=1355))
Caught exception: Database error
dpkg: error processing pluto-system-database (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 pluto-system-database
E: Sub-process /usr/bin/dpkg returned an error code (1)


Hi Murcel,

Looks to us like your work on the German Translation may have caused an issue. Simple solution is;

Login to MySQL and run the line below;
drop table Text_LS

Then from the terminal do;

sudo dpkg --configure -a <return>

***The downside of the above is that any changes you made will be lost when you drop the table.

Did you so a mass import of any language from somewhere?

Regards

Andrew

Andy Herron,
CHT Ltd

For Dianemo/LinuxMCE consulting advice;
@herron on Twitter, totallymaxed+inquiries@gmail.com via email or PM me here.

Get Dianemo-Rpi2 ARM Licenses http://forum.linuxmce.org/index.php?topic=14026.0

Get RaspSqueeze-CEC or Raspbmc-CEC for Dianemo/LinuxMCE: http://wp.me/P4KgIc-5P

Facebook: https://www.facebook.com/pages/Dianemo-Home-Automation/226019387454465

http://www.dianemo.co.uk

murcel

  • Guru
  • ****
  • Posts: 198
    • View Profile
Re: Dianemo S: error installing update
« Reply #2 on: October 12, 2012, 05:00:44 pm »

Did you so a mass import of any language from somewhere?

No i didn't. put in every single record by hand...:-)
ok, should i make an dump before and just add the german lines with an update query later on?

Marc