Error: SQLSTATE[HY000]: General error: 1364 Field 'user_id' doesn't have a default value
*/ |
|
public function execute($params = null) |
|
{ |
|
$this->_driver->connection()->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, $this->_bufferResults); |
|
$result = $this->_statement->execute($params); |
|
$this->_driver->connection()->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true); |
|
return $result; |
|
} |
|
} |
null
public function run(Query $query) |
|
{ |
|
$statement = $this->prepare($query); |
|
$query->valueBinder()->attachTo($statement); |
|
$statement->execute(); |
|
|
|
return $statement; |
|
} |
|
|
No arguments
* @return \Cake\Database\StatementInterface |
|
*/ |
|
public function execute() |
|
{ |
|
$statement = $this->_connection->run($this); |
|
return $this->_iterator = $this->_decorateStatement($statement); |
|
} |
|
|
|
/** |
object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'INSERT INTO users_activites (session_id, activity_id, year_id, created, modified) VALUES (:c0, :c1, :c2, :c3, :c4)', 'params' => [ ':c0' => [ 'value' => '', 'type' => 'string', 'placeholder' => 'c0' ], ':c1' => [ 'value' => (int) 1543, 'type' => 'integer', 'placeholder' => 'c1' ], ':c2' => [ 'value' => (int) 9, 'type' => 'integer', 'placeholder' => 'c2' ], ':c3' => [ 'value' => object(Cake\I18n\Time) {}, 'type' => 'datetime', 'placeholder' => 'c3' ], ':c4' => [ 'value' => object(Cake\I18n\Time) {}, 'type' => 'datetime', 'placeholder' => 'c4' ] ], 'defaultTypes' => [ 'UsersActivites.id' => 'integer', 'id' => 'integer', 'UsersActivites.session_id' => 'string', 'session_id' => 'string', 'UsersActivites.user_id' => 'integer', 'user_id' => 'integer', 'UsersActivites.activity_id' => 'integer', 'activity_id' => 'integer', 'UsersActivites.year_id' => 'integer', 'year_id' => 'integer', 'UsersActivites.last_question' => 'integer', 'last_question' => 'integer', 'UsersActivites.attempted' => 'integer', 'attempted' => 'integer', 'UsersActivites.correct' => 'integer', 'correct' => 'integer', 'UsersActivites.points' => 'integer', 'points' => 'integer', 'UsersActivites.time_spent' => 'integer', 'time_spent' => 'integer', 'UsersActivites.created' => 'datetime', 'created' => 'datetime', 'UsersActivites.modified' => 'datetime', 'modified' => 'datetime', 'UsersActivites.completed_date' => 'datetime', 'completed_date' => 'datetime', 'UsersActivites.status' => 'integer', 'status' => 'integer' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\UsersActivitesTable) { 'registryAlias' => 'UsersActivites', 'table' => 'users_activites', 'alias' => 'UsersActivites', 'entityClass' => 'App\Model\Entity\UsersActivite', 'associations' => [ [maximum depth reached] ], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } }
} |
|
|
|
$statement = $this->query()->insert(array_keys($data)) |
|
->values($data) |
|
->execute(); |
|
|
|
if ($statement->rowCount() !== 0) { |
|
$success = $entity; |
|
$entity->set($filteredKeys, ['guard' => false]); |
No arguments
$data = $entity->extract($this->schema()->columns(), true); |
|
$isNew = $entity->isNew(); |
|
|
|
if ($isNew) { |
|
$success = $this->_insert($entity, $data); |
|
} else { |
|
$success = $this->_update($entity, $data); |
|
} |
|
|
object(App\Model\Entity\UsersActivite) { 'year_id' => (int) 9, 'activity_id' => (int) 1543, 'session_id' => '', 'created' => object(Cake\I18n\Time) { 'time' => '2024-03-29T06:35:25+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2024-03-29T06:35:25+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, '[new]' => true, '[accessible]' => [ '*' => true ], '[dirty]' => [ 'year_id' => true, 'activity_id' => true, 'session_id' => true, 'created' => true, 'modified' => true ], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'UsersActivites' } [ 'session_id' => '', 'activity_id' => (int) 1543, 'year_id' => (int) 9, 'created' => object(Cake\I18n\Time) { 'time' => '2024-03-29T06:35:25+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2024-03-29T06:35:25+0000', 'timezone' => 'UTC', 'fixedNowTime' => false } ]
|
|
$connection = $this->connection(); |
|
if ($options['atomic']) { |
|
$success = $connection->transactional(function () use ($entity, $options) { |
|
return $this->_processSave($entity, $options); |
|
}); |
|
} else { |
|
$success = $this->_processSave($entity, $options); |
|
} |
object(App\Model\Entity\UsersActivite) { 'year_id' => (int) 9, 'activity_id' => (int) 1543, 'session_id' => '', 'created' => object(Cake\I18n\Time) { 'time' => '2024-03-29T06:35:25+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2024-03-29T06:35:25+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, '[new]' => true, '[accessible]' => [ '*' => true ], '[dirty]' => [ 'year_id' => true, 'activity_id' => true, 'session_id' => true, 'created' => true, 'modified' => true ], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'UsersActivites' } object(ArrayObject) { atomic => true associated => [ 'users' => [], 'activities' => [], 'years' => [] ] checkRules => true checkExisting => true _primary => true }
{ |
|
$this->begin(); |
|
|
|
try { |
|
$result = $callback($this); |
|
} catch (\Exception $e) { |
|
$this->rollback(); |
|
throw $e; |
|
} |
object(Cake\Database\Connection) { 'config' => [ 'password' => '*****', 'username' => '*****', 'host' => '*****', 'database' => '*****', 'driver' => 'Cake\Database\Driver\Mysql', 'persistent' => false, 'encoding' => 'utf8', 'timezone' => 'UTC', 'cacheMetadata' => false, 'quoteIdentifiers' => false, 'name' => 'default' ], 'driver' => object(Cake\Database\Driver\Mysql) { 'connected' => true }, 'transactionLevel' => (int) 0, 'transactionStarted' => false, 'useSavePoints' => false, 'logQueries' => false, 'logger' => null }
$connection = $this->connection(); |
|
if ($options['atomic']) { |
|
$success = $connection->transactional(function () use ($entity, $options) { |
|
return $this->_processSave($entity, $options); |
|
}); |
|
} else { |
|
$success = $this->_processSave($entity, $options); |
|
} |
|
|
object(Closure) { }
'session_id' => $session_id |
|
]; |
|
$activity = $this->UsersActivites->newEntity(); |
|
$this->UsersActivites->patchEntity($activity, $row); |
|
$this->UsersActivites->save($activity); |
|
} |
|
|
|
/*$main = $this->UsersActivites->find(); |
|
// $getAllInfo = $main->select(['total' => $main->func()->sum('points'),'total_time'=> $main->func()->sum('time_spent'),'attempt'=> $main->func()->sum('attempted'),'corrected'=> $main->func()->sum('correct')])->where(['user_id' => $user->id, 'activity_id' => $activity->activity_id])->first(); |
object(App\Model\Entity\UsersActivite) { 'year_id' => (int) 9, 'activity_id' => (int) 1543, 'session_id' => '', 'created' => object(Cake\I18n\Time) { 'time' => '2024-03-29T06:35:25+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2024-03-29T06:35:25+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, '[new]' => true, '[accessible]' => [ '*' => true ], '[dirty]' => [ 'year_id' => true, 'activity_id' => true, 'session_id' => true, 'created' => true, 'modified' => true ], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'UsersActivites' }
'plugin' => $request->params['plugin'], |
|
]); |
|
} |
|
$callable = [$this, $request->params['action']]; |
|
return call_user_func_array($callable, $request->params['pass']); |
|
} |
|
|
|
/** |
|
* Merge components, helpers vars from |
[ (int) 0 => object(App\Controller\ActivitiesController) { helpers => [ 'Extended' => null ] layout => 'inner' routes => 'activity' paginate => null awards => [ (int) 200 => 'Hidden Treasure', (int) 500 => 'Secret virtual prize', (int) 1000 => 'Bronze Certificate', (int) 4000 => 'Silver Certificate', (int) 20000 => 'Gold Certificate', (int) 40000 => 'Platinum Certificate' ] countries => [ 'AF' => 'Afghanistan', 'AL' => 'Albania', 'DZ' => 'Algeria', 'AS' => 'American Samoa', 'AD' => 'Andorra', 'AO' => 'Angola', 'AI' => 'Anguilla', 'AQ' => 'Antarctica', 'AG' => 'Antigua and Barbuda', 'AR' => 'Argentina', 'AM' => 'Armenia', 'AW' => 'Aruba', 'AU' => 'Australia', 'AT' => 'Austria', 'AZ' => 'Azerbaijan', 'BS' => 'Bahamas', 'BH' => 'Bahrain', 'BD' => 'Bangladesh', 'BB' => 'Barbados', 'BY' => 'Belarus', 'BE' => 'Belgium', 'BZ' => 'Belize', 'BJ' => 'Benin', 'BM' => 'Bermuda', 'BT' => 'Bhutan', 'BO' => 'Bolivia', 'BA' => 'Bosnia and Herzegovina', 'BW' => 'Botswana', 'BV' => 'Bouvet Island', 'BR' => 'Brazil', 'BQ' => 'British Antarctic Territory', 'IO' => 'British Indian Ocean Territory', 'VG' => 'British Virgin Islands', 'BN' => 'Brunei', 'BG' => 'Bulgaria', 'BF' => 'Burkina Faso', 'BI' => 'Burundi', 'KH' => 'Cambodia', 'CM' => 'Cameroon', 'CA' => 'Canada', 'CT' => 'Canton and Enderbury Islands', 'CV' => 'Cape Verde', 'KY' => 'Cayman Islands', 'CF' => 'Central African Republic', 'TD' => 'Chad', 'CL' => 'Chile', 'CN' => 'China', 'CX' => 'Christmas Island', 'CC' => 'Cocos [Keeling] Islands', 'CO' => 'Colombia', 'KM' => 'Comoros', 'CG' => 'Congo - Brazzaville', 'CD' => 'Congo - Kinshasa', 'CK' => 'Cook Islands', 'CR' => 'Costa Rica', 'HR' => 'Croatia', 'CU' => 'Cuba', 'CY' => 'Cyprus', 'CZ' => 'Czech Republic', 'CI' => 'Cote d'Ivoire', 'DK' => 'Denmark', 'DJ' => 'Djibouti', 'DM' => 'Dominica', 'DO' => 'Dominican Republic', 'NQ' => 'Dronning Maud Land', 'DD' => 'East Germany', 'EC' => 'Ecuador', 'EG' => 'Egypt', 'SV' => 'El Salvador', 'GQ' => 'Equatorial Guinea', 'ER' => 'Eritrea', 'EE' => 'Estonia', 'ET' => 'Ethiopia', 'FK' => 'Falkland Islands', 'FO' => 'Faroe Islands', 'FJ' => 'Fiji', 'FI' => 'Finland', 'FR' => 'France', 'GF' => 'French Guiana', 'PF' => 'French Polynesia', 'TF' => 'French Southern Territories', 'FQ' => 'French Southern and Antarctic Territories', 'GA' => 'Gabon', 'GM' => 'Gambia', 'GE' => 'Georgia', 'DE' => 'Germany', 'GH' => 'Ghana', 'GI' => 'Gibraltar', 'GR' => 'Greece', 'GL' => 'Greenland', 'GD' => 'Grenada', 'GP' => 'Guadeloupe', 'GU' => 'Guam', 'GT' => 'Guatemala', 'GG' => 'Guernsey', 'GN' => 'Guinea', 'GW' => 'Guinea-Bissau', 'GY' => 'Guyana', 'HT' => 'Haiti', 'HM' => 'Heard Island and McDonald Islands', 'HN' => 'Honduras', 'HK' => 'Hong Kong SAR China', 'HU' => 'Hungary', 'IS' => 'Iceland', 'IN' => 'India', 'ID' => 'Indonesia', 'IR' => 'Iran', 'IQ' => 'Iraq', 'IE' => 'Ireland', 'IM' => 'Isle of Man', 'IL' => 'Israel', 'IT' => 'Italy', 'JM' => 'Jamaica', 'JP' => 'Japan', 'JE' => 'Jersey', 'JT' => 'Johnston Island', 'JO' => 'Jordan', 'KZ' => 'Kazakhstan', 'KE' => 'Kenya', 'KI' => 'Kiribati', 'KW' => 'Kuwait', 'KG' => 'Kyrgyzstan', 'LA' => 'Laos', 'LV' => 'Latvia', 'LB' => 'Lebanon', 'LS' => 'Lesotho', 'LR' => 'Liberia', 'LY' => 'Libya', 'LI' => 'Liechtenstein', 'LT' => 'Lithuania', 'LU' => 'Luxembourg', 'MO' => 'Macau SAR China', 'MK' => 'Macedonia', 'MG' => 'Madagascar', 'MW' => 'Malawi', 'MY' => 'Malaysia', 'MV' => 'Maldives', 'ML' => 'Mali', 'MT' => 'Malta', 'MH' => 'Marshall Islands', 'MQ' => 'Martinique', 'MR' => 'Mauritania', 'MU' => 'Mauritius', 'YT' => 'Mayotte', 'FX' => 'Metropolitan France', 'MX' => 'Mexico', 'FM' => 'Micronesia', 'MI' => 'Midway Islands', 'MD' => 'Moldova', 'MC' => 'Monaco', 'MN' => 'Mongolia', 'ME' => 'Montenegro', 'MS' => 'Montserrat', 'MA' => 'Morocco', 'MZ' => 'Mozambique', 'MM' => 'Myanmar [Burma]', 'NA' => 'Namibia', 'NR' => 'Nauru', 'NP' => 'Nepal', 'NL' => 'Netherlands', 'AN' => 'Netherlands Antilles', 'NT' => 'Neutral Zone', 'NC' => 'New Caledonia', 'NZ' => 'New Zealand', 'NI' => 'Nicaragua', 'NE' => 'Niger', 'NG' => 'Nigeria', 'NU' => 'Niue', 'NF' => 'Norfolk Island', 'KP' => 'North Korea', 'VD' => 'North Vietnam', 'MP' => 'Northern Mariana Islands', 'NO' => 'Norway', 'OM' => 'Oman', 'PC' => 'Pacific Islands Trust Territory', 'PK' => 'Pakistan', 'PW' => 'Palau', 'PS' => 'Palestinian Territories', 'PA' => 'Panama', 'PZ' => 'Panama Canal Zone', 'PG' => 'Papua New Guinea', 'PY' => 'Paraguay', 'YD' => 'People's Democratic Republic of Yemen', 'PE' => 'Peru', 'PH' => 'Philippines', 'PN' => 'Pitcairn Islands', 'PL' => 'Poland', 'PT' => 'Portugal', 'PR' => 'Puerto Rico', 'QA' => 'Qatar', 'RO' => 'Romania', 'RU' => 'Russia', 'RW' => 'Rwanda', 'RE' => 'Reunion', 'BL' => 'Saint Barthelemy', 'SH' => 'Saint Helena', 'KN' => 'Saint Kitts and Nevis', 'LC' => 'Saint Lucia', 'MF' => 'Saint Martin', 'PM' => 'Saint Pierre and Miquelon', 'VC' => 'Saint Vincent and the Grenadines', 'WS' => 'Samoa', 'SM' => 'San Marino', 'SA' => 'Saudi Arabia', 'SN' => 'Senegal', 'RS' => 'Serbia', 'CS' => 'Serbia and Montenegro', 'SC' => 'Seychelles', 'SL' => 'Sierra Leone', 'SG' => 'Singapore', 'SK' => 'Slovakia', 'SI' => 'Slovenia', 'SB' => 'Solomon Islands', 'SO' => 'Somalia', 'ZA' => 'South Africa', 'GS' => 'South Georgia and the South Sandwich Islands', 'KR' => 'South Korea', 'ES' => 'Spain', 'LK' => 'Sri Lanka', 'SD' => 'Sudan', 'SR' => 'Suriname', 'SJ' => 'Svalbard and Jan Mayen', 'SZ' => 'Swaziland', 'SE' => 'Sweden', 'CH' => 'Switzerland', 'SY' => 'Syria', 'ST' => 'Sao Tome and Principe', 'TW' => 'Taiwan', 'TJ' => 'Tajikistan', 'TZ' => 'Tanzania', 'TH' => 'Thailand', 'TL' => 'Timor-Leste', 'TG' => 'Togo', 'TK' => 'Tokelau', 'TO' => 'Tonga', 'TT' => 'Trinidad and Tobago', 'TN' => 'Tunisia', 'TR' => 'Turkey', 'TM' => 'Turkmenistan', 'TC' => 'Turks and Caicos Islands', 'TV' => 'Tuvalu', 'UM' => 'U.S. Minor Outlying Islands', 'PU' => 'U.S. Miscellaneous Pacific Islands', 'VI' => 'U.S. Virgin Islands', 'UG' => 'Uganda', 'UA' => 'Ukraine', 'SU' => 'Union of Soviet Socialist Republics', 'AE' => 'United Arab Emirates', 'UK' => 'United Kingdom', 'US' => 'United States', 'ZZ' => 'Unknown or Invalid Region', 'UY' => 'Uruguay', 'UZ' => 'Uzbekistan', 'VU' => 'Vanuatu', 'VA' => 'Vatican City', 'VE' => 'Venezuela', 'VN' => 'Vietnam', 'WK' => 'Wake Island', 'WF' => 'Wallis and Futuna', 'EH' => 'Western Sahara', 'YE' => 'Yemen', 'ZM' => 'Zambia', 'ZW' => 'Zimbabwe', 'AX' => 'Aland Islands' ] coordinates => [ 'AE' => [ [maximum depth reached] ], 'AF' => [ [maximum depth reached] ], 'AS' => [ [maximum depth reached] ], 'AL' => [ [maximum depth reached] ], 'AT' => [ [maximum depth reached] ], 'AU' => [ [maximum depth reached] ], 'AX' => [ [maximum depth reached] ], 'BD' => [ [maximum depth reached] ], 'BH' => [ [maximum depth reached] ], 'BS' => [ [maximum depth reached] ], 'BR' => [ [maximum depth reached] ], 'CA' => [ [maximum depth reached] ], 'ES' => [ [maximum depth reached] ], 'FR' => [ [maximum depth reached] ], 'UK' => [ [maximum depth reached] ], 'IN' => [ [maximum depth reached] ], 'PK' => [ [maximum depth reached] ], 'RU' => [ [maximum depth reached] ], 'RW' => [ [maximum depth reached] ], 'SA' => [ [maximum depth reached] ], 'TH' => [ [maximum depth reached] ], 'TJ' => [ [maximum depth reached] ], 'TM' => [ [maximum depth reached] ], 'US' => [ [maximum depth reached] ], 'UZ' => [ [maximum depth reached] ], 'ZW' => [ [maximum depth reached] ] ] marks => [ (int) 1 => (int) 10, (int) 2 => (int) 8, (int) 3 => (int) 8, (int) 4 => (int) 7, (int) 5 => (int) 7, (int) 6 => (int) 5, (int) 7 => (int) 5, (int) 8 => (int) 5, (int) 9 => (int) 5, (int) 10 => (int) 4, (int) 11 => (int) 4, (int) 12 => (int) 4, (int) 13 => (int) 3, (int) 14 => (int) 3, (int) 15 => (int) 2, (int) 16 => (int) 2, (int) 17 => (int) 2, (int) 18 => (int) 2, (int) 19 => (int) 2, (int) 20 => (int) 2, (int) 21 => (int) 1, (int) 22 => (int) 1, (int) 23 => (int) 1, (int) 24 => (int) 1, (int) 25 => (int) 1, (int) 26 => (int) 1, (int) 27 => (int) 1, (int) 28 => (int) 1, (int) 29 => (int) 1, (int) 30 => (int) 1 ] name => 'Activities' request => object(Cake\Network\Request) {} response => object(Cake\Network\Response) {} autoRender => true components => [] viewClass => null viewPath => 'Activities' view => 'activity' View => null plugin => null passedArgs => [ (int) 0 => 'year-8', (int) 1 => '1543:-:Interpret frequency tables' ] modelClass => 'Activities' viewVars => [] Flash => object(Cake\Controller\Component\FlashComponent) {} Cookie => object(Cake\Controller\Component\CookieComponent) {} Auth => object(Cake\Controller\Component\AuthComponent) {} Users => object(App\Model\Table\UsersTable) {} UsersActivites => object(App\Model\Table\UsersActivitesTable) {} Years => object(App\Model\Table\YearsTable) {} Activities => object(App\Model\Table\ActivitiesTable) {} [protected] _responseClass => 'Cake\Network\Response' [protected] _components => object(Cake\Controller\ComponentRegistry) {} [protected] _validViewOptions => [ (int) 0 => 'viewVars', (int) 1 => 'autoLayout', (int) 2 => 'helpers', (int) 3 => 'view', (int) 4 => 'layout', (int) 5 => 'name', (int) 6 => 'theme', (int) 7 => 'layoutPath', (int) 8 => 'viewPath', (int) 9 => 'plugin', (int) 10 => 'passedArgs' ] [protected] _eventManager => object(Cake\Event\EventManager) {} [protected] _eventClass => '\Cake\Event\Event' [protected] _modelFactories => [ 'Table' => [ [maximum depth reached] ] ] }, (int) 1 => 'activity' ] [ (int) 0 => 'year-8', (int) 1 => '1543:-:Interpret frequency tables' ]
if ($result instanceof Response) { |
|
return $result; |
|
} |
|
|
|
$response = $controller->invokeAction(); |
|
if ($response !== null && !($response instanceof Response)) { |
|
throw new LogicException('Controller action can only return an instance of Response'); |
|
} |
|
|
No arguments
'_ext' => empty($request->params['_ext']) ? null : $request->params['_ext'] |
|
]); |
|
} |
|
|
|
$response = $this->_invoke($controller); |
|
if (isset($request->params['return'])) { |
|
return $response->body(); |
|
} |
|
|
object(App\Controller\ActivitiesController) { helpers => [ 'Extended' => null ] layout => 'inner' routes => 'activity' paginate => null awards => [ (int) 200 => 'Hidden Treasure', (int) 500 => 'Secret virtual prize', (int) 1000 => 'Bronze Certificate', (int) 4000 => 'Silver Certificate', (int) 20000 => 'Gold Certificate', (int) 40000 => 'Platinum Certificate' ] countries => [ 'AF' => 'Afghanistan', 'AL' => 'Albania', 'DZ' => 'Algeria', 'AS' => 'American Samoa', 'AD' => 'Andorra', 'AO' => 'Angola', 'AI' => 'Anguilla', 'AQ' => 'Antarctica', 'AG' => 'Antigua and Barbuda', 'AR' => 'Argentina', 'AM' => 'Armenia', 'AW' => 'Aruba', 'AU' => 'Australia', 'AT' => 'Austria', 'AZ' => 'Azerbaijan', 'BS' => 'Bahamas', 'BH' => 'Bahrain', 'BD' => 'Bangladesh', 'BB' => 'Barbados', 'BY' => 'Belarus', 'BE' => 'Belgium', 'BZ' => 'Belize', 'BJ' => 'Benin', 'BM' => 'Bermuda', 'BT' => 'Bhutan', 'BO' => 'Bolivia', 'BA' => 'Bosnia and Herzegovina', 'BW' => 'Botswana', 'BV' => 'Bouvet Island', 'BR' => 'Brazil', 'BQ' => 'British Antarctic Territory', 'IO' => 'British Indian Ocean Territory', 'VG' => 'British Virgin Islands', 'BN' => 'Brunei', 'BG' => 'Bulgaria', 'BF' => 'Burkina Faso', 'BI' => 'Burundi', 'KH' => 'Cambodia', 'CM' => 'Cameroon', 'CA' => 'Canada', 'CT' => 'Canton and Enderbury Islands', 'CV' => 'Cape Verde', 'KY' => 'Cayman Islands', 'CF' => 'Central African Republic', 'TD' => 'Chad', 'CL' => 'Chile', 'CN' => 'China', 'CX' => 'Christmas Island', 'CC' => 'Cocos [Keeling] Islands', 'CO' => 'Colombia', 'KM' => 'Comoros', 'CG' => 'Congo - Brazzaville', 'CD' => 'Congo - Kinshasa', 'CK' => 'Cook Islands', 'CR' => 'Costa Rica', 'HR' => 'Croatia', 'CU' => 'Cuba', 'CY' => 'Cyprus', 'CZ' => 'Czech Republic', 'CI' => 'Cote d'Ivoire', 'DK' => 'Denmark', 'DJ' => 'Djibouti', 'DM' => 'Dominica', 'DO' => 'Dominican Republic', 'NQ' => 'Dronning Maud Land', 'DD' => 'East Germany', 'EC' => 'Ecuador', 'EG' => 'Egypt', 'SV' => 'El Salvador', 'GQ' => 'Equatorial Guinea', 'ER' => 'Eritrea', 'EE' => 'Estonia', 'ET' => 'Ethiopia', 'FK' => 'Falkland Islands', 'FO' => 'Faroe Islands', 'FJ' => 'Fiji', 'FI' => 'Finland', 'FR' => 'France', 'GF' => 'French Guiana', 'PF' => 'French Polynesia', 'TF' => 'French Southern Territories', 'FQ' => 'French Southern and Antarctic Territories', 'GA' => 'Gabon', 'GM' => 'Gambia', 'GE' => 'Georgia', 'DE' => 'Germany', 'GH' => 'Ghana', 'GI' => 'Gibraltar', 'GR' => 'Greece', 'GL' => 'Greenland', 'GD' => 'Grenada', 'GP' => 'Guadeloupe', 'GU' => 'Guam', 'GT' => 'Guatemala', 'GG' => 'Guernsey', 'GN' => 'Guinea', 'GW' => 'Guinea-Bissau', 'GY' => 'Guyana', 'HT' => 'Haiti', 'HM' => 'Heard Island and McDonald Islands', 'HN' => 'Honduras', 'HK' => 'Hong Kong SAR China', 'HU' => 'Hungary', 'IS' => 'Iceland', 'IN' => 'India', 'ID' => 'Indonesia', 'IR' => 'Iran', 'IQ' => 'Iraq', 'IE' => 'Ireland', 'IM' => 'Isle of Man', 'IL' => 'Israel', 'IT' => 'Italy', 'JM' => 'Jamaica', 'JP' => 'Japan', 'JE' => 'Jersey', 'JT' => 'Johnston Island', 'JO' => 'Jordan', 'KZ' => 'Kazakhstan', 'KE' => 'Kenya', 'KI' => 'Kiribati', 'KW' => 'Kuwait', 'KG' => 'Kyrgyzstan', 'LA' => 'Laos', 'LV' => 'Latvia', 'LB' => 'Lebanon', 'LS' => 'Lesotho', 'LR' => 'Liberia', 'LY' => 'Libya', 'LI' => 'Liechtenstein', 'LT' => 'Lithuania', 'LU' => 'Luxembourg', 'MO' => 'Macau SAR China', 'MK' => 'Macedonia', 'MG' => 'Madagascar', 'MW' => 'Malawi', 'MY' => 'Malaysia', 'MV' => 'Maldives', 'ML' => 'Mali', 'MT' => 'Malta', 'MH' => 'Marshall Islands', 'MQ' => 'Martinique', 'MR' => 'Mauritania', 'MU' => 'Mauritius', 'YT' => 'Mayotte', 'FX' => 'Metropolitan France', 'MX' => 'Mexico', 'FM' => 'Micronesia', 'MI' => 'Midway Islands', 'MD' => 'Moldova', 'MC' => 'Monaco', 'MN' => 'Mongolia', 'ME' => 'Montenegro', 'MS' => 'Montserrat', 'MA' => 'Morocco', 'MZ' => 'Mozambique', 'MM' => 'Myanmar [Burma]', 'NA' => 'Namibia', 'NR' => 'Nauru', 'NP' => 'Nepal', 'NL' => 'Netherlands', 'AN' => 'Netherlands Antilles', 'NT' => 'Neutral Zone', 'NC' => 'New Caledonia', 'NZ' => 'New Zealand', 'NI' => 'Nicaragua', 'NE' => 'Niger', 'NG' => 'Nigeria', 'NU' => 'Niue', 'NF' => 'Norfolk Island', 'KP' => 'North Korea', 'VD' => 'North Vietnam', 'MP' => 'Northern Mariana Islands', 'NO' => 'Norway', 'OM' => 'Oman', 'PC' => 'Pacific Islands Trust Territory', 'PK' => 'Pakistan', 'PW' => 'Palau', 'PS' => 'Palestinian Territories', 'PA' => 'Panama', 'PZ' => 'Panama Canal Zone', 'PG' => 'Papua New Guinea', 'PY' => 'Paraguay', 'YD' => 'People's Democratic Republic of Yemen', 'PE' => 'Peru', 'PH' => 'Philippines', 'PN' => 'Pitcairn Islands', 'PL' => 'Poland', 'PT' => 'Portugal', 'PR' => 'Puerto Rico', 'QA' => 'Qatar', 'RO' => 'Romania', 'RU' => 'Russia', 'RW' => 'Rwanda', 'RE' => 'Reunion', 'BL' => 'Saint Barthelemy', 'SH' => 'Saint Helena', 'KN' => 'Saint Kitts and Nevis', 'LC' => 'Saint Lucia', 'MF' => 'Saint Martin', 'PM' => 'Saint Pierre and Miquelon', 'VC' => 'Saint Vincent and the Grenadines', 'WS' => 'Samoa', 'SM' => 'San Marino', 'SA' => 'Saudi Arabia', 'SN' => 'Senegal', 'RS' => 'Serbia', 'CS' => 'Serbia and Montenegro', 'SC' => 'Seychelles', 'SL' => 'Sierra Leone', 'SG' => 'Singapore', 'SK' => 'Slovakia', 'SI' => 'Slovenia', 'SB' => 'Solomon Islands', 'SO' => 'Somalia', 'ZA' => 'South Africa', 'GS' => 'South Georgia and the South Sandwich Islands', 'KR' => 'South Korea', 'ES' => 'Spain', 'LK' => 'Sri Lanka', 'SD' => 'Sudan', 'SR' => 'Suriname', 'SJ' => 'Svalbard and Jan Mayen', 'SZ' => 'Swaziland', 'SE' => 'Sweden', 'CH' => 'Switzerland', 'SY' => 'Syria', 'ST' => 'Sao Tome and Principe', 'TW' => 'Taiwan', 'TJ' => 'Tajikistan', 'TZ' => 'Tanzania', 'TH' => 'Thailand', 'TL' => 'Timor-Leste', 'TG' => 'Togo', 'TK' => 'Tokelau', 'TO' => 'Tonga', 'TT' => 'Trinidad and Tobago', 'TN' => 'Tunisia', 'TR' => 'Turkey', 'TM' => 'Turkmenistan', 'TC' => 'Turks and Caicos Islands', 'TV' => 'Tuvalu', 'UM' => 'U.S. Minor Outlying Islands', 'PU' => 'U.S. Miscellaneous Pacific Islands', 'VI' => 'U.S. Virgin Islands', 'UG' => 'Uganda', 'UA' => 'Ukraine', 'SU' => 'Union of Soviet Socialist Republics', 'AE' => 'United Arab Emirates', 'UK' => 'United Kingdom', 'US' => 'United States', 'ZZ' => 'Unknown or Invalid Region', 'UY' => 'Uruguay', 'UZ' => 'Uzbekistan', 'VU' => 'Vanuatu', 'VA' => 'Vatican City', 'VE' => 'Venezuela', 'VN' => 'Vietnam', 'WK' => 'Wake Island', 'WF' => 'Wallis and Futuna', 'EH' => 'Western Sahara', 'YE' => 'Yemen', 'ZM' => 'Zambia', 'ZW' => 'Zimbabwe', 'AX' => 'Aland Islands' ] coordinates => [ 'AE' => [ 'lat' => '24.0000', 'long' => '54.0000' ], 'AF' => [ 'lat' => '33.0000', 'long' => '65.0000' ], 'AS' => [ 'lat' => '14.2710', 'long' => '170.1322' ], 'AL' => [ 'lat' => '41.0000', 'long' => '20.0000' ], 'AT' => [ 'lat' => '47.3333', 'long' => '13.3333' ], 'AU' => [ 'lat' => '-27.0000', 'long' => '133.0000' ], 'AX' => [ 'lat' => '60.1785', 'long' => '19.9156' ], 'BD' => [ 'lat' => '24.0000', 'long' => '90.0000' ], 'BH' => [ 'lat' => '26.0667', 'long' => '50.5577' ], 'BS' => [ 'lat' => '25.0343', 'long' => '77.3963' ], 'BR' => [ 'lat' => '-10.0000', 'long' => '-55.0000' ], 'CA' => [ 'lat' => '56.1304', 'long' => '106.3468' ], 'ES' => [ 'lat' => '40.0000', 'long' => '-4.0000' ], 'FR' => [ 'lat' => '46.0000', 'long' => '2.0000' ], 'UK' => [ 'lat' => '54.0000', 'long' => '-2.0000' ], 'IN' => [ 'lat' => '20.0000', 'long' => '77.0000' ], 'PK' => [ 'lat' => '30.0000', 'long' => '70.0000' ], 'RU' => [ 'lat' => '60.0000', 'long' => '100.0000' ], 'RW' => [ 'lat' => '-2.0000', 'long' => '30.0000' ], 'SA' => [ 'lat' => '25.0000', 'long' => '45.0000' ], 'TH' => [ 'lat' => '15.0000', 'long' => '100.0000' ], 'TJ' => [ 'lat' => '39.0000', 'long' => '71.0000' ], 'TM' => [ 'lat' => '40.0000', 'long' => '60.0000' ], 'US' => [ 'lat' => '38.0000', 'long' => '-97.0000' ], 'UZ' => [ 'lat' => '41.0000', 'long' => '64.0000' ], 'ZW' => [ 'lat' => '-20.0000', 'long' => '30.0000' ] ] marks => [ (int) 1 => (int) 10, (int) 2 => (int) 8, (int) 3 => (int) 8, (int) 4 => (int) 7, (int) 5 => (int) 7, (int) 6 => (int) 5, (int) 7 => (int) 5, (int) 8 => (int) 5, (int) 9 => (int) 5, (int) 10 => (int) 4, (int) 11 => (int) 4, (int) 12 => (int) 4, (int) 13 => (int) 3, (int) 14 => (int) 3, (int) 15 => (int) 2, (int) 16 => (int) 2, (int) 17 => (int) 2, (int) 18 => (int) 2, (int) 19 => (int) 2, (int) 20 => (int) 2, (int) 21 => (int) 1, (int) 22 => (int) 1, (int) 23 => (int) 1, (int) 24 => (int) 1, (int) 25 => (int) 1, (int) 26 => (int) 1, (int) 27 => (int) 1, (int) 28 => (int) 1, (int) 29 => (int) 1, (int) 30 => (int) 1 ] name => 'Activities' request => object(Cake\Network\Request) { params => [ [maximum depth reached] ] data => [[maximum depth reached]] query => [[maximum depth reached]] cookies => [[maximum depth reached]] url => 'activities/year-8/1543:-:Interpret+frequency+tables' base => '' webroot => '/' here => '/activities/year-8/1543:-:Interpret+frequency+tables' trustProxy => false [protected] _environment => [ [maximum depth reached] ] [protected] _detectors => [ [maximum depth reached] ] [protected] _detectorCache => [[maximum depth reached]] [protected] _input => '' [protected] _session => object(Cake\Network\Session) {} } response => object(Cake\Network\Response) { [protected] _statusCodes => [ [maximum depth reached] ] [protected] _mimeTypes => [ [maximum depth reached] ] [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => [[maximum depth reached]] [protected] _body => null [protected] _file => null [protected] _fileRange => [[maximum depth reached]] [protected] _charset => 'UTF-8' [protected] _cacheDirectives => [[maximum depth reached]] [protected] _cookies => [[maximum depth reached]] } autoRender => true components => [] viewClass => null viewPath => 'Activities' view => 'activity' View => null plugin => null passedArgs => [ (int) 0 => 'year-8', (int) 1 => '1543:-:Interpret frequency tables' ] modelClass => 'Activities' viewVars => [] Flash => object(Cake\Controller\Component\FlashComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [[maximum depth reached]], '_config' => [ [maximum depth reached] ] } Cookie => object(Cake\Controller\Component\CookieComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [[maximum depth reached]], '_config' => [ [maximum depth reached] ] } Auth => object(Cake\Controller\Component\AuthComponent) { 'components' => [ [maximum depth reached] ], 'implementedEvents' => [ [maximum depth reached] ], '_config' => [ [maximum depth reached] ] } Users => object(App\Model\Table\UsersTable) { 'registryAlias' => 'Users', 'table' => 'users', 'alias' => 'Users', 'entityClass' => 'App\Model\Entity\User', 'associations' => [ [maximum depth reached] ], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } UsersActivites => object(App\Model\Table\UsersActivitesTable) { 'registryAlias' => 'UsersActivites', 'table' => 'users_activites', 'alias' => 'UsersActivites', 'entityClass' => 'App\Model\Entity\UsersActivite', 'associations' => [ [maximum depth reached] ], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } Years => object(App\Model\Table\YearsTable) { 'registryAlias' => 'Years', 'table' => 'years', 'alias' => 'Years', 'entityClass' => 'App\Model\Entity\Year', 'associations' => [ [maximum depth reached] ], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } Activities => object(App\Model\Table\ActivitiesTable) { 'registryAlias' => 'Activities', 'table' => 'activities', 'alias' => 'Activities', 'entityClass' => 'App\Model\Entity\Activity', 'associations' => [ [maximum depth reached] ], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } [protected] _responseClass => 'Cake\Network\Response' [protected] _components => object(Cake\Controller\ComponentRegistry) { '_Controller' => object(App\Controller\ActivitiesController) {}, '_loaded' => [ [maximum depth reached] ], '_eventManager' => object(Cake\Event\EventManager) {}, '_eventClass' => '\Cake\Event\Event' } [protected] _validViewOptions => [ (int) 0 => 'viewVars', (int) 1 => 'autoLayout', (int) 2 => 'helpers', (int) 3 => 'view', (int) 4 => 'layout', (int) 5 => 'name', (int) 6 => 'theme', (int) 7 => 'layoutPath', (int) 8 => 'viewPath', (int) 9 => 'plugin', (int) 10 => 'passedArgs' ] [protected] _eventManager => object(Cake\Event\EventManager) { '_listeners' => [ [maximum depth reached] ], '_isGlobal' => false, '_generalManager' => '(object) EventManager' } [protected] _eventClass => '\Cake\Event\Event' [protected] _modelFactories => [ 'Table' => [ (int) 0 => 'Cake\ORM\TableRegistry', (int) 1 => 'get' ] ] }
$dispatcher = DispatcherFactory::create(); |
|
$dispatcher->dispatch( |
|
Request::createFromGlobals(), |
|
new Response() |
|
); |
|
|
object(Cake\Network\Request) { params => [ 'plugin' => null, 'controller' => 'Activities', 'action' => 'activity', '_ext' => null, 'pass' => [ (int) 0 => 'year-8', (int) 1 => '1543:-:Interpret frequency tables' ], 'year' => 'year-8', 'acitivity' => '1543:-:Interpret frequency tables' ] data => [] query => [] cookies => [] url => 'activities/year-8/1543:-:Interpret+frequency+tables' base => '' webroot => '/' here => '/activities/year-8/1543:-:Interpret+frequency+tables' trustProxy => false [protected] _environment => [ 'CONTEXT_DOCUMENT_ROOT' => '/home/expertre/public_html/myemaths.com', 'CONTEXT_PREFIX' => '', 'DOCUMENT_ROOT' => '/home/expertre/public_html/myemaths.com', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'HTTP_ACCEPT' => '*/*', 'HTTP_HOST' => 'myemaths.com', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_X_HTTPS' => '1', 'PATH' => '/bin:/usr/bin', 'QUERY_STRING' => '', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_SCRIPT_URI' => 'https://myemaths.com/activities/year-8/1543:-:Interpret+frequency+tables', 'REDIRECT_REDIRECT_SCRIPT_URL' => '/activities/year-8/1543:-:Interpret+frequency+tables', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'myemaths.com', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgZhLe9CQyHWtiYUVRxspQAAAAI', 'REDIRECT_SCRIPT_URI' => 'https://myemaths.com/activities/year-8/1543:-:Interpret+frequency+tables', 'REDIRECT_SCRIPT_URL' => '/activities/year-8/1543:-:Interpret+frequency+tables', 'REDIRECT_SSL_TLS_SNI' => 'myemaths.com', 'REDIRECT_STATUS' => '200', 'REDIRECT_UNIQUE_ID' => 'ZgZhLe9CQyHWtiYUVRxspQAAAAI', 'REDIRECT_URL' => '/webroot/activities/year-8/1543:-:Interpret+frequency+tables', 'REMOTE_ADDR' => '34.239.185.22', 'REMOTE_PORT' => '57522', 'REQUEST_METHOD' => 'GET', 'REQUEST_SCHEME' => 'https', 'REQUEST_URI' => '/activities/year-8/1543:-:Interpret+frequency+tables', 'SCRIPT_FILENAME' => '/home/expertre/public_html/myemaths.com/webroot/index.php', 'SCRIPT_NAME' => '/webroot/index.php', 'SCRIPT_URI' => 'https://myemaths.com/activities/year-8/1543:-:Interpret+frequency+tables', 'SCRIPT_URL' => '/activities/year-8/1543:-:Interpret+frequency+tables', 'SERVER_ADDR' => '109.203.107.31', 'SERVER_ADMIN' => 'webmaster@myemaths.camsons.co.uk', 'SERVER_NAME' => 'myemaths.com', 'SERVER_PORT' => '443', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SSL_TLS_SNI' => 'myemaths.com', 'TZ' => 'Europe/London', 'UNIQUE_ID' => 'ZgZhLe9CQyHWtiYUVRxspQAAAAI', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711694125.3274, 'REQUEST_TIME' => (int) 1711694125, 'argv' => [], 'argc' => (int) 0, 'HTTP_X_HTTP_METHOD_OVERRIDE' => null, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] _input => '' [protected] _session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => null [protected] _lifetime => '1440' [protected] _isCLI => false } } object(Cake\Network\Response) { [protected] _statusCodes => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 307 => 'Temporary Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Time-out', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 429 => 'Too Many Requests', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Time-out', (int) 505 => 'Unsupported Version' ] [protected] _mimeTypes => [ 'html' => [ (int) 0 => 'text/html', (int) 1 => '*/*' ], 'json' => 'application/json', 'xml' => [ (int) 0 => 'application/xml', (int) 1 => 'text/xml' ], 'rss' => 'application/rss+xml', 'ai' => 'application/postscript', 'bcpio' => 'application/x-bcpio', 'bin' => 'application/octet-stream', 'ccad' => 'application/clariscad', 'cdf' => 'application/x-netcdf', 'class' => 'application/octet-stream', 'cpio' => 'application/x-cpio', 'cpt' => 'application/mac-compactpro', 'csh' => 'application/x-csh', 'csv' => [ (int) 0 => 'text/csv', (int) 1 => 'application/vnd.ms-excel' ], 'dcr' => 'application/x-director', 'dir' => 'application/x-director', 'dms' => 'application/octet-stream', 'doc' => 'application/msword', 'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'drw' => 'application/drafting', 'dvi' => 'application/x-dvi', 'dwg' => 'application/acad', 'dxf' => 'application/dxf', 'dxr' => 'application/x-director', 'eot' => 'application/vnd.ms-fontobject', 'eps' => 'application/postscript', 'exe' => 'application/octet-stream', 'ez' => 'application/andrew-inset', 'flv' => 'video/x-flv', 'gtar' => 'application/x-gtar', 'gz' => 'application/x-gzip', 'bz2' => 'application/x-bzip', '7z' => 'application/x-7z-compressed', 'hdf' => 'application/x-hdf', 'hqx' => 'application/mac-binhex40', 'ico' => 'image/x-icon', 'ips' => 'application/x-ipscript', 'ipx' => 'application/x-ipix', 'js' => 'application/javascript', 'latex' => 'application/x-latex', 'lha' => 'application/octet-stream', 'lsp' => 'application/x-lisp', 'lzh' => 'application/octet-stream', 'man' => 'application/x-troff-man', 'me' => 'application/x-troff-me', 'mif' => 'application/vnd.mif', 'ms' => 'application/x-troff-ms', 'nc' => 'application/x-netcdf', 'oda' => 'application/oda', 'otf' => 'font/otf', 'pdf' => 'application/pdf', 'pgn' => 'application/x-chess-pgn', 'pot' => 'application/vnd.ms-powerpoint', 'pps' => 'application/vnd.ms-powerpoint', 'ppt' => 'application/vnd.ms-powerpoint', 'pptx' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation', 'ppz' => 'application/vnd.ms-powerpoint', 'pre' => 'application/x-freelance', 'prt' => 'application/pro_eng', 'ps' => 'application/postscript', 'roff' => 'application/x-troff', 'scm' => 'application/x-lotusscreencam', 'set' => 'application/set', 'sh' => 'application/x-sh', 'shar' => 'application/x-shar', 'sit' => 'application/x-stuffit', 'skd' => 'application/x-koan', 'skm' => 'application/x-koan', 'skp' => 'application/x-koan', 'skt' => 'application/x-koan', 'smi' => 'application/smil', 'smil' => 'application/smil', 'sol' => 'application/solids', 'spl' => 'application/x-futuresplash', 'src' => 'application/x-wais-source', 'step' => 'application/STEP', 'stl' => 'application/SLA', 'stp' => 'application/STEP', 'sv4cpio' => 'application/x-sv4cpio', 'sv4crc' => 'application/x-sv4crc', 'svg' => 'image/svg+xml', 'svgz' => 'image/svg+xml', 'swf' => 'application/x-shockwave-flash', 't' => 'application/x-troff', 'tar' => 'application/x-tar', 'tcl' => 'application/x-tcl', 'tex' => 'application/x-tex', 'texi' => 'application/x-texinfo', 'texinfo' => 'application/x-texinfo', 'tr' => 'application/x-troff', 'tsp' => 'application/dsptype', 'ttc' => 'font/ttf', 'ttf' => 'font/ttf', 'unv' => 'application/i-deas', 'ustar' => 'application/x-ustar', 'vcd' => 'application/x-cdlink', 'vda' => 'application/vda', 'xlc' => 'application/vnd.ms-excel', 'xll' => 'application/vnd.ms-excel', 'xlm' => 'application/vnd.ms-excel', 'xls' => 'application/vnd.ms-excel', 'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'xlw' => 'application/vnd.ms-excel', 'zip' => 'application/zip', 'aif' => 'audio/x-aiff', 'aifc' => 'audio/x-aiff', 'aiff' => 'audio/x-aiff', 'au' => 'audio/basic', 'kar' => 'audio/midi', 'mid' => 'audio/midi', 'midi' => 'audio/midi', 'mp2' => 'audio/mpeg', 'mp3' => 'audio/mpeg', 'mpga' => 'audio/mpeg', 'ogg' => 'audio/ogg', 'oga' => 'audio/ogg', 'spx' => 'audio/ogg', 'ra' => 'audio/x-realaudio', 'ram' => 'audio/x-pn-realaudio', 'rm' => 'audio/x-pn-realaudio', 'rpm' => 'audio/x-pn-realaudio-plugin', 'snd' => 'audio/basic', 'tsi' => 'audio/TSP-audio', 'wav' => 'audio/x-wav', 'aac' => 'audio/aac', 'asc' => 'text/plain', 'c' => 'text/plain', 'cc' => 'text/plain', 'css' => 'text/css', 'etx' => 'text/x-setext', 'f' => 'text/plain', 'f90' => 'text/plain', 'h' => 'text/plain', 'hh' => 'text/plain', 'htm' => [ (int) 0 => 'text/html', (int) 1 => '*/*' ], 'ics' => 'text/calendar', 'm' => 'text/plain', 'rtf' => 'text/rtf', 'rtx' => 'text/richtext', 'sgm' => 'text/sgml', 'sgml' => 'text/sgml', 'tsv' => 'text/tab-separated-values', 'tpl' => 'text/template', 'txt' => 'text/plain', 'text' => 'text/plain', 'avi' => 'video/x-msvideo', 'fli' => 'video/x-fli', 'mov' => 'video/quicktime', 'movie' => 'video/x-sgi-movie', 'mpe' => 'video/mpeg', 'mpeg' => 'video/mpeg', 'mpg' => 'video/mpeg', 'qt' => 'video/quicktime', 'viv' => 'video/vnd.vivo', 'vivo' => 'video/vnd.vivo', 'ogv' => 'video/ogg', 'webm' => 'video/webm', 'mp4' => 'video/mp4', 'm4v' => 'video/mp4', 'f4v' => 'video/mp4', 'f4p' => 'video/mp4', 'm4a' => 'audio/mp4', 'f4a' => 'audio/mp4', 'f4b' => 'audio/mp4', 'gif' => 'image/gif', 'ief' => 'image/ief', 'jpg' => 'image/jpeg', 'jpeg' => 'image/jpeg', 'jpe' => 'image/jpeg', 'pbm' => 'image/x-portable-bitmap', 'pgm' => 'image/x-portable-graymap', 'png' => 'image/png', 'pnm' => 'image/x-portable-anymap', 'ppm' => 'image/x-portable-pixmap', 'ras' => 'image/cmu-raster', 'rgb' => 'image/x-rgb', 'tif' => 'image/tiff', 'tiff' => 'image/tiff', 'xbm' => 'image/x-xbitmap', 'xpm' => 'image/x-xpixmap', 'xwd' => 'image/x-xwindowdump', 'ice' => 'x-conference/x-cooltalk', 'iges' => 'model/iges', 'igs' => 'model/iges', 'mesh' => 'model/mesh', 'msh' => 'model/mesh', 'silo' => 'model/mesh', 'vrml' => 'model/vrml', 'wrl' => 'model/vrml', 'mime' => 'www/mime', 'pdb' => 'chemical/x-pdb', 'xyz' => 'chemical/x-pdb', 'javascript' => 'application/javascript', 'form' => 'application/x-www-form-urlencoded', 'file' => 'multipart/form-data', 'xhtml' => [ (int) 0 => 'application/xhtml+xml', (int) 1 => 'application/xhtml', (int) 2 => 'text/xhtml' ], 'xhtml-mobile' => 'application/vnd.wap.xhtml+xml', 'atom' => 'application/atom+xml', 'amf' => 'application/x-amf', 'wap' => [ (int) 0 => 'text/vnd.wap.wml', (int) 1 => 'text/vnd.wap.wmlscript', (int) 2 => 'image/vnd.wap.wbmp' ], 'wml' => 'text/vnd.wap.wml', 'wmlscript' => 'text/vnd.wap.wmlscript', 'wbmp' => 'image/vnd.wap.wbmp', 'woff' => 'application/x-font-woff', 'webp' => 'image/webp', 'appcache' => 'text/cache-manifest', 'manifest' => 'text/cache-manifest', 'htc' => 'text/x-component', 'rdf' => 'application/xml', 'crx' => 'application/x-chrome-extension', 'oex' => 'application/x-opera-extension', 'xpi' => 'application/x-xpinstall', 'safariextz' => 'application/octet-stream', 'webapp' => 'application/x-web-app-manifest+json', 'vcf' => 'text/x-vcard', 'vtt' => 'text/vtt', 'mkv' => 'video/x-matroska', 'pkpass' => 'application/vnd.apple.pkpass', 'ajax' => 'text/html' ] [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => [] [protected] _body => null [protected] _file => null [protected] _fileRange => [] [protected] _charset => 'UTF-8' [protected] _cacheDirectives => [] [protected] _cookies => [] }
If you are using SQL keywords as table column names, you can enable identifier quoting for your database connection in config/app.php.
If you want to customize this error message, create src/Template/Error/pdo_error.ctp