Issue PhpMyadmin 3.3.0 with Export to Excel 2003 or 2007

[Roberto Nunez]

Issue PhpMyadmin 3.3.3 with Export to Excel 2003 or 2007

Hello,
I detect this another issue when I try to export to Excel 97-2003 XLS Workbook or Excel 2007 XLSX Workbook, I get error 500.

Product: Plesk Panel 10.0.1 (latest)

O.S.: CentOS 5.5 64 bits

This function should be works fine because its important.

Regards.

 

[IgorG]

I can't reproduce it on my test environment. Need more details, error logs, etc.

 

[Roberto Nunez]

Hi Igor,
This error appear in this logs:

/var/log/sw-cp-server/error_log

[root@ns sw-cp-server]$ tail -f error_log

2010-11-18 11:52:40: (connections.c.299) SSL: 1 error:140780E5:SSL routines:SSL23_READ:ssl handshake failure
2010-11-18 11:52:40: (connections.c.299) SSL: 1 error:140780E5:SSL routines:SSL23_READ:ssl handshake failure
2010-11-18 11:52:40: (connections.c.299) SSL: 1 error:140780E5:SSL routines:SSL23_READ:ssl handshake failure
2010-11-18 11:52:40: (connections.c.299) SSL: 1 error:140780E5:SSL routines:SSL23_READ:ssl handshake failure
2010-11-18 11:52:56: (connections.c.299) SSL: 1 error:140780E5:SSL routines:SSL23_READ:ssl handshake failure
2010-11-18 11:53:32: (mod_fastcgi.c.2582) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 95 bytes) in /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/PHPExcel/PHPExcel/Worksheet.php on line 977

2010-11-18 11:53:56: (mod_fastcgi.c.2582) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 95 bytes) in /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/PHPExcel/PHPExcel/Worksheet.php on line 977

2010-11-18 11:56:34: (mod_fastcgi.c.2582) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 24 bytes) in /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/PHPExcel/PHPExcel/Cell.php on line 505

I has been increase the memory to 192MB but it still doesnt solve the issue.

[root@]$ grep memory_limit /usr/local/psa/admin/conf/php.ini
memory_limit = 192M

Do you have any idea?

 

[IgorG]

Is it Virtuozzo VPS? Maybe there is lack of resources for VPS?

 

[Roberto Nunez]

No, it is not Virtuozzo, it is a normal server with 4GB Ram, around 750 memory free.

At this moment I increase memory_limit to 256 MB but the issue is persistent.

Do you have any idea?

 

[IgorG]

Did you tried to tune /etc/php.ini file too?