หลังจากการ Restore ข้อมูลที่สำรองไว้ แล้วเปิดเข้าใช้งานมันขึ้น Error ยังนี้แก้ไขงัยครับ หรือว่าตาราง temperport มาไม่ครบ...งง....
เพิ่มเติม Error ครับ
EurekaLog 6.1.04
Application:
-------------------------------------------------------
1.1 Start Date : Sun, 12 Feb 2012 15:45:05 +0700
1.2 Name/Description: HOSMy.exe - (BMS-HOSxP)
1.3 Version Number : 3.55.2.6
1.4 Parameters :
1.5 Compilation Date: Mon, 6 Feb 2012 15:35:24 +0700
1.6 Up Time : 12 seconds
Exception:
----------------------------------------------------------------------
2.1 Date : Sun, 12 Feb 2012 15:45:18 +0700
2.2 Address : 02D6F3A1
2.3 Module Name : HOSMy.exe - (BMS-HOSxP)
2.4 Module Version: 3.55.2.6
2.5 Type : Exception
2.6 Message : SQL Error: Table 'hos.tempreport' doesn't exist.
2.7 ID : 7132
2.8 Count : 1
2.9 Status : New
2.10 Note :
User:
-------------------------------------------------------
3.1 ID : Administrator
3.2 Name : iLLuSioN
3.3 Email :
3.4 Company : Microsoft Corporation
3.5 Privileges: SeChangeNotifyPrivilege - ON
SeSecurityPrivilege - OFF
SeBackupPrivilege - OFF
SeRestorePrivilege - OFF
SeSystemtimePrivilege - OFF
SeShutdownPrivilege - OFF
SeRemoteShutdownPrivilege - OFF
SeTakeOwnershipPrivilege - OFF
SeDebugPrivilege - OFF
SeSystemEnvironmentPrivilege - OFF
SeSystemProfilePrivilege - OFF
SeProfileSingleProcessPrivilege - OFF
SeIncreaseBasePriorityPrivilege - OFF
SeLoadDriverPrivilege - ON
SeCreatePagefilePrivilege - OFF
SeIncreaseQuotaPrivilege - OFF
SeUndockPrivilege - ON
SeManageVolumePrivilege - OFF
SeImpersonatePrivilege - ON
SeCreateGlobalPrivilege - ON
Computer:
-------------------------------------------------------------------------------
5.1 Name : MICROSOF-4364E7
5.2 Total Memory : 3583 Mb
5.3 Free Memory : 2917 Mb
5.4 Total Disk : 180.68 Gb
5.5 Free Disk : 95.34 Gb
5.6 System Up Time: 22 minutes, 31 seconds
5.7 Processor : Intel(R) Core(TM)2 Duo CPU E7400 @ 2.80GHz
5.8 Display Mode : 1366 x 768, 32 bit
5.9 Display DPI : 96
5.10 Video Card : NVIDIA GeForce 9400 GT (driver 6.14.11.8206 - RAM 512 MB)
5.11 Printer :
Operating System:
------------------------------------
6.1 Type : Microsoft Windows XP
6.2 Build # : 2600
6.3 Update : Service Pack 3
6.4 Language: Thai
6.5 Charset : 222
Network:
---------------------------------
7.1 IP Address: 192.168.001.003
7.2 Submask : 255.255.255.000
7.3 Gateway : 192.168.001.001
7.4 DNS 1 : 192.168.001.001
7.5 DNS 2 : 000.000.000.000
7.6 DHCP : ON
Custom Information:
--------------------------------------------------------------------------------
8.1 Hospital Code : 11449 [þÃ. ¡Ø©Ô¹ÒÃÒ³ì]
8.2 Database Type : MySQL
8.3 Database Protocol: mysql-4.1 [5.1.53-MariaDB
Database hos @ 127.0.0.1]
8.4 :
8.5 No 1 : select count(*) as cc from tempreport
8.6 No 2 : select accessright from opduser where loginname='admin'
8.7 No 3 : select count(loginname) as cc from opduser
Call Stack Information:
-------------------------------------------------------------------------------------
|Address |Module |Unit |Class |Procedure/Method |Line |
-------------------------------------------------------------------------------------
|*Exception Thread: ID=2640; Priority=0; Class=; [Main] |
|-----------------------------------------------------------------------------------|
|02D6F3A1|HOSMy.exe |KSKDMU.pas | |HOSxP_GetDataSet |3843[313] |
|02D6ED50|HOSMy.exe |KSKDMU.pas | |HOSxP_GetDataSet |3530[0] |
|020CCA3A|HOSMy.exe |StockModuleU.pas| |HOSxP_GetDataSet |1245[2] |
|020CCA08|HOSMy.exe |StockModuleU.pas| |HOSxP_GetDataSet |1243[0] |
|020CC852|HOSMy.exe |StockModuleU.pas| |GetSQLData |1201[2] |
|020CC810|HOSMy.exe |StockModuleU.pas| |GetSQLData |1199[0] |
|02E30CA6|HOSMy.exe |MainU.pas |TMainForm |LoginTimerTimer |8434[2070]|
|004C8D07|HOSMy.exe |ExtCtrls.pas |TTimer |Create | |
|00405814|HOSMy.exe |System.pas | |_CallDynaInst | |
|004C8BEB|HOSMy.exe |ExtCtrls.pas |TTimer |WndProc | |
|0043ED9C|HOSMy.exe |Classes.pas | |StdWndProc | |
|7E4196C2|USER32.dll| | |DispatchMessageA | |
|7E4196B8|USER32.dll| | |DispatchMessageA | |
|004EA00C|HOSMy.exe |Forms.pas |TApplication|ProcessMessage | |
|004E9F10|HOSMy.exe |Forms.pas |TApplication|ProcessMessage | |
|004EA046|HOSMy.exe |Forms.pas |TApplication|HandleMessage | |
|004EA03C|HOSMy.exe |Forms.pas |TApplication|HandleMessage | |
|004EA33B|HOSMy.exe |Forms.pas |TApplication|Run | |
|005BDFD6|HOSMy.exe |VCLFixPack.pas | |ApplicationRun | |
|004EA288|HOSMy.exe |Forms.pas |TApplication|Run | |
|02E9EA5E|HOSMy.exe |HOSMy.dpr | |Initialization |1959[136] |
|7C90DC9A|ntdll.dll | | |NtSetInformationThread| |
-------------------------------------------------------------------------------------
Modules Information:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Handle |Name |Description |Version |Size |Modified |Path |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|00400000|HOSMy.exe |BMS-HOSxP |3.55.2.6 |84081664|2012-02-06 15:35:00|E:\Program Files\HOSxP |
|06D70000|xpsp2res.dll |Service Pack 2 Messages |5.1.2600.5512 |2897920 |2008-04-13 23:09:26|E:\WINDOWS\system32 |
|07390000|idmmkb.dll |Internet Download Manager module |6.5.12.1 |38304 |2011-04-15 18:32:06|E:\Program Files\Internet Download Manager |
|096A0000|libmysql41.dll | | |1056768 |2004-07-12 14:36:18|E:\WINDOWS\system32 |
|10000000|INBarcodeOCR.dll|INBarcodeOCR |1.3.200.0 |455168 |2007-03-12 15:37:50|E:\Program Files\HOSxP |
|4DE10000|msado15.dll |Microsoft Data Access - ActiveX Data Objects |2.81.1132.0 |536576 |2008-04-14 05:42:00|E:\Program Files\Common Files\System\ado |
|4EC50000|gdiplus.dll |Microsoft GDI+ |5.1.3102.5512 |1724416 |2008-04-14 05:42:48|E:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.2600.5512_x-ww_dfb54e0c |
|5A730000|wbemdisp.dll |WMI Scripting |5.1.2600.5512 |178176 |2008-04-14 05:42:10|E:\WINDOWS\system32\wbem |
|5AD70000|uxtheme.dll |Microsoft UxTheme Library |6.0.2900.5512 |218624 |2008-04-14 05:42:10|E:\WINDOWS\system32 |
|5B860000|NETAPI32.dll |Net Win32 API DLL |5.1.2600.5512 |337408 |2008-04-14 05:42:02|E:\WINDOWS\system32 |
|5EDD0000|olepro32.dll | |5.1.2600.5512 |84992 |2008-04-14 05:42:04|E:\WINDOWS\system32 |
|629C0000|LPK.DLL |Language Pack |5.1.2600.5512 |22016 |2008-04-14 05:41:58|E:\WINDOWS\system32 |
|662B0000|hnetcfg.dll |Home Networking Configuration Manager |5.1.2600.5512 |344064 |2008-04-14 05:41:56|E:\WINDOWS\system32 |
|71190000|AgentMPx.dll |Microsoft Agent Custom Marshaling Proxy DLL |2.0.0.3427 |49152 |2008-04-14 05:41:50|E:\WINDOWS\msagent |
|711D0000|AgentCtl.dll |Microsoft Agent Control |2.0.0.3427 |214016 |2008-04-14 05:41:50|E:\WINDOWS\msagent |
|71A50000|mswsock.dll |Microsoft Windows Sockets 2.0 Service Provider |5.1.2600.5512 |245248 |2008-04-14 05:42:02|E:\WINDOWS\system32 |
|71A90000|wshtcpip.dll |Windows Sockets Helper DLL |5.1.2600.5512 |19456 |2008-04-14 05:42:12|E:\WINDOWS\System32 |
|71AA0000|WS2HELP.dll |Windows Socket 2.0 Helper for Windows NT |5.1.2600.5512 |19968 |2008-04-14 05:42:12|E:\WINDOWS\system32 |
|71AB0000|WS2_32.dll |Windows Socket 2.0 32-Bit DLL |5.1.2600.5512 |82432 |2008-04-14 05:42:12|E:\WINDOWS\system32 |
|71AD0000|wsock32.dll |Windows Socket 32-Bit DLL |5.1.2600.5512 |22528 |2008-04-14 05:42:12|E:\WINDOWS\system32 |
|71B20000|mpr.dll |Multiple Provider Router DLL |5.1.2600.5512 |59904 |2008-04-14 05:41:58|E:\WINDOWS\system32 |
|723D0000|winscard.dll |Microsoft Smart Card API |5.1.2600.5512 |99328 |2008-04-14 05:42:10|E:\WINDOWS\system32 |
|72D10000|msacm32.drv |Microsoft Sound Mapper |5.1.2600.0 |20480 |2005-05-24 02:51:10|E:\WINDOWS\system32 |
|72D20000|wdmaud.drv |WDM Audio driver mapper |5.1.2600.5512 |23552 |2008-04-14 05:42:46|E:\WINDOWS\system32 |
|73000000|winspool.drv |Windows Spooler Driver |5.1.2600.5512 |146432 |2008-04-14 05:42:46|E:\WINDOWS\system32 |
|73BC0000|dciman32.dll |DCI Manager |5.1.2600.5512 |8704 |2008-04-14 05:41:52|E:\WINDOWS\system32 |
|73D90000|CRTDLL.dll |Microsoft C Runtime Library |4.0.1183.1 |149019 |2005-05-24 02:51:10|E:\WINDOWS\system32 |
|746C0000|msls31.dll |Microsoft Line Services library file |3.10.349.0 |146432 |2005-05-24 02:51:10|E:\WINDOWS\system32 |
|74720000|MSCTF.dll |MSCTF Server DLL |5.1.2600.5512 |297984 |2008-04-14 05:42:00|E:\WINDOWS\system32 |
|74810000|quartz.dll | |6.5.2600.5512 |1288192 |2008-04-14 05:42:04|E:\WINDOWS\system32 |
|74C80000|oleacc.dll |Active Accessibility Core Component |4.2.5406.0 |163328 |2005-05-24 02:51:10|E:\WINDOWS\system32 |
|74D90000|USP10.dll |Uniscribe Unicode script processor |1.420.2600.5512 |406016 |2008-04-14 05:42:10|E:\WINDOWS\system32 |
|74E30000|RICHED20.DLL |Rich Text Edit Control, v3.0 |5.30.23.1230 |433664 |2008-04-14 05:42:06|E:\WINDOWS\system32 |
|74ED0000|wbemsvc.dll |WMI |5.1.2600.5512 |43520 |2008-04-14 05:42:10|E:\WINDOWS\system32\wbem |
|74EF0000|wbemprox.dll |WMI |5.1.2600.5512 |18944 |2008-04-14 05:42:10|E:\WINDOWS\system32\wbem |
|75020000|wmiutils.dll |WMI |5.1.2600.5512 |95232 |2008-04-14 05:42:10|E:\WINDOWS\system32\wbem |
|75290000|wbemcomn.dll |WMI |5.1.2600.5512 |214528 |2008-04-14 05:42:10|E:\WINDOWS\system32\wbem |
|755C0000|msctfime.ime |Microsoft Text Frame Work Service IME |5.1.2600.5512 |177152 |2008-04-14 05:40:08|E:\WINDOWS\system32 |
|75690000|fastprox.dll |WMI |5.1.2600.5512 |472064 |2008-04-14 05:41:54|E:\WINDOWS\system32\wbem |
|76080000|MSVCP60.dll |Microsoft (R) C++ Runtime Library |6.2.3104.0 |413696 |2008-04-14 05:42:02|E:\WINDOWS\system32 |
|76360000|WINSTA.dll |Winstation Library |5.1.2600.5512 |53760 |2008-04-14 05:42:10|E:\WINDOWS\system32 |
|76380000|msimg32.dll |GDIEXT Client DLL |5.1.2600.5512 |4608 |2008-04-14 05:42:00|E:\WINDOWS\system32 |
|76390000|imm32.dll |Windows XP IMM32 API Client DLL |5.1.2600.5512 |110080 |2008-04-14 05:41:56|E:\WINDOWS\system32 |
|763B0000|comdlg32.dll |Common Dialogs DLL |6.0.2900.5512 |276992 |2008-04-14 05:41:52|E:\WINDOWS\system32 |
|765B0000|MSDART.DLL |Microsoft Data Access - OLE DB Runtime Routines |2.81.1132.0 |151552 |2008-04-14 05:42:00|E:\WINDOWS\system32 |
|76780000|SHFolder.dll |Shell Folder Service |6.0.2900.5512 |25088 |2008-04-14 05:42:06|E:\WINDOWS\system32 |
|767A0000|NTDSAPI.dll |NT5DS |5.1.2600.5512 |67072 |2008-04-14 05:42:04|E:\WINDOWS\system32 |
|76B20000|ATL.DLL |ATL Module for Windows XP (Unicode) |3.5.2284.1 |58880 |2008-04-14 05:41:52|E:\WINDOWS\system32 |
|76B40000|winmm.dll |MCI API DLL |5.1.2600.5512 |176128 |2008-04-14 05:42:10|E:\WINDOWS\system32 |
|76BF0000|psapi.dll |Process Status Helper |5.1.2600.5512 |23040 |2008-04-14 05:42:04|E:\WINDOWS\system32 |
|76C30000|WINTRUST.dll |Microsoft Trust Verification APIs |5.131.2600.5512 |176640 |2008-04-14 05:42:10|E:\WINDOWS\system32 |
|76C90000|IMAGEHLP.DLL |Windows NT Image Helper |5.1.2600.5512 |144384 |2008-04-14 05:41:56|E:\WINDOWS\system32 |
|76D60000|iphlpapi.dll |IP Helper API |5.1.2600.5512 |94720 |2008-04-14 05:41:56|E:\WINDOWS\system32 |
|76F20000|DNSAPI.dll |DNS Client API DLL |5.1.2600.5512 |147968 |2008-04-14 05:41:54|E:\WINDOWS\system32 |
|76F50000|WTSAPI32.dll |Windows Terminal Server SDK APIs |5.1.2600.5512 |18432 |2008-04-14 05:42:12|E:\WINDOWS\system32 |
|76F60000|WLDAP32.dll |Win32 LDAP API DLL |5.1.2600.5512 |172032 |2008-04-14 05:42:10|E:\WINDOWS\system32 |
|76FB0000|winrnr.dll |LDAP RnR Provider DLL |5.1.2600.5512 |16896 |2008-04-14 05:42:10|E:\WINDOWS\System32 |
|76FC0000|rasadhlp.dll |Remote Access AutoDial Helper |5.1.2600.5512 |7680 |2008-04-14 05:42:04|E:\WINDOWS\system32 |
|76FD0000|CLBCATQ.DLL | |2001.12.4414.700|498688 |2008-04-14 05:41:52|E:\WINDOWS\system32 |
|77050000|COMRes.dll | |2001.12.4414.700|792064 |2008-04-14 05:41:52|E:\WINDOWS\system32 |
|77120000|oleaut32.dll | |5.1.2600.5512 |551936 |2008-04-14 05:42:04|E:\WINDOWS\system32 |
|771B0000|wininet.dll |Internet Extensions for Win32 |6.0.2900.5512 |666112 |2008-04-14 05:42:10|E:\WINDOWS\system32 |
|773D0000|comctl32.dll |User Experience Controls Library |6.0.2900.5512 |1054208 |2008-04-14 05:42:52|E:\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 |2008-04-14 05:42:04|E:\WINDOWS\system32 |
|77920000|SETUPAPI.dll |Windows Setup API |5.1.2600.5512 |985088 |2008-04-14 05:42:06|E:\WINDOWS\system32 |
|77A80000|CRYPT32.dll |Crypto API32 |5.131.2600.5512 |599040 |2008-04-14 05:41:52|E:\WINDOWS\system32 |
|77B20000|MSASN1.dll |ASN.1 Runtime APIs |5.1.2600.5512 |57344 |2008-04-14 05:42:00|E:\WINDOWS\system32 |
|77BD0000|midimap.dll |Microsoft MIDI Mapper |5.1.2600.5512 |18944 |2008-04-14 05:41:58|E:\WINDOWS\system32 |
|77BE0000|MSACM32.dll |Microsoft ACM Audio Filter |5.1.2600.5512 |71680 |2008-04-14 05:42:00|E:\WINDOWS\system32 |
|77C00000|version.dll |Version Checking and File Installation Libraries |5.1.2600.5512 |18944 |2008-04-14 05:42:10|E:\WINDOWS\system32 |
|77C10000|msvcrt.dll |Windows NT CRT DLL |7.0.2600.5512 |343040 |2008-04-14 05:42:02|E:\WINDOWS\system32 |
|77DD0000|ADVAPI32.dll |Advanced Windows 32 Base API |5.1.2600.5512 |617472 |2008-04-14 05:41:50|E:\WINDOWS\system32 |
|77E70000|RPCRT4.dll |Remote Procedure Call Runtime |5.1.2600.5512 |584704 |2008-04-14 05:42:06|E:\WINDOWS\system32 |
|77F10000|GDI32.dll |GDI Client DLL |5.1.2600.5512 |285184 |2008-04-14 05:41:56|E:\WINDOWS\system32 |
|77F60000|SHLWAPI.dll |Shell Light-weight Utility Library |6.0.2900.5512 |474112 |2008-04-14 05:42:06|E:\WINDOWS\system32 |
|77FE0000|Secur32.dll |Security Support Provider Interface |5.1.2600.5512 |56320 |2008-04-14 05:42:06|E:\WINDOWS\system32 |
|7C800000|kernel32.dll |Windows NT BASE API Client DLL |5.1.2600.5512 |989696 |2008-04-14 05:41:58|E:\WINDOWS\system32 |
|7C900000|ntdll.dll |NT Layer DLL |5.1.2600.5512 |706048 |2008-04-14 05:41:26|E:\WINDOWS\system32 |
|7C9C0000|shell32.dll |Windows Shell Common Dll |6.0.2900.5512 |8461312 |2008-04-14 05:42:06|E:\WINDOWS\system32 |
|7DF70000|oledlg.dll |Microsoft Windows(TM) OLE 2.0 User Interface Support|5.1.2600.5512 |122880 |2008-04-14 05:42:04|E:\WINDOWS\system32 |
|7E1E0000|URLMON.DLL |OLE32 Extensions for Win32 |6.0.2900.5512 |619520 |2008-04-14 05:42:10|E:\WINDOWS\system32 |
|7E410000|USER32.dll |Windows XP USER API Client DLL |5.1.2600.5512 |578560 |2008-04-14 05:42:10|E:\WINDOWS\system32 |
|7E4B0000|HHCTRL.OCX |Microsoft? HTML Help Control |5.2.3790.4110 |545280 |2008-04-14 05:39:38|E:\WINDOWS\system32 |
|7E720000|SXS.DLL |Fusion 2.5 |5.1.2600.5512 |713216 |2008-04-14 05:42:08|E:\WINDOWS\system32 |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Processes Information:
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|ID |Name |Description |Version |Memory |Priority|Threads|Path |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|4 |System | | |217088 |Normal |87 | |
|432 |avp.exe |Kaspersky Anti-Virus |11.0.2.571 |17027072|Normal |91 |E:\Program Files\Kaspersky Lab\Kaspersky Internet Security 2011|
|516 |wuauclt.exe |Automatic Updates |5.4.3790.5512|5619712 |Normal |3 |E:\WINDOWS\system32 |
|536 |Explorer.EXE |Windows Explorer |6.0.2900.5512|24952832|Normal |18 |E:\WINDOWS |
|672 |PDVDServ.exe |PowerDVD RC Service |6.0.0.1027 |3452928 |Normal |2 |E:\Program Files\CyberLink\PowerDVD |
|692 |taskswitch.exe | | |2097152 |Normal |1 |E:\WINDOWS\system32 |
|720 |mysqld.exe | | |86515712|Normal |30 |E:\Program Files\HOSxP_PCU\MySQL\bin |
|744 |DevDetect.exe |Device Detector |3.0.9.0 |4308992 |Normal |3 |E:\Program Files\Common Files\ACD Systems\EN |
|776 |RUNDLL32.EXE |Run a DLL as an App |5.1.2600.5512|4083712 |Normal |1 |E:\WINDOWS\system32 |
|784 |RTHDCPL.EXE |Realtek HD Audio Control Panel |2.1.3.0 |22728704|Normal |4 |E:\WINDOWS |
|856 |avp.exe |Kaspersky Anti-Virus |11.0.2.571 |5992448 |Normal |19 |E:\Program Files\Kaspersky Lab\Kaspersky Internet Security 2011|
|864 |cpe17antiautorun1590.exe |CPE17 Autorun Killer (AntiAutorun) |1.8.6.1590 |2846720 |Normal |1 |E:\¢éÍÁÙÅ E_E\â»Ãá¡ÃÁ |
|872 |DefenderDaemon.exe |Shadow Defender Daemon Application |1.1.0.315 |3006464 |Normal |3 |E:\Program Files\Shadow Defender |
|884 |ctfmon.exe |CTF Loader |5.1.2600.5512|3514368 |Normal |1 |E:\WINDOWS\system32 |
|892 |MsnMsgr.Exe |MSN Messenger |7.0.813.0 |2797568 |Normal |2 |E:\Program Files\MSN Messenger |
|904 |TBPanel.exe |EXPERTool : Display Control Panel |7.2.0.1 |5918720 |Normal |1