[Durham] About last night ...

[Richard Patterson]

See http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

You can execute "SELECT @@GLOBAL.sql_mode;" from a mysql prompt on the 
macbook we were working on to prove that it's set globally...

Interestingly, there is an sql_mode you can set - ALLOW_INVALID_DATES - 
which would have allowed your 31st November dates ;-)


Regards

Richard

On 20/11/2013 15:55, Dougie Nisbet wrote:
> Thanks for all your help - those who were at last night's NELUG, but ....
>
> bizarrely, I can't transfer the knowledge.
>
> 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.
>
> 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:
>
> SET SESSION sql_mode='NO_AUTO_VALUE_ON_ZERO'
>
> tried with it and without it.
>
> I've copied the entire /Library/WebServer structure from the macbook 
> to other machines.
>
> 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.
>
> Yours stumped,
>
> Dougie
>
>
> _______________________________________________
> Durham mailing list   -   Durham at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/durham
> http://www.nelug.org.uk/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.lug.org.uk/pipermail/durham/attachments/20131120/06970a12/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4261 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://mailman.lug.org.uk/pipermail/durham/attachments/20131120/06970a12/attachment-0001.bin>