#4773 Trying to create new table results in 500 Internal Server Error

[DisgruntledGoat]

When I click the "New" link below the table name in the left panel, I get this error:

Error in Processing Request
Error code: 500
Error text: Internal Server Error

The same happens when I'm on the Database overview page and try to create a new table from the "Create table" box at the bottom.

It first happened as a user without the required permissions, but the same thing happened as root as well. I was able to create the table using raw SQL with "CREATE TABLE..." so it can't be a permissions issue.

Using: PMA 4.3.9, PHP 5.4, MySQL 5.6, Microsoft IIS 7.5.

[Marc Delisle]

You mean "New" below the database name in the navi panel, correct?

I cannot reproduce this. Can you reproduce on the demo server?

[DisgruntledGoat]

It works fine on the demo server and on my localhost. Perhaps it's something to do with IIS?

The exact path requested (as shown in dev tools) is:
/tbl_create.php?server=1&db=tentors&token=a35a5fc571a3009614c28291b1dcde79&ajax_request=true&ajax_page_request=true&menuHashes=3246c918-ddf9938f&_nocache=142443656011854469

[Marc Delisle]

An internal server error happens at the web server level, probably while interacting with the PHP component.

[DisgruntledGoat]

Update: I'm getting the same error when trying to edit a field type. Clicking the Edit icon makes the error appear.

[Marc Delisle]

Did this problem appear on your IIS with phpMyAdmin 4.3.9? What about 4.3.8 ?

[Abdelfattah Eltayb]

i think you should try it manually;

<?php
$server_name = "localhost";
$user_name = "database username";
$password = "database password";

// this gonna start a connection to the server
$conn = new mysqli($server_name, $user_name, $password);
// make sure that the connection works normally
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

// start creating database afetr connecting to the server
$sql = "CREATE DATABASE DBname";
if ($conn->query($sql) === TRUE) {
echo "successfuly database created";
} else {
echo "Error with creating database: " . $conn->error;
}

$conn->close();
?>

[Isaac Bennetch]

@abdotayb first, your code refers to creating a new database, not table, and secondly the DisgruntledGoat already tried using SQL directly.

[Marc Delisle]

Please give us some feedback on this problem under phpMyAdmin 4.4.1.1.

[Daniel Tuvestam]

I have this problem too in version 4.4.4

Database server

Server: localhost via TCP/IP
Server type: MySQL
Server version: 5.5.30 - MySQL Community Server (GPL)
Protocol version: 10
User: Daniel@localhost
Server charset: UTF-8 Unicode (utf8)

Web server

Microsoft-IIS/7.5
Database client version: libmysql - mysqlnd 5.0.8-dev - 20102224 - $Id: 731e5b87ba42146a687c29995d2dfd8b4e40b325 $
PHP extension: mysqli Documentation
PHP version: 5.3.23

phpMyAdmin

Version information: 4.4.4 (up to date)

[Marc Delisle]

Daniel,
anything in IIS's error log regarding this?

[Daniel Tuvestam]

This is the log from IIS for just that site.

[Marc Delisle]

This is a log of requests but I need the error log. Maybe this can help:
http://stackoverflow.com/questions/4764230/where-does-iis-7-5-log-errors

[Satwinder Rathore]

I am getting this error too. While creating the table.

[Marc Delisle]

Which phpMyAdmin version?

[Satwinder Rathore]

I have installed the latest version 4.4.9

[Marc Delisle]

Same question: any clue in the web server's error log?

[djSuperFive]

Hi, same issue on my local Mac.
phpmyadmin 4.4.9

from the logs :
[Mon Jun 15 13:44:07 2015] [error] [client ::1] FastCGI: comm with server "/Applications/MAMP/fcgi-bin/php5.6.6.fcgi" aborted: idle timeout (30 sec), referer: http://localhost/phpMyAdmin/tbl_structure.php?db=mydb&table=mytable&token=6d009d8111df3d1521ab024d78364407
[Mon Jun 15 13:44:07 2015] [error] [client ::1] FastCGI: incomplete headers (0 bytes) received from server "/Applications/MAMP/fcgi-bin/php5.6.6.fcgi", referer: http://localhost/phpMyAdmin/tbl_structure.php?db=mydb&table=mytable&token=6d009d8111df3d1521ab024d78364407