Deck Listings Database Error

Having a problem getting Nova installed? Can't figure out why something isn't working right? This is the place to get help and report any bugs you find with Nova!

dellucci Sat Aug 26, 2017 5:05 pm

Deck Listings Database Error


I've just installed Nova and updated the specs page. When I click the 'Desk Listing' link I get the following error:

A Database Error Occurred
Error Number: 1055

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nova_tour_decks.deck_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT * FROM (`nova_tour_decks`) GROUP BY `deck_item`

Filename: \nova\ci\database\DB_driver.php

Line Number: 331

I've checked the database and the table is there but is empty. Any help would be most welcome.

Posts: 1

AgentPhoenix Tue Aug 29, 2017 8:46 am

Re: Deck Listings Database Error

The error you're seeing is a new feature in MySQL 5.7 which is the latest version. Nova 2 wasn't designed with some of that stuff in mind. The first thing to do is going to be to reach out to your host and see if they can disable the ONLY_FULL_GROUP_BY SQL mode. If they can't or won't do that, then we'll need to look at other solutions, but that's probably the simplest right now.
User avatar

Posts: 7584

Return to Help

Who is online

Users browsing this forum: No registered users and 1 guest