Page 1 of 1
memory size error in listcontent.php
Posted: Sun Jul 12, 2009 10:38 pm
by henris
Hello,
I restored a database with mysql dump and now when I connect to content > pages I get:
"Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 264085 bytes) in /home/content/b/e/r/berika/html/admin/listcontent.php on line 960"
Apparently the front is ok, but impossible to edit it further on. Any idea ?
Henris
Re: memory size error in listcontent.php
Posted: Mon Jul 13, 2009 12:03 am
by viebig
thats a lot of memory....
cmsms version?
anyway... try to raise the php memory limit and check if everything is ok
Regards
G
Re: memory size error in listcontent.php
Posted: Mon Jul 13, 2009 5:11 pm
by Pierre M.
System Info...?
64M can't list your pages ? How many thousands pages has your site ?
Pierre M.
Re: memory size error in listcontent.php
Posted: Tue Jul 14, 2009 6:33 am
by henris
The problem is that the message is "wrong", the site has a lot of pages it is true, but worked normally, with a PHP set to 8M limit.. I have put it on a local server and increased the memeorylimit way above 100M, whatever the increase, the same message appeared (with different requested memory size)
I think there must be something with EOF tags or some component blocking it... such... not with the size of the data,. On a certain moment I deleted the Users (accordiong to another post) and it was working ok, but now the error is coming again and the website cannot be edited.
@ Viebig : CMS version was 1.06 is now 1.54
Henri
Re: memory size error in listcontent.php
Posted: Wed Jul 15, 2009 5:01 pm
by viebig
well... I´m confused.. what the original version, the one that you dump the database? can you explin step by step what you did to get this error.. for example
Eg.
1. Dumped database from CMSMS version x with modules a,b,c,d and module versions x,x,x,x
2 Restored database to cmsms version x, or Upgrade cmsms to version y on a linux server,
Regards
G
Re: memory size error in listcontent.php
Posted: Thu Jul 16, 2009 1:29 pm
by Pierre M.
Now than you are almost running supported 1.6.x instead of pre-1.4.x please discover System Info and System checksum.
Pierre M.
Re: memory size error in listcontent.php
Posted: Fri Jul 17, 2009 11:16 pm
by henris
Thanks for your help.
Even when running back on 1.06 Nihau version I get the same error (it's 1.06 not 1.6.)
What I did ?
The server went down we recuperated the database sql files. reinstalled everything in version 1.06. The database server changed name: we modified config.php accordingly. The front is working ok, but content>page give this error.
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 263813 bytes) in /home/content/b/e/r/berika/html/admin/listcontent.php on line 893
We followed some advice on this forum and erased some users (??) cleared the cache and sporadically we could see the pages, but then no more. Now we cannot and I cannot reproduce the procedure we used when it worked. I backed up the datas with mysql dump module. Tried in 1.5 version and even 1.6 but no success. We tried 1.06 on our local server, where we can raise the memory to whatever we like, but still this isn't helping. So now we have at
www.globamundus.com awebsite where it is impossible to change anything
So I beg you for my client... do you have an idea how to correct this. My guess is that the first backup, missed some EOF tags or such, which brings the data in some loop.
SQL files are 1.613.492 bytes long.
Regards
Henri
Re: memory size error in listcontent.php
Posted: Mon Jul 20, 2009 2:17 am
by viebig
henris...
try to bring this site up locally... or in a testing server where you can manage the amount of memory... ok you did it.. but what was the output? (just to be sure if a infinite loop is the problem)
It will be impossible to help you since I didnt get what was the original first version that was working. Was it 1.06 ?
can you send me your listcontent.php ?
What did you mean with EOF tags, from where? How did you do this backup?
Regards
G
Re: memory size error in listcontent.php
Posted: Mon Jul 20, 2009 4:19 pm
by henris
@viebig. I put the site to local and pushed the php memory to 100 mb Istill got a memory overflow error message... but I will redo it. and tell you about. I think that this lay in a corrupt sql. The backup was done by the hosting company (they do this before closing a website... they did also the restore. of the sql (probably compressed) I restored it with phpmyadmin and later saved it and restored it via the mysqldump component.
In the listcontent.php (i cannot upload here apparently)
The incriminating line is
$thelist.=$item;
Code: Select all
#display_hierarchy($hierarchy, $userid, check_modify_all($userid), $templates, $users, $menupos, $openedArray, $pagelist, $image_true, $image_set_false, $image_set_true, $upImg, $downImg, $viewImg, $editImg, $deleteImg, $expandImg, $contractImg, $mypages, $page);
foreach ($pagelist as $item)
{
$thelist.=$item;
}
$thelist .= '<tr class="invisible"><td> </td><td> </td><td> </td>
<td> </td><td> </td><td> </td><td> </td><td> </td>
<td> </td><td><input type="submit" name="reorderpages" value="'.lang('reorderpages').'" /></td><td> </td><td> </td><td> </td><td> </td></tr>';