Paydirt Football.com Forum Index
 TWR.comLeague Site  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getSetting(im_protocol); failed:

SELECT value FROM MYSQL_DATABASE.league_settings WHERE setting = 'im_protocol'

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`league_settings`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGM(101); failed:

SELECT DISTINCT u.user_id, u.username, u.user_email, u.user_, u.user_lastvisit, IFNULL(t.team, 'NFL') as _team, IFNULL(n.full_name, '') FROM MYSQL_DATABASE.phpbb_users u LEFT JOIN MYSQL_DATABASE.league_gms_yearly t ON t.user_id = u.user_id AND t.year = DEFAULT_START_YEAR AND t.end_date > 1713959811 LEFT JOIN MYSQL_DATABASE.league_gms_yearly at ON at.user_id = u.user_id LEFT JOIN MYSQL_DATABASE.MYSQL_STANDINGS s ON s.team = t.team AND s.year = DEFAULT_START_YEAR LEFT JOIN MYSQL_DATABASE.league_gms n ON n.user_id = u.user_id WHERE u.user_id = 101

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`phpbb_users`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getHistory(); failed:

SELECT MIN(t.start_date) as join_date, MAX(t.year) as last_year, MIN(t.year) as first_year, MAX(t.end_date) FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id =

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year, t.team, t.first_week, t.last_week, t.start_date, t.end_date FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT DISTINCT t.team FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = AND t.team = '' ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND t.team = '' ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1

Joined LEAGUE_NAME: January 01, 1970
GM Experience: to
Main :: Trophy Case :: vs. Other GMs
TEAM W L T .PCT
0.000
LEAGUE_NAME 0.000
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getSetting(im_protocol); failed:

SELECT value FROM MYSQL_DATABASE.league_settings WHERE setting = 'im_protocol'

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`league_settings`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGM(27); failed:

SELECT DISTINCT u.user_id, u.username, u.user_email, u.user_, u.user_lastvisit, IFNULL(t.team, 'NFL') as _team, IFNULL(n.full_name, '') FROM MYSQL_DATABASE.phpbb_users u LEFT JOIN MYSQL_DATABASE.league_gms_yearly t ON t.user_id = u.user_id AND t.year = DEFAULT_START_YEAR AND t.end_date > 1713959811 LEFT JOIN MYSQL_DATABASE.league_gms_yearly at ON at.user_id = u.user_id LEFT JOIN MYSQL_DATABASE.MYSQL_STANDINGS s ON s.team = t.team AND s.year = DEFAULT_START_YEAR LEFT JOIN MYSQL_DATABASE.league_gms n ON n.user_id = u.user_id WHERE u.user_id = 27

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`phpbb_users`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getHistory(); failed:

SELECT MIN(t.start_date) as join_date, MAX(t.year) as last_year, MIN(t.year) as first_year, MAX(t.end_date) FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id =

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year, t.team, t.first_week, t.last_week, t.start_date, t.end_date FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT DISTINCT t.team FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = AND t.team = '' ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND t.team = '' ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1

Joined LEAGUE_NAME: January 01, 1970
GM Experience: to
Main :: Trophy Case :: vs. Other GMs
TEAM W L T .PCT
0.000
LEAGUE_NAME 0.000
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getSetting(im_protocol); failed:

SELECT value FROM MYSQL_DATABASE.league_settings WHERE setting = 'im_protocol'

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`league_settings`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGM(23); failed:

SELECT DISTINCT u.user_id, u.username, u.user_email, u.user_, u.user_lastvisit, IFNULL(t.team, 'NFL') as _team, IFNULL(n.full_name, '') FROM MYSQL_DATABASE.phpbb_users u LEFT JOIN MYSQL_DATABASE.league_gms_yearly t ON t.user_id = u.user_id AND t.year = DEFAULT_START_YEAR AND t.end_date > 1713959811 LEFT JOIN MYSQL_DATABASE.league_gms_yearly at ON at.user_id = u.user_id LEFT JOIN MYSQL_DATABASE.MYSQL_STANDINGS s ON s.team = t.team AND s.year = DEFAULT_START_YEAR LEFT JOIN MYSQL_DATABASE.league_gms n ON n.user_id = u.user_id WHERE u.user_id = 23

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`phpbb_users`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getHistory(); failed:

