-
- 330 Posts
I have a template with 3 TV's assigned to it 2 are text boxes and one is an image.
When I enter details in and click save the page saves pops up the little pop to state it was succesfull. but when I reload the page editor the tv's are empty. I am getting the following error in the logs.
(ERROR @ /var/www/..../public_html/core/xpdo/om/xpdoobject.class.php : 240) Error HY000 executing statement:
Array
(
[0] => HY000
[1] => 3065
[2] => Expression #1 of ORDER BY clause is not in SELECT list, references column 'modx.tvtpl.rank' which is not in SELECT list; this is incompatible with DISTINCT
)
-
- 24,544 Posts
Look in the DB with PhpMyAdmin and see if your modx_categories table has a 'rank' field. If not, see this:
http://bobsguides.com/blog.html/2016/06/27/missing-db-fields-(unknown-column)/.
-
- 330 Posts
Thanks for the reply the table does have a rank field see attached screen shot.
-
- 24,544 Posts
In that case, I'm stumped. -- sorry.
-
- 330 Posts
This is driving me nuts now I have tried a setup on my webserver and localmachine I've wiped and reinstalled a few times tried a new download. and still having the same issue, and error.
Anyone else anymore suggestions.