ผม up จาก 3.50.7.22 เป็น 3.50.8.3 แล้ว up structure เกิด Error ดังนี้ครับ
EurekaLog 6.0.6
Application:
------------------------------------------------------
1.1 Start Date : Mon, 6 Aug 2007 21:07:58 +0700
1.2 Name/Description: HOSMy.exe
1.3 Version Number : 3.50.8.3
1.4 Parameters :
1.5 Compilation Date: Fri, 3 Aug 2007 17:54:16 +0700
1.6 Up Time : 1 hour, 7 minutes, 43 seconds
Exception:
-------------------------------------------------------------------
2.1 Date : Mon, 6 Aug 2007 22:15:42 +0700
2.2 Address : 0102F695
2.3 Module Name : HOSMy.exe
2.4 Module Version: 3.50.8.3
2.5 Type : Exception
2.6 Message : Install trigger fail !!! operation abort !!!.
2.7 ID : F90E
2.8 Count : 1
2.9 Status : New
2.10 Note :
User:
-------------------------------------------------------
3.1 ID : shukree
3.2 Name : shukree
3.3 Email : shukreez@hotmail.com
3.4 Company :
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
Active Controls:
-----------------------------------------------------------------------------
4.1 Form Class : XLMAIN
4.2 Form Text : Microsoft Excel - สอ. เบิกยา ปี 50 [Compatibility Mode]
4.3 Control Class: TSeSkinButton
4.4 Control Text :
Computer:
-------------------------------------------------------------------------
5.1 Name : ACER-RX
5.2 Total Memory : 1023 Mb
5.3 Free Memory : 397 Mb
5.4 Total Disk : 34.18 Gb
5.5 Free Disk : 26.11 Gb
5.6 System Up Time: 10 hours, 13 minutes, 0 second
5.7 Processor : Intel(R) Pentium(R) D CPU 3.00GHz
5.8 Display Mode : 1024 x 768, 32 bit
5.9 Display DPI : 96
5.10 Video Card : Radeon X1300 Series (driver 8.273.0.0 - RAM 512 MB)
5.11 Printer : HP LaserJet 1022 (driver 6, 0, 3508, 0)
Operating System:
------------------------------------
6.1 Type : Microsoft Windows XP
6.2 Build # : 2600
6.3 Update : Service Pack 2
6.4 Language: Thai
6.5 Charset : 222
Network:
---------------------------------
7.1 IP Address: 192.168.001.100
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 : OFF
Custom Information:
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
8.1 Hospital Code : 11441 [รพช. สุคิริน]
8.2 Database Type : MySQL
8.3 Database Protocol: mysql-4.1
8.4 :
8.5 No 1 : select * from information_schema.triggers where TRIGGER_SCHEMA = 'hos' and EVENT_OBJECT_TABLE = 'ipt'
8.6 No 2 : create trigger ipt_trigger3 before delete on ipt for each row begin insert into tmp_ipt_repl set data_type='varchar', trigger_date = current_timestamp,sync_state =0, table_name = 'ipt' ,pkname1 = 'an', pkvalue1 = OLD.an; end;
8.7 No 3 : create trigger ipt_trigger2 before update on ipt for each row begin insert into tmp_ipt_repl set data_type='varchar', trigger_date = current_timestamp,sync_state =0, table_name = 'ipt' ,pkname1 = 'an', pkvalue1 = OLD.an; end;
ไม่ทราบต้องทำอย่างไร