Error message

[Martin]

I am getting an error. I am grouping books by publisher by clicking on a publishers name and then choosing "Group books by "Publisher"". But there two almost similar publisher names. When I click the first one I see the book that is published by this publisher but when I click the second almost similar publisher name it kind off looks like there is no book there and I get an error message (see below)

EurekaLog 4.6.7

"Application":
---------------------------------------------------------
1.1 "Start Date" : Tue, 14 Apr 2009 19:56:59 +0200
1.2 "Name/Description": allmybooks.exe
1.3 "Version Number" :
1.4 "Parameters" :

"Exception":
-----------------------------------------------------------------------------------------------------------------------------------------------
2.1 "Date" : Tue, 14 Apr 2009 20:00:03 +0200
2.2 "Address": 00560E0D
2.3 Module : allmybooks.exe
2.4 "Type" : EOleException
2.5 "Message": Syntax error (missing operator) in query expression '[publisher] ='Everyman's University Library' ORDER BY originaltitle ASC'.

"Active Controls":
------------------------------------------------------
3.1 "Form Class" : TMainForm
3.2 "Form Text" : All My Books v1.5 - martin1.amb
3.3 "Control Class": TTeTreeView
3.4 "Control Text" :

"Computer":
-------------------------------
4.1 "Name" :
4.2 User :
4.3 "Total Memory": 2048 Mb
4.4 "Free Memory" : 2048 Mb
4.5 "Total Disk" : 180.25 Gb
4.6 "Free Disk" : 90.12 Gb

"Operating System":
-----------------------------------------
5.1 "Type" : Microsoft Windows XP
5.2 "Build #" : 2600
5.3 "Update" : Service Pack 3
5.4 "Language": English (United States)

"Call Stack Information":
------------------------------------------------------------------------------------
|"Address"|"Module" |"Unit" |"Class" |"Procedure/Method" |"Line"|
------------------------------------------------------------------------------------
|008194E4 |allmybooks.exe|DM.pas |TDataModule1|SQLCommand |575 |
|0081949C |allmybooks.exe|DM.pas |TDataModule1|SQLCommand |572 |
|007E60B8 |allmybooks.exe|MAIN.pas|TMainForm |ExpandLevel |3069 |
|007E557C |allmybooks.exe|MAIN.pas|TMainForm |ExpandLevel |2984 |
|007E5571 |allmybooks.exe|MAIN.pas|TMainForm |TreeView1Expanding |2972 |
|7C90EC9A |ntdll.dll | | |RtlMultiByteToUnicodeN | |
|7C90EB74 |ntdll.dll | | |RtlAnsiStringToUnicodeString| |
|7E42A993 |USER32.DLL | | |CallWindowProcA | |
|773E0F5A |COMCTL32.DLL | | |DPA_InsertPtr | |
|7E4292DE |USER32.DLL | | |SendMessageW | |
|7E4297B5 |USER32.DLL | | |ScreenToClient | |
|7E4188CC |USER32.DLL | | |GetWindowLongW | |
|7E4188D5 |USER32.DLL | | |GetWindowLongW | |
|7E42A993 |USER32.DLL | | |CallWindowProcA | |
|7E42B3FC |USER32.DLL | | |CallNextHookEx | |
|7E4196C2 |USER32.DLL | | |DispatchMessageA | |
------------------------------------------------------------------------------------

