have been getting this error consistently after downgrading the MySQL Sever to 5.7 (had 8.0 before) and MySQL Workbench to 5.7.7 (had 8.0 before). The nice bloke who helped me setup this Halcyon World last year told me that it looks like an SQL error, though it's the same between the older and newer versions.
This is for a website with a Halcyon World.
Have:
- Microsoft .NET Framework 4.8
- Microsoft ASP.NET MVC 3
- IIS URL Rewrite Module 2
- Microsoft Visual C++ 2008 (x64)
- Microsoft Visual C++ 2010 (x64)
- Microsoft Visual C++ 2013 (x86)
- Microsoft Visual C++ 2015-2019 (x64)
- Microsoft Visual C++ 2015-2019 (x86)
- MySQL Connector C 6.0.2
- MySQL Connector Net 6.9.11
- MySQL Server 5.7.7
- MySQL Workbench 6.3.10 CE
& of course the MySQL Installer - Community.
The MySQL Server is Running and have the MySQL Workbench open and showing that.
Server Error in '/' Application.
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
Line 269: drGetPage = MyDB.GetReader("MySite", SQLCmd)
Line 270: If Trace.IsEnabled And MyDB.Error Then Trace.Warn("Default", "DB Error: " + MyDB.ErrMessage().ToString())
**Line 271: If Not drGetPage.HasRows() Then**
Line 272: drGetPage.Close()
Line 273: ' Create page entry
Source File: C:\Websites\World\wwwroot\Default.aspx.vb Line: 271
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
_Default.Page_Load(Object sender, EventArgs e) in C:\Websites\World\wwwroot\Default.aspx.vb:271
System.Web.UI.Control.OnLoad(EventArgs e) +98
System.Web.UI.Control.LoadRecursive() +153
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4081
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.3535.0
I have opened this Default.aspx.vb file in Visual Studio 2019 and it shows "No issues found."
Thank you.
