ผมอัพเกรด จาก 3.50.11.30 มาเป็น 3.50.3.14 แล้วเกิด Error อย่างนี้ครับ ยังไม่ได้อัพเกรดจริงนะครับ ทดสอบในเครื่องทดลองน่ะ เตรียมจะอัพเกรดแล้วละครับ
EurekaLog 6.0.13
Application:
-------------------------------------------------------
1.1 Start Date : Thu, 5 Jun 2008 13:25:32 +0700
1.2 Name/Description: HOSMy.exe
1.3 Version Number : 3.51.5.14
1.4 Parameters :
1.5 Compilation Date: Wed, 14 May 2008 18:26:16 +0700
1.6 Up Time : 34 seconds
Exception:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2.1 Date : Thu, 5 Jun 2008 13:26:07 +0700
2.2 Address : 01ECBACB
2.3 Module Name : HOSMy.exe
2.4 Module Version: 3.51.5.14
2.5 Type : Exception
2.6 Message : SQL Error: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable).
2.7 ID : 4AAA
2.8 Count : 1
2.9 Status : New
2.10 Note :
User:
-------------------------------------------------------
3.1 ID : Black
3.2 Name : Black
3.3 Email :
3.4 Company : WBH
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 : TMainForm
4.2 Form Text : :: HOSxP ::
4.3 Control Class: TcxButton
4.4 Control Text : ตกลง
Computer:
-----------------------------------------------------------------------------
5.1 Name : INSUR3
5.2 Total Memory : 959 Mb
5.3 Free Memory : 248 Mb
5.4 Total Disk : 24.41 Gb
5.5 Free Disk : 0.84 Gb
5.6 System Up Time: 22 hours, 9 minutes, 57 seconds
5.7 Processor : Genuine Intel(R) CPU 2160 @ 1.80GHz
5.8 Display Mode : 1024 x 768, 32 bit
5.9 Display DPI : 96
5.10 Video Card : SiS Mirage 3 Graphics (driver 6.14.10.3800 - RAM 64 MB)
5.11 Printer : Samsung SCX-4100 Series (driver 0,5,0,2)
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.187.023
7.2 Submask : 255.255.255.000
7.3 Gateway : 192.168.187.254
7.4 DNS 1 : 192.168.187.254
7.5 DNS 2 : 000.000.000.000
7.6 DHCP : ON
Custom Information:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
8.1 Hospital Code : 11255
8.2 Database Type : MySQL
8.3 Database Protocol: mysql-4.1 [5.1.24-rc-log
Database hos @ 192.168.187.2]
8.4 :
8.5 No 1 : create function get_serialnumber(param1 varchar(150)) returns int begin declare serial_exist int; declare xserial_no int; if param1='' then select 'test' into param1; end if; select count(serial_no) into serial_exist from serial where name = param1; if serial_exist = 0 then insert into serial (name,serial_no) values (param1,0); end if; update serial set serial_no = serial_no + 1 where name = param1; select serial_no into xserial_no from serial where name = param1; return xserial_no; end;
8.6 No 2 : drop function get_serialnumber
8.7 No 3 : select get_serialnumber('test')
หัวข้อ: อัพเกรดแล้ว Error (อ่าน 3767 ครั้ง)