572
« เมื่อ: พฤศจิกายน 19, 2009, 09:37:44 AM »
EurekaLog 6.0.20
Application:
-------------------------------------------------------
1.1 Start Date : Thu, 19 Nov 2009 09:09:14 +0700
1.2 Name/Description: HOSMy.exe
1.3 Version Number : 3.52.10.14
1.4 Parameters :
1.5 Compilation Date: Thu, 15 Oct 2009 09:27:45 +0700
1.6 Up Time : 41 minutes, 4 seconds
Exception:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2.1 Date : Thu, 19 Nov 2009 09:50:19 +0700
2.2 Address : 022CF21F
2.3 Module Name : HOSMy.exe
2.4 Module Version: 3.52.10.14
2.5 Type : Exception
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 '944,27945,27946,27949,27972,28003,28007,28013,28014,28015,28016,28021,28022,2802' at line 15.
2.7 ID : 0C8A
2.8 Count : 1
2.9 Status : New
2.10 Note :
User:
-------------------------------------------------------
3.1 ID : Insurance4
3.2 Name : MoZarD
3.3 Email :
3.4 Company : LiteOS
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 : Account1MainForm - :: HOSxP :: 3.52.10.14 MySQL 5.0.45-community [sa@192.168.1.252/hos]
4.3 Control Class: TcxButton
4.4 Control Text : พิมพ์รายชื่อ
Computer:
--------------------------------------------------------------------------------
5.1 Name : งานประกัน4
5.2 Total Memory : 3071 Mb
5.3 Free Memory : 2401 Mb
5.4 Total Disk : 195.32 Gb
5.5 Free Disk : 159.62 Gb
5.6 System Up Time: 1 hour, 2 minutes, 40 seconds
5.7 Processor : Pentium(R) Dual-Core CPU E5200 @ 2.50GHz
5.8 Display Mode : 1024 x 768, 32 bit
5.9 Display DPI : 96
5.10 Video Card : NVIDIA GeForce 9600 GT (driver 6.14.11.8206 - RAM 1024 MB)
5.11 Printer : PDFCreator (driver 5.1.2600.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.002.214 - 169.254.023.154 - 192.168.001.004 - 192.168.002.043
7.2 Submask : 255.255.255.000 - 255.255.000.000 - 255.255.255.000 - 255.255.255.000
7.3 Gateway : 192.168.002.001 - 000.000.000.000 - 000.000.000.000 - 192.168.002.001
7.4 DNS 1 : 192.168.002.001 - 000.000.000.000 - 000.000.000.000 - 192.168.002.001
7.5 DNS 2 : 000.000.000.000 - 000.000.000.000 - 000.000.000.000 - 000.000.000.000
7.6 DHCP : OFF - ON - OFF - ON
Custom Information:
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
8.1 Hospital Code : 11082 [รพช. ห้วยเม็ก]
8.2 Database Type : MySQL
8.3 Database Protocol : mysql-4.1 [5.0.45-community
Database hos @ 192.168.1.252]
8.4 :
8.5 No 1 : select h.village_id,h.address,p.* ,pc.name as pttype_name,x.name as sex_name ,n.name as nationality_name, concat(p2.fname,' ',p2.lname) as father_name , concat(p3.fname,' ',p3.lname) as mother_name , concat(p4.fname,' ',p4.lname) as couple_name , e.name as education_name ,o.name as occupation_name,r.name as religion_name , y.name as marrystatus_name ,t.house_regist_type_name , f.family_no , pp.person_house_position_name from person p
left outer join house h on h.house_id = p.house_id
left outer join pttype pc on pc.pttype = p.pttype
left outer join sex x on x.code = p.sex left outer join nationality n on n.nationality = p.nationality
left outer join education e on e.education = p.education left outer join occupation o on o.occupation = p.occupation
left outer join religion r on r.religion = p.religion left outer join marrystatus y on y.code = p.marrystatus
left outer join person p2 on p2.person_id = p.father_person_id
left outer join person p3 on p3.person_id = p.mother_person_id
left outer join person p4 on p4.person_id = p.couple_person_id
left outer join person_house_position pp on pp.person_house_position_id = p.person_house_position_id
left outer join family f on f.family_id = p.family_id
left outer join house_regist_type t on t.house_regist_type_id = p.house_regist_type_id
where
p.person_id in (462,3649,27437,27450,27452,27454,27455,27457,27459,27461,27467,27478,27498,27571,27578,27579,27580,27582,27583,27584,27585,27586,27587,27590,27591,27592,27593,27594,27597,27598,27600,27602,27603,27604,27609,27610,27611,27612,27613,27614,27615,27616,27617,27626,27628,27629,27631,27633,27634,27635,27636,27637,27638,27639,27642,27643,27644,27645,27648,27649,27650,27651,27653,27654,27655,27656,27657,27659,27666,27668,27669,27670,27672,27673,27675,27678,27679,27680,27681,27682,27684,27685,27686,27687,27688,27689,27690,27691,27692,27693,27694,27695,27696,27698,27699,27703,27704,27705,27706,27707,27709,27711,27712,27714,27716,27718,27719,27720,27721,27722,27724,27726,27727,27728,27733,27734,27735,27736,27737,27738,27741,27743,27744,27745,27746,27747,27750,27751,27752,27753,27755,27756,27757,27760,27761,27763,27764,27765,27767,27768,27772,27773,27776,27777,27779,27780,27781,27783,27784,27785,27786,27787,27788,27789,27790,27793,27794,27797,27798,27806,27824,27832,27835,27838,27839,27872,27902,27943,27
944,27945,27946,27949,27972,28003,28007,28013,28014,28015,28016,28021,28022,28023,28024,28037,28040,28042,28049,28050,28051,28052,28053,28058,28059,28064,28066,28067,28068,28071,28072,28073,28074,28075,28076,28079,28080,28081,28082,28083,28088,28089,28091,28092,28093,28094,28104,28107,28114,28115,28123,28125,28126,28135,28136,28142,28147,28160,28181,28182,28183,28184,28185,28186,28187,28193,28195,28198,28199,28200,28203,28204,28205,28206,28207,28208,28216,28221,28226,28234,28235,28238,28239,28240,28241,28251,28259,28260,28271,28287,28298,28299,28302,28304,28309,28317,28318,28319,28320,28321,28328,28330,28331,28334,28336,28337,28338,28339,28341,28343,28350,28351,28352,28353,28355,28359,28360,28362,28365,28370,28372,28373,28387,28388,28389,28391,28393,28397,28400,28404,28405,28406,28407,28408,28409,28410,28411,28413,28414,28415,28417,28418,28425,28426,28427,28428,28429,28430,28431,28432,28433,28434,28435,28436,28437,28440,28445,28447,28448,28449,28450,28451,28452,28453,28454,28455,28457,28458,28459,28460,28461,
28462,28463,28464,28465,28466,28467,28468,28469,28470,28471,28472,28476,28477,28478,28479,28485,28486,28487,28488,28489,28490,28491,28493,28495,28496,28497,28498,28500,28501,28502,28505,28506,28507,28512,28514,28515,28516,28517,28518,28519,28520,28521,28522,28523,28524,28525,28526,28527,28530,28533,28534,28535,28536,28537,28539,28540,28541,28542,28543,28544,28546,28547,28549,28552,28553,28554,28560,28561,28566,28568,28569,28570,28571,28572,28575,28578,28579,28580,28581,28582,28583,28585,28586,28587,28588,28589,28590,28591,28592,28593,28595,28596,28597,28598,28600,28601,28602,28603,28604,28605,28607,28608,28609,28610,28611,28612,28613,28614,28615,28616,28618,28619,28620,28625,28626,28627,28628,28632,28633,28634,28636,28637,28638,28639,28641,28642,28643,28644,28646,28648,28649,28650,28661,28668,28669,28670,28671,28677,28678,28699,28700,28701,28702,28708,28709,28710,28711,28712,28713,28714,28715,28724,28728,28729,28730,28732,28733,28734,28735,28736,28737,28744,28745,28746,28747,28748,28749,28751,28752,28757,2875
8,28759,28760,28767,28768,28769,28770,28771,28772,28774,28775,28783,28785,28786,28788,28789,28790,28808,28809,28810,28811,28812,28813,28830,28833,28835,28836,28837,28838,28839,28840,28843,28845,28846,28857,28858,28859,28860,28861,28862,28863,28864,28865,28866,28867,28870,28871,28872,28875,28876,28877,28880,28881,28882,28883,28884,28921,28922,28924,28932,28933,28935,28936,28937,28938,28940,28949,28952,28956,28962,28976,29012,29029,29032,29034,29037,29043,29313,29315,29338,29349,29350,29353,29354,29355,29356,29357,29361,29363,29383,29384,29386,29387,29403,29412,29426,29427,29431,29432,29433,29434,29435,29436,29437,29438,29439,29440,29443,29457,29461,29478,29479,29496,29517,29518,29519,29520,29523,29746,30077,30082,30083,30084,30136,30137,30144,30145,30146,30274,30275,30276,30279,30280,30281,30282,30288,30308,30309,30313,30314,30315,30316,30317,30318,30319,30320,30321,30322,30323,30324,30325,30364,30365,30386,30389,30413,30414,30416,30417,30420,30421,30431,30432,30434,30435,30436,30450,30451,30452,30453,30454,30
456,30461,30464,30465,30466,30480,30484,30486,30487,30488,30489,30498,30499,30500,30504,30505,30508,30509,30520,30529,30530,30531,30535,30545,30547,30549,30550,30551,30552,30553,30554,30555,30562,30564,30585,30588,30594,30595,30596,30597,30598,30611,30634,30635,30641,30642,30648,30649,30650,30651,30652,30653,30654,30655,30660,30661,30671,30673,30674,30675,30676,30679,30683,30684,30686,30696,30699,30703,30714,30771,30772,30773,30774,30775,30782,30783,30784,30785,30786,30790,30797,30798,30799,30800,30801,30802,30803,30804,30815,30817,30818,30819,30820,30821,30824,30825,30826,30827,30830,30835,30839,30862,30868,30871,30873,30874,30875,30877,30878,30879,30890,30892,30893,30894,30895,30896,30897,30898,30901,30902,30903,30909,30910,30913,30914,30919,30920,30921,30922,30927,30928,30929,30930,30953,30954,30955,30956,30957,30958,30959,30962,30963,30965,30966,30968,30969,30970,30971,30972,30973,30974,30978,30979,30980,30981,30982,30983,30984,30985,30986,30987,30988,30989,30990,30991,30992,30993,30994,30995,30996,30997,
30998,30999,31000,31001,31002,31003,31004,31005,31006,31007,31008,31009,31010,31011,31012,31013,31014,31015,31016,31022,31023,31027,31030,31031,31035,31036,31037,31041,31046,31047,31049,31050,31051,31052,31053,31056,31057,31058,31060,31061,31063,31064,31065,31066,31067,31069,31070,31072,31073,31074,31075,31076,31077,31078,31079,31080,31081,31082,31083,31084,31085,31086,31087,31088,31089,31090,31091,31092,31093,31094,31095,31096,31097,31098,31099,31100,31101,31102,31103,31104,31105,31106,31107,31108,31109,31110,31111,31112,31113,31114,31115,31116,31117,31118,31119,31120,31121,31122,31123,31124,31125,31126,31127,31128,31129,31130,31131,31132,31133,31134,31135,31136,31137,31138,31139,31140,31141,31142,31143,31144,31145,31146,31147,31148,31149,31150,31151,31152,31153,31154,31155,31156,31157,31158,31159,31160,31165,31171,31172,31192,31193,31194,31195,31196,31197,31198,31199,31200,31201,31202,31203,31221,31222,31223,31256,31267,31272,31335,31336,31337,31343,31349,31359,31360,31361,31366,31367,31368,31374,31375,3137
6,31377,31385,31386,31387,31388,31389,31390,31391,31392,31399,31400,31401,31402,31403,31404,31405,31409,31410,31411,31412,31413,31414,31418,31420,31421,31422,31423,31429,31430,31431,31432,31433,31434,31436,31444,31445,31446,31447,31457,31458,31460,31461,31462,31463,31465,31466,31467,31468,31469,31470,31478,31480,31481,31482,31485,31486,31487,31488,31489,31490,31491,31495,31496,31497,31498,31509,31510,31511,31512,31513,31514,31515,31518,31519,31520,31521,31522,31528,31533,31534,31553,31554,31555,31558,31559,31560,31561,31562,31563,31564,31565,31566,31567,31577,31578,31579,31580,31581,31585,31586,31587,31588,31589,31590,31591,31592,31593,31596,31597,31598,31599,31600,31602,31604,31605,31606,31607,31608,31609,31610,31615,31616,31617,31618,31626,31627,31628,31636,31637,31638,31647,31652,31653,31654,31655,31656,31657,31658,31659,31660,31673,31674,31675,31676,31681,31682,31683,31687,31697,31698,31699,31700,31701,31702,31703,31710,31711,31712,31716,31717,31718,31719,31724,31725,31726,31727,31728,31729,31743,31744,31
745,31746,31747,31749,31751,31752,31759,31760,31761,31762,31772,31773,31774,31775,31776,31779,31780,31787,31788,31789,31790,31791,31796,31797,31798,31799,31802,31805,31806,31807,31808,31813,31814,31820,31821,31829,31834,31835,31836,31838,31839,31840,31849,31850,31851,31852,31864,31865,31866,31868,31869,31870,31871,31872,31873,31874,31875,31881,31882,31883,31884,31885,31886,31887,31890,31894,31895,31896,31898,31901,31903,31904,31905,31909,31910,31911,31936,31951,31972,31979,31990,31999,32064,32076,32077,32080,32081,32107,32132,32133,32135,32153,32154,32181,32213,32215,32218,32220,32222,32249,32250,32259,32262,32264,32266,32277,32279,32288,32289,32290,32305,32313,32319,32333,32340,32342,32343,32349,32371,32375,32383,32394,32430,32436,32440,32445,32469,32493,32503,32506,32510,32512,32534,32538,32561,32572,32589,32590,32594,32595,32604,32632,32659) and p.age_y between 0 and 20
and p.death = 'N'
order by p.person_id
8.6 No 2 : select script_dfm from reporttemplate where name = 'PCU-Person-Search-1'
8.7 No 3 : select * from reporttemplate where name='PCU-Person-Search-1'
8.8 DBMS Variables :
8.9 :
8.10 auto_increment_increment: 1
auto_increment_offset = 1
automatic_sp_privileges = ON
back_log = 50
basedir = /
binlog_cache_size = 32768
bulk_insert_buffer_size = 8388608
character_set_client = tis620
character_set_connection = tis620
character_set_database = tis620
character_set_filesystem = binary
character_set_results = tis620
character_set_server = tis620
character_set_system = utf8
character_sets_dir = /usr/share/mysql/charsets/
collation_connection = tis620_thai_ci
collation_database = tis620_thai_ci
collation_server = tis620_thai_ci
completion_type = 0
concurrent_insert = 1
connect_timeout = 5
datadir = /var/lib/mysql/
date_format = %Y-%m-%d
datetime_format = %Y-%m-%d %H:%i:%s
default_week_format = 0
delay_key_write = ON
delayed_insert_limit = 100
delayed_insert_timeout = 300
delayed_queue_size = 1000
div_precision_increment = 4
engine_condition_pushdown = OFF
expire_logs_days = 0
flush = OFF
flush_time = 0
ft_boolean_syntax = + -><()~*:""&|
ft_max_word_len = 84
ft_min_word_len = 4
ft_query_expansion_limit = 20
ft_stopword_file = (built-in)
group_concat_max_len = 1024
have_archive = YES
have_bdb = NO
have_blackhole_engine = YES
have_compress = YES
have_crypt = YES
have_csv = YES
have_dynamic_loading = YES
have_example_engine = YES
have_federated_engine = YES
have_geometry = YES
have_innodb = YES
have_isam = NO
have_merge_engine = YES
have_ndbcluster = DISABLED
have_openssl = NO
have_ssl = NO
have_query_cache = YES
have_raid = NO
have_rtree_keys = YES
have_symlink = YES
hostname = huaimek.hosxp
init_connect = SET NAMES tis620
init_file =
init_slave =
innodb_additional_mem_pool_size = 209715200
innodb_autoextend_increment = 8
innodb_buffer_pool_awe_mem_mb = 0
innodb_buffer_pool_size = 897581056
innodb_checksums = ON
innodb_commit_concurrency = 0
innodb_concurrency_tickets = 500
innodb_data_file_path = ibdata1:10M:autoextend
innodb_data_home_dir = /var/lib/mysql/
innodb_doublewrite = ON
innodb_fast_shutdown = 1
innodb_file_io_threads = 4
innodb_file_per_table = ON
innodb_flush_log_at_trx_commit = 1
innodb_flush_method =
innodb_force_recovery = 0
innodb_lock_wait_timeout = 50
innodb_locks_unsafe_for_binlog = OFF
innodb_log_arch_dir = /var/lib/mysql/
innodb_log_archive = OFF
innodb_log_buffer_size = 8388608
innodb_log_file_size = 67108864
innodb_log_files_in_group = 2
innodb_log_group_home_dir = /var/lib/mysql/
innodb_max_dirty_pages_pct = 90
innodb_max_purge_lag = 0
innodb_mirrored_log_groups = 1
innodb_open_files = 300
innodb_rollback_on_timeout = OFF
innodb_support_xa = ON
innodb_sync_spin_loops = 20
innodb_table_locks = ON
innodb_thread_concurrency = 8
innodb_thread_sleep_delay = 10000
interactive_timeout = 28800
join_buffer_size = 131072
key_buffer_size = 858783744
key_cache_age_threshold = 300
key_cache_block_size = 1024
key_cache_division_limit = 100
language = /usr/share/mysql/english/
large_files_support = ON
large_page_size = 0
large_pages = OFF
lc_time_names = en_US
license = GPL
local_infile = ON
locked_in_memory = OFF
log = OFF
log_bin = OFF
log_bin_trust_function_creators = OFF
log_error =
log_queries_not_using_indexes = OFF
log_slave_updates = OFF
log_slow_queries = OFF
log_warnings = 1
long_query_time = 10
low_priority_updates = OFF
lower_case_file_system = OFF
lower_case_table_names = 0
max_allowed_packet = 16776192
max_binlog_cache_size = 4294967295
max_binlog_size = 1073741824
max_connect_errors = 10
max_connections = 1000
max_delayed_threads = 20
max_error_count = 64
max_heap_table_size = 16777216
max_insert_delayed_threads = 20
max_join_size = 18446744073709551615
max_length_for_sort_data = 1024
max_prepared_stmt_count = 16382
max_relay_log_size = 0
max_seeks_for_key = 4294967295
max_sort_length = 1024
max_sp_recursion_depth = 0
max_tmp_tables = 32
max_user_connections = 0
max_write_lock_count = 4294967295
multi_range_count = 256
myisam_data_pointer_size = 6
myisam_max_sort_file_size = 2147483647
myisam_recover_options = OFF
myisam_repair_threads = 1
myisam_sort_buffer_size = 213909504
myisam_stats_method = nulls_unequal
ndb_autoincrement_prefetch_sz = 32
ndb_force_send = ON
ndb_use_exact_count = ON
ndb_use_transactions = ON
ndb_cache_check_time = 0
ndb_connectstring =
net_buffer_length = 16384
net_read_timeout = 30
net_retry_count = 10
net_write_timeout = 60
new = OFF
old_passwords = OFF
open_files_limit = 5000
optimizer_prune_level = 1
optimizer_search_depth = 62
pid_file = /var/lib/mysql/huaimek.hosxp.pid
port = 3306
preload_buffer_size = 32768
profiling = OFF
profiling_history_size = 15
protocol_version = 10
query_alloc_block_size = 8192
query_cache_limit = 1048576
query_cache_min_res_unit = 4096
query_cache_size = 213909504
query_cache_type = ON
query_cache_wlock_invalidate = OFF
query_prealloc_size = 8192
range_alloc_block_size = 2048
read_buffer_size = 16773120
read_only = OFF
read_rnd_buffer_size = 12578816
relay_log_purge = ON
relay_log_space_limit = 0
rpl_recovery_rank = 0
secure_auth = OFF
secure_file_priv =
server_id = 1
skip_external_locking = ON
skip_networking = OFF
skip_show_database = OFF
slave_compressed_protocol = OFF
slave_load_tmpdir = /tmp/
slave_net_timeout = 3600
slave_skip_errors = OFF
slave_transaction_retries = 10
slow_launch_time = 2
socket = /var/lib/mysql/mysql.sock
sort_buffer_size = 16777208
sql_big_selects = ON
sql_mode =
sql_notes = ON
sql_warnings = OFF
ssl_ca =
ssl_capath =
ssl_cert =
ssl_cipher =
ssl_key =
storage_engine = MyISAM
sync_binlog = 0
sync_frm = ON
system_time_zone = ICT
table_cache = 556
table_lock_wait_timeout = 50
table_type = MyISAM
thread_cache_size = 8
thread_stack = 196608
time_format = %H:%i:%s
time_zone = SYSTEM
timed_mutexes = OFF
tmp_table_size = 33554432
tmpdir = /tmp/
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
tx_isolation = REPEATABLE-READ
updatable_views_with_limit = YES
version = 5.0.45-community
version_comment = MySQL Community Edition (GPL)
version_compile_machine = i686
version_compile_os = pc-linux-gnu
wait_timeout = 28800
แสดงกระทู้
