You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

AppleSyncNotifier: The procedure entry point sqlite3_wal_checkpoint could not be located in the dynamic link library QLite3.dll.

I just downloaded and installed the latest iTunes and Safari update. It required a reboot, and after the PC restarted I was greeted with this error message:


AppleSyncNotifier: The procedure entry point sqlite3_wal_checkpoint could not be located in the dynamic link library QLite3.dll.


First time to ever see this one. I can only presume that it is a bug. But any help to correct the problem will be greatly appreciated.


TIA

iOS 4.3.3

Posted on Jul 21, 2011 3:07 PM

Reply
64 replies

Nov 25, 2011 7:27 PM in response to tit4tat

I have had to perform this copy procedure several times after several iTunes updates since this summer (2011) Prior to performing the copy this time, I peeked into the "C:\Program Files\Common Files\Apple\Mobile Device Support" folder and noticed a 2008 copy of sqlite3.dll. The date stamp of the file in "C:\Program Files\Common Files\Apple\Apple Application Support" is 2011.06.24. So, my guess is that Apple isn't installing sqlite3.dll into the wrong directory but is, instead, actually installing the wrong version into "C:\Program Files\Common Files\Apple\Mobile Device Support."


Obviously, I won't be able to verify this until the next iTunes update. Of course, by then I'm sure I will have forgotten everything I just said or even that I just left this post. 🙂

Jan 20, 2012 11:44 AM in response to tit4tat

The true cause of this problem is an extra sqlite3.dll (or libxml2.dll if you're getting that message). I suggest going into "c:\windows\system32" (and if you have 64 bit windows, "c:\windows\syswow64" as well) and renaming sqlite3.dll to sqlite3.bak and libxml2.dll to libxml2.bak.



A previous version of iTunes, or another program, has dropped an old version of one of those two files in the system folder. When iTunes launches, normally it will look in the Application Support folder for those files, but Windows operates a little strangely - when looking for a DLL file, windows will first check the same folder as the application (which is why copying the DLL works), then the system32/syswow64 folders, then the Path (%PATH%), then where the application wants. If the DLL in the System32 folder is older than the prograrrm needs, the program won't work.


On the computer I fixed this problem on, Adobe Reader, some HP software, and a few other programs also had their own copies of sqlite3.dll in their folders, so removing these from the system32/syswow64 folders may prevent future problems.

Mar 9, 2012 7:41 PM in response to tit4tat

Rather than take the risk of downloading a file from an unknown or untrusted site you can easily make your own Batch File...


1. Simply right click on your desktop

2. Select New Text Document

3. When the new file shows up on your desktop change the Name to iTunes-sqlFix.bat

4. Press Enter to Save the Name

5. Press OK when prompted to ignore the file extension warning

6. Right click the new file and select Edit

7. Copy and Paste the command below into the document


Xcopy "C:\Program Files (x86)\Common Files\Apple\Apple Application Support\SQLite3.dll" "C:\Program Files (x86)\Common Files\Apple\Mobile Device Support" /w


8. Save the File

9. Right click the file and select "Run as Administrator"

10. Select "Yes" on the UAC warning box

11. Select any key to perform the file copy

12. Done!


Next time you reboot the problem is gone....


Next time iTunes is updated just run steps 9 thru 12 and your fixed again....


Hope this Helps...

Mar 9, 2012 8:02 PM in response to CTS inc

I had this same problem with itunes and I saw most everyone posted a lenthy, confusing way fix this itunes error, so I created a simple batch file that accounts for both win32 and 64bit computers and offered it back to the community. I've revised it several times from user feedback and have helped hundreds of people. I typically get nice 'thank you' letters from people all over the world that used the batch file. I don't claim that it will help everyone. The instructions from CTS accounts for one possible reason for the error. The batch file I wrote accounts for several more and is legitimate. Anyone is welcome to download it. http://www.computerwild.com/downloads.html. Let me know how it goes.

Mar 13, 2012 6:23 AM in response to tit4tat

Nice idea with the batch file but unfortunately told me 'path not found'.

I have also had this update problem several times running Windows 7and a few days ago (7th March ?) I got this again after downloading the latest update. Back in August last year I had written this note for myself to remind me where to look and have already used about 5 times :

fixing error message "The procedure entry point sqlite3_wal_checkpoint could not be located in the dynamic link library SQLite3.dll"

copy the file SQLite3.dll from the C:\Program Files\Common Files\Apple\Apple Application Support folder to the C:\Program Files\Common Files\Apple\Mobile Device Support folder

It still seems to work, but this is getting ridiculous, having to 'fix' something from Apple so often And for so long... Cmon Apple, it's not much to ask now 😉


Note there is also a SQLite3.dll in my Safari folder (Program Files(x86)/Safari/Apple Application Support), which was updated successfully at the same time as the Itunes update (i.e. has a date of 07/03/2012) but this does NOT work if copied to the required location. The file I copy across from the C:\Program Files\Common Files\Apple\Apple Application Support folder has a date of 26th June....

Mar 13, 2012 1:36 PM in response to Boudica

Thank you for the feedback. I have reviewed the batch file and the first line already for your solution. I also explain in the batch file that "If you see 'The system cannot find the path specified', it's okay." The batch file simply looks in several places for the SQLite3.dll. If it can not find it in a particular location, it says so. It's worked for many people, and until Apple fixes their 2 year old problem, I will keep the batch file up to fix this itunes error for anyone that needs it. http://www.computerwild.com/downloads.html

AppleSyncNotifier: The procedure entry point sqlite3_wal_checkpoint could not be located in the dynamic link library QLite3.dll.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.