BMS-HOSxP Community
HOSxP => แจ้งปัญหา / ขอความช่วยเหลือ => ข้อความที่เริ่มโดย: ถึงจะเท่ห์ไม่มาก...แต่ท่ายากส์มีเยอะ... ที่ กุมภาพันธ์ 12, 2012, 15:54:16 PM
-
??? ??? หลังจากการ Restore ข้อมูลที่สำรองไว้ แล้วเปิดเข้าใช้งานมันขึ้น Error ยังนี้แก้ไขงัยครับ หรือว่าตาราง tempreport มาไม่ครบ...งง.... ??? ???
-
??? ??? หลังจากการ 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  
-
??? ??? หลังจากการ Restore ข้อมูลที่สำรองไว้ แล้วเปิดเข้าใช้งานมันขึ้น Error ยังนี้แก้ไขงัยครับ หรือว่าตาราง temperport มาไม่ครบ...งง.... ??? ???
??? ??? ตรวจสอบในโฟล์เดอร์ hos แล้ว ปรากฎว่าไม่มีตารางชื่อ tempreport เลยอ่ะครับ แสดงว่า สำรองข้อมูลมาไม่สอบบูรณ์ใช่มั๊ยครับ. ??? ???
ปล. สำรองจาก Version 3.55.1.26 แต่ใช้ 3.55.2.6 restore ข้อมูล
-
ลองดูนี่ http://hosxp.net/index.php?option=com_smf&Itemid=28&topic=24746.0
-
ลอง upgrade structure ดูครับ
จะได้สร้างตารางต่างๆที่ไม่มี
แต่ว่างลองตรวจสอบการสำรองข้อมูลด้วยว่าทำไมมาไม่ครบ
;D ;D
-
ลอง upgrade structure ดูครับ
จะได้สร้างตารางต่างๆที่ไม่มี
แต่ว่างลองตรวจสอบการสำรองข้อมูลด้วยว่าทำไมมาไม่ครบ
;D ;D
??? ??? คือว่า....หลังจากที่ขึ้น Error แล้ว คลิ๊ก OK แล้วเข้า HOSxP ไม่ได้เลยครับ ค้างแกร่วเลยครับ...แก้ไขงัย แสดงว่าการสำรองข้อมูล Ver 3.55.1.26 มันไม่ได้เอาตาราง tempreport มาด้วย เป็นไปได้มั๊ยครับ.... ??? ???
-
;D ;D ;D
ใช้ EMERGENCY แล้ว Restore ใหม่ ก่อนจะ Restore ลองตรวจสอบไฟล์ Backup ดูก่อนครับว่ามีตาราง tempreport อยู่หรือเปล่า
;D ;D ;D
-
;D ;D ;D
ใช้ EMERGENCY แล้ว Restore ใหม่ ก่อนจะ Restore ลองตรวจสอบไฟล์ Backup ดูก่อนครับว่ามีตาราง tempreport อยู่หรือเปล่า
;D ;D ;D
;D ;D ขอบคุณครับ อ.jdadmin1 เดี๋ยวจะขอตรวจสอบดูก่อนครับ >:( >:(
-
;D ;D ;D
ใช้ EMERGENCY แล้ว Restore ใหม่ ก่อนจะ Restore ลองตรวจสอบไฟล์ Backup ดูก่อนครับว่ามีตาราง tempreport อยู่หรือเปล่า
;D ;D ;D
;D ;D ขอบคุณครับ อ.jdadmin1 เดี๋ยวจะขอตรวจสอบดูก่อนครับ >:( >:(
:'( :'( งานเข้าแล้วครับ....สำรองข้อมูลด้วย HOSxP 3.55.1.26 พอจะนำข้อมูลมา Restore ใช้ กดปุ่ม Check backup ตรวจสอบตารางแล้วปรากฏว่า ไม่มีตาราง tempreport แสดงว่าฐานข้อมูลมีปัญหา หรือว่าโปรแกรมสำรองข้อมูลให้ไม่ครบ.... ที่อื่นเป็นมั๊ยครับ ??? ???
ปล.ตอนกดปุ่มสำรองข้อมูลสำรองจากเครื่อง slave (ยิงเข้า IP slave ซี่งก็ innitial import จากเครื่อง master เข้าตามปกติ เพราะว่า สำรองจาก master ทีไรแล้ว โดนว่าทุกที ระบบหยุดนิ่งไปเลย ไม่สามารถทำอะไรได้ ทำเวลาประมาณช่วง ตี2 ก็ยังเป็นเหมือนเดิม)