<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">I had replied to this thread but found
it lurking unsent in the outbox of my iPad. There's a moral there
somewhere.<br>
<br>
Anyway, thankyou and yes, it's all working now. As the saying
goes, when you've eliminated the impossible, them whatever's left,
no matter how improbable, must be the truth. So when an identical
macbook pro didn't work, it dawned on me that the macbook I
brought to the pub had not been shutdown since then. It was
suspended and the same instance of mysql was still running. A
side-by-side 'show variables' with the pub-macbook soon showed the
glaring difference.<br>
<br>
Still some work to do. e.g. was tempted to push it live but
stumbled upon
<a class="moz-txt-link-freetext" href="http://www.php.net/manual/en/function.htmlspecialchars.php#112476">http://www.php.net/manual/en/function.htmlspecialchars.php#112476</a>
where function htmlspecialchars returns null. That could've been
embarrassing. <br>
<br>
But all looking good!<br>
<br>
thanks and see you in January.<br>
<br>
Dougie<br>
<br>
<br>
<br>
On 20/11/13 15:55, Dougie Nisbet wrote:<br>
</div>
<blockquote
cite="mid:CA+KSp6M9Sj7KNfnuxitsHABzxWntHp1ZgWf7n=-8gXNBo4tZHw@mail.gmail.com"
type="cite">
<div dir="ltr">Thanks for all your help - those who were at last
night's NELUG, but ....
<div><br>
</div>
<div>bizarrely, I can't transfer the knowledge. </div>
<div><br>
</div>
<div>I have tried exporting the data to a MAC Mini, and iMAC,
and, ANOTHER identical Macbook to the one we used last night.
All will retrieve records, will not save data. It's possible
to enter data into the fields, but they are not saved.</div>
<div><br>
</div>
<div>So what's different? I don't know. I've dumped the data
from the Macbook, and even tried copying the raw files over to
other servers. I've included Dave's last minute finding of:</div>
<div><br>
</div>
<div>SET SESSION sql_mode='NO_AUTO_VALUE_ON_ZERO'</div>
<div><br>
</div>
<div>tried with it and without it. </div>
<div><br>
</div>
<div>I've copied the entire /Library/WebServer structure from
the macbook to other machines.</div>
<div><br>
</div>
<div>So what did we do last night on the macbook that I'm
missing? Am I going to have to do a Crimewatch like
reconstruction of last night's events to try and recall what
configuration change was made that seems to be unique to the
macbook? I was beginning to think it was hardware specific -
but having tried migrating it to an identically specced
macbook and having the same problem makes me think that
there's some unique config change on last night's macbook.</div>
<div><br>
</div>
<div>Yours stumped,</div>
<div><br>
</div>
<div>Dougie</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Durham mailing list - <a class="moz-txt-link-abbreviated" href="mailto:Durham@mailman.lug.org.uk">Durham@mailman.lug.org.uk</a>
<a class="moz-txt-link-freetext" href="https://mailman.lug.org.uk/mailman/listinfo/durham">https://mailman.lug.org.uk/mailman/listinfo/durham</a>
<a class="moz-txt-link-freetext" href="http://www.nelug.org.uk/">http://www.nelug.org.uk/</a></pre>
</blockquote>
<br>
</body>
</html>