phpcompta-support
[Top][All Lists]
Advanced
[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'
reply via email to
[Prev in Thread] Current Thread [Next in Thread]