1
แจ้งข้อผิดพลาดการทำงานของ HOSxP V3 / พิมพ์ profile sheet แล้ว ตัว report เพิ่มหน้าไม่รู้จบครับ
« เมื่อ: มกราคม 18, 2017, 14:56:32 PM »
เนื่องจาก เภสัช ต้องการใช้ profile sheet ในการพิมพ์รายการยาในแต่ละวัน แต่เกิดปัญหาขึ้นตามรูปครับ
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
select o.vstdate,o.vsttime,o.hn,d.*,dt.name,concat(p.pname,p.fname,' ',p.lname) as ptname ,t.name as pttype_name
from pq_doctor d
left outer join doctor dt on dt.code = d.doctor
left outer join ovst o on o.vn = d.vn
left outer join patient p on p.hn = o.hn
left outer join pttype t on t.pttype = o.pttype
where d.doctor in ("0076","0091","0157","0208","0229","0230") and (d.doctor_date between '2014-06-02' and '2014-06-06'
or d.doctor_date between '2014-06-09' and '2014-06-13')
and d.doctor_time between "08:30:00" and "16:30:00"
order by doctor_date,doctor_time
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=tis620
[xtrabackup]
target_dir=/mysqlbackup
datadir=/var/lib/mysql
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
#skip-locking
skip-external-locking
log_bin_trust_function_creators = 1
key_buffer = 128M
max_allowed_packet = 512M
#table_cache = 1500
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
join_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_type=1
query_cache_size = 256M
thread_concurrency = 8
#default-character-set=tis620
character-set-server=tis620
init_connect = 'SET NAMES tis620'
skip-name-resolve
innodb_file_per_table
skip-character-set-client-handshake
init_connect = 'SET NAMES tis620'
max_heap_table_size = 512M
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_buffer_pool_size = 1024M
innodb_additional_mem_pool_size = 20M
innodb_thread_concurrency = 0
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
innodb_flush_method=O_DIRECT
innodb_doublewrite=0
innodb_support_xa = 0
innodb_open_files = 2000
innodb_io_capacity = 400
transaction_isolation = REPEATABLE-READ
#innodb_adaptive_checkpoint = 1
innodb_write_io_threads = 16
innodb_read_io_threads = 16
innodb_data_file_path = ibdata1:200M:autoextend
innodb_log_buffer_size = 16M
innodb_log_file_size = 256M
innodb_locks_unsafe_for_binlog=1
concurrent_insert = 2
max_connections = 100
[mysqldump]
quick
max_allowed_packet =512M
allow-keywords
[mysql]
no-auto-rehash
default-character-set=tis620
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysql_safe]
open-files-limit = 50000
121127 02:58:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121127 2:58:28 [Note] Plugin 'FEDERATED' is disabled.
121127 2:58:28 InnoDB: The InnoDB memory heap is disabled
121127 2:58:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121127 2:58:28 InnoDB: Compressed tables use zlib 1.2.3
121127 2:58:28 InnoDB: Using Linux native AIO
121127 2:58:28 InnoDB: Initializing buffer pool, size = 1.0G
121127 2:58:28 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file /var/lib/mysql/ibdata1 did not exist:
InnoDB: a new database to be created!
121127 2:58:28 InnoDB: Setting file /var/lib/mysql/ibdata1 size to 200 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
121127 2:58:30 InnoDB: Log file /var/lib/mysql/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile0 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
121127 2:58:32 InnoDB: Log file /var/lib/mysql/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile1 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
121127 2:58:35 InnoDB: Waiting for the background threads to start
121127 2:58:36 Percona XtraDB (http://www.percona.com) 1.1.8-rel29.1 started; log sequence number 0
121127 2:58:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121127 2:58:36 [Note] - '0.0.0.0' resolves to '0.0.0.0';
121127 2:58:36 [Note] Server socket created on IP: '0.0.0.0'.
121127 2:58:36 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
121127 2:58:36 [ERROR] Do you already have another mysqld server running on port: 3306 ?
121127 2:58:36 [ERROR] Aborting
121127 2:58:36 InnoDB: Starting shutdown...
121127 2:58:41 InnoDB: Shutdown completed; log sequence number 1597914
121127 2:58:41 [Note] /usr/sbin/mysqld: Shutdown complete
121127 02:58:41 mysqld_safe mysqld from pid file /var/lib/mysql/phraodatacenter.com.pid ended