The automated job function of the Geocode Dealer Locator Addresses is stuck on RUN

Permalink Browser Info Environment
I'm running the automated job function of the Geocode Dealer Locator Addresses and it's stuck in running mode. It's been stuck for several days. I only run the geocode finder after I upload a CSV list, which is only every several months.

Secondly, what is the difference between the 2 import methods:
Replace existing contacts in this directory with csv file
Append this csv file to the contacts in this directory

If I select REPLACE does it delete all previous uploads? I've always only APPENDed files.

Type: Discussion
Status: In Progress
carolanderson
View Replies:
andrew replied on at Permalink Reply 1 Attachment
andrew
It's likely that something about the data itself is causing the job to not complete. It appears to be running, but that's simply because something has interrupted it and not given it the ability to mark itself as finished. First, cancel the job by clicking the "Reset All Jobs" button (see the attached screenshot.) Then, try running the job again.

If the job doesn't complete after staying on the page for several minutes, there may be something about your data that's causing the job to get stuck. To debug what this might be, click the automate button next to the Geocode Job (see the attached screenshot.) This will give you a URL that you can use to directly run the job. Click the URL in the screenshot (it will look likehttp://yoursite.com/index.php/tools/required/jobs/run_single?auth=6... . Add &debug=1 to the end of the URL, and paste it in a new browser window. This will run the job, and show any errors that come with it. If you're still having trouble and this results in some errors showing up, you can post them here and we'll try and look at them.

To answer your second question: choosing "append" adds records to the list, and does not touch any existing records. Choosing "replace" deletes all records, replacing the entire contents of the dealer directory with the contents of the CSV file.

concrete5 Environment Information

# concrete5 Version
5.6.3.1

# concrete5 Packages
Blueberry Image Slider (1.3), Breadcrumbs (2.0), Dealer Locator (1.5), Easy News (1.1), Gallery (1.8.1), Skyline (0.9.6), Sortable Fancybox Gallery (1.17), Soul Mate (1.02), Tweetcrete (1.6.8), Whitespace Theme (1.2).

# concrete5 Overrides
themes/skyline_custom

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - Off

# Server Software
Apache

# Server API
cgi-fcgi

# PHP Version
5.3.2-1ubuntu4.30

# PHP Extensions
ADOdb, apc, bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, json, libxml, mbstring, mcrypt, mhash, mysql, mysqli, openssl, pcre, PDO, pdo_mysql, Phar, posix, pspell, Reflection, session, shmop, SimpleXML, soap, sockets, SPL, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, zip, zlib.

# PHP Settings
max_execution_time - 30
apc.max_file_size - 1M
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 30M
safe_mode - Off
safe_mode_exec_dir - <i>no value</i>
safe_mode_gid - Off
safe_mode_include_dir - <i>no value</i>
sql.safe_mode - Off
upload_max_filesize - 20M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 100000
pcre.recursion_limit - 100000
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
safe_mode_allowed_env_vars - PHP_
safe_mode_protected_env_vars - LD_LIBRARY_PATH

Browser User-Agent String

Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.