SELECT MIN(t.start_date) as join_date, MAX(t.year) as last_year, MIN(t.year) as first_year, MAX(t.end_date) FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id =

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year, t.team, t.first_week, t.last_week, t.start_date, t.end_date FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT DISTINCT t.team FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = AND t.team = '' ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND t.team = '' ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1

Joined LEAGUE_NAME: January 01, 1970
GM Experience: to
Main :: Trophy Case :: vs. Other GMs
TEAM W L T .PCT
0.000
LEAGUE_NAME 0.000
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getSetting(im_protocol); failed:

SELECT value FROM MYSQL_DATABASE.league_settings WHERE setting = 'im_protocol'

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`league_settings`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGM(59); failed:

SELECT DISTINCT u.user_id, u.username, u.user_email, u.user_, u.user_lastvisit, IFNULL(t.team, 'NFL') as _team, IFNULL(n.full_name, '') FROM MYSQL_DATABASE.phpbb_users u LEFT JOIN MYSQL_DATABASE.league_gms_yearly t ON t.user_id = u.user_id AND t.year = DEFAULT_START_YEAR AND t.end_date > 1713959811 LEFT JOIN MYSQL_DATABASE.league_gms_yearly at ON at.user_id = u.user_id LEFT JOIN MYSQL_DATABASE.MYSQL_STANDINGS s ON s.team = t.team AND s.year = DEFAULT_START_YEAR LEFT JOIN MYSQL_DATABASE.league_gms n ON n.user_id = u.user_id WHERE u.user_id = 59

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`phpbb_users`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getHistory(); failed:

SELECT MIN(t.start_date) as join_date, MAX(t.year) as last_year, MIN(t.year) as first_year, MAX(t.end_date) FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id =

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year, t.team, t.first_week, t.last_week, t.start_date, t.end_date FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT DISTINCT t.team FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = AND t.team = '' ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND t.team = '' ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1

Joined LEAGUE_NAME: January 01, 1970
GM Experience: to
Main :: Trophy Case :: vs. Other GMs
TEAM W L T .PCT
0.000
LEAGUE_NAME 0.000
PFL Primetime Highlights - '21 Season

 
Post new topic   Reply to topic    Paydirt Football.com Forum Index -> League Articles
View previous topic :: View next topic  
Author Message
virtualcappy1
Team Owner


Joined: 05 Jan 2020
Posts: 200

PostPosted: Sun Nov 14, 2021 10:45 am    Post subject: PFL Primetime Highlights - '21 Season Reply with quote

Highlight's from all of your favorite games this season!
_________________
Back to top
View user's profile Send private message AIM Address
virtualcappy1
Team Owner


Joined: 05 Jan 2020
Posts: 200

PostPosted: Sun Nov 14, 2021 10:51 am    Post subject: Week 2 Reply with quote

TEN @ SEA
_________________
Back to top
View user's profile Send private message AIM Address
Oompa Loompas
Team Owner


Joined: 01 Oct 2011
Posts: 1062
Location: Cleveland, OH

PostPosted: Sun Nov 14, 2021 11:31 am    Post subject: Reply with quote

Awesome job bud.
Thanks for taking time to do this.
I love the commentary.
_________________
Back to top
View user's profile Send private message AIM Address
Pigskin
Team Owner


Joined: 01 Oct 2011
Posts: 1813
Location: Ohio

PostPosted: Sun Nov 14, 2021 12:25 pm    Post subject: Reply with quote

Nice job, enjoyed it!
_________________
Back to top
View user's profile Send private message AIM Address
Bojack
Team Owner


Joined: 25 Sep 2013
Posts: 1316
Location: Indiana

PostPosted: Sun Nov 14, 2021 2:00 pm    Post subject: Reply with quote

Great work! The content is awesome and it’s awesome Glen is having a fabulous season!
_________________

www.twitch.tv/average_joker
Back to top
View user's profile Send private message Send e-mail AIM Address
Display posts from previous:   
Post new topic   Reply to topic    Paydirt Football.com Forum Index -> League Articles All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group