Welcome, Guest
Username: Password: Remember me

TOPIC: ComfortUpdate memory problem when updating from 1.78

ComfortUpdate memory problem when updating from 1.78 5 years 5 months ago #47150

  • andiliebl
  • andiliebl's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 15
  • Karma: 1
Hi all,

I try to run the comfort update, however I receive the following error message:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 21954126 bytes) in C:\Programme\xampp\htdocs\limesurvey\admin\update\updater.php on line 413

It seems not enough memory size is allocated to the temp storage but where can I change this? Line 413 in updater.php is not about memory size.

Thanks,

Andi
Last Edit: 4 years 7 months ago by c_schmitz.
The administrator has disabled public write access.

comfort update memory problem 5 years 5 months ago #47160

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 8218
  • Thank you received: 1122
  • Karma: 333
Update need a lot of memory.

You can change the memory allowed for php script in your xamp installation. (see xamp documentation :))
The administrator has disabled public write access.

comfort update memory problem 5 years 5 months ago #47201

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5840
  • Thank you received: 347
  • Karma: 261
This can be changed at the php.ini file which configures your webserver. Restart the server after having changed this setting.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

comfort update memory problem 5 years 5 months ago #47308

  • chrissmit
  • chrissmit's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 18
  • Karma: -1
Hi all,

I run into the same problem (the exact message is:
"Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 16314223 bytes) in /mounted-storage/home66a/sub001/sc23859-VLLI/culturematters.com/cmsurvey/admin/update/updater.php on line 413").

Updating the php.ini file, can I do that myself? or does my host have to do this?
If I can do this myself, where is that file located?

thx
Chris
Thanks,

Chris

No links in the footer please.
The administrator has disabled public write access.

comfort update memory problem 5 years 5 months ago #47309

  • chrissmit
  • chrissmit's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 18
  • Karma: -1
Hi all,

A quick addition to my previous post.

These lines I can find in my .htaccess file in the root of the folder where LS resides:

php_value memory_limit 64M

php_value upload_max_filesize 128M

This should be enough, no?

would appreciate any help.

thx
Thanks,

Chris

No links in the footer please.
The administrator has disabled public write access.

comfort update memory problem 5 years 5 months ago #47312

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 8218
  • Thank you received: 1122
  • Karma: 333
Maybe you can put :
php_value memory_limit 256M

?
The administrator has disabled public write access.

comfort update memory problem 5 years 5 months ago #47318

  • chrissmit
  • chrissmit's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 18
  • Karma: -1
Hi all,

I've updated the memory size to 256M, but did not solve the issue...

any other suggestions?
Thanks,

Chris

No links in the footer please.
The administrator has disabled public write access.

comfort update memory problem 5 years 5 months ago #47330

  • andiliebl
  • andiliebl's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 15
  • Karma: 1
Hi,

after changing php.ini and config-defaults.php it works at my computer. Maybe you can check the memory limit in config-defaults. Just search for memorylimit in config-defaults and check the value. If low, increase it.

Good luck
The administrator has disabled public write access.

comfort update memory problem 5 years 5 months ago #47341

  • mdekker
  • mdekker's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 343
  • Thank you received: 68
  • Karma: 38
Probably you are not allowed to change the memory limit or your server does not have more memory available.

Check the phpinfo from the settings page to see if the memory limit was changed. In the limesurvey config-defaults.php is a line that sets the limit to 32mb if I am correct, don't forget to update that line too.
---
Menno Dekker
The administrator has disabled public write access.

comfort update memory problem 5 years 5 months ago #47355

  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 919
  • Thank you received: 131
  • Karma: 96
Please have a look at bugs.limesurvey.org/view.php?id=4557 for a solution and tell us if that helped.
Best regards

Carsten Schmitz
LimeSurvey project leader
The administrator has disabled public write access.

comfort update memory problem 5 years 5 months ago #47406

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 8218
  • Thank you received: 1122
  • Karma: 333
c_schmitz wrote:
Please have a look at bugs.limesurvey.org/view.php?id=4557 for a solution and tell us if that helped.
A french user had the same problem and the patch work :)
The administrator has disabled public write access.

[SOLVED] Re:comfort update memory problem 5 years 5 months ago #47425

  • chrissmit
  • chrissmit's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 18
  • Karma: -1
Hi all,

Yes!, got it solved.

The patched updater.php file did the trick.

Thanks for all your help!
Thanks,

Chris

No links in the footer please.
The administrator has disabled public write access.

[SOLVED] Re:comfort update memory problem 5 years 5 months ago #47440

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5840
  • Thank you received: 347
  • Karma: 261
You're welcome!

If our hints have been helpful and you enjoy limesurvey please consider a donation to the team .
We do all this in our free time and you don't have to pay a penny for this software.

Without your help we can't keep this project alive.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

comfort update memory problem 4 years 8 months ago #61067

  • jeantoul
  • jeantoul's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
I did an update from 1.87 to 1.91 and comfort update just stalls on the installation screen. This is what I see below:

It was working with some php warnings before the update, so I am wondering what the problem could be. I've change the memory to 128M and it doesn't appear to be timing out, so there seems to be another problem.
SQL command failed: ALTER TABLE `lime_questions` ADD `parent_qid` integer NOT NULL default '0' Reason: Duplicate column name 'parent_qid'

SQL command failed: ALTER TABLE `lime_answers` ADD `scale_id` tinyint NOT NULL default '0' Reason: Duplicate column name 'scale_id'

SQL command failed: ALTER TABLE `lime_questions` ADD `scale_id` tinyint NOT NULL default '0' Reason: Duplicate column name 'scale_id'

SQL command failed: ALTER TABLE `lime_questions` ADD `same_default` tinyint NOT NULL default '0' COMMENT 'Saves if user set to use the same default value across languages in default options dialog' Reason: Duplicate column name 'same_default'
.
SQL command failed: CREATE TABLE `lime_defaultvalues` ( `qid` int(11) NOT NULL default '0', `scale_id` int(11) NOT NULL default '0', `sqid` int(11) NOT NULL default '0', `language` varchar(20) NOT NULL, `specialtype` varchar(20) NOT NULL default '', `defaultvalue` text, PRIMARY KEY (`qid` , `scale_id`, `language`, `specialtype`, `sqid` ) ) ENGINE=myISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci Reason: Table 'lime_defaultvalues' already exists
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
The administrator has disabled public write access.

comfort update memory problem 4 years 8 months ago #61292

  • Nickko
  • Nickko's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 2654
  • Thank you received: 343
  • Karma: 77
I have the same problem but the files is different, is dumpdp.php.

Fatal error: Out of memory (allocated 23855104) (tried to allocate 7376488 bytes) in /homepages/25/d144922175/htdocs/limesurvey/admin/dumpdb.php on line 151

My server is limited to 32M of memory. I can't change this.

I have try the updated updater.php but the problem still.
Nickko
Ergonome / Usability expert
Last Edit: 4 years 8 months ago by Nickko.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.262 seconds