search

i7MEDIA / mojoportal

mojoPortal is an extensible, cross database, mobile friendly, web content management system (CMS) and web application framework written in C# ASP.NET.
https://www.mojoportal.com
Other
197 stars 100 forks source link

Blog throws error with mysql #217

Closed JosephMDavis closed 1 year ago

JosephMDavis commented 1 year ago

Blog will throw this error when using mysql 8.0.33

MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'shac_mojo.mp_Blogs.StartDate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(MySqlConnection connection, MySqlTransaction transaction, String commandText, MySqlParameter[] commandParameters, Boolean externalConn) at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters) at mojoPortal.Data.DBBlog.GetBlogMonthArchive(Int32 moduleId, DateTime currentTime) at mojoPortal.Web.BlogUI.BlogArchiveList.BindList() at mojoPortal.Web.BlogUI.BlogArchiveList.OnPreRender(EventArgs e)