Warning (512): SQL Error: 1064: 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 '(`BlogPost`.`posts_date`) = '9'' at line 1 [CORE/baser/models/datasources/dbo_source.php, line 535]

Code | Context

$this	=	dbomysqlex
dbomysqlex::$_log = NULL
dbomysqlex::$connected = true
dbomysqlex::$fullDebug = true
dbomysqlex::$error = "1064: 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 '(`BlogPost`.`posts_date`) = '9'' at line 1"
dbomysqlex::$affected = NULL
dbomysqlex::$numRows = NULL
dbomysqlex::$took = 0
dbomysqlex::$startQuote = "`"
dbomysqlex::$endQuote = "`"
dbomysqlex::$_result = false
dbomysqlex::$_queriesCnt = 2
dbomysqlex::$_queriesTime = 0
dbomysqlex::$_queriesLog = array
dbomysqlex::$_queriesLogMax = 200
dbomysqlex::$_queryCache = array
dbomysqlex::$_baseConfig = array
dbomysqlex::$__descriptions = array
dbomysqlex::$_sources = array
dbomysqlex::$connection = resource
dbomysqlex::$config = array
dbomysqlex::$configKeyName = "plugin"
dbomysqlex::$_transactionStarted = false
dbomysqlex::$cacheSources = true
dbomysqlex::$description = "MySQL DBO Driver"
dbomysqlex::$index = array
dbomysqlex::$alias = "AS "
dbomysqlex::$fieldCache = array
dbomysqlex::$__bypass = true
dbomysqlex::$__sqlOps = array
dbomysqlex::$_commands = array
dbomysqlex::$_encodingMaps = array
dbomysqlex::$_useAlias = false
dbomysqlex::$columns = array
dbomysqlex::$__booleans = array
dbomysqlex::$results = false
dbomysqlex::$map = array
$sql	=	"SELECT COUNT(*) AS `count` FROM `bc_pg_blog_posts` AS `BlogPost` LEFT JOIN `bc_pg_blog_categories` AS `BlogCategory` ON (`BlogPost`.`blog_category_id` = `BlogCategory`.`id`) LEFT JOIN `bc_pg_blog_contents` AS `BlogContent` ON (`BlogPost`.`blog_content_id` = `BlogContent`.`id`)  WHERE `BlogPost`.`status` = '1' AND ((`BlogPost`.`publish_begin` <= '2011-02-14 08:11:02') OR (`BlogPost`.`publish_begin` IS NULL) OR (`BlogPost`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`BlogPost`.`publish_end` >= '2011-02-14 08:11:02') OR (`BlogPost`.`publish_end` IS NULL) OR (`BlogPost`.`publish_end` = '0000-00-00 00:00:00')) AND `BlogPost`.`blog_content_id` = 1 AND YEAR(`BlogPost`.`posts_date`) = '2011' AND MONTH(`BlogPost`.`posts_date`) = '2' AND DAY(`BlogPost`.`posts_date`) = '9'   "
$error	=	"1064: 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 '(`BlogPost`.`posts_date`) = '9'' at line 1"
$out	=	null

            $out = null;
            if ($error) {
                trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);

dbomysqlex::showquery() - CORE/baser/models/datasources/dbo_source.php, line 535
dbomysqlex::execute() - CORE/baser/models/datasources/dbo_source.php, line 211
dbomysqlex::fetchall() - CORE/baser/models/datasources/dbo_source.php, line 346
dbomysqlex::read() - CORE/baser/models/datasources/dbo_source.php, line 663
blogpost::find() - CORE/cake/libs/model/model.php, line 2045
blogpost::debug_backtrace() - [internal], line ??
blogcontroller::paginate() - CORE/cake/libs/controller/controller.php, line 1084
blogcontroller::archives() - CORE/baser/plugins/blog/controllers/blog_controller.php, line 309
blogcontroller::dispatchmethod() - CORE/cake/libs/object.php, line 123
dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226
dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193
require - APP/webroot/index.php, line 111
[main] - CORE/index.php, line 60

