Fatal error uploading old Gedcom in 4.2.2
Brought to you by:
canajun2eh,
yalnifj
Menu
▾
▴
I have just upgraded to 4.2.2, and as a final step, reimported my Gedcom (which hasn't changed since successfully importing into 4.2.1). The import seemed to take much longer than in 4.2.1, and then I got:-
SQLSTATE: General error: 1 SQL logic error or missing database
SQLSTATE: General error: 7 out of memory
SQLSTATE: General error: 7 malformed database schema - out of memory
SQLSTATE: General error: 21 library routine called out of sequence
This line repeated many times, and then finally ended with:-
Fatal error: Out of memory (allocated 9175040) (tried to allocate 2048 bytes) in /homepages/14/xxxxxxxxxx/htdocs/mydomain/PhpGedView/includes/functions/functions_UTF8.php on line 248.
The memory limit is set to 32M in my config file. I have checked that PDO is ok and has drivers for sqlite. As everything was ok in 4.2.1 is there something I am missing in 4.2.2?
Yes, I'm afraid you're missing memory. If you increase the memory to at least 64MB the problem will go away.
But setting 32MB in config.php only works IF your web server's php.ini is set to at least that or higher. PGV can only use the highest of those two settings.
In your case that error message says you only have 9,175,040 bytes.
Ummm ….
"highest" --> "lower"
The memory limit configured by the people who set up the PHP system is taken as being an absolute limit. No PHP script may ever request more memory than this setting.
When the PHP configuration doesn't specify a memory limit, the default is 8 Mb.
Are you sure your server supports PDO? This is essential for PGV version 4.4.2.
Oops - quite right, I did mean to say
"PGV can only use the lowest of those two settings"
The master PHP config memory limit is 40M, although my config file is set to 32M. So I am not sure why it thinks there is a 9M limit.
Server definitely supports PDO. Data as follows:-
PDO Driver for SQLite 3.x enabled
PECL Module version (bundled) 1.0.1 $Id: pdo_sqlite.c, v 1.10.2.6.2.4 2008/12/31 11:17:42 sebastian Exp $
SQLite Library 3.3.7
I have now loaded a much smaller GEDCOM (16k, instead of 267k), which has gone through ok.
<<So I am not sure why it thinks there is a 9M limit>>
The default value for PHP is 8MB. Your value is 8.75MB. This small difference might be explained by implemenation details.
<<The master PHP config memory limit is 40M>>
Are you sure this limit is being applied? What value is shown in your phpinfo page?
On my PGV PHP info page (PHP 5.2.11) in the 'configuration' 'php core' section, there are 3 columns: Directive, Local Value, and Master value. On the line for 'memory_limit' it shows 32M and 40M respectively.
However, on the line for 'post_max_size' it shows 8M in both columns. Could this be where the problem is?
No - post_max_size is (related to) the maximum file upload size.
You are using sqlite. I don't have a great deal of experience with this DB. I suppose it could be possible that the memory used by it counts against your 32M limit, but doesn't appear in PHP's memory-used stats?
Have you tried increasing PGV's limit from 32M to 40M?
Hello Graham-
Just offering a suggestion that may help. Looks like you are on 1&1, so am I. I recently had problems getting my Ged to upload also. Although I specified the max. amount on the Config page, it still failed after MANY tries. (I was using a GED backup which was downloaded from another PGV install, so I know the data was not corrupt).
Here is my trick: 1) Disable all Pop-up blockers in your browser (I use IE8) by deactivating the Google and/or Yahoo! toolbars. 2) Lower your Timeout to 15 or 20 seconds and Turn OFF the "Press CONTINUE automatically" option in the GED upload screen. 3) Get your GED installed !
Don't know why, but mine ONLY worked with this combination after 10-12 previous tries. Your mileage may vary, but Good Luck.
RL
Increasing the memory limit to 40M made no difference.
Roland - you are right I am using 1&1. I am using Firefox, but did not need to disable anything. I just reduced the time out to 15 secs, turned off the continue automatically, and then had to press the continue button about 10 times while it uploaded in stages. This seems to have worked, but I will check more thoroughly tomorrow. Thanks!!
I have checked through most things, and they all seem ok. I re-uploaded my gedcom tonight, but had to reduce the time to 10 secs to get it to work.