[solved]How to fix sql import error "ob_clean();failed to delete buffer" ?

[Presta1.5.4.1Newbies]

What should I do to fix this problem?

 

I found this error when I tried to restore my shop from SQl which is directly backed up Prestashop backoffice itself.

While there is no error when I import from SQl file that exported from PHPmyAdmin.

 

I have to fix this since next admin does not have to log on t server to back it up.

 

My shop version is 1.5.4.1, I turned my on maintenance before using function DB back up from backoffice.

Shop url : www.grandcoralaustralia.com.au/Grandcoral

Edited August 19, 2013 by Xarapauy (see edit history)

[mfedorets]

If you have access to your php.ini try to set

 

output_buffering = 4096

 

Possible reason is you have output_buffering = Off

[Presta1.5.4.1Newbies]

If you have access to your php.ini try to set

 

output_buffering = 4096

 

Possible reason is you have output_buffering = Off

Dear mfeodorets, unfortunately my server does not allow to access php.ini. What else should I do?

[mfedorets]

You can try the following:

 

1. put ob_start() in the top of the script, output buffering will be on (backup.php)

2. via .htaccess:

php_flag output_buffering on

or

php_value output_buffering 1

3. try to find this setting in the backend panel (ex.CPanel) of your hosting

4. contact hosting administrator on this issue

[Presta1.5.4.1Newbies]

@mfedorets

I have tried with ob_start(), it cause server error that I can not download the backup file.

With the .htaccess it will be auto generate in version 1.5.4.1.

Thank you anyway

[mfedorets]

Try to add condition in the /psadmin/backup.php, istead ob_clean() add

if (ob_get_length()) ob_clean();

Edited August 16, 2013 by mfedorets (see edit history)

[Presta1.5.4.1Newbies]

@mfedorets You are my life saver. IT is perfecto, I can import back to the server without any problem.

What is the cause of this problem? The increased amount of data, or server. please shade the light for php dumb.

Thank you very much

[mfedorets]

@mfedorets You are my life saver. IT is perfecto, I can import back to the server without any problem.

What is the cause of this problem? The increased amount of data, or server. please shade the light for php dumb.

Thank you very much

 

Thank you for this feedback

The reason was the ob_clean() function wasn't able to find the buffer, maybe because the buffering was off on your server.

You can read about the buffering in simple words in this article.

As you have no rights at your hosting to manage php settings, one possible way is just check buffer size before ob_clean evaluation. If buffer is empty we don't start buffer cleaning and error will not appear.

 

Think you can mark this topic as solved.

[Presta1.5.4.1Newbies]

Thank you very much dear mfedorets