schemas/public_.sql: geoscrub_input_view_modify(): add unique constraint on the same columns as geoscrub.geoscrub_output, as a sanity check to assist future debugging

bugfix: schemas/postgresql.conf: need to set extra_float_digits = 3 (the maximum) to enable verbatim export. this should fix issue #955.

added inputs/CVS/verify/Review of CVS data in BIEN3-RKP2014Sept7.docx from Bob

added config/dev_machine/com.apple.PowerManagement.plist from /Library/Preferences/SystemConfiguration/com.apple.PowerManagement.plist , so that this file can be easily restored when the system spuriously resets settings in it

/README.TXT: To re-run geoscrubbing: updated runtimes. note that these are faster on the new hardware.

fix: /README.TXT: To re-run geoscrubbing: `rm=1 inputs/.geoscrub/geoscrub_output/geoscrub.csv.run`: use a subshell to avoid closing screen on errexit

fix: /README.TXT: Single datasource refresh: also back up DB after this

/README.TXT: datasource removal: documented bien2_traits runtime

added inputs/bien2_traits/_no_import since bien2_traits has been replaced by Cyrille_traits

/README.TXT: added datasource removal instructions

fix: /README.TXT: Single datasource refresh: place updated extract: generalized datasrc name

added inputs/Cyrille_traits/

