MYSQL Bug
Closed this issue · 5 comments
當我使用MySQL Community Server時，AllenDisk出現Bug
情況為當我上傳檔案且上傳程式顯示成功上傳時，檔案未能出現於網頁中，但文件成功加密並儲存。
以及PHPMYADMIN中未看見資料庫中有任何記錄出現
但我使用XAMPP中的MYSQL時並沒有出現以上錯誤。
系統環境:
OS : Windows Server 2012 R2
Web Server : IIS 7
MySQL DataBase : MySQL Community Server 5.6.27
您好，如果可以的話，能不能嘗試看看把 Error Reporting 打開並且提交錯誤訊息，謝謝
是MYSQL的Error Reporting 或是IIS的Error Reporting ? Thx
MySQL 和 PHP 的
php:
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) in C:\xampp\htdocs\class\sql.class.php on line 33
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli_error(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 37
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Notice: Undefined index: login in C:\xampp\htdocs\index.php on line 14
[25-Oct-2015 14:42:38 Europe/Berlin] PHP Notice: Undefined index: login in C:\xampp\htdocs\index.php on line 35
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) in C:\xampp\htdocs\class\sql.class.php on line 33
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli_error(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 37
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:41 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) in C:\xampp\htdocs\class\sql.class.php on line 33
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli_error(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 37
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 51
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 64
[25-Oct-2015 14:42:42 Europe/Berlin] PHP Warning: MySQL::ExecuteSQL(): Couldn't fetch mysqli in C:\xampp\htdocs\class\sql.class.php on line 82
[25-Oct-2015 14:46:31 Europe/Berlin] PHP Notice: Undefined index: update in C:\xampp\htdocs\install\mysql-set.php on line 15
[25-Oct-2015 14:46:31 Europe/Berlin] PHP Notice: Undefined index: update in C:\xampp\htdocs\install\mysql-set.php on line 57
[25-Oct-2015 14:46:47 Europe/Berlin] PHP Notice: Undefined index: tos in C:\xampp\htdocs\install\site-set.php on line 21
[25-Oct-2015 14:46:47 Europe/Berlin] PHP Notice: Undefined index: why in C:\xampp\htdocs\install\site-set.php on line 27
[25-Oct-2015 14:46:47 Europe/Berlin] PHP Notice: Undefined index: reg in C:\xampp\htdocs\install\site-set.php on line 33
[25-Oct-2015 14:46:47 Europe/Berlin] PHP Notice: Undefined index: err in C:\xampp\htdocs\install\newuser-setting.php on line 35
[25-Oct-2015 14:46:47 Europe/Berlin] PHP Notice: Undefined index: err in C:\xampp\htdocs\install\newuser-setting.php on line 36
[25-Oct-2015 14:47:03 Europe/Berlin] PHP Notice: Undefined index: login in C:\xampp\htdocs\index.php on line 14
[25-Oct-2015 14:47:03 Europe/Berlin] PHP Notice: Undefined index: login in C:\xampp\htdocs\index.php on line 35
[25-Oct-2015 14:47:11 Europe/Berlin] PHP Notice: Undefined index: dir in C:\xampp\htdocs\home.php on line 42
[25-Oct-2015 14:47:11 Europe/Berlin] PHP Notice: Undefined index: dir in C:\xampp\htdocs\home.php on line 43
[25-Oct-2015 14:47:12 Europe/Berlin] PHP Notice: Undefined index: id in C:\xampp\htdocs\preview.php on line 29
[25-Oct-2015 14:47:12 Europe/Berlin] PHP Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\ajax\ajax_dir_tree.php on line 12
mysql:
2015-10-25 21:46:06 11392 [Note] Plugin 'FEDERATED' is disabled.
2015-10-25 21:46:06 2538 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-10-25 21:46:06 11392 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-10-25 21:46:06 11392 [Note] InnoDB: The InnoDB memory heap is disabled
2015-10-25 21:46:06 11392 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-10-25 21:46:06 11392 [Note] InnoDB: Memory barrier is not used
2015-10-25 21:46:06 11392 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-10-25 21:46:06 11392 [Note] InnoDB: Not using CPU crc32 instructions
2015-10-25 21:46:06 11392 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-10-25 21:46:06 11392 [Note] InnoDB: Completed initialization of buffer pool
2015-10-25 21:46:06 11392 [Note] InnoDB: Highest supported file format is Barracuda.
2015-10-25 21:46:06 11392 [Note] InnoDB: The log sequence numbers 1665244 and 1665244 in ibdata files do not match the log sequence number 1702596 in the ib_logfiles!
2015-10-25 21:46:06 11392 [Note] InnoDB: Database was not shutdown normally!
2015-10-25 21:46:06 11392 [Note] InnoDB: Starting crash recovery.
2015-10-25 21:46:06 11392 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-10-25 21:46:06 11392 [Note] InnoDB: Restoring possible half-written data pages
2015-10-25 21:46:06 11392 [Note] InnoDB: from the doublewrite buffer...
2015-10-25 21:46:06 11392 [Note] InnoDB: 128 rollback segment(s) are active.
2015-10-25 21:46:06 11392 [Note] InnoDB: Waiting for purge to start
2015-10-25 21:46:06 11392 [Note] InnoDB: 5.6.26 started; log sequence number 1702596
2015-10-25 21:46:06 11392 [Note] Server hostname (bind-address): '*'; port: 3306
2015-10-25 21:46:06 11392 [Note] IPv6 is available.
2015-10-25 21:46:06 11392 [Note] - '::' resolves to '::';
2015-10-25 21:46:06 11392 [Note] Server socket created on IP: '::'.