Re: [Phpcompta-support] PhpCompta 3.0 beta 3

[Alain Vaugham]

Le Lundi 15 Octobre 2007 17:49, Dany De Bontridder a écrit :
| ça y est la beta 3 est arrivé, 

Je viens juste de l'installer sur une machine qui faisait tourner la 2.3.3.2 
avec cette procédure habituelle :
# unzip phpcompta-x.x.x.zip
# cp -Rf phpcompta /var/www/
# chown -R www-data:www-data /var/www/
# /etc/init.d/postgresql-8.1 restart
# /etc/init.d/apache2 restart
http://le-serveur/phpcompta/html/admin/setup.php

La 2.3.3.2 est bien passée en "Version 3.0-beta3" et je vois bien le module de 
compta analytique mais il y a eu plein de messages d'erreur lors du setup.
Les voici-ci dessous. C'est grave?

Info
Vous utilisez le domaine
Php setting
magic_quotes_gpc: Ok
magic_quotes_runtime: Ok
include_path : ok (.:../include:addon)

php.ini est bien configuré
Database version
string(5) "8.1.9"
Database Setting

La base de données est bien configurée
Connect to database success
Congratulation : Test successfull
Patching databases
Patching vafac
Patching vafac from the version 31 to 32 begin ;

CREATE or replace FUNCTION insert_quant_sold(
found a function p_internal text,
p_jid numeric,
p_fiche character varying,
p_quant numeric,
p_price numeric,
p_vat numeric,
p_vat_code integer,
p_client character varying)
RETURNS void
AS $$
declare
fid_client integer;
fid_good integer;
begin

select f_id into fid_client from
attr_value join jnt_fic_att_value using (jft_id) where ad_id=23 and 
av_text=upper(p_client);
select f_id into fid_good from
attr_value join jnt_fic_att_value using (jft_id) where ad_id=23 and 
av_text=upper(p_fiche);
insert into quant_sold
(qs_internal,j_id,qs_fiche,qs_quantite,qs_price,qs_vat,qs_vat_code,qs_client,qs_valid)
values
(p_internal,p_jid,fid_good,p_quant,p_price,p_vat,p_vat_code,fid_client,'Y');
return;
end;
$$
LANGUAGE plpgsql;



CREATE or REPLACE FUNCTION account_update(p_f_id integer, p_account 
poste_comptable) RETURNS integer
found a function AS $$
declare
nMax fiche.f_id%type;
nCount integer;
nParent tmp_pcmn.pcm_val_parent%type;
sName varchar;
nJft_id attr_value.jft_id%type;
begin

if length(trim(p_account)) != 0 then
select count(*) into nCount from tmp_pcmn where pcm_val=p_account;
if nCount = 0 then
select av_text into sName from
attr_value join jnt_fic_att_value using (jft_id)
where
ad_id=1 and f_id=p_f_id;
nParent:=account_parent(p_account);
insert into tmp_pcmn(pcm_val,pcm_lib,pcm_val_parent) values 
(p_account,sName,nParent);
end if;
end if;
select jft_id into njft_id from jnt_fic_att_value where f_id=p_f_id and 
ad_id=5;
update attr_value set av_text=p_account where jft_id=njft_id;

return njft_id;
end;
$$
LANGUAGE plpgsql;



CREATE TABLE quant_purchase (
qp_id integer DEFAULT nextval(('s_quantity'::text)::regclass) NOT NULL,
qp_internal text NOT NULL,
j_id integer not null,
qp_fiche integer NOT NULL,
qp_quantite numeric(20,4) NOT NULL,
qp_price numeric(20,4),
qp_vat numeric(20,4) default 0.0,
qp_vat_code integer,
qp_nd_amount numeric(20,4) default 0.0,
qp_nd_tva numeric(20,4) default 0.0,
qp_nd_tva_recup numeric(20,4) default 0.0,
qp_supplier integer NOT NULL,
qp_valid char(1) default 'Y' not null
);
ALTER TABLE ONLY quant_purchase
ADD CONSTRAINT qp_id_pk PRIMARY KEY (qp_id);

ALTER TABLE ONLY quant_purchase
ADD CONSTRAINT quant_purchase_j_id_fkey FOREIGN KEY (j_id) REFERENCES 
jrnx(j_id) ON UPDATE CASCADE ON DELETE CASCADE;

Warning: pg_query() [function.pg-query]: Query failed: ERREUR: il n'existe 
aucune contrainte correspondant aux clés données pour la table référencée 
«jrnx» in /var/www/phpcompta/include/postgres.php on line 136

Fatal error: Uncaught exception 'Exception' with message 'SQL ERROR ::: ALTER 
TABLE ONLY quant_purchase ADD CONSTRAINT quant_purchase_j_id_fkey FOREIGN KEY 
(j_id) REFERENCES jrnx(j_id) ON UPDATE CASCADE ON DELETE CASCADE ' 
in /var/www/phpcompta/include/postgres.php:138 Stack trace: 
#0 /var/www/phpcompta/html/admin/setup.php(147): ExecSql(Resource id #19, 
'?ALTER TABLE ON...', false) #1 /var/www/phpcompta/html/admin/setup.php(176): 
ExecuteScript(Resource id #19, 'sql/patch/upgra...') 
#2 /var/www/phpcompta/html/admin/setup.php(463): apply_patch(Resource id #19, 
'vafac') #3 {main} thrown in /var/www/phpcompta/include/postgres.php on line 
138

pgp4DocujQaLe.pgp
Description: PGP signature