lib/sql_io.py: null_strs: added N/A and NA (this will remove a common abbr for North America, but we don't use the continent, so this is OK)

mappings/VegCore.htm: regenerated from wiki. made verbatimLocality a synonym of locality since they are used to store the same data.

bugfix: schemas/util.sql: col_rename(): also need to run util.name_truncate() on the names used in the "don't try to rename to itself" comparison

fix: schemas/util.sql: col_rename(): don't try to rename a column to itself (this will cause an error)

schemas/util.sql: set_col_names(): use util.col_rename() so that all renames uses this function

schemas/util.sql: added col_rename()

schemas/util.sql: added quote_ident() wrapper

schemas/util.sql: added name_truncate()

fix: inputs/input.Makefile: $(nonHeaderSrcs): updated to exclude new header.txt

lib/runscripts/table.run: added check_headers()

bugfix: lib/runscripts/table.run: srcs: missing []

lib/runscripts/table.run: added header() and use it in header.txt()

lib/runscripts/table.run: 1st_src(): use a variable for this instead, to avoid needing to run this function each time it's used, and to make @srcs available

lib/sh/util.sh: wildcard.(): clarified that it only removes . .. when at then beginning of the list

fix: schemas/public_.sql: view_full_occurrence_individual_view: materialize time: updated revision

schemas/public_.sql: view_full_occurrence_individual_view: materialize time: updated (2 days)

web/links/index.htm: updated to Firefox bookmarks: added bash shellshock links. LibreOffice: added steps to convert files from the command line.

lib/runscripts/table.run: added header.txt()

lib/runscripts/table.run: added 1st_src()

inputs/input.Makefile: added %/list_srcs

lib/runscripts/subdir.run: subdir_make(): use new $datasrc_dir

lib/runscripts/subdir.run: added $datasrc_dir

lib/sh/make.sh: make(): added support for $output_data mode which uses --silent

fix: lib/sh/util.sh: already_exists_msg(): changed calling convention to avoid it seeming like `return 0` is run if already_exists_msg() throws an error, when in fact already_exists_msg() is just a command that should be run before returning/errexiting

fix: inputs/input.Makefile: need to escape $ in commands, including inside comments

bugfix: lib/common.Makefile: $(wildcard/): need final pass with $(wildcard) to support inputs without wildcard chars

bugfix: inputs/input.Makefile: `$(call add*,$(svnFiles))` must be invoked externally to clear the $(wildcard) cache before expanding $(svnFiles)

/README.TXT: Installation: added instructions for inputs/download/live prompts

/README.TXT: Installation: added instructions for MySQL installation prompts

fix: /README.TXT: Installation: "Are you sure you want to continue connecting" prompt comes before "aaronmk@jupiter's password" prompt

/Makefile: phppgadmin-Linux: removed no longer needed $(editApacheConfForPhppgadmin), as phpPgAdmin no longer uses this file (/etc/phppgadmin/apache.conf)

/Makefile: phppgadmin-Linux: removed no longer needed $(editPhppgadminApacheConf)

/Makefile: misc-Linux: added htop

/Makefile: misc-Linux: added jedit

/Makefile: postgres-Linux: added pgadmin3

bugfix: /Makefile: $(postgresReload-*) calls: do not prepend $(MAKE) or - because these are multi-command functions

bugfix: /Makefile: $(bien*Password): need to use = instead of := because these files are not available until config/download/live has run

fix: /README.TXT: Installation: added instructions for "aaronmk@jupiter's password" prompt

/README.TXT: Installation: added step to open a terminal window

fix: /README.TXT: Installation: added instructions for "Are you sure you want to continue connecting" prompt

inputs/VegBank/run*.log: updated. this adds the function call context in addition to the function location.

bugfix: /Makefile: $(uutils_install): need to exit after printing instructions instead of continuing

fix: /README.TXT: Installation: need instructions for "reload PATH" prompt

fix: /README.TXT: Installation: `apt-get install subversion`: need --yes

bugfix: /Makefile: bin/install: uutils: need to reopen terminal window before can proceed with other installation steps

/Makefile: python-Linux: removed no longer used installation of pp (Parallel Python). we use Python's multiprocessing package instead.

bugfix: /Makefile: install: must be config/download/live, not config/download

README.TXT: bin/sync_upload calls as root: don't need to set $USER because this is now set to the correct value in bin/sync_upload's scripts

bugfix: lib/sh/local.sh: $sync_remote_url: jupiter user is always aaronmk, not the local user

*{.sh,run}: use standard WARNING syntax for warning labels

bugfix: /Makefile: bin/install: also need to install uutils

*{.sh,run}: use standard WARNING syntax for warning labels

fix: lib/sh/util.sh: verbosity_compat(): documented that this should not be run until right before executing an external command, so that it doesn't mess up the logging mechanism

bugfix: bin/make: don't run verbosity_compat until right before executing the external command, so that it doesn't mess up the logging mechanism. this is run automatically by command(), so there is no need to do anything here. note that logging bugs like these can now be troubleshooted much more easily with pst() to narrow down which functions could be causing the problem.

bugfix: lib/sh/util.sh: functions called by pst(): commented out/removed logging calls that would have caused infinite recursion when pst()'ing a logging function

lib/sh/util.sh: echo_func(): get call context before wrapper(s), which is more useful for debugging. this uses skip_stack_frames()'s lookahead=1 mode.

fix: lib/sh/util.sh: skip_stack_frames() callers: updated for new skip_stack_frames rather than get_stack_frame behavior

lib/sh/util.sh: skip_stack_frames(): added lookahead support, which looks at entry after current to deterine whether to skip current. this is useful for skipping wrappers, by looking at the calling function's name.

fix: lib/sh/util.sh: skip_stack_frames(): for new skip_stack_frames rather than get_stack_frame behavior, stack frames must be skipped in the caller to preserve the stack frame pointer

lib/sh/util.sh: get_stack_frame_after(): renamed to skip_stack_frames() for clarity

lib/sh/util.sh: added skip_stack_frame_in_caller, unskip_stack_frame_in_caller

lib/sh/util.sh: added prev_stack_frame

lib/sh/util.sh: echo_func(): use new format_stack_frame, which adds call context information to what was provided by func_loc

fix: lib/sh/util.sh: format_stack_frame(): need to hide canon_rel_path() info using log+

lib/sh/util.sh: added get_stack_frame_after()

lib/sh/util.sh: added matches()

lib/sh/util.sh: next_stack_frame: documented usage

fix: lib/runscripts/util.run: runscript template: all(): moved example commands to target(), where they would more likely be located

lib/sh/util.sh: format_stack_frame(): support including args

lib/sh/util.sh: debugging: added pst() (print_stack_trace)

lib/sh/util.sh: added stack_trace(), print_stack_trace()

lib/sh/util.sh: added format_stack_frame()

lib/sh/util.sh: added get_stack_frame() and helpers

lib/sh/util.sh: terminal: moved before errors so it can be used by it

lib/sh/util.sh: errors, debugging: moved after datatype sections so their functions can use these

bugfix: lib/sh/util.sh: canon_rel_path() stub: proper no-op requires passing through original path

lib/sh/util.sh: canon_rel_path(): fall back to original path if can't resolve, instead of errexiting

bugfix: lib/sh/util.sh: canon_rel_path(): don't re-localize $path because this clears it

lib/sh/util.sh: canon_rel_path(): import $1 to $path before function body, so that the function body can be moved to a nested function

lib/sh/util.sh: added canon_rel_path() stub for use by debugging functions

bugfix: /Makefile: install: run bin/install first since config/download depends on it

lib/sh/util.sh: moved func_loc() to before debugging section so it can be used by debugging functions

bugfix: lib/sh/util.sh: command__exec(): need to restore $verbosity before calling die_e

bugfix: /Makefile: install: also need to run config/download to get the necessary passwords

config/Makefile: added download target

/Makefile: config: renamed to bin/install because config is the name of a directory

/README.TXT: Installation: `make install`: added instructions for what to do at each prompt

/README.TXT: Installation: Check out svn: need to install svn first as this does not come preinstalled on Ubuntu