AMPPS MySQL Errors

So I’ve been receiving errors with PHP functions of mine, and I couldn’t figure it out, until I looked at the error log of the MySQL. There are four errors:

  1. 09:17:02 7472 [Warning] Info table is not ready to be used. Table ‘mysql.slave_master_info’ cannot be opened.

  2. 09:17:02 7472 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

  3. 2016-03-13 09:17:02 7472 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

  4. 2016-03-13 09:17:02 7472 [Warning] Info table is not ready to be used. Table ‘mysql.slave_relay_log_info’ cannot be opened.

If someone can resolve these issues, it would be great, because my PHP needs the SQL database :slight_smile:

1 Like

Maybe

I’ve never (knock on wood) seen that error before myself.

1 Like

Please read the entire entry before responding, thanks :^)
So I’m working with a friend in growing a company, and he sent me the files so I can work with them too. I use a software called AMPPS to run the PHP, HTML, CSS, etc. I’ve mentioned before in other topics I’ve posted, that I’ve received many PHP errors. Some errors I’ve received:

“Warning: Invalid argument supplied for foreach() in C:\Program Files (x86)\Ampps\www\includes\class-query.php on line 106”

"
Warning: Invalid argument supplied for foreach() in C:\Program Files (x86)\Ampps\www\includes\class-query.php on line 78"

I’ve then figured out that the values I “supplied” weren’t arrays, so I asked my friend about this, and he said it was working perfectly fine for him. (Yes, I’ve also filled in the tables in phpMyAdmin)

So I then looked at the error log in the MySQL Dashboard of AMPPS and discovered these errors:

2016-03-15 07:37:36 52 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

“2016-03-15 07:37:36 52 [Warning] Info table is not ready to be used. Table ‘mysql.slave_master_info’ cannot be opened.”

“2016-03-15 07:37:36 52 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.”

“2016-03-15 07:37:36 52[Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.”

“2016-03-15 07:37:36 52 [Warning] Info table is not ready to be used. Table ‘mysql.slave_relay_log_info’ cannot be opened.”

I have no idea what these errors mean, and I don’t know if they affect my databases. All I know is that my PHP files require the data in my databases in order to work. If anyone can identify the problem, that would be great!

Do you mean XAMPP?

I would recommend using a vm for local development. Anything other than .NET is a pita on Windows. Using a vm you will be able to work on a true Linux environment. One that probably closely matches the production environment more so than a windows one. Unless of course you plan using a windows server to which I say good luck.

I really mean AMPPS. It’s an amazing software containing MAMP, WAMP, and LAMP stacks. I don’t use XAMPP or WAMP.

http://www.ampps.com/

How many hours have you wasted trying to figure out this error?

Not that much really, tried some solutions that didn’t work out.

Has it completely halted your development tasks?

Significantly. Most of the links literally have the same PHP error because the PHP can’t receive the data from the MySQL databases. If I don’t fix these errors, my development will be very limited.

So maybe ampps isn’t the best thing to use for local development?

troll level: expert

2 Likes

XAMPP requires 32-bit, I have 64-bit. WAMP is too lengthy and difficult to install. AMPPS is amazing, just have to solve these errors and done.

I agree.

puphpet

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.