CDbException: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 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 ''11264'')) ORDER BY t.id DESC' at line 1. The SQL statement executed was: SELECT `t`.`id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`description` AS `t0_c2`, `t`.`install_source` AS `t0_c3`, `t`.`web_visible` AS `t0_c4`, `t`.`install_source_android` AS `t0_c5`, `t`.`price_android` AS `t0_c6`, `t`.`install_source_android_lite` AS `t0_c7`, `t`.`price_android_us` AS `t0_c8`, `t`.`install_source_ios` AS `t0_c9`, `t`.`price_ios` AS `t0_c10`, `t`.`install_source_ios_lite` AS `t0_c11`, `t`.`price_ios_us` AS `t0_c12`, `t`.`install_source_windows` AS `t0_c13`, `t`.`price_windows` AS `t0_c14`, `t`.`install_source_blackberry` AS `t0_c15`, `t`.`price_blackberry` AS `t0_c16`, `t`.`install_source_amazon` AS `t0_c17`, `t`.`price_amazon` AS `t0_c18`, `t`.`install_source_mac` AS `t0_c19`, `t`.`price_mac` AS `t0_c20`, `t`.`page_title` AS `t0_c21`, `t`.`app_subtitle` AS `t0_c22`, `t`.`seo_title` AS `t0_c23`, `t`.`summary_title` AS `t0_c24`, `t`.`review_title` AS `t0_c25`, `t`.`publisher` AS `t0_c26`, `t`.`website` AS `t0_c27`, `t`.`release_date` AS `t0_c28`, `t`.`version` AS `t0_c29`, `t`.`operating_system` AS `t0_c30`, `t`.`platform` AS `t0_c31`, `t`.`category` AS `t0_c32`, `t`.`keystage` AS `t0_c33`, `t`.`curriculumtopics` AS `t0_c34`, `t`.`topics` AS `t0_c35`, `t`.`learning_activity` AS `t0_c36`, `t`.`screenshot` AS `t0_c37`, `t`.`price` AS `t0_c38`, `t`.`status` AS `t0_c39`, `t`.`app_available` AS `t0_c40`, `t`.`date_posted` AS `t0_c41`, `t`.`logo` AS `t0_c42`, `t`.`last_modified` AS `t0_c43`, `t`.`shortname` AS `t0_c44`, `t`.`app_listing` AS `t0_c45`, `t`.`on_carousel` AS `t0_c46`, `t`.`on_banner` AS `t0_c47`, `t`.`developer_id` AS `t0_c48`, `t`.`developer_email` AS `t0_c49`, `t`.`wide_creative` AS `t0_c50`, `t`.`wide_banner` AS `t0_c51`, `t`.`sponsor_img` AS `t0_c52`, `t`.`sponsor_img_low` AS `t0_c53`, `t`.`filename` AS `t0_c54`, `t`.`youtube_id` AS `t0_c55`, `t`.`recommended` AS `t0_c56`, `t`.`review_link` AS `t0_c57`, `t`.`eas_star` AS `t0_c58`, `t`.`review_points` AS `t0_c59`, `t`.`summary` AS `t0_c60`, `t`.`summary_us` AS `t0_c61`, `t`.`eas_review` AS `t0_c62`, `t`.`parent_review` AS `t0_c63`, `t`.`review_date` AS `t0_c64`, `t`.`name_of_reviewer` AS `t0_c65`, `t`.`start_date` AS `t0_c66`, `t`.`in_app_purchases` AS `t0_c67`, `t`.`in_app_advertising` AS `t0_c68`, `t`.`app_subscription` AS `t0_c69`, `t`.`curriculum_app` AS `t0_c70`, `t`.`pal_entry` AS `t0_c71`, `t`.`curriculum_app_us` AS `t0_c72`, `t`.`curriculum_tool` AS `t0_c73`, `t`.`curriculum_reviewed_date` AS `t0_c74`, `t`.`curriculum_app_status` AS `t0_c75`, `t`.`sen_app` AS `t0_c76`, `t`.`sponsored_date` AS `t0_c77`, `t`.`sponsored` AS `t0_c78`, `t`.`trending` AS `t0_c79`, `t`.`trending_date` AS `t0_c80`, `t`.`webapp` AS `t0_c81`, `t`.`app_video_status` AS `t0_c82`, `t`.`wifi` AS `t0_c83`, `t`.`special_needs` AS `t0_c84`, `t`.`app_language` AS `t0_c85`, `t`.`lesson_applan` AS `t0_c86`, `t`.`parental_applan` AS `t0_c87`, `t`.`meta_description` AS `t0_c88`, `t`.`backlink` AS `t0_c89`, `t`.`app_marketing` AS `t0_c90`, `t`.`marketing_start_date` AS `t0_c91`, `t`.`marketing_end_date` AS `t0_c92`, `t`.`affiliate` AS `t0_c93`, `t`.`affiliate_link` AS `t0_c94`, `t`.`promo_text` AS `t0_c95`, `t`.`evidence` AS `t0_c96`, `t`.`user_review` AS `t0_c97`, `t`.`content_visible` AS `t0_c98`, `t`.`us_only` AS `t0_c99`, `t`.`ios_id` AS `t0_c100`, `t`.`token_key` AS `t0_c101`, `t`.`private_key` AS `t0_c102`, `categories`.`id` AS `t1_c0`, `categories`.`name` AS `t1_c1`, `categories`.`status` AS `t1_c2`, `categories`.`shortname` AS `t1_c3`, `categories`.`father` AS `t1_c4`, `categories`.`in_group` AS `t1_c5`, `categories`.`order_value` AS `t1_c6`, `categories`.`page_title` AS `t1_c7`, `categories`.`meta_description` AS `t1_c8`, `categories`.`description` AS `t1_c9`, `categories`.`date_posted` AS `t1_c10`, `categories`.`date_modified` AS `t1_c11`, `platformobj`.`id` AS `t2_c0`, `platformobj`.`name` AS `t2_c1`, `platformobj`.`shortname` AS `t2_c5`, `developer`.`id` AS `t3_c0`, `developer`.`name` AS `t3_c1`, `developer`.`city` AS `t3_c2`, `developer`.`country` AS `t3_c3`, `developer`.`description` AS `t3_c4`, `developer`.`app_story` AS `t3_c5`, `developer`.`bio_photo` AS `t3_c6`, `developer`.`avatar` AS `t3_c7`, `developer`.`shortname` AS `t3_c8`, `developer`.`website` AS `t3_c9`, `developer`.`twitter_profile` AS `t3_c10`, `developer`.`facebook_profile` AS `t3_c11`, `developer`.`award_logo_1` AS `t3_c12`, `developer`.`award_logo_2` AS `t3_c13`, `developer`.`award_logo_3` AS `t3_c14`, `developer`.`admin` AS `t3_c15`, `developer`.`status` AS `t3_c16`, `developer`.`email` AS `t3_c17`, `developer`.`app_certified` AS `t3_c18`, `easratings`.`id` AS `t4_c0`, `easratings`.`name` AS `t4_c1`, `easratings`.`description` AS `t4_c2`, `easratings`.`status` AS `t4_c3` FROM `app` `t` LEFT OUTER JOIN `app_category` `categories_categories` ON (`t`.`id`=`categories_categories`.`app_id`) LEFT OUTER JOIN `category` `categories` ON (`categories`.`id`=`categories_categories`.`category_id`) LEFT OUTER JOIN `platform` `platformobj` ON (`t`.`platform`=`platformobj`.`id`) LEFT OUTER JOIN `developer` `developer` ON (`t`.`developer_id`=`developer`.`id`) LEFT OUTER JOIN `app_easrating` `easratings_easratings` ON (`t`.`id`=`easratings_easratings`.`app_id`) LEFT OUTER JOIN `eas_rating` `easratings` ON (`easratings`.`id`=`easratings_easratings`.`rating_id`) WHERE (((t.status = 'public') AND (platformobj.status = 'public')) AND (t.shortname = '11264'')) ORDER BY t.id DESC in /var/www/eduappstore/yii-1.1.8/framework/db/CDbCommand.php:516 Stack trace: #0 /var/www/eduappstore/yii-1.1.8/framework/db/CDbCommand.php(374): CDbCommand->queryInternal('fetchAll', Array, Array) #1 /var/www/eduappstore/yii-1.1.8/framework/db/ar/CActiveFinder.php(815): CDbCommand->queryAll() #2 /var/www/eduappstore/yii-1.1.8/framework/db/ar/CActiveFinder.php(447): CJoinElement->runQuery(Object(CJoinQuery)) #3 /var/www/eduappstore/yii-1.1.8/framework/db/ar/CActiveFinder.php(72): CJoinElement->find(Object(CDbCriteria)) #4 /var/www/eduappstore/yii-1.1.8/framework/db/ar/CActiveRecord.php(1295): CActiveFinder->query(Object(CDbCriteria), false) #5 /var/www/eduappstore/yii-1.1.8/framework/db/ar/CActiveRecord.php(1396): CActiveRecord->query(Object(CDbCriteria)) #6 /var/www/eduappstore/public_html/protected/models/App.php(1595): CActiveRecord->find(Object(CDbCriteria)) #7 /var/www/eduappstore/public_html/protected/controllers/AppController.php(2588): App->getById('11264'') #8 /var/www/eduappstore/public_html/protected/controllers/AppController.php(2495): AppController->loadModel('11264'') #9 /var/www/eduappstore/yii-1.1.8/framework/web/actions/CInlineAction.php(50): AppController->actionDownloadplatform() #10 /var/www/eduappstore/yii-1.1.8/framework/web/CController.php(300): CInlineAction->runWithParams(Array) #11 /var/www/eduappstore/yii-1.1.8/framework/web/filters/CFilterChain.php(134): CController->runAction(Object(CInlineAction)) #12 /var/www/eduappstore/yii-1.1.8/framework/web/filters/CFilter.php(41): CFilterChain->run() #13 /var/www/eduappstore/yii-1.1.8/framework/web/CController.php(1144): CFilter->filter(Object(CFilterChain)) #14 /var/www/eduappstore/yii-1.1.8/framework/web/filters/CInlineFilter.php(59): CController->filterAccessControl(Object(CFilterChain)) #15 /var/www/eduappstore/yii-1.1.8/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain)) #16 /var/www/eduappstore/yii-1.1.8/framework/web/CController.php(283): CFilterChain->run() #17 /var/www/eduappstore/yii-1.1.8/framework/web/CController.php(257): CController->runActionWithFilters(Object(CInlineAction), Array) #18 /var/www/eduappstore/yii-1.1.8/framework/web/CWebApplication.php(277): CController->run('downloadplatfor...') #19 /var/www/eduappstore/yii-1.1.8/framework/web/CWebApplication.php(136): CWebApplication->runController('app/downloadpla...') #20 /var/www/eduappstore/yii-1.1.8/framework/base/CApplication.php(158): CWebApplication->processRequest() #21 /var/www/eduappstore/public_html/index.php(12): CApplication->run() #22 {main}