An error occurred in script '/home/claudebu/public_html/print_open_confirmation_sheet.php' on line 113:
Undefined variable: open_id
Date/Time: 2-8-2012 19:55:27
Array
(
[GLOBALS] => Array
*RECURSION*
[_ENV] => Array
(
[DOCUMENT_ROOT] => /home/claudebu/public_html
[GATEWAY_INTERFACE] => CGI/1.1
[HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_CACHE_CONTROL] => no-cache
[HTTP_CONNECTION] => close
[HTTP_COOKIE] => PHPSESSID=4f7cdbdba164326549227aff03e933b7
[HTTP_HOST] => www.midkentgolfclub.co.uk
[HTTP_PRAGMA] => no-cache
[HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
[HTTP_X_CC_ID] => ccc01-01
[PATH] => /bin:/usr/bin
[QUERY_STRING] =>
[REDIRECT_STATUS] => 200
[REMOTE_ADDR] => 38.107.179.210
[REMOTE_PORT] => 50670
[REQUEST_METHOD] => GET
[REQUEST_URI] => /print_open_confirmation_sheet.php
[SCRIPT_FILENAME] => /home/claudebu/public_html/print_open_confirmation_sheet.php
[SCRIPT_NAME] => /print_open_confirmation_sheet.php
[SERVER_ADDR] => 188.64.188.21
[SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
[SERVER_NAME] => www.midkentgolfclub.co.uk
[SERVER_PORT] => 80
[SERVER_PROTOCOL] => HTTP/1.1
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[UNIQUE_ID] => TzLTL7xAvBUAAGidx3oAAAAC
)
[HTTP_ENV_VARS] => Array
(
[DOCUMENT_ROOT] => /home/claudebu/public_html
[GATEWAY_INTERFACE] => CGI/1.1
[HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_CACHE_CONTROL] => no-cache
[HTTP_CONNECTION] => close
[HTTP_COOKIE] => PHPSESSID=4f7cdbdba164326549227aff03e933b7
[HTTP_HOST] => www.midkentgolfclub.co.uk
[HTTP_PRAGMA] => no-cache
[HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
[HTTP_X_CC_ID] => ccc01-01
[PATH] => /bin:/usr/bin
[QUERY_STRING] =>
[REDIRECT_STATUS] => 200
[REMOTE_ADDR] => 38.107.179.210
[REMOTE_PORT] => 50670
[REQUEST_METHOD] => GET
[REQUEST_URI] => /print_open_confirmation_sheet.php
[SCRIPT_FILENAME] => /home/claudebu/public_html/print_open_confirmation_sheet.php
[SCRIPT_NAME] => /print_open_confirmation_sheet.php
[SERVER_ADDR] => 188.64.188.21
[SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
[SERVER_NAME] => www.midkentgolfclub.co.uk
[SERVER_PORT] => 80
[SERVER_PROTOCOL] => HTTP/1.1
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[UNIQUE_ID] => TzLTL7xAvBUAAGidx3oAAAAC
)
[_POST] => Array
(
)
[HTTP_POST_VARS] => Array
(
)
[_GET] => Array
(
)
[HTTP_GET_VARS] => Array
(
)
[_COOKIE] => Array
(
[PHPSESSID] => 4f7cdbdba164326549227aff03e933b7
)
[HTTP_COOKIE_VARS] => Array
(
[PHPSESSID] => 4f7cdbdba164326549227aff03e933b7
)
[_SERVER] => Array
(
[DOCUMENT_ROOT] => /home/claudebu/public_html
[GATEWAY_INTERFACE] => CGI/1.1
[HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_CACHE_CONTROL] => no-cache
[HTTP_CONNECTION] => close
[HTTP_COOKIE] => PHPSESSID=4f7cdbdba164326549227aff03e933b7
[HTTP_HOST] => www.midkentgolfclub.co.uk
[HTTP_PRAGMA] => no-cache
[HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
[HTTP_X_CC_ID] => ccc01-01
[PATH] => /bin:/usr/bin
[QUERY_STRING] =>
[REDIRECT_STATUS] => 200
[REMOTE_ADDR] => 38.107.179.210
[REMOTE_PORT] => 50670
[REQUEST_METHOD] => GET
[REQUEST_URI] => /print_open_confirmation_sheet.php
[SCRIPT_FILENAME] => /home/claudebu/public_html/print_open_confirmation_sheet.php
[SCRIPT_NAME] => /print_open_confirmation_sheet.php
[SERVER_ADDR] => 188.64.188.21
[SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
[SERVER_NAME] => www.midkentgolfclub.co.uk
[SERVER_PORT] => 80
[SERVER_PROTOCOL] => HTTP/1.1
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[UNIQUE_ID] => TzLTL7xAvBUAAGidx3oAAAAC
[PHP_SELF] => /print_open_confirmation_sheet.php
[REQUEST_TIME] => 1328730927
[argv] => Array
(
)
[argc] => 0
)
[HTTP_SERVER_VARS] => Array
(
[DOCUMENT_ROOT] => /home/claudebu/public_html
[GATEWAY_INTERFACE] => CGI/1.1
[HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_CACHE_CONTROL] => no-cache
[HTTP_CONNECTION] => close
[HTTP_COOKIE] => PHPSESSID=4f7cdbdba164326549227aff03e933b7
[HTTP_HOST] => www.midkentgolfclub.co.uk
[HTTP_PRAGMA] => no-cache
[HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
[HTTP_X_CC_ID] => ccc01-01
[PATH] => /bin:/usr/bin
[QUERY_STRING] =>
[REDIRECT_STATUS] => 200
[REMOTE_ADDR] => 38.107.179.210
[REMOTE_PORT] => 50670
[REQUEST_METHOD] => GET
[REQUEST_URI] => /print_open_confirmation_sheet.php
[SCRIPT_FILENAME] => /home/claudebu/public_html/print_open_confirmation_sheet.php
[SCRIPT_NAME] => /print_open_confirmation_sheet.php
[SERVER_ADDR] => 188.64.188.21
[SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
[SERVER_NAME] => www.midkentgolfclub.co.uk
[SERVER_PORT] => 80
[SERVER_PROTOCOL] => HTTP/1.1
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[UNIQUE_ID] => TzLTL7xAvBUAAGidx3oAAAAC
[PHP_SELF] => /print_open_confirmation_sheet.php
[REQUEST_TIME] => 1328730927
[argv] => Array
(
)
[argc] => 0
)
[_FILES] => Array
(
)
[HTTP_POST_FILES] => Array
(
)
[_REQUEST] => Array
(
[PHPSESSID] => 4f7cdbdba164326549227aff03e933b7
)
[page_title] => Print Open Confirmation Sheet (L)
[increment_version] => Y
[mod_comments] =>
[referer] => HTTP_REFERER not set.
[dev] =>
[live] =>
[email] => tcbuttle@btinternet.com
[dbc] => Resource id #5
[module_name] => print_open_confirmation_sheet.php
[querya] => SELECT version FROM module WHERE (module_name = 'print_open_confirmation_sheet.php')
[resulta] => Resource id #6
[rowa] => Array
(
[version] => 64
)
[vn] => 65
[url] => http://www.midkentgolfclub.co.uk
[baseurl] => http://www.midkentgolfclub.co.uk
[HTTP_SESSION_VARS] => Array
(
)
[_SESSION] => Array
(
)
[fname] =>
[css_path] =>
[css_print_path] =>
[writer] =>
[admin] => 0
[a] => td-even
[b] => td-odd
[c] => style="color:rgb(119,136,153,"
[tbclass] => td-even
[_vets] => Array
(
[0] => Array
(
[vet_id] =>
[surname] =>
[initials] =>
[handicap] =>
[active] =>
[year_paid] =>
[forename] =>
[comment] =>
[telephone_no] =>
[guest] =>
)
)
[vets] => Array
(
[0] => Array
(
[vet_id] =>
[surname] =>
[initials] =>
[forename] =>
[handicap] =>
[active] =>
[year_paid] =>
)
)
[open_teams] => Array
(
[0] => Array
(
[vets_open_team_id] =>
[vets_open_team_name] =>
[vets_open_id] =>
[contact_id] =>
[host_id] =>
[tee] =>
[tee_off_time] =>
[points_scored] =>
[test_tot] =>
)
)
[current_yyyy] => 2012
[this_year] => 2012
[next_year] => 2013
[last_year] => 2011
[current_mm] => 2
[current_dd] => 8
[current_day_name] => Wednesday
[current_month_name] => February
[now_unix] => 1328659200
[team_ct] => 0
[srt] => vets_open_team_name ASC
[div4w] => 1200
[div4h] => 500
[div4l] => 0
[div4t] => 0
[div5h] => 200
[div5w] => 200
[div5t] => 0
[div5l] => 1250
[div6h] => 200
[div6l] => 1250
[div6w] => 200
[div6t] => 300
[query] => SELECT vets_open_id, DATE_FORMAT(vets_open_date,'%Y') AS od_yyyy FROM vets_open
WHERE (DATE_FORMAT(vets_open_date,'%Y')= 2012)
[result] => Resource id #9
[row] =>
)
An error occurred in script '/home/claudebu/public_html/print_open_confirmation_sheet.php' on line 114:
Query: SELECT contact_id, vets_open_team_name, vets_open_team_id, host_id, tee,
TIME_FORMAT(tee_off_time, '%l:%i')AS short_tot, points_scored FROM vets_open_team WHERE (vets_open_id = ) ORDER BY vets_open_team_name ASC
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY vets_open_team_name ASC' at line 2
Date/Time: 2-8-2012 19:55:27
Array
(
[GLOBALS] => Array
*RECURSION*
[_ENV] => Array
(
[DOCUMENT_ROOT] => /home/claudebu/public_html
[GATEWAY_INTERFACE] => CGI/1.1
[HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_CACHE_CONTROL] => no-cache
[HTTP_CONNECTION] => close
[HTTP_COOKIE] => PHPSESSID=4f7cdbdba164326549227aff03e933b7
[HTTP_HOST] => www.midkentgolfclub.co.uk
[HTTP_PRAGMA] => no-cache
[HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
[HTTP_X_CC_ID] => ccc01-01
[PATH] => /bin:/usr/bin
[QUERY_STRING] =>
[REDIRECT_STATUS] => 200
[REMOTE_ADDR] => 38.107.179.210
[REMOTE_PORT] => 50670
[REQUEST_METHOD] => GET
[REQUEST_URI] => /print_open_confirmation_sheet.php
[SCRIPT_FILENAME] => /home/claudebu/public_html/print_open_confirmation_sheet.php
[SCRIPT_NAME] => /print_open_confirmation_sheet.php
[SERVER_ADDR] => 188.64.188.21
[SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
[SERVER_NAME] => www.midkentgolfclub.co.uk
[SERVER_PORT] => 80
[SERVER_PROTOCOL] => HTTP/1.1
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[UNIQUE_ID] => TzLTL7xAvBUAAGidx3oAAAAC
)
[HTTP_ENV_VARS] => Array
(
[DOCUMENT_ROOT] => /home/claudebu/public_html
[GATEWAY_INTERFACE] => CGI/1.1
[HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_CACHE_CONTROL] => no-cache
[HTTP_CONNECTION] => close
[HTTP_COOKIE] => PHPSESSID=4f7cdbdba164326549227aff03e933b7
[HTTP_HOST] => www.midkentgolfclub.co.uk
[HTTP_PRAGMA] => no-cache
[HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
[HTTP_X_CC_ID] => ccc01-01
[PATH] => /bin:/usr/bin
[QUERY_STRING] =>
[REDIRECT_STATUS] => 200
[REMOTE_ADDR] => 38.107.179.210
[REMOTE_PORT] => 50670
[REQUEST_METHOD] => GET
[REQUEST_URI] => /print_open_confirmation_sheet.php
[SCRIPT_FILENAME] => /home/claudebu/public_html/print_open_confirmation_sheet.php
[SCRIPT_NAME] => /print_open_confirmation_sheet.php
[SERVER_ADDR] => 188.64.188.21
[SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
[SERVER_NAME] => www.midkentgolfclub.co.uk
[SERVER_PORT] => 80
[SERVER_PROTOCOL] => HTTP/1.1
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[UNIQUE_ID] => TzLTL7xAvBUAAGidx3oAAAAC
)
[_POST] => Array
(
)
[HTTP_POST_VARS] => Array
(
)
[_GET] => Array
(
)
[HTTP_GET_VARS] => Array
(
)
[_COOKIE] => Array
(
[PHPSESSID] => 4f7cdbdba164326549227aff03e933b7
)
[HTTP_COOKIE_VARS] => Array
(
[PHPSESSID] => 4f7cdbdba164326549227aff03e933b7
)
[_SERVER] => Array
(
[DOCUMENT_ROOT] => /home/claudebu/public_html
[GATEWAY_INTERFACE] => CGI/1.1
[HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_CACHE_CONTROL] => no-cache
[HTTP_CONNECTION] => close
[HTTP_COOKIE] => PHPSESSID=4f7cdbdba164326549227aff03e933b7
[HTTP_HOST] => www.midkentgolfclub.co.uk
[HTTP_PRAGMA] => no-cache
[HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
[HTTP_X_CC_ID] => ccc01-01
[PATH] => /bin:/usr/bin
[QUERY_STRING] =>
[REDIRECT_STATUS] => 200
[REMOTE_ADDR] => 38.107.179.210
[REMOTE_PORT] => 50670
[REQUEST_METHOD] => GET
[REQUEST_URI] => /print_open_confirmation_sheet.php
[SCRIPT_FILENAME] => /home/claudebu/public_html/print_open_confirmation_sheet.php
[SCRIPT_NAME] => /print_open_confirmation_sheet.php
[SERVER_ADDR] => 188.64.188.21
[SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
[SERVER_NAME] => www.midkentgolfclub.co.uk
[SERVER_PORT] => 80
[SERVER_PROTOCOL] => HTTP/1.1
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[UNIQUE_ID] => TzLTL7xAvBUAAGidx3oAAAAC
[PHP_SELF] => /print_open_confirmation_sheet.php
[REQUEST_TIME] => 1328730927
[argv] => Array
(
)
[argc] => 0
)
[HTTP_SERVER_VARS] => Array
(
[DOCUMENT_ROOT] => /home/claudebu/public_html
[GATEWAY_INTERFACE] => CGI/1.1
[HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_CACHE_CONTROL] => no-cache
[HTTP_CONNECTION] => close
[HTTP_COOKIE] => PHPSESSID=4f7cdbdba164326549227aff03e933b7
[HTTP_HOST] => www.midkentgolfclub.co.uk
[HTTP_PRAGMA] => no-cache
[HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
[HTTP_X_CC_ID] => ccc01-01
[PATH] => /bin:/usr/bin
[QUERY_STRING] =>
[REDIRECT_STATUS] => 200
[REMOTE_ADDR] => 38.107.179.210
[REMOTE_PORT] => 50670
[REQUEST_METHOD] => GET
[REQUEST_URI] => /print_open_confirmation_sheet.php
[SCRIPT_FILENAME] => /home/claudebu/public_html/print_open_confirmation_sheet.php
[SCRIPT_NAME] => /print_open_confirmation_sheet.php
[SERVER_ADDR] => 188.64.188.21
[SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
[SERVER_NAME] => www.midkentgolfclub.co.uk
[SERVER_PORT] => 80
[SERVER_PROTOCOL] => HTTP/1.1
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[UNIQUE_ID] => TzLTL7xAvBUAAGidx3oAAAAC
[PHP_SELF] => /print_open_confirmation_sheet.php
[REQUEST_TIME] => 1328730927
[argv] => Array
(
)
[argc] => 0
)
[_FILES] => Array
(
)
[HTTP_POST_FILES] => Array
(
)
[_REQUEST] => Array
(
[PHPSESSID] => 4f7cdbdba164326549227aff03e933b7
)
[page_title] => Print Open Confirmation Sheet (L)
[increment_version] => Y
[mod_comments] =>
[referer] => HTTP_REFERER not set.
[dev] =>
[live] =>
[email] => tcbuttle@btinternet.com
[dbc] => Resource id #5
[module_name] => print_open_confirmation_sheet.php
[querya] => SELECT version FROM module WHERE (module_name = 'print_open_confirmation_sheet.php')
[resulta] => Resource id #6
[rowa] => Array
(
[version] => 64
)
[vn] => 65
[url] => http://www.midkentgolfclub.co.uk
[baseurl] => http://www.midkentgolfclub.co.uk
[HTTP_SESSION_VARS] => Array
(
)
[_SESSION] => Array
(
)
[fname] =>
[css_path] =>
[css_print_path] =>
[writer] =>
[admin] => 0
[a] => td-even
[b] => td-odd
[c] => style="color:rgb(119,136,153,"
[tbclass] => td-even
[_vets] => Array
(
[0] => Array
(
[vet_id] =>
[surname] =>
[initials] =>
[handicap] =>
[active] =>
[year_paid] =>
[forename] =>
[comment] =>
[telephone_no] =>
[guest] =>
)
)
[vets] => Array
(
[0] => Array
(
[vet_id] =>
[surname] =>
[initials] =>
[forename] =>
[handicap] =>
[active] =>
[year_paid] =>
)
)
[open_teams] => Array
(
[0] => Array
(
[vets_open_team_id] =>
[vets_open_team_name] =>
[vets_open_id] =>
[contact_id] =>
[host_id] =>
[tee] =>
[tee_off_time] =>
[points_scored] =>
[test_tot] =>
)
)
[current_yyyy] => 2012
[this_year] => 2012
[next_year] => 2013
[last_year] => 2011
[current_mm] => 2
[current_dd] => 8
[current_day_name] => Wednesday
[current_month_name] => February
[now_unix] => 1328659200
[team_ct] => 0
[srt] => vets_open_team_name ASC
[div4w] => 1200
[div4h] => 500
[div4l] => 0
[div4t] => 0
[div5h] => 200
[div5w] => 200
[div5t] => 0
[div5l] => 1250
[div6h] => 200
[div6l] => 1250
[div6w] => 200
[div6t] => 300
[query] => SELECT vets_open_id, DATE_FORMAT(vets_open_date,'%Y') AS od_yyyy FROM vets_open
WHERE (DATE_FORMAT(vets_open_date,'%Y')= 2012)
[result] => Resource id #9
[row] =>
[query1] => SELECT contact_id, vets_open_team_name, vets_open_team_id, host_id, tee,
TIME_FORMAT(tee_off_time, '%l:%i')AS short_tot, points_scored FROM vets_open_team WHERE (vets_open_id = ) ORDER BY vets_open_team_name ASC
[result1] =>
)