"Modules Information":
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|"Handle"|"Name" |"Description" |"Version" |"Size" |"Path" |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|00400000|allmybooks.exe | | |2869984|C:\Program Files\AllMyBooks |
|01410000|Normaliz.dll |Unicode Normalization DLL |6.0.5441.0 |23552 |C:\WINDOWS\system32 |
|02360000|xpsp2res.dll |Service Pack 2 Messages |5.1.2600.5512 |2897920|C:\WINDOWS\system32 |
|030E0000|google.dll | | |142336 |C:\Program Files\AllMyBooks\plugins |
|08440000|msadcer.dll |Microsoft Data Access - OLE DB Cursor Engine Resources |2.81.1132.0 |20480 |C:\Program Files\Common Files\System\msadc |
|0F9A0000|VBAJET32.DLL |Visual Basic for Applications Development Environment - Expression Service Loader|6.0.1.9432 |30749 |C:\WINDOWS\system32 |
|0F9C0000|expsrv.dll |Visual Basic for Applications Runtime - Expression Service |6.0.72.9590 |380445 |C:\WINDOWS\system32 |
|1A400000|urlmon.dll |OLE32 Extensions for Win32 |8.0.6001.18702 |1206784|C:\WINDOWS\system32 |
|1B000000|msjet40.dll |Microsoft Jet Engine Library |4.0.9511.0 |1516568|C:\WINDOWS\system32 |
|1B2C0000|msjter40.dll |Microsoft Jet Database Engine Error DLL |4.0.9502.0 |60192 |C:\WINDOWS\system32 |
|1B2D0000|MSJINT40.DLL |Microsoft Jet Database Engine International DLL |4.0.9502.0 |151583 |C:\WINDOWS\system32 |
|1B570000|msjetoledb40.dll| |4.0.9502.0 |355112 |C:\WINDOWS\system32 |
|1B5D0000|mswstr10.dll |Microsoft Jet Sort Library |4.0.9502.0 |621344 |C:\WINDOWS\system32 |
|1B800000|msjtes40.dll |Microsoft Jet Expression Service |4.0.9502.0 |248608 |C:\WINDOWS\system32 |
|4DE10000|msado15.dll |Microsoft Data Access - ActiveX Data Objects |2.81.1132.0 |536576 |C:\Program Files\Common Files\System\ado |
|4EC50000|GdiPlus.dll |Microsoft GDI+ |5.1.3102.5581 |1724416|C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.2600.5581_x-ww_dfbc4fc4 |
|5AD70000|uxtheme.dll |Microsoft UxTheme Library |6.0.2900.5512 |218624 |C:\WINDOWS\system32 |
|5B860000|NETAPI32.dll |Net Win32 API DLL |5.1.2600.5694 |337408 |C:\WINDOWS\system32 |
|5DCA0000|iertutil.dll |Run time utility for Internet Explorer |8.0.6001.18702 |1985024|C:\WINDOWS\system32 |
|5EDD0000|olepro32.dll | |5.1.2600.5512 |84992 |C:\WINDOWS\system32 |
|63000000|wininet.dll |Internet Extensions for Win32 |8.0.6001.18702 |914944 |C:\WINDOWS\system32 |
|6D020000|adialhk.dll |kldialhk |8.0.0.506 |83208 |C:\PROGRA~1\KASPER~1\KASPER~1 |
|6D4C0000|kloehk.dll |Kaspersky OE plugin loader |8.0.0.506 |11016 |C:\PROGRA~1\KASPER~1\KASPER~1 |
|6D710000|mzvkbd.dll |Mozilla 2 Virtual Keyboard |8.0.0.506 |79112 |C:\PROGRA~1\KASPER~1\KASPER~1 |
|6D730000|mzvkbd3.dll |Mozilla 3 Virtual Keyboard |8.0.0.506 |79112 |C:\PROGRA~1\KASPER~1\KASPER~1 |
|71AA0000|WS2HELP.dll |Windows Socket 2.0 Helper for Windows NT |5.1.2600.5512 |19968 |C:\WINDOWS\system32 |
|71AB0000|WS2_32.dll |Windows Socket 2.0 32-Bit DLL |5.1.2600.5512 |82432 |C:\WINDOWS\system32 |
|71AD0000|wsock32.dll |Windows Socket 32-Bit DLL |5.1.2600.5512 |22528 |C:\WINDOWS\system32 |
|73000000|winspool.drv |Windows Spooler Driver |5.1.2600.5512 |146432 |C:\WINDOWS\system32 |
|73160000|oledb32.dll |Microsoft Data Access - OLE DB Core Services |2.81.1132.0 |487424 |C:\Program Files\Common Files\System\Ole DB |
|73B50000|avifil32.dll |Microsoft AVI File support library |5.1.2600.5512 |84992 |C:\WINDOWS\system32 |
|74060000|msadce.dll |Microsoft Data Access - OLE DB Cursor Engine |2.81.3002.0 |331776 |C:\Program Files\Common Files\System\msadc |
|750B0000|RESUTILS.DLL |Microsoft Cluster Resource Utility DLL |5.1.2600.5512 |58880 |C:\WINDOWS\system32 |
|750F0000|MTXCLU.DLL |MS DTC amd MTS clustering support DLL |2001.12.4414.700|66560 |C:\WINDOWS\system32 |
|75130000|colbact.DLL | |2001.12.4414.700|60416 |C:\WINDOWS\system32 |
|75350000|OLEDB32R.DLL |Microsoft Data Access - OLE DB Core Services Resources |2.81.1132.0 |65536 |C:\Program Files\Common Files\System\Ole DB |
|755C0000|msctfime.ime |Microsoft Text Frame Work Service IME |5.1.2600.5512 |177152 |C:\WINDOWS\system32 |
|75A70000|MSVFW32.dll |Microsoft Video for Windows DLL |5.1.2600.5512 |121344 |C:\WINDOWS\system32 |
|76380000|msimg32.dll |GDIEXT Client DLL |5.1.2600.5512 |4608 |C:\WINDOWS\system32 |
|76390000|IMM32.DLL |Windows XP IMM32 API Client DLL |5.1.2600.5512 |110080 |C:\WINDOWS\system32 |
|763B0000|comdlg32.dll |Common Dialogs DLL |6.0.2900.5512 |276992 |C:\WINDOWS\system32 |
|765B0000|MSDART.DLL |Microsoft Data Access - OLE DB Runtime Routines |2.81.1132.0 |151552 |C:\WINDOWS\system32 |
|76620000|comsvcs.dll | |2001.12.4414.702|1267200|C:\WINDOWS\system32 |
|769C0000|USERENV.dll |Userenv |5.1.2600.5512 |727040 |C:\WINDOWS\system32 |
|76B40000|winmm.dll |MCI API DLL |5.1.2600.5512 |176128 |C:\WINDOWS\system32 |
|76BF0000|PSAPI.DLL |Process Status Helper |5.1.2600.5512 |23040 |C:\WINDOWS\system32 |
|76D10000|CLUSAPI.DLL |Cluster API Library |5.1.2600.5512 |58368 |C:\WINDOWS\system32 |
|76FD0000|CLBCATQ.DLL | |2001.12.4414.700|498688 |C:\WINDOWS\system32 |
|77050000|COMRes.dll | |2001.12.4414.700|792064 |C:\WINDOWS\system32 |
|77120000|oleaut32.dll | |5.1.2600.5512 |551936 |C:\WINDOWS\system32 |
|773D0000|COMCTL32.DLL |User Experience Controls Library |6.0.2900.5512 |1054208|C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.5512_x-ww_35d4ce83|
|774E0000|ole32.dll |Microsoft OLE for Windows |5.1.2600.5512 |1287168|C:\WINDOWS\system32 |
|77BE0000|MSACM32.dll |Microsoft ACM Audio Filter |5.1.2600.5512 |71680 |C:\WINDOWS\system32 |
|77C00000|version.dll |Version Checking and File Installation Libraries |5.1.2600.5512 |18944 |C:\WINDOWS\system32 |
|77C10000|msvcrt.dll |Windows NT CRT DLL |7.0.2600.5512 |343040 |C:\WINDOWS\system32 |
|77DD0000|ADVAPI32.dll |Advanced Windows 32 Base API |5.1.2600.5512 |617472 |C:\WINDOWS\system32 |
|77E70000|RPCRT4.dll |Remote Procedure Call Runtime |5.1.2600.5512 |584704 |C:\WINDOWS\system32 |
|77F10000|GDI32.dll |GDI Client DLL |5.1.2600.5698 |286720 |C:\WINDOWS\system32 |
|77F60000|SHLWAPI.dll |Shell Light-weight Utility Library |6.0.2900.5512 |474112 |C:\WINDOWS\system32 |
|77FE0000|Secur32.dll |Security Support Provider Interface |5.1.2600.5512 |56320 |C:\WINDOWS\system32 |
|7C800000|kernel32.dll |Windows NT BASE API Client DLL |5.1.2600.5512 |989696 |C:\WINDOWS\system32 |
|7C900000|ntdll.dll |NT Layer DLL |5.1.2600.5512 |706048 |C:\WINDOWS\system32 |
|7C9C0000|shell32.dll |Windows Shell Common Dll |6.0.2900.5622 |8461312|C:\WINDOWS\system32 |
|7E410000|USER32.DLL |Windows XP USER API Client DLL |5.1.2600.5512 |578560 |C:\WINDOWS\system32 |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