Query: SELECT COUNT(*) AS `count` FROM `bc_pg_blog_posts` AS `BlogPost` LEFT JOIN `bc_pg_blog_categories` AS `BlogCategory` ON (`BlogPost`.`blog_category_id` = `BlogCategory`.`id`) LEFT JOIN `bc_pg_blog_contents` AS `BlogContent` ON (`BlogPost`.`blog_content_id` = `BlogContent`.`id`) WHERE `BlogPost`.`status` = '1' AND ((`BlogPost`.`publish_begin` <= '2011-02-14 08:11:02') OR (`BlogPost`.`publish_begin` IS NULL) OR (`BlogPost`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`BlogPost`.`publish_end` >= '2011-02-14 08:11:02') OR (`BlogPost`.`publish_end` IS NULL) OR (`BlogPost`.`publish_end` = '0000-00-00 00:00:00')) AND `BlogPost`.`blog_content_id` = 1 AND YEAR(`BlogPost`.`posts_date`) = '2011' AND MONTH(`BlogPost`.`posts_date`) = '2' AND DAY(`BlogPost`.`posts_date`) = '9'

Warning (512): SQL Error: 1064: 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 '(`BlogPost`.`posts_date`) = '9'   ORDER BY `BlogPost`.`posts_da [CORE/baser/models/datasources/dbo_source.php, line 535]

Code | Context

$this	=	dbomysqlex
dbomysqlex::$_log = NULL
dbomysqlex::$connected = true
dbomysqlex::$fullDebug = true
dbomysqlex::$error = "1064: 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 '(`BlogPost`.`posts_date`) = '9'   ORDER BY `BlogPost`.`posts_da"
dbomysqlex::$affected = NULL
dbomysqlex::$numRows = NULL
dbomysqlex::$took = 0
dbomysqlex::$startQuote = "`"
dbomysqlex::$endQuote = "`"
dbomysqlex::$_result = false
dbomysqlex::$_queriesCnt = 3
dbomysqlex::$_queriesTime = 0
dbomysqlex::$_queriesLog = array
dbomysqlex::$_queriesLogMax = 200
dbomysqlex::$_queryCache = array
dbomysqlex::$_baseConfig = array
dbomysqlex::$__descriptions = array
dbomysqlex::$_sources = array
dbomysqlex::$connection = resource
dbomysqlex::$config = array
dbomysqlex::$configKeyName = "plugin"
dbomysqlex::$_transactionStarted = false
dbomysqlex::$cacheSources = true
dbomysqlex::$description = "MySQL DBO Driver"
dbomysqlex::$index = array
dbomysqlex::$alias = "AS "
dbomysqlex::$fieldCache = array
dbomysqlex::$__bypass = false
dbomysqlex::$__sqlOps = array
dbomysqlex::$_commands = array
dbomysqlex::$_encodingMaps = array
dbomysqlex::$_useAlias = false
dbomysqlex::$columns = array
dbomysqlex::$__booleans = array
dbomysqlex::$results = false
dbomysqlex::$map = array
$sql	=	"SELECT `BlogPost`.`id`, `BlogPost`.`blog_content_id`, `BlogPost`.`no`, `BlogPost`.`name`, `BlogPost`.`content`, `BlogPost`.`detail`, `BlogPost`.`blog_category_id`, `BlogPost`.`user_id`, `BlogPost`.`status`, `BlogPost`.`posts_date`, `BlogPost`.`content_draft`, `BlogPost`.`detail_draft`, `BlogPost`.`publish_begin`, `BlogPost`.`publish_end`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogCategory`.`id`, `BlogCategory`.`blog_content_id`, `BlogCategory`.`no`, `BlogCategory`.`name`, `BlogCategory`.`title`, `BlogCategory`.`status`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogContent`.`id`, `BlogContent`.`name`, `BlogContent`.`title`, `BlogContent`.`description`, `BlogContent`.`layout`, `BlogContent`.`template`, `BlogContent`.`status`, `BlogContent`.`list_count`, `BlogContent`.`list_direction`, `BlogContent`.`feed_count`, `BlogContent`.`comment_use`, `BlogContent`.`comment_approve`, `BlogContent`.`auth_captcha`, `BlogContent`.`widget_area`, `BlogContent`.`created`, `BlogContent`.`modified` FROM `bc_pg_blog_posts` AS `BlogPost` LEFT JOIN `bc_pg_blog_categories` AS `BlogCategory` ON (`BlogPost`.`blog_category_id` = `BlogCategory`.`id`) LEFT JOIN `bc_pg_blog_contents` AS `BlogContent` ON (`BlogPost`.`blog_content_id` = `BlogContent`.`id`)  WHERE `BlogPost`.`status` = '1' AND ((`BlogPost`.`publish_begin` <= '2011-02-14 08:11:02') OR (`BlogPost`.`publish_begin` IS NULL) OR (`BlogPost`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`BlogPost`.`publish_end` >= '2011-02-14 08:11:02') OR (`BlogPost`.`publish_end` IS NULL) OR (`BlogPost`.`publish_end` = '0000-00-00 00:00:00')) AND `BlogPost`.`blog_content_id` = 1 AND YEAR(`BlogPost`.`posts_date`) = '2011' AND MONTH(`BlogPost`.`posts_date`) = '2' AND DAY(`BlogPost`.`posts_date`) = '9'   ORDER BY `BlogPost`.`posts_date` DESC,  `BlogPost`.`id` DESC  LIMIT 10"
$error	=	"1064: 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 '(`BlogPost`.`posts_date`) = '9'   ORDER BY `BlogPost`.`posts_da"
$out	=	null

            $out = null;
            if ($error) {
                trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);

