Witajcie, postanowiłem się trochę pobawić pewnym skryptem
Kiedy debugowanie w nim jest ustawione na 1 pokazuje się czasem takowy błąd:
Query: SELECT `User`.`id`, `User`.`username`, `User`.`hashed_password`, `User`.`email`, `User`.`rank`, `User`.`token`, `User`.`created`, `User`.`updated`, `User`.`language`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`photos`, `User`.`birthday`, `User`.`hidden`, `User`.`location`, `User`.`photo_id`, `User`.`phone`, `User`.`gg`, `User`.`skype`, `User`.`msn`, `User`.`aim`, `User`.`jabber`, `User`.`photo_secret`, `User`.`last_public_photo`, `User`.`friends`, `User`.`email_messages_notification`, `User`.`photos_limit`, `User`.`slideshows`, `User`.`last_public_slideshow`, `User`.`last_friend_photo`, `User`.`last_friend_slideshow`, `User`.`privacy` FROM `fociki_users` AS `User` WHERE `User`.`username` = '�*�Cm' AND `z ` = '����(�b����m02���FB+���c' LIMIT 1
Warning (512): SQL Error: 1054: Unknown column 'z
' in 'where clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 440]
Context | Code
$sql = "SELECT `User`.`id`, `User`.`username`, `User`.`hashed_password`, `User`.`email`, `User`.`rank`, `User`.`token`, `User`.`created`, `User`.`updated`, `User`.`language`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`photos`, `User`.`birthday`, `User`.`hidden`, `User`.`location`, `User`.`photo_id`, `User`.`phone`, `User`.`gg`, `User`.`skype`, `User`.`msn`, `User`.`aim`, `User`.`jabber`, `User`.`photo_secret`, `User`.`last_public_photo`, `User`.`friends`, `User`.`email_messages_notification`, `User`.`photos_limit`, `User`.`slideshows`, `User`.`last_public_slideshow`, `User`.`last_friend_photo`, `User`.`last_friend_slideshow`, `User`.`privacy` FROM `fotencja_users` AS `User` WHERE `User`.`username` = '�*�Cm' AND `z
` = '����(�b����m02���FB+���c' LIMIT 1"
$error = "1054: Unknown column 'z
' in 'where clause'"
if (($this->debug || $error) && Configure::read() > 0) {
e("<p style = \"text-align:left\"><b>Query:</b> {$sql} ");
if ($error) {
trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING
);
} else {
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 440
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 166
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 297
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 571
Model::find() - CORE/cake/libs/model/model.php, line 1502
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 252
Model::call__() - CORE/cake/libs/model/model.php, line 507
Overloadable::__call() - CORE/cake/libs/overloadable_php5.php, line 59
User
::findByUsernameAndHashedPassword() - [internal
], line

AppController::beforeFilter() - CORE/app/app_controller.php, line 105
Dispatcher::start() - CORE/cake/dispatcher.php, line 320
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 234
require - CORE/app/webroot/index.php, line 85
[main] - CORE/index.php, line 63
Warning
(2
): Cannot modify
header information
- headers already sent by
(output started at
/srv
/home
/m92995my
/public_html
/fotencja
/cake
/basics
.php
:919
) [CORE
/cake
/libs
/controller
/components
/cookie
.php
, line 399
]
Context | Code
$name = "[User][username]"
* @access private
*/
function __delete($name) {
setcookie($this->name . $name, '', time() - 42000
, $this->path, $this->domain, $this->secure);
}
CookieComponent::__delete() - CORE/cake/libs/controller/components/cookie.php, line 399
CookieComponent::del() - CORE/cake/libs/controller/components/cookie.php, line 302
UsersController::kill_user() - CORE/app/controllers/users_controller.php, line 385
UsersController::signin() - CORE/app/controllers/users_controller.php, line 341
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 276
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 248
require - CORE/app/webroot/index.php, line 85
[main] - CORE/index.php, line 63
Warning
(2
): Cannot modify
header information
- headers already sent by
(output started at
/srv
/home
/m92995my
/public_html
/fotencja
/cake
/basics
.php
:919
) [CORE
/cake
/libs
/controller
/components
/cookie
.php
, line 384
]
Context | Code
$name = "[User][username]"
$value = "admin"
* @access private
*/
function __write($name, $value) {
setcookie($this->name . "$name", $this->__encrypt
($value), $this->__expires
, $this->path, $this->domain, $this->secure);
CookieComponent::__write() - CORE/cake/libs/controller/components/cookie.php, line 384
CookieComponent::write() - CORE/cake/libs/controller/components/cookie.php, line 230
UsersController::signin() - CORE/app/controllers/users_controller.php, line 364
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 276
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 248
require - CORE/app/webroot/index.php, line 85
[main] - CORE/index.php, line 63
Warning
(2
): Cannot modify
header information
- headers already sent by
(output started at
/srv
/home
/m92995my
/public_html
/fotencja
/cake
/basics
.php
:919
) [CORE
/cake
/libs
/controller
/controller
.php
, line 503
]
Context | Code
$this = array("name" => "Users", "uses" => array, "paginate" => array, "components" => array, "helpers" => array, "here" => "/index.php/signin", "webroot" => "/app/webroot/", "action" => "signin", "params" => array, "data" => array, "viewPath" => "users", "layoutPath" => null, "viewVars" => array, "pageTitle" => false, "modelNames" => array, "base" => "/index.php", "layout" => "default", "autoRender" => false, "autoLayout" => true, "view" => "View", "ext" => ".ctp", "__viewClass" => null, "output" => null, "plugin" => null, "cacheAction" => false, "persistModel" => false, "webservices" => null, "passedArgs" => array, "_log" => null, "modelClass" => "User", "modelKey" => "user", "Email" => array, "Cookie" => array, "RequestHandler" => array, "Session" => array, "User" => array, "Photo" => array, "Friend" => array, "PhotoComment" => array, "Invitation" => array, "Slideshow" => array, "menu" => array, "user_menu" => array) $url = "/"
$status = null
$exit = false
$c = "Session"
$path = array(0 => "Session") $resp = null
}
if ($url !== null) {
header('Location: ' . Router
::url($url, true));
}
Controller::redirect() - CORE/cake/libs/controller/controller.php, line 503
UsersController::signin() - CORE/app/controllers/users_controller.php, line 367
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 276
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 248
require - CORE/app/webroot/index.php, line 85
[main] - CORE/index.php, line 63
Jak sobie z tym poradzić??