Error message

Description: Feel free to ask here any questions about All My Books software. Any suggestions are welcome
Moderators: Viki, Gus, Gemini, admins

Martin
Martin
Reputation: 1
With us: 12 years 1 month

Post #1by Martin » Tue Apr 14, 2009 6:02 pm

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
Martin
Reputation: 1
With us: 12 years 1 month

Post #2by Martin » Tue Apr 14, 2009 6:12 pm

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
Gemini
Reputation: 0
With us: 11 years 3 months

Post #3by Gemini » Tue Apr 14, 2009 6:27 pm

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,
Bolide Software Support Team


Return to “All My Books”

Who is online (over the past 5 minutes)

Users browsing this forum: 1 guest