> Receiving an error message when attempting to filter on a custom
> field. Any thoughts?
>
> ----------------------------------- ERROR MESSAGE
> -----------------------------------
>
> ------------------------------------------------------------
> Error message was:
> Unknown column 'ak_customfieldsettings.custom_3' in 'where clause'
The ak_customfieldsettings table was not set up by import.pl when you imported your voter file with custom data. You need to run the perl script "regeneratecustomfields.pl", which is located in the advokit-installer's utils folder. This copies your custom field data into a separate table that is used for filtering. (Note that if you edit voter data that is in a custom field, this table will not reflect the change. To synchronize, you need to run regeneratecustomfields.pl again. For this reason, it can be a good idea to set up a cron job to run it on a regular basis.)
As you did with import.pl, you will need to edit your database connection information in regeneratecustomfields.pl...
# ----------------------------------------------------------------------
# Configuration -- edit to suit you.
# ----------------------------------------------------------------------
my $CFG_DBHOST = 'localhost';
my $CFG_DBPORT = 3306;
my $CFG_DBNAME = 'ak';
my $CFG_DBUSER = 'root';
my $CFG_DBPASS = '';
my $CFG_DBPREFIX = 'ak_';
To run the script (as with voterfile import) you need shell access on your server. There are no command-line arguments. You can run this script by cd'ing to the utils folder and simply typing "perl regeneratecustomfields.pl" on your command line.