0

We’ve run into scenarios where mysql databases with a “-” in the name cause solidcp to fail when attempting to access the database and perform functions such as manage the database, view size, backup, delete etc.

Could you guys please investigate this issue and provide a fix within the next version of Solid?

Page URL:
https://XXXXXX/Default.aspx?pid=SpaceMySql5&mid=XXXXXX&ctl=edit_item&ItemID=XXXXXX&SpaceID=XXXXXX

Logged User:
serveradmin

Work on Behalf:
XXXXXX@XXXXXX.co.za

Hosting Space:
XXXXXX

Stack Trace:
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘-db‘ at line 1 
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) 
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) 
at SolidCP.Providers.Database.DatabaseServer.GetDatabase(String databaseName) 
at SolidCP.EnterpriseServer.DatabaseServerController.GetSqlDatabase(Int32 itemId) 
at SolidCP.EnterpriseServer.esDatabaseServers.GetSqlDatabase(Int32 itemId) 
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) 
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) 
at SolidCP.EnterpriseServer.esDatabaseServers.GetSqlDatabase(Int32 itemId) 
at SolidCP.Portal.SqlEditDatabase.BindItem()

Answered question