LinuxMCE Forums

General => Installation issues => Topic started by: murcel on October 11, 2012, 10:02:07 pm

Title: Solved: Dianemo S: error installing update
Post by: murcel 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)



Title: Re: Dianemo S: error installing update
Post by: totallymaxed on October 12, 2012, 04:56:29 pm

Quote from: murcel 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)



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

Title: Re: Dianemo S: error installing update
Post by: murcel on October 12, 2012, 05:00:44 pm

Quote from: totallymaxed on October 12, 2012, 04:56:29 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