Problème d\'encodage à l\'installation
Posté : mar. nov. 14, 2017 10:35 pm
Bonjour,
J\'essaye d\'installer phpcompta sur un nouveau serveur. Nouveaux problèmes:
Vesrion: phpcompta-4.2-build-2311
postgresql: 8.1
OS: linux debian
Tuto suivi: http://doc.ubuntu-fr.org/phpcompta
Message su setup.php:
J\'essaye d\'installer phpcompta sur un nouveau serveur. Nouveaux problèmes:
Vesrion: phpcompta-4.2-build-2311
postgresql: 8.1
OS: linux debian
Tuto suivi: http://doc.ubuntu-fr.org/phpcompta
Message su setup.php:
Code : Tout sélectionner
Info
Vous utilisez le domaine
Php setting
magic_quotes_gpc: Ok
magic_quotes_runtime: Ok
include_path : ok (.:../../include:../include:addon)
php.ini est bien configuré
Database version
string(6) \"8.1.15\"
...
# Patching (BE) Basique from the version 50 to 51
# Patching (BE) Basique from the version 51 to 52
# Patching (BE) Basique from the version 52 to 53
# Patching (BE) Basique from the version 53 to 54
# Patching (BE) Basique from the version 54 to 55
begin;
create or replace function fiche_attribut_synchro (p_fd_id fiche_def.fd_id%TYPE) returns void as
found a function$BODY$
declare
-- this sql gives the f_id and the missing attribute (ad_id)
list_missing cursor for select f_id,fd_id,ad_id,jnt_order from jnt_fic_attr join fiche as A using (fd_id) where fd_id=p_fd_id and ad_id not in (select ad_id from fiche join jnt_fic_att_value using (f_id) where fd_id=jnt_fic_attr.fd_id and A.f_id=f_id);
rec record;
-- value of the last insert
jnt jnt_fic_att_value%ROWTYPE;
begin
open list_missing;
loop
fetch list_missing into rec;
IF NOT FOUND then
exit;
end if;
-- insert a value into jnt_fic_att_value
insert into jnt_fic_att_value (f_id,ad_id) values (rec.f_id,rec.ad_id) returning * into jnt;
-- now we insert into attr_value
insert into attr_value values (jnt.jft_id,\'\');
end loop;
close list_missing;
end;
$BODY$ language plpgsql;
Fatal error: Uncaught exception \'Exception\' with message \' SQL ERROR create or replace function fiche_attribut_synchro (p_fd_id fiche_def.fd_id%TYPE) returns void as $BODY$ declare -- this sql gives the f_id and the missing attribute (ad_id) list_missing cursor for select f_id,fd_id,ad_id,jnt_order from jnt_fic_attr join fiche as A using (fd_id) where fd_id=p_fd_id and ad_id not in (select ad_id from fiche join jnt_fic_att_value using (f_id) where fd_id=jnt_fic_attr.fd_id and A.f_id=f_id); rec record; -- value of the last insert jnt jnt_fic_att_value%ROWTYPE; begin open list_missing; loop fetch list_missing into rec; IF NOT FOUND then exit; end if; -- insert a value into jnt_fic_att_value insert into jnt_fic_att_value (f_id,ad_id) values (rec.f_id,rec.ad_id) returning * into jnt; -- now we insert into attr_value insert into attr_value values (jnt.jft_id,\'\'); end loop; close list_missing; end; $BODY$ language plpgsql; \' in /home/web/phpcompta/include/postgres.php:143 Stack trace: #0 /home/web/phpcom in /home/web/phpcompta/include/postgres.php on line 143