functional คีย์ไม่ได้ต้องทำไงรบกวนด้วยครับ 3.57.2.25f

วันที่ admit กับวันที่ dch เป็นวันเดียวกัน

ครัยก็ได้ช่วยทีครับ upgrade แล้ว error

รบกวนทุกท่านด้วยครับ
พอดีผม upgrade จาก 3.54.8.19-->3.54.10.27  เสร็จประมาณ 6 ทุ่ม ตอนเช้าเขาแจ้งว่าใช้ไม่ได้
พอไหดูมันแจ้งตาราง person หาย up 3 เครื่อง เป็นเครื่องเดียว
ไม่ทราบว่าจะต้องแก้ไขยังงัยครับ
ผมว่าจะ restore เฉพาะ person
ขอความคิดเห็นหน่อยครับ
ขอบคุณครับ


restore person แล้ว อัพไม่ผ่าน
Safe alter table start for table person command add index ix_father_cid  (father_cid)
Install Trigger on person
Clone table person -> tmp_person
SQL Error: Can't create table 'hos.tmp_person' (errno: -1)
SQL Error: Table 'hos.tmp_person' doesn't exist
SQL Error: Table 'hos.tmp_person' doesn't exist
Execute command  add index ix_father_cid  (father_cid)
SQL Error: Table 'hos.tmp_person' doesn't exist
Enabling keys
SQL Error: Table 'hos.tmp_person' doesn't exist
Synchronize table  person
Synchronize row data done.

ส่งออก op แฟ้ม diag รหัสที่มี 5 หลัก โปรแกรมไม่ส่งออกให้เลยครับ เช่น M6544 เป็นต้น
แก้อย่างไรขอบคุณล่วงหน้าครับ

จะต้องทำยังงัยในการกำหนดรหัสสิทธิ์ใหม่

พิมพ์หัว สติกเกอร์แล้วมันกระโดดครับไม่ทราบว่าจะทำยังงัย

ในบัญชี 3 มีทั้งหมด 77 ราย คือไม่อยากให้มันส่งออกทั้ง 77 รายในแฟ้ม pp ต้องทำอย่างไร

ขอบคุณครับ

ทางโรงพยาบาลได้ยาตามโครงการซึ่งไม่ให้เก็บค่าใช้จ่ายกับผู้ป่วย
แต่ 18 แฟ้ม 2554 drugcost,drugprice ต้องมากวกว่า 0
ไม่ทราบว่าผมต้องเซ็ตอย่างไรดีครับ

พอดีผมกำหนอดรหัสในการส่งออกของวัคซีน measles/mmr เป็น 061
แต่เวลา export ยังส่งออกเป็นของเดิมอยู่ คือ 071  แก้ไขอย่างไรดีครับ

เกิดจาก ผมได้รวม person ที่บัญชี1  เข้าด้วยกัน  พอ export ข้อมูลมันกลับดึง pid เก่าออกมาจากแฟ้ม women,service,fp ซึ่งใน person ได้รวมไปเป็น pid อื่นไปแล้ว  ต้องแก้ไขอย่างไร

พอดีผมซื้อ headphone ที่มีไมด้วย  มาแต่ไม่รู้จาเซ็ตอย่างไรให้ออกลำโพงไ้ด้ครับ  ช่วยแนะนำหน่อย

พอดีจาซื้อแรมใหม่นะครับ ใส่เครื่อง server
ของเก่ามันเป็น 512 x 4 พอดีผมจะเปลี่ยนให้เป็น 8 gb นะครับ
ผมต้องซื้อรุ่นใหนครับ
ดูยังงัยว่า บอร์ดผมรองรับบัสเท่าไหร่
แล้วแรม server ใช้เหมือนกับ pc ธรรมดาเราได้มั๊ย
ของเดิม 1Rx8 pc2-5300

มีปัญหาคือว่า ผู้ป่วยหนึ่งคน มี 2 hn
1. hn เก่า ที่ยังไม่ยุบ hn เข้า hn ใหม่
2. hn ใหม่
เวลา patient link
มันจาเอา hn เก่าเข้ามาครับไม่สามารถเลือก hn ใหม่ได้

