Actualize a la versión 6.0.3 y al ingresar mi usuario y contraseña obtengo el siguiente error:
Unknown column 'u.dateemployment' in 'field list'
Estos errores me aparecieron durante la instalación:
Error DB_ERROR_1072: ALTER TABLE llxmr_categorie_fournisseur ADD PRIMARY KEY pk_categorie_fournisseur (fk_categorie, fk_societe);
Key column 'fk_societe' doesn't exist in table
Request 89 sql='ALTER TABLE llxmr_categorie_fournisseur ADD INDEX idx_categorie_fournisseur_fk_categorie (fk_categorie);'
Request 90 sql='ALTER TABLE llxmr_categorie_fournisseur ADD INDEX idx_categorie_fournisseur_fk_societe (fk_societe);'
Error DB_ERROR_1072: ALTER TABLE llxmr_categorie_fournisseur ADD INDEX idx_categorie_fournisseur_fk_societe (fk_societe);
Key column 'fk_societe' doesn't exist in table
Request 91 sql='DELETE FROM llxmr_categorie_fournisseur WHERE fk_categorie NOT IN (SELECT rowid FROM llxmr_categorie);'
Request 92 sql='DELETE FROM llxmr_categorie_fournisseur WHERE fk_societe NOT IN (SELECT rowid FROM llxmr_societe);'
Request 93 sql='ALTER TABLE llxmr_categorie_fournisseur ADD CONSTRAINT fk_categorie_fournisseur_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llxmr_categorie (rowid);'
Request 94 sql='ALTER TABLE llxmr_categorie_fournisseur ADD CONSTRAINT fk_categorie_fournisseur_fk_soc FOREIGN KEY (fk_societe) REFERENCES llxmr_societe (rowid);'
Error DB_ERROR_1072: ALTER TABLE llxmr_categorie_fournisseur ADD CONSTRAINT fk_categorie_fournisseur_fk_soc FOREIGN KEY (fk_societe) REFERENCES llxmr_societe (rowid);
Key column 'fk_societe' doesn't exist in table
Request 95 sql='INSERT INTO llxmr_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23201, 232, 23201, '', 0, 'Los Andes', 1);'
Request 96 sql='INSERT INTO llxmr_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23202, 232, 23202, '', 0, 'Capital', 1);'
Request 97 sql='INSERT INTO llxmr_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23203, 232, 23203, '', 0, 'Central', 1);'
Request 98 sql='INSERT INTO llxmr_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23204, 232, 23204, '', 0, 'Cento Occidental', 1);'
Request 99 sql='INSERT INTO llxmr_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23205, 232, 23205, '', 0, 'Guayana', 1);'
Request 100 sql='INSERT INTO llxmr_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23206, 232, 23206, '', 0, 'Insular', 1);'
Request 101 sql='INSERT INTO llxmr_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23207, 232, 23207, '', 0, 'Los Llanos', 1);'
Request 102 sql='INSERT INTO llxmr_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23208, 232, 23208, '', 0, 'Nor-Oriental', 1);'
Request 103 sql='INSERT INTO llxmr_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23209, 232, 23209, '', 0, 'Zuliana', 1);'
Request 104 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-L', 23201, '', 0, 'VE-L', 'Mérida', 1);'
Request 105 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-T', 23201, '', 0, 'VE-T', 'Trujillo', 1);'
Request 106 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-E', 23201, '', 0, 'VE-E', 'Barinas', 1);'
Request 107 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-M', 23202, '', 0, 'VE-M', 'Miranda', 1);'
Request 108 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-W', 23202, '', 0, 'VE-W', 'Vargas', 1);'
Request 109 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-A', 23202, '', 0, 'VE-A', 'Distrito Capital', 1);'
Request 110 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-D', 23203, '', 0, 'VE-D', 'Aragua', 1);'
Request 111 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-G', 23203, '', 0, 'VE-G', 'Carabobo', 1);'
Request 112 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-I', 23204, '', 0, 'VE-I', 'Falcón', 1);'
Request 113 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-K', 23204, '', 0, 'VE-K', 'Lara', 1);'
Request 114 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-U', 23204, '', 0, 'VE-U', 'Yaracuy', 1);'
Request 115 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-F', 23205, '', 0, 'VE-F', 'Bolívar', 1);'
Request 116 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-X', 23205, '', 0, 'VE-X', 'Amazonas', 1);'
Request 117 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-Y', 23205, '', 0, 'VE-Y', 'Delta Amacuro', 1);'
Request 118 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-O', 23206, '', 0, 'VE-O', 'Nueva Esparta', 1);'
Request 119 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-Z', 23206, '', 0, 'VE-Z', 'Dependencias Federales', 1);'
Request 120 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-C', 23207, '', 0, 'VE-C', 'Apure', 1);'
Request 121 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-J', 23207, '', 0, 'VE-J', 'Guárico', 1);'
Request 122 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-H', 23207, '', 0, 'VE-H', 'Cojedes', 1);'
Request 123 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-P', 23207, '', 0, 'VE-P', 'Portuguesa', 1);'
Request 124 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-B', 23208, '', 0, 'VE-B', 'Anzoátegui', 1);'
Request 125 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-N', 23208, '', 0, 'VE-N', 'Monagas', 1);'
Request 126 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-R', 23208, '', 0, 'VE-R', 'Sucre', 1);'
Request 127 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-V', 23209, '', 0, 'VE-V', 'Zulia', 1);'
Request 128 sql='INSERT INTO llxmr_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-S', 23209, '', 0, 'VE-S', 'Táchira', 1);'
Request 129 sql='insert into llxmr_c_currencies ( code, code_iso, active, label ) VALUES ( 'VE', 'VEF', 1, 'Venezuelan Bolívar');'
Request 130 sql='insert into llxmr_c_tva(rowid,fk_pays,taux,recuperableonly,note,active) values (2321,232, '0','0','No VAT',1);'
Request 131 sql='insert into llxmr_c_tva(rowid,fk_pays,taux,recuperableonly,note,active) values (2322,232, '12','0','VAT 12%',1);'
Request 132 sql='insert into llxmr_c_tva(rowid,fk_pays,taux,recuperableonly,note,active) values (2323,232, '8','0','VAT 8%',1);'
Request 133 sql='update llxmr_cotisation set fk_bank = null where fk_bank not in (select rowid from llxmr_bank);'
Request 134 sql='insert into llxmr_c_chargesociales (id, libelle, deductible, active, code, fk_pays) values (12, 'Cotisation foncière des entreprises', 0, 1, 'TAXCFE', '1');'
Request 135 sql='insert into llxmr_c_chargesociales (id, libelle, deductible, active, code, fk_pays) values (13, 'Cotisation sur la valeur ajoutée des entreprises', 0, 1, 'TAXCVAE', '1');'
Request 136 sql='ALTER TABLE llxmr_paiement ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;'
Request 137 sql='ALTER TABLE llxmr_product_price ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;'
Request 138 sql='UPDATE llxmr_expedition SET fk_expedition_methode = null WHERE fk_expedition_methode NOT IN (SELECT rowid FROM llxmr_c_shipment_mode);'
Request 139 sql='ALTER TABLE llxmr_expedition DROP FOREIGN KEY fk_expedition_fk_expedition_methode;'
Request 140 sql='ALTER TABLE llxmr_expedition ADD CONSTRAINT fk_expedition_fk_expedition_methode FOREIGN KEY (fk_expedition_methode) REFERENCES llxmr_c_shipment_mode (rowid);'
Error DB_ERROR_1072: ALTER TABLE llxmr_expedition ADD CONSTRAINT fk_expedition_fk_expedition_methode FOREIGN KEY (fk_expedition_methode) REFERENCES llxmr_c_shipment_mode (rowid);
Key column 'fk_expedition_methode' doesn't exist in table
Después de actualizar a 6.0.3 marca error al ingresar
Hola doy soporte a dolibarr x si aun no solucionas el problema.. te dejo mi email: licoes75@gmail.com Ing. Marco Stalin
MSTALIN