ERROR: column "race_option" does not exist LINE 1: SELECT count(*) AS count, race_option FROM race_entry WHERE ... ^
SELECT count(*) AS count, race_option FROM race_entry WHERE (status='paid' OR status='manual-entry') AND race_id='1' GROUP BY race_option
Variable:
Array
(
[0] => Array
(
[file] => /var/www/system-bootstrap/code/includes/db.inc
[line] => 62
[function] => _db_query
[args] => Array
(
[0] => SELECT count(*) AS count, race_option FROM race_entry WHERE (status='paid' OR status='manual-entry') AND race_id='1' GROUP BY race_option
)
)
[1] => Array
(
[file] => /var/www/system-bootstrap/code/includes/db.inc
[line] => 312
[function] => db_query
[args] => Array
(
[0] => SELECT count(*) AS count, race_option FROM race_entry WHERE (status='paid' OR status='manual-entry') AND race_id='1' GROUP BY race_option
[1] => 1
)
)
[2] => Array
(
[file] => /var/www/system-bootstrap/code/includes/db.inc
[line] => 300
[function] => get_cacheable
[args] => Array
(
[0] => SELECT count(*) AS count, race_option FROM race_entry WHERE (status='paid' OR status='manual-entry') AND race_id=? GROUP BY race_option
[1] => Array
(
[0] => SELECT count(*) AS count, race_option FROM race_entry WHERE (status='paid' OR status='manual-entry') AND race_id=? GROUP BY race_option
[1] => 1
)
[2] => race-entry-count-1
[3] => 3600
[4] => 1
)
)
[3] => Array
(
[file] => /var/www/system-bootstrap/code/modules/raceentry.module
[line] => 1439
[function] => get_cacheable_list
[args] => Array
(
[0] => SELECT count(*) AS count, race_option FROM race_entry WHERE (status='paid' OR status='manual-entry') AND race_id=? GROUP BY race_option
[1] => Array
(
[0] => 1
)
[2] => race-entry-count-1
)
)
[4] => Array
(
[file] => /var/www/system-bootstrap/code/modules/raceentry.module
[line] => 2376
[function] => _raceentry_get_count
[args] => Array
(
[0] => 1
)
)
[5] => Array
(
[file] => /var/www/system-bootstrap/code/modules/raceentry.module
[line] => 2366
[function] => raceentry_load_race
[args] => Array
(
[0] => 1
)
)
[6] => Array
(
[file] => /var/www/system-bootstrap/code/modules/raceentry.module
[line] => 249
[function] => _raceentry_load_race
[args] => Array
(
[0] => 1
)
)
[7] => Array
(
[file] => /var/www/system-bootstrap/code/includes/core.inc
[line] => 338
[function] => raceentry
[args] => Array
(
)
)
[8] => Array
(
[file] => /var/www/system-bootstrap/code/includes/core.inc
[line] => 158
[function] => module_build_page
[args] => Array
(
[0] => race/entry/1
)
)
[9] => Array
(
[file] => /var/www/system-bootstrap/code/includes/core.inc
[line] => 66
[function] => do_page
[args] => Array
(
)
)
[10] => Array
(
[file] => /var/www/strugglers/web/index.php
[line] => 33
[function] => request_process
[args] => Array
(
)
)
)
ERROR: column "racetime" does not exist LINE 1: ...ntry_id FROM race_entry WHERE race_id='1' AND NOT racetime i... ^ HINT: Perhaps you meant to reference the column "race_entry.race_id".
SELECT race_entry_id FROM race_entry WHERE race_id='1' AND NOT racetime is null and (status='paid' or status='manual-entry') LIMIT 1
Variable:
Array
(
[0] => Array
(
[file] => /var/www/system-bootstrap/code/includes/db.inc
[line] => 62
[function] => _db_query
[args] => Array
(
[0] => SELECT race_entry_id FROM race_entry WHERE race_id='1' AND NOT racetime is null and (status='paid' or status='manual-entry') LIMIT 1
)
)
[1] => Array
(
[file] => /var/www/system-bootstrap/code/includes/db.inc
[line] => 312
[function] => db_query
[args] => Array
(
[0] => SELECT race_entry_id FROM race_entry WHERE race_id='1' AND NOT racetime is null and (status='paid' or status='manual-entry') LIMIT 1
[1] => 1
)
)
[2] => Array
(
[file] => /var/www/system-bootstrap/code/modules/raceentry.module
[line] => 2396
[function] => get_cacheable
[args] => Array
(
[0] => SELECT race_entry_id FROM race_entry WHERE race_id=? AND NOT racetime is null and (status='paid' or status='manual-entry') LIMIT 1
[1] => Array
(
[0] => SELECT race_entry_id FROM race_entry WHERE race_id=? AND NOT racetime is null and (status='paid' or status='manual-entry') LIMIT 1
[1] => 1
)
[2] => race-has-results-1
)
)
[3] => Array
(
[file] => /var/www/system-bootstrap/code/modules/raceentry.module
[line] => 2377
[function] => raceentry_race_has_results
[args] => Array
(
[0] => 1
)
)
[4] => Array
(
[file] => /var/www/system-bootstrap/code/modules/raceentry.module
[line] => 2366
[function] => raceentry_load_race
[args] => Array
(
[0] => 1
)
)
[5] => Array
(
[file] => /var/www/system-bootstrap/code/modules/raceentry.module
[line] => 249
[function] => _raceentry_load_race
[args] => Array
(
[0] => 1
)
)
[6] => Array
(
[file] => /var/www/system-bootstrap/code/includes/core.inc
[line] => 338
[function] => raceentry
[args] => Array
(
)
)
[7] => Array
(
[file] => /var/www/system-bootstrap/code/includes/core.inc
[line] => 158
[function] => module_build_page
[args] => Array
(
[0] => race/entry/1
)
)
[8] => Array
(
[file] => /var/www/system-bootstrap/code/includes/core.inc
[line] => 66
[function] => do_page
[args] => Array
(
)
)
[9] => Array
(
[file] => /var/www/strugglers/web/index.php
[line] => 33
[function] => request_process
[args] => Array
(
)
)
)
Castle Hill Corker