1. ติดตั้ง MySQL ลงในเครื่่องที่จะทำหน้าที่เป็น Slave
2. เปิด configuration file ของ mysql มาแก้ไข หากใช้ linux จะอยู่ที่ /etc/my.cnf หรือหากใช้ Windows จะอยู่ที่ c:\windows\my.ini
3 ในเครื่องที่ทำหน้าที่เป็น Master ให้เพิ่ม ตรง section [mysqld] ดังนี้ครับ
server-id=1
log-bin
sync_binlog=1
innodb_safe_binlog
และที่สำคัญต้อง grant สิทธิให้ sa ด้วยคำสั่ง
grant all on *.* to sa@'%' identified by 'sa' with grant option
4. ในเครื่องที่ทำหน้าที่เป็น Slave ให้เพิ่ม ตรง section [mysqld] ดังนี้ครับ (สมมติว่าเครื่อง server มี IP Address เป็น 192.168.0.1 นะครับ)
server-id=2
master-host=192.168.0.1
master-user=sa
master-password=sa
replicate-do-db=hos
log-warnings
slave-skip-errors=all
5. ทำการ Re-Start mysql ทั้ง master และ slave
6. ที่เครื่อง slave ใช้คำสั่ง
mysql> load data from master
เพื่อทำนำเข้าข้อมูลจากเครื่อง master ไปยัง slave

หากไม่สำเร็จให้เปิด Log file ของ MySQL มาดู ทั้งใน Master และ slave
**************************
error ข้อที่ 5  ที่เกิดหลังจาก restart mysql  maste start mysql failed
starting MySQL...Manager of pid-file quit without updating file [failed]ครับ
centos master-->centos slave
ต้องแอย่างไรผมทำมา 3 วันแล้วครับช่วยหน่อยครับ
ช่วยผมหน่อยครับ

