tcloud Posted July 28, 2016 Report Share Posted July 28, 2016 I have installed TNG numerous times, including TNG-11, on this localhost, but maybe not since I upgraded to Apache 2.4 (see the apache error.log below) ... and I access databases and run PHP code on it every day, though I haven't recently tried to create tables on any database -- except with phpMyAdmin. Actions/Symptoms: ================== - readme.html writes to config.php - readme.html says it successfully connected to database - Step 2: will not create tables -- hangs with " Please wait, attempting to process..." System specs: ================== XAMPP PHP Version: 5.6.19 mySQL Version: 5.5.5-10.1.10-MariaDB Web Server: Apache/2.4.17 (Win32) OpenSSL/1.0.2d PHP/5.6.19 Server Name: localhost Server Platform: WINNT/x86 Server IP Address: 127.0.0.1 Port: 80 The database user has been set to ALL privileges, including Administration (which I've never had to do before) Apache error.log ================== [Thu Jul 28 14:40:05.730248 2016] [core:alert] [pid 3700:tid 1856] [client ::1:59495] C:/Users/tc/Documents/My Webs/Cloud-Web/__mykindred.com_root/_vti_pvt/.htaccess: 'Options All' must be the first option given. (I don't use FrontPage extensions so don't know why this shows up) The .htaccess in root/_vti_log: ================== # -FrontPage- Options None All -Indexes <Limit GET POST PUT DELETE> order deny,allow deny from all </Limit> Apache access.log ================== ::1 - - [28/Jul/2016:16:07:39 -0500] "POST /MyKindred/public_html/cloud/TNG%20work/TNG.10.1.3/ajx_tnginstall.php HTTP/1.1" 200 345 "http://localhost/MyKindred/public_html/cloud/TNG%20work/TNG.10.1.3/readme.html" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:47.0) Gecko/20100101 Firefox/47.0" ::1 - - [28/Jul/2016:16:08:04 -0500] "POST /MyKindred/public_html/cloud/TNG%20work/TNG.10.1.3/ajx_tnginstall.php HTTP/1.1" 200 345 "http://localhost/MyKindred/public_html/cloud/TNG%20work/TNG.10.1.3/readme.html" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:47.0) Gecko/20100101 Firefox/47.0" ::1 - - [28/Jul/2016:16:08:18 -0500] "POST /MyKindred/public_html/cloud/TNG%20work/TNG.10.1.3/ajx_tnginstall.php HTTP/1.1" 200 239 "http://localhost/MyKindred/public_html/cloud/TNG%20work/TNG.10.1.3/readme.html" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:47.0) Gecko/20100101 Firefox/47.0" ::1 - - [28/Jul/2016:16:08:52 -0500] "POST /MyKindred/public_html/cloud/TNG%20work/TNG.10.1.3/ajx_tnginstall.php HTTP/1.1" 200 531 "http://localhost/MyKindred/public_html/cloud/TNG%20work/TNG.10.1.3/readme.html" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:47.0) Gecko/20100101 Firefox/47.0" ** Note -- there is no additional entry in either the Apache error.log or the access.log following the click on "Database Tables ... Save and Create" I'm out of ideas. thanks, Tom Quote Link to comment Share on other sites More sharing options...
tcloud Posted July 29, 2016 Author Report Share Posted July 29, 2016 Refresh: this is a problem using XAMPP locally with Apache 2.4, PHP 5.6.19 and MariaDB 5.5.5-10.1.10. I can create the tables using phpMyAdmin. I can create them with PHP using tabledefs.php as a template. But the installation script -- readme.html -- won't create them. It hangs at step 7 (Express Install) with message "Please wait, attempting to process..." In my testing, I questioned whether the problem lay with my switching from mysql to mariadb, but it works fine. The only problem I've experienced using phpMyAdmin or the PHP script is when using COLLATION utf8mb4_general_ci which throws a #1071 index too long error. Any suggestions as to how to troubleshoot this -- or the solution -- would be most appreciated. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.