s3131212 / allendisk

http://ad.allenchou.cc
MIT License
39 stars 8 forks source link

MYSQL Bug #4

Closed yeungalan closed 7 years ago

yeungalan commented 8 years ago

當我使用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

s3131212 commented 8 years ago

您好,如果可以的話,能不能嘗試看看把 Error Reporting 打開並且提交錯誤訊息,謝謝

yeungalan commented 8 years ago

是MYSQL的Error Reporting 或是IIS的Error Reporting ? Thx

s3131212 commented 8 years ago

MySQL 和 PHP 的

yeungalan commented 8 years ago

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

yeungalan commented 8 years ago

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: '::'.