• Willkommen im Linux Club - dem deutschsprachigen Supportforum für GNU/Linux. Registriere dich kostenlos, um alle Inhalte zu sehen und Fragen zu stellen.

Fehler bei PHP Anwendung

A

abalorio

Member
Hi Leute, ich habe folgenden Fehler, wenn ich ein Script auf dem Server ausführe:


Code: 
Warning: pg_exec(): Query failed: ERROR:  date/time field value out of range: "1  0"
HINT:  Perhaps you need a different "datestyle" setting.
. in /service/versand.php on line 201

Warning: pg_fetch_object(): supplied argument is not a valid PostgreSQL result resource in /service/versand.php on line 202

In den Zeilen 201 und 202 steht:

Code: 
$result2= pg_exec($connection, $sql2);                                                                                      
        $periode = pg_fetch_object($result2,0);

pg_exec und pg_fetch_object ist laut cpan schon installiert. Hat jemand von euch eine Idee?

Gruß Abalorio
 
OP
A

abalorio

Member
Code: 
select
                extract('month' from cast('1 Mar 2006' as date)) as d1,
                extract('year' from cast('1 Mar 2006' as date)) as y1,
                extract('month' from (cast('1 Mar 2006' as date) +  cast('3 months' as interval))) as d2,
                extract('year' from (cast('1 Mar 2006' as date) +  cast('3 months' as interval))) as y2,
                extract('month' from (cast('1 Mar 2006' as date) +  cast('6 months' as interval))) as d3,
                extract('year' from (cast('1 Mar 2006' as date) +  cast('6 months' as interval))) as y3,
                extract('month' from (cast('1 Mar 2006' as date) +  cast('9 months' as interval))) as d4,
                extract('year' from (cast('1 Mar 2006' as date) +  cast('9 months' as interval))) as y4,
                extract('month' from (cast('1 Mar 2006' as date) +  cast('12 months' as interval))) as d5,
                extract('year' from (cast('1 Mar 2006' as date) +  cast('12 months' as interval))) as y5,
                extract('month' from (cast('1 Mar 2006' as date) +  cast('15 months' as interval))) as d6,
                extract('year' from (cast('1 Mar 2006' as date) +  cast('15 months' as interval))) as y6,
                extract('month' from (cast('1 Mar 2006' as date) +  cast('18 months' as interval))) as d7,
                extract('year' from (cast('1 Mar 2006' as date) +  cast('18 months' as interval))) as y7,
                extract('month' from (cast('1 Mar 2006' as date) +  cast('21 months' as interval))) as d8,
                extract('year' from (cast('1 Mar 2006' as date) +  cast('21 months' as interval))) as y8,
                extract('month' from (cast('1 Mar 2006' as date) +  cast('24 months' as interval))) as d9,
                extract('year' from (cast('1 Mar 2006' as date) +  cast('24 months' as interval))) as y9,
                extract('month' from (cast('1 Mar 2006' as date) +  cast('27 months' as interval))) as d10,
                extract('year' from (cast('1 Mar 2006' as date) +  cast('27 months' as interval))) as y10,
                extract('month' from (cast('1 Mar 2006' as date) +  cast('30 months' as interval))) as d11,
                extract('year' from (cast('1 Mar 2006' as date) +  cast('30 months' as interval))) as y11,
                extract('month' from (cast('1 Mar 2006' as date) +  cast('33 months' as interval))) as d12,
                extract('year' from (cast('1 Mar 2006' as date) +  cast('33 months' as interval))) as y12;

Ich glaube aber nicht, dass es daran liegt. Es hat ja schon einmal funktioniert.

Gruß Abalorio
 
B

Bartlin

Member
also so wie ich das sehe, fragst du ja keine Datenbank ab, sondern lässt dir nur Zeiten berechnen - warum über eine DB-Abfrage?

Ansonsten meckert dein Script, dass das Date/Time Field "out of range" ist. Wann hast du das Script das letzte mal laufen lassen? Ist es vielleicht ein yr2k- Fehler?

Ansonsten könnte es evtl. sein, dass du bei einem Feld eine doppelte Leertaste hast?

Bartlin
 
Du musst dich einloggen oder registrieren, um hier zu antworten.
Oben