<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">Dougie,<br>
<br>
I seem to recall that we did an import with SET GLOBAL
sql_mode='NO_AUTO_VALUE_ON_ZERO' first, before you changed it to
the SESSION version.<br>
<br>
"Setting the <code class="literal">GLOBAL</code> variable
requires the <span class="link"><code class="literal">SUPER</code></span>
privilege and affects the operation of all clients that connect
from that time on"<br>
<br>
So when we did it the first time, it set it for *future*
connections, including the website.<br>
<br>
Doing it with just SET SESSION, would only effect the current
session (the import).<br>
<br>
So, try opening a mysql prompt, and do the above SET GLOBAL.<br>
<br>
then try your website stuff...<br>
<br>
Regards<br>
<br>
Richard<br>
<br>
On 20/11/2013 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>