| ( ! ) Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.firstName' in 'field list' in /www/wwwroot/FAR/dev-env/src/models/Post/Post.php on line 413 |
|---|
| ( ! ) PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.firstName' in 'field list' in /www/wwwroot/FAR/dev-env/src/models/Post/Post.php on line 413 |
|---|
| Call Stack |
|---|
| # | Time | Memory | Function | Location |
|---|
| 1 | 0.0002 | 479072 | {main}( ) | .../route.php:0 |
| 2 | 0.0353 | 672120 | Controller\PageController->home( ) | .../route.php:50 |
| 3 | 0.0353 | 672120 | App\Core\Controller->render( $view = 'home', $data = ['title' => 'Frontier Africa Reports'] ) | .../PageController.php:9 |
| 4 | 0.0356 | 672120 | App\Utility\TemplateRenderer::renderContent( $view = 'home', $data = ['title' => 'Frontier Africa Reports'] ) | .../Controller.php:11 |
| 5 | 0.0359 | 690320 | include( '/www/wwwroot/FAR/dev-env/src/views/home.php ) | .../TemplateRenderer.php:15 |
| 6 | 0.0366 | 691312 | require( '/www/wwwroot/FAR/dev-env/src/components/post/top-stories.php ) | .../home.php:4 |
| 7 | 0.0374 | 691312 | Model\Post\Post::getPostsByCategories( $categoryRefs = [0 => '53743265'], $limit = 11 ) | .../top-stories.php:5 |
| 8 | 0.0375 | 692208 | prepare( $query = 'SELECT\n\t\t\t\tp.*,\n\t\t\t\tpt.*,\n\t\t\t\tu.firstName,\n\t\t\t\tu.lastName,\n\t\t\t\tu.avatar,\n\t\t\t\tu.userRef as author_id,\n\t\t\t\tCONCAT(COALESCE(u.firstName, \'\'), \' \', COALESCE(u.lastName, \'\')) as author_name,\n\t\t\t\tCASE \'en\'\n\t\t\t\t\tWHEN \'en\' THEN c.categoryNameEn\n\t\t\t\t\tWHEN \'fr\' THEN c.categoryNameFr\n\t\t\t\t\tELSE c.categoryNameEn\n\t\t\t\tEND as categoryName,\n\t\t\t\tc.categoryParent\n\t\t\t\tFROM posts p\n\t\t\t\t\tJOIN posts_translations pt USING (postRef)\n\t\t\t\t\tJOIN posts_cat_assign pca ON p.postRef = pca.postRef\n\t\t\t\t\tJOIN posts_category c ON pca.category'... ) | .../Post.php:413 |