dbomysqlex::showquery() - CORE/baser/models/datasources/dbo_source.php, line 535
dbomysqlex::execute() - CORE/baser/models/datasources/dbo_source.php, line 211
dbomysqlex::fetchall() - CORE/baser/models/datasources/dbo_source.php, line 346
dbomysqlex::read() - CORE/baser/models/datasources/dbo_source.php, line 663
blogpost::find() - CORE/cake/libs/model/model.php, line 2045
blogpost::debug_backtrace() - [internal], line ??
blogcontroller::paginate() - CORE/cake/libs/controller/controller.php, line 1102
blogcontroller::archives() - CORE/baser/plugins/blog/controllers/blog_controller.php, line 309
blogcontroller::dispatchmethod() - CORE/cake/libs/object.php, line 123
dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226
dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193
require - APP/webroot/index.php, line 111
[main] - CORE/index.php, line 60

Query: SELECT `BlogPost`.`id`, `BlogPost`.`blog_content_id`, `BlogPost`.`no`, `BlogPost`.`name`, `BlogPost`.`content`, `BlogPost`.`detail`, `BlogPost`.`blog_category_id`, `BlogPost`.`user_id`, `BlogPost`.`status`, `BlogPost`.`posts_date`, `BlogPost`.`content_draft`, `BlogPost`.`detail_draft`, `BlogPost`.`publish_begin`, `BlogPost`.`publish_end`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogCategory`.`id`, `BlogCategory`.`blog_content_id`, `BlogCategory`.`no`, `BlogCategory`.`name`, `BlogCategory`.`title`, `BlogCategory`.`status`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogContent`.`id`, `BlogContent`.`name`, `BlogContent`.`title`, `BlogContent`.`description`, `BlogContent`.`layout`, `BlogContent`.`template`, `BlogContent`.`status`, `BlogContent`.`list_count`, `BlogContent`.`list_direction`, `BlogContent`.`feed_count`, `BlogContent`.`comment_use`, `BlogContent`.`comment_approve`, `BlogContent`.`auth_captcha`, `BlogContent`.`widget_area`, `BlogContent`.`created`, `BlogContent`.`modified` FROM `bc_pg_blog_posts` AS `BlogPost` LEFT JOIN `bc_pg_blog_categories` AS `BlogCategory` ON (`BlogPost`.`blog_category_id` = `BlogCategory`.`id`) LEFT JOIN `bc_pg_blog_contents` AS `BlogContent` ON (`BlogPost`.`blog_content_id` = `BlogContent`.`id`) WHERE `BlogPost`.`status` = '1' AND ((`BlogPost`.`publish_begin` <= '2011-02-14 08:11:02') OR (`BlogPost`.`publish_begin` IS NULL) OR (`BlogPost`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`BlogPost`.`publish_end` >= '2011-02-14 08:11:02') OR (`BlogPost`.`publish_end` IS NULL) OR (`BlogPost`.`publish_end` = '0000-00-00 00:00:00')) AND `BlogPost`.`blog_content_id` = 1 AND YEAR(`BlogPost`.`posts_date`) = '2011' AND MONTH(`BlogPost`.`posts_date`) = '2' AND DAY(`BlogPost`.`posts_date`) = '9' ORDER BY `BlogPost`.`posts_date` DESC, `BlogPost`.`id` DESC LIMIT 10 