upgrade structor 52ไปเป็น53ครับ ที่ debug windowform  ครับมันขึ้น  error  ช่วยบอกหน่อยครับต้องแก้อย่างไร
ver stable 3.53.2.9c
System Message
Table al2dc Has No primary key !!!
Table al2mdc Has No primary key !!!
Table anc_birthcontrol Has No primary key !!!
Table anc_birthcontrol_history Has No primary key !!!
Table anc_delivery Has No primary key !!!
Table anc_family_history Has No primary key !!!
Table anc_ill_history Has No primary key !!!
Table anc_midwife Has No primary key !!!
Table anc_preg_history Has No primary key !!!
Table appserver Has No primary key !!!
Table baby_development_status Has No primary key !!!
Table baby_growth Has No primary key !!!
Table backuplist Has No primary key !!!
Table backupx Has No primary key !!!
Table backupx1 Has No primary key !!!
Table billrece Has No primary key !!!
Table clinic_auto_lab Has No primary key !!!
Table clinic_cormobidity Has No primary key !!!
Table clinic_cormobidity_diabete Has No primary key !!!
Table clinic_cormobidity_list Has No primary key !!!
Table clinic_dm_member Has No primary key !!!
Table clinic_dm_refer_type Has No primary key !!!
Table clinic_persist_icd Has No primary key !!!
Table clinic_profile Has No primary key !!!
Table code506 Has No primary key !!!
Table comdep Has No primary key !!!
Table ct2ax Has No primary key !!!
Table ct2bimdc Has No primary key !!!
Table ct2ccexc Has No primary key !!!
Table ct2icd10 Has No primary key !!!
Table ct2mdcpr Has No primary key !!!
Table ct2mscc Has No primary key !!!
Table ct2pcom Has No primary key !!!
Table ct2proc Has No primary key !!!
Table ct2rw Has No primary key !!!
Table ct2sh Has No primary key !!!
Table cupsmoney Has No primary key !!!
Table cupsname Has No primary key !!!
Table data_system Has No primary key !!!
Table debtor Has No primary key !!!
Table debtor_dt Has No primary key !!!
Table dentop Has No primary key !!!
Table detail_account Has No primary key !!!
Table devnote Has No primary key !!!
Table doctor_keyword Has No primary key !!!
Table doctorptotlist Has No primary key !!!
Table doctorscreen Has No primary key !!!
Table drgcc Has No primary key !!!
Table drgdxmain Has No primary key !!!
Table drgicd10 Has No primary key !!!
Table drgmdc Has No primary key !!!
Table drgnoncc Has No primary key !!!
Table drgopadd Has No primary key !!!
Table drgopmain Has No primary key !!!
Table drgoutput Has No primary key !!!
Table drgprocedure Has No primary key !!!
Table drgrw Has No primary key !!!
Table drug_group_check Has No primary key !!!
Table drug_user_check Has No primary key !!!
Table drugalias Has No primary key !!!
Table drugbarcode Has No primary key !!!
Table drugbdgtype Has No primary key !!!
Table drugcom Has No primary key !!!
Table drugdepartment Has No primary key !!!
Table drugessential Has No primary key !!!
Table druggpo Has No primary key !!!
Table drugitems_inc Has No primary key !!!
Table drugitems_picture Has No primary key !!!
Table drugjoin Has No primary key !!!
Table drugminp Has No primary key !!!
Table drugminpdt Has No primary key !!!
Table drugminptype Has No primary key !!!
Table drugorderplan Has No primary key !!!
Table drugpaylist Has No primary key !!!
Table drugpayref Has No primary key !!!
Table drugphmtype Has No primary key !!!
Table drugpotype Has No primary key !!!
Table drugptype Has No primary key !!!
Table drugrecipient Has No primary key !!!
Table drugrequestdetail Has No primary key !!!
Table drugrequestsummary Has No primary key !!!
Table drugstickeridr Has No primary key !!!
Table drugstock Has No primary key !!!
Table drugstockperson Has No primary key !!!
Table drugstockpersontype Has No primary key !!!
Table drugstockpropose Has No primary key !!!
Table drugstockproposedetail Has No primary key !!!
Table drugstockproposeorder Has No primary key !!!
Table drugstockproposeperson Has No primary key !!!
Table drugstore_detail Has No primary key !!!
Table drugstore_head Has No primary key !!!
Table drugstrength Has No primary key !!!
Table drugsupport Has No primary key !!!
Table drugtempreorder Has No primary key !!!
Table drugusage_default Has No primary key !!!
Table dtacthistory Has No primary key !!!
Table dtapp Has No primary key !!!
Table dtdn Has No primary key !!!
Table dtmain_ipd Has No primary key !!!
Table dtmain_save Has No primary key !!!
Table dttmrpt Has No primary key !!!
Table dxa_advice Has No primary key !!!
Table dxa_disease Has No primary key !!!
Table dxa_disease_cc Has No primary key !!!
Table dxa_disease_habit Has No primary key !!!
Table dxa_disease_physical_exam Has No primary key !!!
Table dxa_person_habit Has No primary key !!!
Table dxa_person_properties Has No primary key !!!
Table dxa_physical_exam Has No primary key !!!
Table dxa_treatment Has No primary key !!!
Table dxa_vital_sign Has No primary key !!!
Table er_command Has No primary key !!!
Table erais Has No primary key !!!
Table eris Has No primary key !!!
Table eriscode Has No primary key !!!
Table eroprt Has No primary key !!!
Table factordm Has No primary key !!!
Table family_person Has No primary key !!!
Table ffdeath Has No primary key !!!
Table ffhealthcare Has No primary key !!!
Table ffmember Has No primary key !!!
Table finance_check Has No primary key !!!
Table fpapp Has No primary key !!!
Table fpmain Has No primary key !!!
Table fpspclty Has No primary key !!!
Table gpsccode Has No primary key !!!
Table hinso1 Has No primary key !!!
Table hipdatachw Has No primary key !!!
Table hismember Has No primary key !!!
Table icd10help Has No primary key !!!
Table inc_opd_print Has No primary key !!!
Table inj_demo Has No primary key !!!
Table inj_er Has No primary key !!!
Table inj_injury Has No primary key !!!
Table inj_refer Has No primary key !!!
Table injury Has No primary key !!!
Table intraweb Has No primary key !!!
Table ipt_income_auto_charge Has No primary key !!!
Table ipt_income_auto_check Has No primary key !!!
Table ipt_income_auto_template Has No primary key !!!
Table ipt_nutrition Has No primary key !!!
Table ipt_nutrition_order Has No primary key !!!
Table ipt_pregnancy_deliver_type Has No primary key !!!
Table iptbedmove Has No primary key !!!
Table iptdrugorder Has No primary key !!!
Table iptoprt Has No primary key !!!
Table karaoke Has No primary key !!!
Table kkpopdb Has No primary key !!!
Table kskbackuprule Has No primary key !!!
Table kskdocument Has No primary key !!!
Table lab_routine_result Has No primary key !!!
Table medplan Has No primary key !!!
Table moo_home_image Has No primary key !!!
Table moo_home_water Has No primary key !!!
Table name506_form_image Has No primary key !!!
Table ncr_doctor Has No primary key !!!
Table ncr_patient Has No primary key !!!
Table ncr_patient2 Has No primary key !!!
Table ncr_patnew Has No primary key !!!
Table ncr_pnhn Has No primary key !!!
Table ncr_stock1 Has No primary key !!!
Table ncr_table2 Has No primary key !!!
Table ndrugdurable Has No primary key !!!
Table ndruggroup Has No primary key !!!
Table ndrugitems Has No primary key !!!
Table ndrugminp Has No primary key !!!
Table ndrugminpdt Has No primary key !!!
Table ndrugpaylist Has No primary key !!!
Table ndrugpayref Has No primary key !!!
Table ndrugstock Has No primary key !!!
Table ndrugtempreorder Has No primary key !!!
Table oldpttypeno Has No primary key !!!
Table opd_ill_history Has No primary key !!!
Table opdnurse Has No primary key !!!
Table opdoprt Has No primary key !!!
Table opdquickccscreen Has No primary key !!!
Table opdscreen_bp Has No primary key !!!
Table opitemreceh Has No primary key !!!
Table ovaccident Has No primary key !!!
Table patient_ipd_scan Has No primary key !!!
Table patient_nc Has No primary key !!!
Table patient_search Has No primary key !!!
Table pcu_child Has No primary key !!!
Table pcu_node Has No primary key !!!
Table pcu_replicate_cfg Has No primary key !!!
Table pcu_replicate_log Has No primary key !!!
Table personcardtime Has No primary key !!!
Table personid Has No primary key !!!
Table personsalary Has No primary key !!!
Table presetdosageregimen Has No primary key !!!
Table ptdepart Has No primary key !!!
Table pteroprt Has No primary key !!!
Table qno Has No primary key !!!
Table replicate_cfg Has No primary key !!!
Table replicate_err Has No primary key !!!
Table replicate_lock Has No primary key !!!
Table replicate_slave Has No primary key !!!
Table replicate_trigger_service Has No primary key !!!
Table rfrcs0 Has No primary key !!!
Table rpt_accident_code Has No primary key !!!
Table rpt_accident_name Has No primary key !!!
Table rtfreport Has No primary key !!!
Table sccredit Has No primary key !!!
Table scguarantorcut Has No primary key !!!
Table sclendmoney Has No primary key !!!
Table scloan Has No primary key !!!
Table scloandt Has No primary key !!!
Table scmember Has No primary key !!!
Table scpay Has No primary key !!!
Table screen_doctor Has No primary key !!!
Table scshare Has No primary key !!!
Table scsystem Has No primary key !!!
Table sigtoidr Has No primary key !!!
Table stat_clinic Has No primary key !!!
Table stockconfig Has No primary key !!!
Table table1 Has No primary key !!!
Table temp412a061 Has No primary key !!!
Table temp412a071 Has No primary key !!!
Table temp412a091 Has No primary key !!!
Table temp412b031 Has No primary key !!!
Table temp412b051 Has No primary key !!!
Table temp412b091 Has No primary key !!!
Table temp421d071 Has No primary key !!!
Table tempball1 Has No primary key !!!
Table tempblue_command1 Has No primary key !!!
Table tempcom41 Has No primary key !!!
Table tempdental1 Has No primary key !!!
Table tempmanoi_xp1 Has No primary key !!!
Table tempmanoi_xp2 Has No primary key !!!
Table tempreport Has No primary key !!!
Table test Has No primary key !!!
Table validitaken Has No primary key !!!
Table web_board Has No primary key !!!
Table web_conf Has No primary key !!!
Table web_session Has No primary key !!!
Table web_var Has No primary key !!!
Table xray_report_film Has No primary key !!!
Table xrayexam Has No primary key !!!
Drop duplicate primary key unique index datadictionary.ix_fieldname_tablename_unique ["fieldname","tablename"]
Wrong unique index death.ix_hn_unique [hn]
Drop duplicate primary key unique index health_med_operation_item_organ.ix_unique ["health_med_operation_item_organ_id","health_med_operation_item_id","health_med_operation_type_id"]
SQL Error: Column 'did' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0

SQL Error: Column 'drug_name' cannot be null
select * from pcu_drugitems limit 0