Author Topic: Solved: Dianemo S: error installing update  (Read 642 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: 4459
  • 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,
Convergent Home Technologies Ltd

Read My Blog; http://ellipticalcurve.com

Contact me for Smart Home consulting advice here;
@herron on Twitter, inquiries@ellipticalcurve.com via email or PM me here.

Get a Dianemo License: http://forum.linuxmce.org/index.php?topic=8880.msg100221#msg100221
Follow us on Facebook: https://www.facebook.com/pages/Dianemo-Home-Automation/226019387454465

Sales & Info:
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