bugPhpCompta - Bugs: bug #16254, erreur à l'insertion d'une fiche

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #16254: erreur à l'insertion d'une fiche

Submitted by:  Stan Pinte <stanpinte>
Submitted on:  Mon 03 Apr 2006 07:44:19 AM UTC  
 
Category: DisturbingSeverity: 3 - Normal
Item Group: NoneStatus: Fixed
Privacy: PublicAssigned to: Dany De Bontridder <sparkyx>
Open/Closed: ClosedRelease: CVS

Thu 20 Jul 2006 01:12:15 PM UTC, comment #1:

Le type de la colonne est dorénavant numeric 25, cela devrait convenir

Dany De Bontridder <sparkyx>
Project AdministratorIn charge of this item.
Mon 03 Apr 2006 07:44:19 AM UTC, original submission:

Stan Pinte wrote:

>> >Warning: pg_query(): Query failed: ERROR: integer out of range in
>> >c:\export\phpcompta\include\postgres.php on line 104
>> >Operation cancelled due to error : insert into tmp_pcmn
>> >(pcm_val,pcm_lib,pcm_val_parent) values (48910000001,'Tanguy
>> > Pinte',4891000)
>> >
>> >--> curieux, non?


>
> en fait non, quand on sait que le champs pcm_val est de type int4 dans
> PostgreSQL, donc entier 32 bits...
>
> 48910000001 > 4294967296 (232-1)
>
> Maintenant de deux choses l'une:
>
> soit le type int4 est mal choisi, soit l'algoritme de création de fiches
> avec ajout automatique de poste comptable est foireux.
>
> Stan.

Stan Pinte <stanpinte>

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Thu 20 Jul 2006 01:12:15 PM UTCsparkyxStatusNone=>Fixed
  Assigned tostanpinte=>sparkyx
  Open/ClosedOpen=>Closed

Back to the top


Powered by Savane 3.1-cleanup1