Fatal Error when backing up [message #187478] |
Sun, 20 May 2018 20:02 |
Kermit
Messages: 35 Registered: November 2004
Karma: 0
|
Member |
|
|
Hi, I;m getting an error when trying to perform a forum dump since yesterday when my host server migrated from an older PHP and MySQL (iirc around v5.4 for both) to PHP v5.6.36 & MySQL v5.6.38.
I didn't get the error when it was on older versions of php/mysql. Error occuring on both 3.0.8RC which I was running yesterday (on the newer php/mysql) and now today when I've updated to 3.0.9 but dump always worked with 3.0.8RC (and earlier) on the older php and mysql.
Now I'm on newer servers, my PHP can now be updated to PHP 7.0 or 7.1 with a few clicks by the tech support. Will PHP 7.7,1 possibly resolve the issue?
Backup forum files:
... backup DATA_DIR/ (0 MB)
... backup WWW_ROOT_DISK/images/ (3.88 MB)
... backup WWW_ROOT_DISK/adm/ (0.68 MB)
Backup database tables:
... dump table fud30_action_log (108 rows)
... dump table fud30_ann_forums (14 rows)
... dump table fud30_announce (10 rows)
... dump table fud30_attach (259 rows)
... dump table fud30_avatar (0 rows)
... dump table fud30_blocked_logins (0 rows)
... dump table fud30_bookmarks (27 rows)
... dump table fud30_buddy (262 rows)
... dump table fud30_calendar (6 rows)
... dump table fud30_cat (3 rows)
... dump table fud30_custom_fields (1 rows)
... dump table fud30_custom_tags (0 rows)
... dump table fud30_email_block (0 rows)
... dump table fud30_ext_block (9 rows)
... dump table fud30_fc_view (19 rows)
... dump table fud30_forum (24 rows)
... dump table fud30_forum_notify (41 rows)
... dump table fud30_forum_read (9931 rows)
... dump table fud30_geoip (1 rows)
... dump table fud30_group_cache (69 rows)
... dump table fud30_group_members (68 rows)
... dump table fud30_group_resources (26 rows)
... dump table fud30_groups (27 rows)
... dump table fud30_index (8608491 rows)
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 65273816 bytes) in /home/hondafor/FUDforum/include/theme/default/db.inc on line 110
[Updated on: Sun, 20 May 2018 20:03] Report message to a moderator
|
|
|
|
Re: Fatal Error when backing up [message #187480 is a reply to message #187479] |
Sun, 20 May 2018 21:20 |
Kermit
Messages: 35 Registered: November 2004
Karma: 0
|
Member |
|
|
Thanks but they have raised the memory limit to 256M then 512M and still get the error.
the PHP is currently updated to v7.1 and the forum itself seems to be working fine but on going into administration, I get this error
Parse error: syntax error, unexpected 'function' (T_FUNCTION) in /home/hondafor/FUDforum/include/theme/default/db.inc on line 46
So I've asked them to put PHP back to 5.6.36 unless you have any ideas?
[Updated on: Sun, 20 May 2018 21:21] Report message to a moderator
|
|
|
Re: Fatal Error when backing up [message #187481 is a reply to message #187480] |
Sun, 20 May 2018 23:25 |
Kermit
Messages: 35 Registered: November 2004
Karma: 0
|
Member |
|
|
I've managed to resolve the T_FUNCTION error by setting PHP to 7.1 then re-running upgrade.php to 3.0.9 again (after clearing upgrade_status) and now the forum is fully functional except the backup still giving me error
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 65273816 bytes) in /home/hondafor/FUDforum/include/theme/default/db.inc on line 110
That said I can backup the lot with the hosts own backup system but it'd be nice to get this working as its the fudforum own backup I've always used
I've tried playing around with php.ini files
memory_limit = 128M (have tried it at 1024M)
post_max_size = 128M (tried 1024MB not sure what forum default should be)
upload_max_filesize - 128M (tried 1024M but set back to 128M now)
this is my basic PHP.ini settings atm
[Updated on: Sun, 20 May 2018 23:27] Report message to a moderator
|
|
|
Re: Fatal Error when backing up [message #187482 is a reply to message #187481] |
Tue, 22 May 2018 06:26 |
|
naudefj
Messages: 3771 Registered: December 2004
Karma: 28
|
Senior Member Administrator Core Developer |
|
|
Please try the following:
Open ../adm/admdump.php in a text editor and replace
@ini_set('memory_limit', '256M');
with
@ini_set('memory_limit', '-1');
PS: 65273816 bytes == 64M. This may be a limit imposed by your web server.
[Updated on: Tue, 22 May 2018 06:30] Report message to a moderator
|
|
|
Re: Fatal Error when backing up [message #187483 is a reply to message #187478] |
Tue, 22 May 2018 12:32 |
Kermit
Messages: 35 Registered: November 2004
Karma: 0
|
Member |
|
|
Hi,
I've tried
@ini_set('memory_limit', '-1');
but still get the same error so also tried
@ini_set('memory_limit', '128M'); & @ini_set('memory_limit', '64M'); to no avail.
looking in Admin -> System Info -> Detailed PHP Info -> Core section the local and master values of this setting are both 128M so was hoping that perhaps setting admdump.php to a value less than the 128M local and master would work.
memory_limit 128M 128M
Do you have any other ideas as I'm sure I or the host has raised the memory_limits above 128M which didn't seem to make any conerable difference?
[Updated on: Tue, 22 May 2018 12:33] Report message to a moderator
|
|
|
|
Re: Fatal Error when backing up [message #187486 is a reply to message #187484] |
Wed, 23 May 2018 18:44 |
Kermit
Messages: 35 Registered: November 2004
Karma: 0
|
Member |
|
|
Yes, same error with Local & Master showing 128M. Just tried again now and unticked the "Use Gzip Compression:" which I normally leave ticked just in case the extra burden of compression was playing a part.
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 10485768 bytes) in /home/hondafor/FUDforum/include/theme/default/db.inc on line 110
|
|
|