#4700 (ok 4.3.8) Error text: Internal Server Error

[Alexander Schuch]

When I load phpMyAdmin 4.3.6 for the first time a browser session, I get the following red error box error. Maybe it is related to a non-present cookie?

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

This happens at the first page where I am supposed to select a server in a multi-server setup, so basically at "https://…/". I do not have a "Persistent favorite tables" enabled.

The Firefox developer tools show the query:

POST: https://…/db_structure.php?ajax_request=1&favorite_table=1&sync_favorite_tables=1&lang=en&collation_connection=utf8_unicode_ci&token=…

Request body:
favorite_tables=&_nocache=…

Request headers:
Host: …
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:29.0) Gecko/20100101 Firefox/29.0
Accept: /
Accept-Language: en-gb,en;q=0.5
Accept-Encoding: gzip, deflate
DNT: 1
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
X-Requested-With: XMLHttpRequest
Referer: https://…/
Content-Length: 45
Cookie: phpMyAdmin=…; pma_lang=en; pma_collation_connection=utf8_unicode_ci
Connection: keep-alive
Pragma: no-cache
Cache-Control: no-cache

[Madhura Jayaratne]

I was not successful in recreating this bug by deactivating "Persistent favorite tables" and following the other steps. Do you see any errors in the server log?

[Alexander Schuch]

Yes, you are right. I get the following error in 4.3.6:

PHP Fatal error: Call to a member function isSuperuser() on a non-object in …/phpMyAdmin-4.3.6-english/libraries/Menu.class.php on line 510, referer: https://…/

[Madhura Jayaratne]

Can you paste the full stack trace?

[Alexander Schuch]

Do I need to change something somewhere - where? There was no stack trace in the log. Just this error message. An uncaught exception shows a stack trace, but usually not a PHP fatal error?

[Alexander Schuch]

The reason is the same as for [#4685]. When removing "$cfg['ServerDefault'] = 0;", there is no error anymore. I checked the documentation of 4.3.7 and this option is still supported. Looks like a bug then.

[derados]

Since i upgraded from last 4.2.13.1 to 4.3.x (tried all from .0 till .6), it is not possible any more to Edit/Change Table Structure, add new field or even Create New Table in Hierarchy Tree. Always getting Internal Server Error 500. Now i am back to 4.2.13.1 and waiting that you solve this.

[derados]

ok, after analyzing apache error_log i found that the problem is connected with Altering 'pma_column_info' table, i used existing SQL file in /examples to upgrade and i also have to remove /library folder and upload it again cause some old files were left there. now 4.3.7 works perfectly, without internal server error.

[Marc Delisle]

Upgrading by overwriting may not work, see
http://docs.phpmyadmin.net/en/latest/setup.html#upgrading-from-an-older-version

[Alexander Schuch]

If you have upgraded your phpMyAdmin to 4.3.0 or newer from 2.5.0 or newer (<= 4.2.x) and if you use the phpMyAdmin configuration storage, you should run the SQL script found in sql/upgrade_column_info_4_3_0+.sql.

For phpMyAdmin 4.3.7, the file seems to be located at "./examples/upgrade_column_info_4_3_0+.sql" -- Small documentation issue, I guess.

Edit: Okay, the 4.3.7 documentation actually refers to "examples". The "latest" documentation refers to 4.4.0-dev. So never mind. :)

[Madhura Jayaratne]

Should be fixed with https://github.com/phpmyadmin/phpmyadmin/commit/cb18ec2320592a7adba33187ad139772eef04c45