Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
CRITICAL SECURITY VERSION UPDATE:
https://github.com/daylightstudio/FUEL-CMS/releases/tag/1.4.13
https://github.com/daylightstudio/FUEL-CMS/releases/tag/1.4.13
Unknown column 'fuel_blog_users.id' in 'where clause'
Hello,
under the default BLOG, I set up a new AUTHOR. I then clicked View and get the following error:
A Database Error Occurred
Error Number: 1054
Unknown column 'fuel_blog_users.id' in 'where clause'
SELECT fuel_blog_users.*, fuel_users.id, CONCAT(first_name, " ", last_name) as name, fuel_users.first_name, fuel_users.last_name, fuel_users.email, fuel_users.user_name, fuel_users.active, posts_count FROM (fuel_blog_users) LEFT JOIN fuel_users ON fuel_users.id = fuel_blog_users.fuel_user_id LEFT JOIN fuel_blog_posts ON fuel_blog_posts.author_id = fuel_users.id LEFT JOIN (SELECT COUNT(*) AS posts_count, author_id FROM fuel_blog_posts GROUP BY author_id) AS temp ON temp.author_id= fuel_users.id WHERE `fuel_blog_users`.`id` = '1' GROUP BY fuel_users.id LIMIT 1
Filename: core/MY_Model.php
Line Number: 261
URL: http://localhost:8888/localfolder/fuel/blog/users/view/1
Any ideas?
under the default BLOG, I set up a new AUTHOR. I then clicked View and get the following error:
A Database Error Occurred
Error Number: 1054
Unknown column 'fuel_blog_users.id' in 'where clause'
SELECT fuel_blog_users.*, fuel_users.id, CONCAT(first_name, " ", last_name) as name, fuel_users.first_name, fuel_users.last_name, fuel_users.email, fuel_users.user_name, fuel_users.active, posts_count FROM (fuel_blog_users) LEFT JOIN fuel_users ON fuel_users.id = fuel_blog_users.fuel_user_id LEFT JOIN fuel_blog_posts ON fuel_blog_posts.author_id = fuel_users.id LEFT JOIN (SELECT COUNT(*) AS posts_count, author_id FROM fuel_blog_posts GROUP BY author_id) AS temp ON temp.author_id= fuel_users.id WHERE `fuel_blog_users`.`id` = '1' GROUP BY fuel_users.id LIMIT 1
Filename: core/MY_Model.php
Line Number: 261
URL: http://localhost:8888/localfolder/fuel/blog/users/view/1
Any ideas?
Comments
If you edit an Author and role over the View button, the URL is...
http://localhost:8888/localfolder/blog/authors/1
But if you view all Authors and then click view on a specific Author, the URL is...
http://localhost:8888/localfolder/fuel/blog/users/view/1
Seems that FuelCMS has 2 different actions for viewing an Author, one works, one doesn't. Is it a bug or is there some default configuration that needs completing?
$this->model->find_one_array(array($this->model->table_name().'.'.$this->model->key_field() => $id));If that fixes your issue, I'll post the fix. Thanks for the report.
http://www.getfuelcms.com/forums/discussion/749/table-mydatabase.categories_to_articles_model-doesn-t-exist
Please ignore. Fixed.