Quote:
|
Also there is an issue saving the data: sometimes it works, mostly not,
|
John - are you using table/query components or direct mysql access for the postings? With direct you can just trap the result failures and look up what the error is.
PHP Code:
function sqlErrors($query)
{
//debug log
$regdate=date('Y/m/d H:i:s');
$message = $regdate.' <b>'.$_SERVER['PHP_SELF'].' - Invalid query: '.mysql_errno().'</b><br>' . mysql_error() ." ip ".$_SERVER["REMOTE_ADDR"]. '<br><br>';
$message .= '<b>Whole query:</b><br>' . $query .'<br>'.json_encode($_REQUEST).'<br>___________________________________<br>';
$file="errors.html";
$handle = fopen($file, "a");
fwrite($handle, $message);
fclose($handle);
}
$result=mysql_query($sql);
if (!$result) sqlErrors($sql);
I've never tried this but, you may be able to check the errors in adodb with just adding mysql_errno().'</b><br>' . mysql_error() to a test label value to see if anything is happening that you can check.
from the docs
MySQL :: MySQL 5.1 Reference Manual :: 10.3 Date and Time Types
Quote:
|
Although MySQL tries to interpret values in several formats, dates always must be given in year-month-day order (for example, '98-09-04'), rather than in the month-day-year or day-month-year orders commonly used elsewhere (for example, '09-04-98', '04-09-98').
|
Steve - I've not had any problem with viewing ajax responses with firebug, from old versions to new ones they are always visible in the console. A quick look there has always told me if I had a problem.