ลง Server ใหม่เข้า hosxp แล้ว มีข้อความดังรูปครับ
ทำตามนี้ก็ไม่หายครับ
1.#mysql_upgrade -u root -p
2.#mysql_fix_privilege_tables --password=root_password
3.mysql>SET GLOBAL log_bin_trust_function_creators = 1;
EurekaLog 6.0.20
Application:
-------------------------------------------------------
1.1 Start Date : Fri, 4 Dec 2009 11:36:30 +0700
1.2 Name/Description: HOSMy.exe
1.3 Version Number : 3.52.9.26
1.4 Parameters :
1.5 Compilation Date: Sat, 26 Sep 2009 09:20:36 +0700
1.6 Up Time : 1 minute, 40 seconds
Exception:
------------------------------------------------------
2.1 Date : Fri, 4 Dec 2009 11:38:10 +0700
2.2 Address : 02320C07
2.3 Module Name : HOSMy.exe
2.4 Module Version: 3.52.9.26
2.5 Type : Exception
2.6 Message : Can not retrieve ResultSet data.
2.7 ID : D6C3
2.8 Count : 1
2.9 Status : New
2.10 Note :
User:
-------------------------------------------------------
3.1 ID : Administrator
3.2 Name : SSHPT
3.3 Email :
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 : TMainForm
4.2 Form Text : 5.1.30-log Database hos @ 192.168.1.236
4.3 Control Class: TcxButton
4.4 Control Text : ตกลง
Computer:
-------------------------------------------------------------------------------
5.1 Name : COMP11
5.2 Total Memory : 2047 Mb
5.3 Free Memory : 1056 Mb
5.4 Total Disk : 65.21 Gb
5.5 Free Disk : 41.64 Gb
5.6 System Up Time: 21 hours, 28 minutes, 44 seconds
5.7 Processor : Intel(R) Core(TM)2 Duo CPU E4500 @ 2.20GHz
5.8 Display Mode : 1024 x 768, 32 bit
5.9 Display DPI : 96
5.10 Video Card : NVIDIA GeForce 8400 GS (driver 6.14.11.8250 - RAM 512 MB)
5.11 Printer : Canon iP1900 series (driver 2.20.2.30)
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.233 - 192.168.239.001 - 192.168.150.001
7.2 Submask : 255.255.255.000 - 255.255.255.000 - 255.255.255.000
7.3 Gateway : 192.168.001.001 - 000.000.000.000 - 000.000.000.000
7.4 DNS 1 : 192.168.001.001 - 000.000.000.000 - 000.000.000.000
7.5 DNS 2 : 000.000.000.000 - 000.000.000.000 - 000.000.000.000
7.6 DHCP : OFF - OFF - OFF
Custom Information:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
8.1 Hospital Code : 10872 [รพช. เสิงสาง]
8.2 Database Type : MySQL
8.3 Database Protocol: mysql-4.1 [5.1.30-log
Database hos @ 192.168.1.236]
8.4 :
8.5 No 1 : select get_serialnumber('test') as cc
8.6 No 2 : 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.7 No 3 : drop function get_serialnumber
หัวข้อ: ลง Server ใหม่เข้า hosxp แล้ว มีข้อความดังรูปครับ (อ่าน 3645 ครั้ง)