New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

4.0.10.12 Fatal error: Cannot 'break' 2 levels in ../phpmyadmin/export.php on line 864 #11912

Closed
osben opened this Issue Feb 2, 2016 · 7 comments

Comments

Projects
None yet
8 participants
@osben

osben commented Feb 2, 2016

Когда нажимаю експорт
Fatal error: Cannot 'break' 2 levels in ../phpmyadmin/export.php on line 864

)) { break 2; }
Apache/2.4.17 (Win32)
MySQL 5.6.26
PHP 7.0.0, mysqli
phpMyAdmin 4.0.10.12

@devenbansod

This comment has been minimized.

Show comment
Hide comment
@devenbansod

devenbansod Feb 2, 2016

Member

Actually this version is no longer supported, except for security fixes.
Please try a newer version.

Member

devenbansod commented Feb 2, 2016

Actually this version is no longer supported, except for security fixes.
Please try a newer version.

@devenbansod devenbansod closed this Feb 2, 2016

@bbalet

This comment has been minimized.

Show comment
Hide comment
@bbalet

bbalet Feb 10, 2016

You can solve this issue my modifying line 864, change :

break 2;

By:

break;

Don't worry, this is a code mistake from the phpMyAdmin team: you are into one loop and not two nested loops. That's why you can't "break 2" (because 2 denotes that you're inside a nested loop). The error appears because PHP7 is stricter than former versions. By the way, this can fix other packages (PHPExcel, newer versions of phpMyAdmin etc.). Most of the time, the developper deleted the nested loop and forgot to update this line of code.

bbalet commented Feb 10, 2016

You can solve this issue my modifying line 864, change :

break 2;

By:

break;

Don't worry, this is a code mistake from the phpMyAdmin team: you are into one loop and not two nested loops. That's why you can't "break 2" (because 2 denotes that you're inside a nested loop). The error appears because PHP7 is stricter than former versions. By the way, this can fix other packages (PHPExcel, newer versions of phpMyAdmin etc.). Most of the time, the developper deleted the nested loop and forgot to update this line of code.

@DOCTOR-5

This comment has been minimized.

Show comment
Hide comment
@DOCTOR-5

DOCTOR-5 Jan 25, 2017

@bbalet : THANK YOU!!

DOCTOR-5 commented Jan 25, 2017

@bbalet : THANK YOU!!

@steadistone

This comment has been minimized.

Show comment
Hide comment
@steadistone

steadistone Jul 27, 2017

Thank you bbalet. Appreciate you documenting this.

Found the "export.php" file on Ubuntu 14.04 LTS at:

/usr/share/phpmyadmin

and it was indeed located at line number 864. Database files can now be exported.

Got the rest of my day back. Thanks!

-Andrew Stone

steadistone commented Jul 27, 2017

Thank you bbalet. Appreciate you documenting this.

Found the "export.php" file on Ubuntu 14.04 LTS at:

/usr/share/phpmyadmin

and it was indeed located at line number 864. Database files can now be exported.

Got the rest of my day back. Thanks!

-Andrew Stone

@rsedger

This comment has been minimized.

Show comment
Hide comment
@rsedger

rsedger Jan 18, 2018

Thank you bbalet. I have a fresh install of mysql (Ver 14.14 Distrib 5.5.58) and php7.1 with phpmyadmin version 4.0.10deb1. This issue still exists.

rsedger commented Jan 18, 2018

Thank you bbalet. I have a fresh install of mysql (Ver 14.14 Distrib 5.5.58) and php7.1 with phpmyadmin version 4.0.10deb1. This issue still exists.

@akuladouglas

This comment has been minimized.

Show comment
Hide comment
@akuladouglas

akuladouglas Mar 6, 2018

Thanks you. Worked for me as well

Thanks you. Worked for me as well

@invom

This comment has been minimized.

Show comment
Hide comment

invom commented Apr 3, 2018

thank you @bbalet

@phpmyadmin phpmyadmin deleted a comment from angelfreedomv Apr 3, 2018

@phpmyadmin phpmyadmin deleted a comment from angelfreedomv Apr 3, 2018

@phpmyadmin phpmyadmin locked and limited conversation to collaborators Apr 3, 2018

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.