Import to Collections from Region timing out
I want to start by saying, "I know I messed up." I used Perch rather than Perch Runway to create a site that is very content heavy. I have now realized my mistake and upgraded to Perch Runway 3.
Prior to the upgrade, I was having an issue with content in a region duplicating itself. As of this afternoon, there were over 11,000 items in the content region. But my best guess is that is 5-8 times more than what is actually there because of the duplications. I called our host (GoDaddy); they optimized the database tables, but that duplicate information is still showing in the perch2_content_items database table.
Because of this massive amount of content (I believe this is the reason), I am unable to import the content into a Collection. It starts the process, but after 300 or so items it times out. Even if I were able to import the content, I need all those duplicates out of there, and I don't see a way to just click a bunch of checkboxes and delete multiple items at once. I am also unable to get into the region to do anything with it. I could earlier today but it wouldn't allow me to delete, save or do anything.
I exported my database before the upgrade, so I do have that. However, that still includes all the duplicate info. After calling GoDaddy back again they said they could TRY a "join syntax" for a mere $80. I'm not ready to do that just yet in case there is something I'm missing in Perch. Is there anything I can do? Anything at all? I am not very familiar with databases, phpMyAdmin, etc.
As a side note, when I went to get my diagnostics report to post, I noticed that the health check notes: "Temp folder is not writable. Check the path to your temp folder in your runway.php file and check permissions are set for PHP to write to it." I do not even see a file called runway.php to be able to update this information.
Perch Runway: 3.0.4, PHP: 5.4.45, MySQL: 5.6.35, with PDO Server OS: Linux, cgi-fcgi Installed apps: content (3.0.4), assets (3.0.4), categories (3.0.4), perch_events (1.9.3), perch_comments (1.2), perch_mailchimp (3.0.1) App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_comments', 'perch_events', 'perch_mailchimp', ); PERCH_LOGINPATH: /perch PERCH_PATH: /home/jstahr99/public_html/aroundptown2016/perch PERCH_CORE: /home/jstahr99/public_html/aroundptown2016/perch/core PERCH_RESFILEPATH: /home/jstahr99/public_html/aroundptown2016/perch/resources Image manipulation: GD Imagick PHP limits: Max upload 128M, Max POST 64M, Memory: 256M, Total max file upload: 64M F1: 0c66c2e1f82f9e0b7617b2cb8270f2c7 Resource folder writeable: Yes SCRIPT_NAME: /perch/core/settings/diagnostics/index.php REQUEST_URI: /perch/core/settings/diagnostics/ DOCUMENT_ROOT: /home/jstahr99/public_html/aroundptown2016 HTTP_HOST: aroundptown.com