ADODB_Exception Object ( [dbms] => mysqli [fn] => EXECUTE [sql] => SELECT games.id, games.season_id, games.field, games.game_date, games.game_time, games.game_number, games.week, games.game_type, games.home_runs, games.visitors_runs, games.home_final, games.visitors_final, games.home_hits, games.visitors_hits, games.home_errors, games.visitors_errors, games.stats, games.home_team_id, games.visiting_team_id, t1.location as home_location, t1.team_name as home_team, t2.location as away_location, t2.team_name as away_team FROM games LEFT JOIN teams as t1 ON games.home_team_id = t1.id LEFT JOIN teams as t2 ON games.visiting_team_id = t2.id WHERE games.id = [params] => [host] => localhost [database] => mabldb [message:protected] => mysqli error: [1064: 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 31] in EXECUTE(" SELECT games.id, games.season_id, games.field, games.game_date, games.game_time, games.game_number, games.week, games.game_type, games.home_runs, games.visitors_runs, games.home_final, games.visitors_final, games.home_hits, games.visitors_hits, games.home_errors, games.visitors_errors, games.stats, games.home_team_id, games.visiting_team_id, t1.location as home_location, t1.team_name as home_team, t2.location as away_location, t2.team_name as away_team FROM games LEFT JOIN teams as t1 ON games.home_team_id = t1.id LEFT JOIN teams as t2 ON games.visiting_team_id = t2.id WHERE games.id = ") [string:Exception:private] => [code:protected] => 1064 [file:protected] => /home/gt1jrukbcj1j/public_html/wp-content/plugins/coachos-baseball-functions/adodb5lib/adodb-exceptions.inc.php [line:protected] => 80 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home/gt1jrukbcj1j/public_html/wp-content/plugins/coachos-baseball-functions/adodb5lib/adodb.inc.php [line] => 1265 [function] => adodb_throw [args] => Array ( [0] => mysqli [1] => EXECUTE [2] => 1064 [3] => 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 31 [4] => SELECT games.id, games.season_id, games.field, games.game_date, games.game_time, games.game_number, games.week, games.game_type, games.home_runs, games.visitors_runs, games.home_final, games.visitors_final, games.home_hits, games.visitors_hits, games.home_errors, games.visitors_errors, games.stats, games.home_team_id, games.visiting_team_id, t1.location as home_location, t1.team_name as home_team, t2.location as away_location, t2.team_name as away_team FROM games LEFT JOIN teams as t1 ON games.home_team_id = t1.id LEFT JOIN teams as t2 ON games.visiting_team_id = t2.id WHERE games.id = [5] => [6] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM `%s` [fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => 3306 [socket] => [_bindInputArray] => [nameQuote] => ` [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table if not exists %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table if exists %s [database] => mabldb [host] => localhost [user] => mabercrombie [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] =>   [emptyTimeStamp] =>   [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => adodb_throw [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 1064 [error] => 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 31 [error_list] => Array ( [0] => Array ( [errno] => 1064 [sqlstate] => 42000 [error] => 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 31 ) ) [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.5-10.6.17-MariaDB-cll-lve [server_version] => 50505 [stat] => Uptime: 780721 Threads: 100 Questions: 365710730 Slow queries: 61 Opens: 894682 Open tables: 2975 Queries per second avg: 468.426 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 3613517 [warning_count] => 0 ) [_errorMsg] => 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 31 [_errorCode] => [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => mabldb ) ) ) [1] => Array ( [file] => /home/gt1jrukbcj1j/public_html/wp-content/plugins/coachos-baseball-functions/adodb5lib/adodb.inc.php [line] => 1229 [function] => _Execute [class] => ADOConnection [type] => -> [args] => Array ( [0] => SELECT games.id, games.season_id, games.field, games.game_date, games.game_time, games.game_number, games.week, games.game_type, games.home_runs, games.visitors_runs, games.home_final, games.visitors_final, games.home_hits, games.visitors_hits, games.home_errors, games.visitors_errors, games.stats, games.home_team_id, games.visiting_team_id, t1.location as home_location, t1.team_name as home_team, t2.location as away_location, t2.team_name as away_team FROM games LEFT JOIN teams as t1 ON games.home_team_id = t1.id LEFT JOIN teams as t2 ON games.visiting_team_id = t2.id WHERE games.id = [1] => ) ) [2] => Array ( [file] => /home/gt1jrukbcj1j/public_html/wp-content/plugins/coachos-baseball-functions/adodb5lib/adodb.inc.php [line] => 1793 [function] => Execute [class] => ADOConnection [type] => -> [args] => Array ( [0] => SELECT games.id, games.season_id, games.field, games.game_date, games.game_time, games.game_number, games.week, games.game_type, games.home_runs, games.visitors_runs, games.home_final, games.visitors_final, games.home_hits, games.visitors_hits, games.home_errors, games.visitors_errors, games.stats, games.home_team_id, games.visiting_team_id, t1.location as home_location, t1.team_name as home_team, t2.location as away_location, t2.team_name as away_team FROM games LEFT JOIN teams as t1 ON games.home_team_id = t1.id LEFT JOIN teams as t2 ON games.visiting_team_id = t2.id WHERE games.id = [1] => ) ) [3] => Array ( [file] => /home/gt1jrukbcj1j/public_html/wp-content/plugins/coachos-baseball-functions/php/box-image.php [line] => 41 [function] => GetArray [class] => ADOConnection [type] => -> [args] => Array ( [0] => SELECT games.id, games.season_id, games.field, games.game_date, games.game_time, games.game_number, games.week, games.game_type, games.home_runs, games.visitors_runs, games.home_final, games.visitors_final, games.home_hits, games.visitors_hits, games.home_errors, games.visitors_errors, games.stats, games.home_team_id, games.visiting_team_id, t1.location as home_location, t1.team_name as home_team, t2.location as away_location, t2.team_name as away_team FROM games LEFT JOIN teams as t1 ON games.home_team_id = t1.id LEFT JOIN teams as t2 ON games.visiting_team_id = t2.id WHERE games.id = ) ) [4] => Array ( [file] => /home/gt1jrukbcj1j/public_html/wp-content/themes/poseidon/page.php [line] => 36 [args] => Array ( [0] => /home/gt1jrukbcj1j/public_html/wp-content/plugins/coachos-baseball-functions/php/box-image.php ) [function] => include ) [5] => Array ( [file] => /home/gt1jrukbcj1j/public_html/wp-includes/template-loader.php [line] => 74 [args] => Array ( [0] => /home/gt1jrukbcj1j/public_html/wp-content/themes/poseidon/page.php ) [function] => include ) [6] => Array ( [file] => /home/gt1jrukbcj1j/public_html/wp-blog-header.php [line] => 19 [args] => Array ( [0] => /home/gt1jrukbcj1j/public_html/wp-includes/template-loader.php ) [function] => require_once ) [7] => Array ( [file] => /home/gt1jrukbcj1j/public_html/index.php [line] => 17 [args] => Array ( [0] => /home/gt1jrukbcj1j/public_html/wp-blog-header.php ) [function] => require ) ) [previous:Exception:private] => [msg] => 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 31 )

db-demo

Content