Thread

Is it always just 256 bytes, or does the amount vary? Are you using the default control panel theme?

Amount veries - see following error message:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 77 bytes) in /mnt/Target01/334174/www.hotelmarketing.com/web/content/system/codeigniter/system/database/drivers/mysql/mysql_result.php on line 162

Yes, I’m using the default control panel.

For a change, let me ask you two questions:

1. Do you have other EE 2 customers with 10’000+ articles in their database?

2. Is there a way that we can speed up support - I’m prepare to pay for it, if such a plan is available. This tread is now open a week, and all we have are a few basic questions answered.

Thanks. markus

Do you have other EE 2 customers with 10’000+ articles in their database?

Yes, that shouldn’t be an issue given the required server resources. Somehow MySQL is running out of memory, though. I’ll bring this up with the devs. What version of PHP and MySQL are you running?

Hi, Markus,

Yes, there are EE 2 Sites with many times that number of entries.

As far as support, we promise responses within one business day, as per our support policy.  There is not currently a way to speed that up.

Just upgraded from EE 1.x, upgrade went smooth, except with the reported memory issue

did you receive the memory error during the update? Or only after?

Can you give us a bit more information about your installation?  Approximately how many custom fields do you have? Have you ever used a third-party extension to create a custom field type?  And have you modified your publish page layout?

Do you have multiple channels, and if so - is this happening in all channels, or only in one? That could help us pinpoint what is going on. 

And lastly, how many of these entries “related” entries, if any?

We will figure this out - but it is an unusual one and not reported previously. I’m sorry that you’re running into this.

- No, I did not receive the memory error during the install - the install went without problems;
- I have online one custom field;
- I have never used any third party extensions
- I have not modified my publish page layout
- I have only one channel
- I have only one related entries section on my article page.

Txs. markus

Sorry this has been going on for a while, Markus, but this is really a rather odd one. Please check your associated email account in a few minutes.

Hi Markus,

I’m definitely able to reproduce the issue. However, you’re still on 2.1.1 and there were many changes to the Publish area since that version. Please upgrade to 2.1.3 and let us know if there’s any change. Thanks!

Upgraded to the 2.1.3 version - upgrade interupted, with some database error messages. The latest beeing:

A Database Error Occurred
Error Number: 1060

Duplicate column name ‘show_sidebar’

ALTER TABLE exp_members ADD show_sidebar char(1) NOT NULL default ‘y’ AFTER quick_tabs

Filename: updates/ud_212.php

Line Number: 53

Now my sight is not accessible at all. Appreciate any help you can give me, to get my site back live.

Markus, what’s the value of $config[‘app_version’]?

Where do i find $config[‘app_version’]? I FYI: I have no access to my site nor my control panel.

You’d download and view the /system/expressionengine/config/config.php file. It’s in there. Sorry I didn’t specify that earlier.

It says 219.

Funny enough, I get now the following error message when I load the CP:

Site Error: Unable to Load Site Preferences; Invalid Preference Data

And a 404 Not Found Error message when I load the site index page.

Txs for your help. markus

Hi Markus,

Our current app_version is 213.  Can you confirm that number for us again?

Sincerely,

Barry Cogan

Markus,

I was able to get your site back online with 2.1.3. However, the memory error when attempting to publish still occurs.

I notice that your MySQL database version is 4.1.22-standard-log (shown in Tools > Data > SQL Manager) and your MySQL client version is 5.0.77 (shown in Tools > Utilities > PHP Info). I suspect a database issue has been the cause of these problems. Can you get your host to upgrade your MySQL database so that it is in sync with your client version? Please backup your current database before doing this.

Thanks for your patience and keep us posted!

Yes, it is 213. And thanks for getting my site live again.

Yet, I still get the following error message when hitting the save button for a post:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 87 bytes) in /mnt/Target01/334174/www.hotelmarketing.com/web/content/system/codeigniter/system/database/drivers/mysql/mysql_result.php on line 162

Any idea, where else we could look for the solution?