[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Phpcompta-support] Problème encodage
From: |
Roland |
Subject: |
Re: [Phpcompta-support] Problème encodage |
Date: |
Thu, 17 Jul 2008 18:42:58 +0200 |
User-agent: |
Mozilla-Thunderbird 2.0.0.14 (X11/20080509) |
Dany De Bontridder wrote:
Roland writes:
Malheureusement j'ai le message d'erreur suivant quand j'encode une
dépense : Erreur dans l'enregistrement
/home/roland/phpcompta/include/user_form_ach.php:1043 SQL ERROR
update jrn set jr_internal='13ACH-01-329' where jr_grpt_id = 336
Misère, tu peux m'envoyer le log (/tmp/phpcompta.log)
..D..
Bonjour,
effectivement "misère"
Voici mon log.
Il ne veut toujours pas les accents. J'ai l'impression que c'est la
config de php car j'ai des caractères bizares qui s'affichent pour les
mots avec accent.
Merci
Roland
class_dossier.php : 43 'id'
class_dossier.php : 44 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
class_dossier.php : 74 'get_name'
class_dossier.php : 75 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
postgres.php : 121 'connect to -1 dbname account_repository'
postgres.php : 131 'SQL = select dos_name from ac_dossier where dos_id=13'
postgres.php : 121 'connect to 13 dbname dossier13'
class_user.php : 45 ' g_user = roland'
postgres.php : 121 'connect to -1 dbname account_repository'
class_user.php : 104 'Sql = select ac_users.use_login,ac_users.use_active,
ac_users.use_pass,
use_admin,use_first_name,use_name
from ac_users
where ac_users.use_login=\'roland\'
and ac_users.use_active=1
and
ac_users.use_pass=\'42a9ddb171e2dac9fa98eaca7294c9bb\''
class_user.php : 107 'Number of found rows : 1'
class_user.php : 307 'function load_global_pref'
postgres.php : 121 'connect to -1 dbname account_repository'
postgres.php : 131 'SQL = select parameter_type,parameter_value from
user_global_pref
where user_id=\'roland\''
postgres.php : 121 'connect to -1 dbname account_repository'
postgres.php : 131 'SQL = select the_filestyle from theme
where the_name=\'Light\''
class_dossier.php : 58 'get'
class_dossier.php : 59 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
class_dossier.php : 74 'get_name'
class_dossier.php : 75 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
postgres.php : 121 'connect to -1 dbname account_repository'
postgres.php : 131 'SQL = select dos_name from ac_dossier where dos_id=13'
class_dossier.php : 43 'id'
class_dossier.php : 44 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
class_dossier.php : 58 'get'
class_dossier.php : 59 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
class_dossier.php : 58 'get'
class_dossier.php : 59 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
class_dossier.php : 58 'get'
class_dossier.php : 59 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
class_dossier.php : 58 'get'
class_dossier.php : 59 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
class_dossier.php : 58 'get'
class_dossier.php : 59 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
class_dossier.php : 58 'get'
class_dossier.php : 59 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
class_dossier.php : 58 'get'
class_dossier.php : 59 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
class_dossier.php : 58 'get'
class_dossier.php : 59 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
postgres.php : 121 'connect to 13 dbname dossier13'
user_menu.php : 249 'U_SHOWMENUJRNUSER PTYPE=ACH'
class_dossier.php : 58 'get'
class_dossier.php : 59 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
postgres.php : 121 'connect to 13 dbname dossier13'
class_user.php : 45 ' g_user = roland'
postgres.php : 121 'connect to -1 dbname account_repository'
class_user.php : 104 'Sql = select ac_users.use_login,ac_users.use_active,
ac_users.use_pass,
use_admin,use_first_name,use_name
from ac_users
where ac_users.use_login=\'roland\'
and ac_users.use_active=1
and
ac_users.use_pass=\'42a9ddb171e2dac9fa98eaca7294c9bb\''
class_user.php : 107 'Number of found rows : 1'
class_user.php : 307 'function load_global_pref'
postgres.php : 121 'connect to -1 dbname account_repository'
postgres.php : 131 'SQL = select parameter_type,parameter_value from
user_global_pref
where user_id=\'roland\''
postgres.php : 121 'connect to -1 dbname account_repository'
postgres.php : 131 'SQL = select use_id from ac_users where use_login=\'roland\'
and use_active=1 and use_admin=1 and
use_pass=\'42a9ddb171e2dac9fa98eaca7294c9bb\''
postgres.php : 131 'SQL = select
jrn_def_id,jrn_def_type,jrn_def_name,jrn_def_class_deb,jrn_def_class_cred,jrn_deb_max_line,jrn_cred_max_line,
jrn_type_id,jrn_desc,\'W\' as uj_priv
from jrn_def join jrn_type on
jrn_def_type=jrn_type_id where
jrn_def_type=\'ACH\' order by jrn_Def_id'
postgres.php : 121 'connect to -1 dbname account_repository'
postgres.php : 131 'SQL = select use_id from ac_users where use_login=\'roland\'
and use_active=1 and use_admin=1 and
use_pass=\'42a9ddb171e2dac9fa98eaca7294c9bb\''
user_menu.php : 294 'p_jrn = 3 '
postgres.php : 121 'connect to -1 dbname account_repository'
postgres.php : 131 'SQL = select use_id from ac_users where use_login=\'roland\'
and use_active=1 and use_admin=1 '
postgres.php : 131 'SQL = select parameter_type,parameter_value from
user_local_pref where user_id=\'roland\''
user_form_ach.php : 291 'Enter form_verify_input Resource id #24,3,97,array (
\'gDossier\' => \'13\',
\'amount_t0\' => \'630\',
\'nb_t0\' => \'1\',
\'ta_0o1row_1\' => \'-1\',
\'val0l1\' => \'630\',
\'jrn_type\' => \'ACH\',
\'opd_save\' => \'on\',
\'e_date\' => \'27.05.2008\',
\'e_ech\' => \'27.05.2008\',
\'e_comm\' => \'Réparation toiture\',
\'e_client\' => \'SCH02\',
\'nb_item\' => \'1\',
\'e_march0\' => \'FID1975\',
\'e_march0_buy\' => \'630\',
\'e_march0_tva_id\' => \'3\',
\'e_march0_tva_amount\' => \'0\',
\'e_quant0\' => \'1\',
\'view_invoice\' => \'Enregistrer\',
\'save\' => \'Confirmer\',
),1'
postgres.php : 131 'SQL = select * from parameter where pr_id like \'MY_%\''
ac_common.php : 117 ' date = array (
0 => \'27\',
1 => \'05\',
2 => \'2008\',
)'
postgres.php : 131 'SQL = select tva_id from tva_rate where tva_id=3'
ac_common.php : 117 ' date = array (
0 => \'27\',
1 => \'05\',
2 => \'2008\',
)'
postgres.php : 131 'SQL = select jrn_def_fiche_cred as fiche from jrn_def where
jrn_def_id=3'
postgres.php : 131 'SQL = select *
from vw_fiche_attr
where
fd_id in (4) and quick_code=upper(\'SCH02\')'
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=5
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'SCH02\')) '
poste.php : 1170 'poste value = 4400091size = 7'
postgres.php : 131 'SQL = select * from tmp_pcmn where pcm_val=4400091'
postgres.php : 131 'SQL = select jrn_def_fiche_deb as fiche from jrn_def where
jrn_def_id=3'
postgres.php : 131 'SQL = select *
from vw_fiche_attr
where
fd_id in (1,5) and quick_code=upper(\'FID1975\')'
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=5
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')) '
poste.php : 1170 'poste value = 61602size = 5'
postgres.php : 131 'SQL = select * from tmp_pcmn where pcm_val=61602'
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=20
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')) '
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=21
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')) '
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=22
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')) '
postgres.php : 131 'SQL = select to_char(p_start,\'DD.MM.YYYY\') as p_start,
to_char(p_end,\'DD.MM.YYYY\') as p_end
from parm_periode
where p_id=97'
user_form_ach : 481 'date start periode 01.05.2008 date fin periode 31.05.2008
date demande 27.05.2008'
ac_common.php : 117 ' date = array (
0 => \'27\',
1 => \'05\',
2 => \'2008\',
)'
ac_common.php : 117 ' date = array (
0 => \'01\',
1 => \'05\',
2 => \'2008\',
)'
ac_common.php : 117 ' date = array (
0 => \'27\',
1 => \'05\',
2 => \'2008\',
)'
ac_common.php : 117 ' date = array (
0 => \'31\',
1 => \'05\',
2 => \'2008\',
)'
postgres.php : 131 'SQL = select status from jrn_periode where jrn_def_id=3
and p_id =97'
user_form_ach : 767 'function RecordSell(Resource id #24,Array,roland,3)'
postgres.php : 131 'SQL = select parameter_type,parameter_value from
user_local_pref where user_id=\'roland\''
postgres.php : 131 'SQL = select * from parameter where pr_id like \'MY_%\''
postgres.php : 131 'SQL = select nextval(\'s_oa_group\') as seq'
user_form_ach.php : 810 'Total customer:630'
user_form_achat.php : 816 'Call ComputeTotalVat'
user_common.php : 79 'ComputeTotalVat Array Array Array'
user_common.php : 81 't 0 e FID1975'
user_common.php : 87 'idx 0 element FID1975'
user_common : 96 ' tva_id is given'
user_common : 97 array (
0 => '3',
)
user_common : 104 'tva id 3'
postgres.php : 131 'SQL = select tva_id,tva_rate,tva_label from tva_rate where
tva_id=3'
user_common : 125 'vat amount = 37.8'
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=31
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')) '
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=21
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')) '
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=22
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')) '
user_common.php : 204 ' return array (
3 => 37.8,
)'
postgres.php : 131 'SQL = start transaction'
postgres.php : 131 'SQL = select nextval(\'s_grpt\') as seq'
postgres.php : 131 'SQL = select nextval(\'s_internal\') as seq'
postgres.php : 131 'SQL = select
jrn_Def_id,jrn_def_name,jrn_def_class_deb,jrn_def_class_cred,jrn_def_type,
jrn_deb_max_line,jrn_cred_max_line,jrn_def_ech,jrn_def_ech_lib,jrn_def_code,
jrn_def_fiche_deb,jrn_def_fiche_deb
from jrn_Def
where jrn_def_id=3'
class_dossier.php : 43 'id'
class_dossier.php : 44 array (
'p_action' => 'depense',
'p_jrn' => '3',
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
'style_cookie' => 'printonly',
'phpbb3_fauep_sid' => '2f06387464dc6c8e8bc09ddcd2043a6d',
'phpbb3_fauep_u' => '1',
'phpbb3_fauep_k' => '',
'PHPSESSID' => '82e1247cd1cb236fb1956e11ede0e4b9',
)
class_acc_ledger.php : 1090 'internal_code = 13ACH-01-347'
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=5
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')) '
user_common.php : 228 'function ComputeVat(Resource id #24,FID1975,1,630,3 )'
user_common : 235 'ComputeVat tva id = 3'
postgres.php : 131 'SQL = select tva_id,tva_rate,tva_label from tva_rate where
tva_id=3'
user_common : 246 'return tva37.8'
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=20
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')) '
user_form_ach.php : 850 'value non ded : '
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=31
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')) '
user_form_ach.php : 867 'value non ded : '
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=21
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')) '
user_form_ach.php : 892 'TVA value non ded : '
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=22
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')) '
user_form_ach.php : 910 'TVA value non ded : '
user_form_ach.php : 932 'InsertJrnx(Resource id
#24,\'d\',roland,3,61602,27.05.2008,round(630,2),354,97);'
user_common.php : 299 'InsertJrnx param
type = d p_user roland
p_date 27.05.2008 p_poste 61602
p_amount 630 p_grpt = 354 p_periode = 97'
user_common.php : 317 'InsertJrnx select insert_jrnx
(\'27.05.2008\',abs(630.00),61602,354,3,true,\'roland\',97,upper(\'FID1975\'))'
postgres.php : 131 'SQL = select insert_jrnx
(\'27.05.2008\',abs(630.00),61602,354,3,true,\'roland\',97,upper(\'FID1975\'))'
postgres.php : 131 'SQL = select currval(\'s_jrn_op\') as seq'
user_common.php : 810 'function InsertStockGoods(Resource id
#24,1232,FID1975,1,d)'
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=19
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')) '
postgres.php : 131 'SQL = select f_id from vw_poste_qcode where
j_qcode=upper(\'FID1975\')'
class_user.php : 45 ' g_user = roland'
postgres.php : 131 'SQL = select parameter_type,parameter_value from
user_local_pref where user_id=\'roland\''
postgres.php : 131 'SQL = select p_exercice from parm_periode where p_id=97'
postgres.php : 131 'SQL = insert into stock_goods (
j_id,
f_id,
sg_code,
sg_quantity,
sg_type,sg_exercice ) values (
1232,
252,
\'\',
1, \'d\',2008)
'
user_form_ach.php : 942 'value non ded : FID1975is'
class_anc_operation.php:476 : p_array is array (
'gDossier' => '13',
'amount_t0' => '630',
'nb_t0' => '1',
'ta_0o1row_1' => '-1',
'val0l1' => '630',
'jrn_type' => 'ACH',
'opd_save' => 'on',
'e_date' => '27.05.2008',
'e_ech' => '27.05.2008',
'e_comm' => 'Réparation toiture',
'e_client' => 'SCH02',
'nb_item' => '1',
'e_march0' => 'FID1975',
'e_march0_buy' => '630',
'e_march0_tva_id' => '3',
'e_march0_tva_amount' => '0',
'e_quant0' => '1',
'view_invoice' => 'Enregistrer',
'save' => 'Confirmer',
)
class_anc_operation.php:483- : max of row for CA = 1 ''
postgres.php : 131 'SQL = select pa_id from plan_analytique'
class_anc_operation.php:487 : nb of PA 1 ''
class_anc_operation.php:490 loop i 1 : ''
class_anc_operation.php:495loop e 1 : ''
class_anc_operation.php:496 : Checking ta_0o1row_1 ''
class_anc_operation.php:495loop e 2 : ''
class_anc_operation.php:496 : Checking ta_0o2row_1 ''
user_form_ach.php:958 : a_vat = array (
3 => 37.8,
)
form_ach : 968 'Insert into insert_quant_purchase'
postgres.php : 131 'SQL = select insert_quant_purchase
(\'13ACH-01-347\',1232,\'FID1975\',1,630,37.8,3,0,0,0,0,\'SCH02\')'
user_form_ach : 993 'a_vat = array (
3 => 37.8,
)'
user_form_ach : 996 ' tva_amount = 37.8 tva_id=3'
postgres.php : 131 'SQL = select tva_poste from tva_rate where tva_id=3'
user_common.php : 299 'InsertJrnx param
type = d p_user roland
p_date 27.05.2008 p_poste 4113
p_amount 37.8 p_grpt = 354 p_periode = 97'
user_common.php : 317 'InsertJrnx select insert_jrnx
(\'27.05.2008\',abs(37.80),4113,354,3,true,\'roland\',97,upper(\'\'))'
postgres.php : 131 'SQL = select insert_jrnx
(\'27.05.2008\',abs(37.80),4113,354,3,true,\'roland\',97,upper(\'\'))'
postgres.php : 131 'SQL = select currval(\'s_jrn_op\') as seq'
user_form_ach.php : 1005 'echeance = 27.05.2008'
user_form_ach.php : 1006 'sum_tva = 37.8'
user_form_ach.php : 1007 'amount_jrn = 630'
user_form_ach.php : 1008 'sum_tva_nd = 0'
postgres.php : 131 'SQL = select av_text from
attr_value
natural join jnt_fic_att_value
natural join fiche
where
ad_id=5
and f_id=(select f_id from vw_poste_qcode where
j_qcode=upper(\'SCH02\')) '
user_form_achat.php : 1012 'get e_client SCH02 poste 4400091'
user_form_achat.php : 1013 'insert client'
user_common.php : 299 'InsertJrnx param
type = c p_user roland
p_date 27.05.2008 p_poste 4400091
p_amount 667.8 p_grpt = 354 p_periode = 97'
user_common.php : 317 'InsertJrnx select insert_jrnx
(\'27.05.2008\',abs(667.80),4400091,354,3,false,\'roland\',97,upper(\'SCH02\'))'
postgres.php : 131 'SQL = select insert_jrnx
(\'27.05.2008\',abs(667.80),4400091,354,3,false,\'roland\',97,upper(\'SCH02\'))'
postgres.php : 131 'SQL = select currval(\'s_jrn_op\') as seq'
user_common.php : 341 'InsertJrn param
p_date 27.05.2008 p_poste -- p_amount
p_grpt = 354 p_periode = 97 p_echeance = 27.05.2008
comment = --'
postgres.php : 131 'SQL = select sum(j_montant) from jrnx where j_debit=\'t\'
and j_grpt=354'
postgres.php : 131 'SQL = select sum(j_montant) from jrnx where j_debit=\'f\'
and j_grpt=354'
InsertJrn : 356 'debit = 667.8000 credit = 667.8000 '
user_common.php : 372 'InsertJrn insert into jrn
(jr_def_id,jr_montant,jr_comment,jr_date,jr_ech,jr_grpt_id,jr_tech_per)
values (
3,abs(667.80),\'--\',to_date(\'27.05.2008\',\'DD.MM.YYYY\'),to_date(\'27.05.2008\',\'DD.MM.YYYY\'),354,97)'
postgres.php : 131 'SQL = insert into jrn
(jr_def_id,jr_montant,jr_comment,jr_date,jr_ech,jr_grpt_id,jr_tech_per)
values (
3,abs(667.80),\'--\',to_date(\'27.05.2008\',\'DD.MM.YYYY\'),to_date(\'27.05.2008\',\'DD.MM.YYYY\'),354,97)'
postgres.php : 131 'SQL = select currval(\'s_jrn\') as seq'
postgres.php : 131 'SQL = update jrn set jr_internal=\'13ACH-01-347\' where
jr_grpt_id = 354'
postgres.php : 131 'SQL = update jrn set jr_comment=\'Réparation toiture\'
where jr_grpt_id=354'
postgres.php : 131 'SQL = rollback'
- Re: [Phpcompta-support] Problème encodage, Roland, 2008/07/15
- Re: [Phpcompta-support] Problème encodage, Dany De Bontridder, 2008/07/15
- Re: [Phpcompta-support] Problème encodage, Roland, 2008/07/16
- Re: [Phpcompta-support] Problème encodage, Dany De Bontridder, 2008/07/16
- Message not available
- Re: [Phpcompta-support] Problème encodage, Dany De Bontridder, 2008/07/16
- Message not available
- Message not available
- Message not available
- Message not available
- Message not available
- Re: [Phpcompta-support] Problème encodage, Dany De Bontridder, 2008/07/16
- Re: [Phpcompta-support] Problème encodage, Roland, 2008/07/16
- Re: [Phpcompta-support] Problème encodage, Dany De Bontridder, 2008/07/16
- Re: [Phpcompta-support] Problème encodage,
Roland <=
- Re: [Phpcompta-support] Problème encodage, Dany De Bontridder, 2008/07/17
- Re: [Phpcompta-support] Problème encodage, Roland, 2008/07/18
- Re: [Phpcompta-support] Problème encodage, Dany De Bontridder, 2008/07/24