"Registers":
-----------------------------
EAX: 0199AF50 EDI: 00000001
EBX: 80040E14 ESI: 00560E12
ECX: 00000000 ESP: 0012EFF0
EDX: 00560E12 EIP: 00560E0D

"Stack": "Memory Dump":
------------------ ---------------------------------------------------------------------------
0012EFF0: 0012F030 00560E0D: E8 76 6A EA FF 8D 45 E8 E8 42 59 EA FF 89 03 33 .vj...E..BY....3
0012EFF4: 00404C90 00560E1D: C0 5A 59 59 64 89 10 68 40 0E 56 00 33 C9 BA 02 .ZYYd..h@.V.3...
0012EFF8: 0012F024 00560E2D: 00 00 00 8B 45 FC 8B 18 FF 53 3C C3 E9 22 3E EA ....E....S<..">.
0012EFFC: 00860A78 00560E3D: FF EB E9 33 C0 5A 59 59 64 89 10 68 5D 0E 56 00 ...3.ZYYd..h].V.
0012F000: 0121E9FC 00560E4D: 8D 45 E8 E8 27 5A EA FF C3 E9 05 3E EA FF EB F0 .E..'Z.....>....
0012F004: 00000000 00560E5D: 5F 5E 5B 8B E5 5D C2 04 00 8B C0 55 8B EC 33 C9 _^[..].....U..3.
0012F008: 00000000 00560E6D: 51 51 51 51 53 56 8B DA 8B F0 33 C0 55 68 AB 0F QQQQSV....3.Uh..
0012F00C: 00000000 00560E7D: 56 00 64 FF 30 64 89 20 8B C6 E8 D4 FC FF FF 84 V.d.0d. ........
0012F010: 004C56F8 00560E8D: DB 0F 84 F4 00 00 00 8B C6 E8 11 05 00 00 04 FE ................
0012F014: 00000000 00560E9D: 2C 02 0F 83 DB 00 00 00 8B 56 3C B8 BC 0F 56 00 ,........V<...V.
0012F018: 00000000 00560EAD: E8 BA 51 EA FF 85 C0 0F 8E C6 00 00 00 8B 46 3C ..Q...........F<
0012F01C: 00000000 00560EBD: 66 83 38 5B 0F 84 B9 00 00 00 8D 45 FC 8B 56 3C f.8[.......E..V<
0012F020: 00000000 00560ECD: E8 96 47 EA FF 8B 55 FC B8 C8 0F 56 00 E8 FD 4A ..G...U....V...J
0012F024: 0012F070 00560EDD: EA FF 85 C0 7E 29 A0 CC 0F 56 00 50 8D 45 F8 50 ....~)...V.P.E.P
0012F028: 0040789B 00560EED: B9 D8 0F 56 00 BA C8 0F 56 00 8B 45 FC E8 51 26 ...V....V..E..Q&
0012F02C: 00560E12 00560EFD: EB FF 8B 55 F8 8D 45 FC E8 4A 45 EA FF EB 10 8D ...U..E..JE.....


Reqards,

Martin

[Martin]

I did find the cause of the problem.
The publishers name is: Everyman's University Library
appearantly AllMyBooks can't deal with the ' sign in the name as soon as I changed the name to: Everymans University Library the problem was gone.

You really should change this because some publishers do have a ' sign in their name as does Everyman's University Library.

[Gemini]

Thanks again, Martin, for your bug report! Yes, the reason is an apostrophe sign. We'll fix the problem in one of the nearest updates.

Best regards,