{"id":18704189,"date":"2025-11-02T19:03:50","date_gmt":"2025-11-02T19:03:50","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/problem-uploading-gedcom\/"},"modified":"2025-11-02T19:04:46","modified_gmt":"2025-11-02T19:04:46","slug":"problem-uploading-gedcom","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/problem-uploading-gedcom\/","title":{"rendered":"Problem uploading GEDCOM"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">After installation, while I was able to upload a GEDCOM file, no one was being added to the database. Indeed, none of the GEDSHOW tables even existed in the database.  I found that MySQL was throwing errors when trying to create the &#8216;_gedshow_names&#8217; table.  The errors were 1074 &#8211; Column length too big for column &#8216;note&#8217; (max = 16383) and 1118 &#8211; Row size too large.  Changing the <code>note<\/code> field to VARCHAR(1000) solved the problem. Using phpmyAdmin, I manually created the table:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>CREATE TABLE [prefix]_gedshow_names (<br \/>id int NOT NULL AUTO_INCREMENT,<br \/>indref VARCHAR(22) NOT NULL,<br \/>given VARCHAR(100),<br \/>surname VARCHAR(100),<br \/>gender VARCHAR(1) NOT NULL DEFAULT 'U',<br \/>living VARCHAR(1) NOT NULL DEFAULT 'Y',<br \/>dob VARCHAR(35),<br \/>dod VARCHAR(35),<br \/>note VARCHAR(1000),<br \/>UNIQUE KEY id (id)<br \/>) COLLATE = 'utf16_general_ci';<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I also had to manually update wp-config.php to add this line:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>define('ALLOW_UNFILTERED_UPLOADS', true);<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After uploading the file successfully, I deleted this line from wp-config for security.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This may be helpful to others.  <\/p>\n","protected":false},"template":"","class_list":["post-18704189","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18704189","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18704189\/revisions"}],"predecessor-version":[{"id":18704192,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18704189\/revisions\/18704192"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=18704189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}