company taking over hosting for a school districts website, the original server is running
freebsd not sure what version
php not sure what version
postgre not sure what version
the new server is running
php newest i assume
here the php error there getting. do you think it could be because there running newer versions of postgre or php?
Warning: pg_exec(): Query failed: ERROR: Type "datetime" does not exist . in /home/gps/public_html/handlers/calendar.php on line 527
Warning: pg_numrows(): supplied argument is not a valid PostgreSQL result resource in /home/gps/public_html/handlers/calendar.php on line 528
no events for this date range were found.
Here are lines starting at 527 from the php file.
$result = pg_exec( $database, $exec );
if( pg_numrows( $result ) )
for( $count = 0; $count < pg_numrows( $result ); $count++ )
$row = pg_fetch_array( $result, $count );
$date = date( "m/d/Y", strtotime( $row[ "date" ] ) );
if( $date != $previous_date )
if( $previous_date )
print "<h4 style=\"border-bottom: 1px solid;\">" . date( "l, F d, Y", strtotime( $row[ "date" ] ) ) . "</h4>\n";