2
« เมื่อ: ตุลาคม 05, 2007, 15:06:17 PM »
ระบบการเงินคนไข้ในเกิด Error ช่วยด้วยครับ
รพ.บางปะกอก 2
HOSxP Version 3.50.7.20
SQL:5.0.27 Standart
Server:Cent OS
เพิ่งเป็นเมื่อเช้าครับ 1 Case Case อื่นไม่เป็นครับ
พอกดปุ่ม ออกใบเสร็จรับเงิน [F4] ก้อขึ้น Error ดังภาพ
แล้วตัว Refresh Data ก้อวิ่งไม่ยอมหยุด
ไม่ทราบว่าต้องแก้ตรงไหน ช่วยด้วยครับ
EurekaLog 6.0.6
Application:
-------------------------------------------------------
1.1 Start Date : Fri, 5 Oct 2007 11:27:19 +0700
1.2 Name/Description: HOSMy.exe
1.3 Version Number : 3.50.7.20
1.4 Parameters :
1.5 Compilation Date: Fri, 20 Jul 2007 15:14:51 +0700
1.6 Up Time : 22 minutes, 44 seconds
Exception:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2.1 Date : Fri, 5 Oct 2007 11:50:04 +0700
2.2 Address : 0080E5F1
2.3 Module Name : HOSMy.exe
2.4 Module Version: 3.50.7.20
2.5 Type : EZSQLException
2.6 Message : SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and department='IPD' and discount>0' at line 1.
2.7 ID : 2A1C
2.8 Count : 1
2.9 Status : New
2.10 Note :
User:
-------------------------------------------------------
3.1 ID : DemoMS
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
Active Controls:
--------------------------------------
4.1 Form Class : TJSTaskDialogForm
4.2 Form Text : Information
4.3 Control Class: TJSTaskDialogForm
4.4 Control Text : Information
Computer:
--------------------------------------------------------------------------------
5.1 Name : MICROSOF-360F79
5.2 Total Memory : 446 Mb
5.3 Free Memory : 189 Mb
5.4 Total Disk : 37.28 Gb
5.5 Free Disk : 31.45 Gb
5.6 System Up Time: 26 minutes, 5 seconds
5.7 Processor : Intel(R) Pentium(R) 4 CPU 3.00GHz
5.8 Display Mode : 1024 x 768, 32 bit
5.9 Display DPI : 96
5.10 Video Card : VIA/S3G UniChrome Pro IGP (driver 6.14.10.283 - RAM 64 MB)
5.11 Printer : HP LaserJet 1020 (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: 005.084.011.234 - 192.168.002.005
7.2 Submask : 255.000.000.000 - 255.255.255.000
7.3 Gateway : 000.000.000.000 - 000.000.000.000
7.4 DNS 1 : 000.000.000.000 - 000.000.000.000
7.5 DNS 2 : 000.000.000.000 - 000.000.000.000
7.6 DHCP : ON - OFF
Custom Information:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
8.1 Hospital Code : 11734 [โรงพยาบาล บางปะกอก 2]
8.2 Database Type : MySQL
8.3 Database Protocol: mysql-4.1
8.4 :
8.5 No 1 : select * from company_contact_discount where company_id = and department='IPD' and discount>0
8.6 No 2 : select use_contract_id from pttype where pttype = '45'
8.7 No 3 : select sum(sum_price) as cc from opitemrece where an = '500000627' and income = '51' and paidst ='02' and pttype='45' and (finance_number is null or finance_number = '')