29-03-2023, 05:55 PM
Ok, ejecuta en la consola DB estos comandos uno a uno (ojo, tardarán un ratito en ejecutarse y dar el ok, hazlo cuando tengas un rato de calma):
delete from pagoscobros2 where id_pagoscobros in (select id_pagoscobros from pagoscobros);
delete from apcajas2 where id_apcajas in (select id_apcajas from apcajas);
delete from tiquet2 where (id_tiquet,serie) in (select id_tiquet,serie from tiquet);
delete from factura2 where (id_factura,serie) in (select id_factura,serie from factura);
delete from ventadirecta2 where id_venta in (select id_venta from ventadirecta);
delete from ventadir_comg2 where (id_venta,id_linea) in (select id_venta,id_linea from ventadir_comg);
una vez ejecutados, recupera los datos antiguos (tardará un rato) y te saldrá el panel para hacer una nueva copia (que tardará otro buen rato)
Ya me dices.
delete from pagoscobros2 where id_pagoscobros in (select id_pagoscobros from pagoscobros);
delete from apcajas2 where id_apcajas in (select id_apcajas from apcajas);
delete from tiquet2 where (id_tiquet,serie) in (select id_tiquet,serie from tiquet);
delete from factura2 where (id_factura,serie) in (select id_factura,serie from factura);
delete from ventadirecta2 where id_venta in (select id_venta from ventadirecta);
delete from ventadir_comg2 where (id_venta,id_linea) in (select id_venta,id_linea from ventadir_comg);
una vez ejecutados, recupera los datos antiguos (tardará un rato) y te saldrá el panel para hacer una nueva copia (que tardará otro buen rato)
Ya me dices.