|
iTEC
|
September 19, 2012 at 3:57 am
Hi!
I’m having the Problem, that when i upload the sample.xls i always get the error:
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 32 bytes) in /home/www/xxxxxxxx/html/wordpress/wp-content/plugins/espresso-seating/lib/class/oleread.inc on line 27
My Hosting provider already gave me the maximum of memory size and it still dosen’t work.
If i transfer the sample.xls in a .xlsx the upload is working but it dosen’t write the seats into the DB Table.
Someone knows how to fix this?
I have instaled the latest Version of Event Espresso and the seating chart extension.
|
|
Dean
|
September 19, 2012 at 4:17 am
Hello Rahel,
How much memory did the host provide? Did you or they update your wp-config.php accordingly? http://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP
|
|
iTEC
|
September 19, 2012 at 5:13 am
I set it to define(‘WP_MEMORY_LIMIT’, ’64M’); in my wp_config.
I instaled also a plugin to show the use of the memory size and it seams to be ok.
|
|
Dean
|
September 19, 2012 at 6:09 am
Hi,
I have not been able to recreate this on a test server (3.1.27 and seating chart and then with all addons activated.)
Therefore I would say it is highly possible that another plugin is causing the issue, as the server is literally running out of its allocated memory (memory leak).
Try deactivating your plugins except Event Espresso and add ons and see if that works.
|
|
iTEC
|
September 19, 2012 at 6:19 am
I deactivated all other plugins but it still dosent work.
I even reinstaled Event Espresso all new but nothing…
Could it be that i’m having a failure in my .xls?
http://www.4cultura.ch/kategorie1.xls
|
|
Seth Shoultes
|
September 19, 2012 at 9:39 am
Sometimes the .xls format doesn’t work on some servers. Try saving it as a .csv file, then upload that.
|
|
iTEC
|
September 20, 2012 at 2:35 am
That was the first thing i tried when the problem came up und it dosen’t make any difference.
Still the same troubles.
|
|
iTEC
|
September 20, 2012 at 2:36 am
And by the way: it is so strage, that the problem also happens if i use the sample.xls form event espresso itselfe.
|
|
Seth Shoultes
|
September 20, 2012 at 9:01 pm
Ya, this definitely sounds like a memory issue. I use Hostgator for my test site and have uploaded over 1,000 seats without a problem. It could also be an issue with missing PHP libraries that are used to parse the data.
Just thought of something else. What version of PHP and MySQL are installed on your server? Who is the hosting company (please don’t say Godaddy)?
|
|
iTEC
|
September 20, 2012 at 11:44 pm
No, it’s hoststar.ch
Is there a way how i can solve that with my hoster?
They already gave me more memory in zhe php.ini, anything else i can do?
|
|
Seth Shoultes
|
September 21, 2012 at 12:34 am
What version of PHP and MySQL are installed on your server?
Do you have access to the error logs? It would be good to see if there are any errors. There might be an error log in your wp-admin directory that might have some information. If you don’t have access to the error logs, you may want to get your hosting company involved and tell them what troubles you are having. They may be able to help track down the problem and find a solution.
Last resort would be to try importing the csv file directly into your database using PHPMyAdmin. That is if your version of PHPMyAdmin and MySQL support this scenario. If not, then it might be time to move to a different host that has up to date hosting technology.
|
|
iTEC
|
September 21, 2012 at 12:39 am
It’s mySQL5 and PHP 5.4.7
I will try to get the error logs.
|
