1. Hoppsan
  2. MAMP - Troubleshooting
  3. Tuesday, 19 May 2020

Hello, first post here and really need help.

 

iMAC (21.5") OS 10.13.6 (17G4015)

Had old MAMP w/ old PHP, need new for coming PHP update. So yesterday I upgraded to MAMP 5.7.

Got a message that I should (start servers? and then) click somewhere to update the database. Did so and everything was OK - at least no error messages.

Enter PHPMyAdmin and I get 3 messages - 2 short and 1 long:

 

Short 1:

mysqli_real_connect(): Error while reading greeting packet. PID=49437

 

Short 2:

mysqli_real_connect(): (HY000/2006): MySQL server has gone away

 

Long:

Warning in ./libraries/classes/Dbi/DbiMysqli.php#228
mysqli_query(): (HY000/1682): Native table 'performance_schema'.'session_variables' has the wrong structure

Backtrace

./libraries/classes/Dbi/DbiMysqli.php#228: mysqli_query(
,
string 'SHOW SESSION VARIABLES LIKE \'character_set_server\';',
integer 0,
)
./libraries/classes/DatabaseInterface.php#319: PhpMyAdmin\Dbi\DbiMysqli->realQuery(
string 'SHOW SESSION VARIABLES LIKE \'character_set_server\';',
,
integer 1,
)
./libraries/classes/DatabaseInterface.php#1621: PhpMyAdmin\DatabaseInterface->tryQuery(
string 'SHOW SESSION VARIABLES LIKE \'character_set_server\';',
integer 256,
integer 1,
boolean false,
)
./libraries/classes/DatabaseInterface.php#1403: PhpMyAdmin\DatabaseInterface->fetchValue(
string 'SHOW SESSION VARIABLES LIKE \'character_set_server\';',
integer 0,
integer 1,
integer 256,
)
./libraries/classes/Charsets.php#150: PhpMyAdmin\DatabaseInterface->getVariable(string 'character_set_server')
./index.php#373: PhpMyAdmin\Charsets::getServerCharset(<class:phpmyadmin\databaseinterface>)

 

Clicking a table name in the left list gives 2 new short messages like the ones above and 2 really long (SQLcode).

If I "Ignore all" and click Browse, I can browse the table after I "Ignore all" again. To Browse is all I dare to do...

My PHP scripts work fine, as far as I can tell.

 

Do you know how to fix this. It's been sooo stable for so long.

Thanks In Advance,

Hoppsan



Accepted Answer Pending Moderation
0
Votes
Undo

Are you sure your site/cms is compatible with the newer version of PHP you are running? Try a lower or same version of PHP before. Else, revert back to your old version of MAMP. What version were you running?

  1. more than a month ago
  2. MAMP - Troubleshooting
  3. # 1
Accepted Answer Pending Moderation
0
Votes
Undo

A complete restart of the computer solved everything.

Strange.

/H

  1. more than a month ago
  2. MAMP - Troubleshooting
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!