Got this error in MySQL on my dev box, but not online, despite running MySQL 5+ on both machines.
Turns out in some versions of MySQL you cannot have a space between a function name and it’s parameters, e.g.
CONCAT (MyField, ‘ some text’) <-BAD
CONCAT(MyField, ‘ some text’) <-GOOD
So good practice is to never put a space in 
I wanted to move a Subversion repository from a flat structure into the more desirable
My Repository
/trunk
/ branch
/ tag
folder structure. I found the easiest way to do this was to dump the repository to a file, then import it again in the correct location, something like
svnadmin dump C:\Repositories\OldRepo > OldRepoDumpFile
svnadmin load –parent-dir /trunk C:\Repositories\NewRepo < OldRepoDumpFile
On the load though I got the following error, at different times during the import
The requested operation cannot be performed on a file with a user-mapped section open.
This literally means the file is open somewhere else, where??? AVG Anti-Virus (or your virus scanner of choice). I went into AVG, disabled the Resident Shield (temporarily) and the file loaded absolutely fine (and a lot faster to boot).
7 comments so far, add yours ▶I keep getting this error and forgetting how to solve it, so time to blog.
When debugging in Visual Studio 2008 I sometimes get
Loaderlock was detected
DLL ‘c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\f8542944\24ca7c20\assembly\dl3\83245f41\feb88c06_9e6eca01\someNaughty.DLL’ is attempting managed execution inside OS Loader lock. Do not attempt to run managed code inside a DllMain or image initialization function since doing so can cause the application to hang.
The solution is to switch off the Managed Debug Assistant (MDA) for Loaderlocks.
Debug -> Exceptions -> Managed Debug Assistants and uncheck the LoaderLock item.
Thanks to Simon Harriyott post here for solving it.
3 comments so far, add yours ▶I received this error a few times, and variations of it, when trying to import some sql at the command prompt (CLI).
ERROR 1064 (42000) at line 3499917: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Fatal error: Maximum execution time of 300 seconds exceeded in /usr/share/phpmyadmin/libraries/export/sql.php on line 757‘
Lots of googling kept pointing to changing the maximum execution time of Apache or PHP, by default Apache is 300 seconds (as per my error) and PHP 30 seconds. It didn’t make sense as I was doing am import at the CLI, which doesn’t use Apache or PHP. The mistake I made was using phpmyadmin to export the sql file I was trying to import. Despite the sql file downloading correctly from phpmyadmin and not reporting any errors, the last lines in my sql file were
[End of file snippet ...]
(3566987, 1225461, 4, 52530, ’2009-05-00′),
(3566988, 1225464, 4, 52530, ’2009-05-00′),
(3566989, 1577089, 4, 4422, ’2009-05-00′),
(3566990, 1762231, 8, 4422, ’2009-05-00′),
(3566991, 1768654, 8, 4422, ’2009-05-00′)<br />
<b>Fatal error</b>: Maximum execution time of 300 seconds exceeded in <b>/usr/share/phpmyadmin/libraries/export/sql.php</b> on line <b>757</b><br />
The solution is of course to do things properly and use mysqldump -u [USERNAME] -p [DATABASE NAME] [TABLE] > [OUTPUT FILE NAME].sql.
One comment so far, add another ▶
Alan’s GTR – images from http://www.japanesenostalgiccar.com/forum/viewtopic.php?t=3260
My dream garage posts take too long to build, so this is a repository of vehicles I need to add to it. No order of priority/desire, just a list.
Sunbeam S7
BSA Goldstar or similar, like Nicks bike
Kawasaki ZX-10R
Kawasaki ZX-12R
Harley Davidson WLC
Old shape ltd ed Speed Triple
Edwards Rep Mille
Hayabusa
More to follow …
Leave the first comment ▶Had an annoying bug writing a WCF service. If the service was hosted on the same server as the IIS6 ASPX site that consumed it I got the following error:
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: Reference.svcmap: Specified argument was out of the range of valid values.
Parameter name: siteSource Error:
[No relevant source lines]
Source File: /App_WebReferences/MyServiceReference
Really no help whatsoever. There are two solutions, firstly you could generate a proxy for the service like
Secondly update your .net framework from 3.5 to 3.5 SP1! This bug has been cleared up in SP1 and totally avoids the problem.
http://www.microsoft.com/net/Download.aspx
2 comments so far, add yours ▶This has been driving me mad for about 4 months, having to resort to downloading tv to my laptop. I found the problem tonight! The KService would not run, this was because BBC and 4oD were conflicting!
Turns out the Channel 4oD service uses the same Kontiki software as the BBC iPlayer. I had uninstalled and reinstalled the iPlayer to no avail many times. This is what I did to fix it:
