Forums (Obsolete)

Old Forums

Portal Engine Questions on portal engine and web parts.

Version 5.x > Portal Engine > service Unavailable Problem

View modes:

Member

sabuj-matrixnmedia - 5/17/2011 7:36:46 AM

service Unavailable Problem

Hello,
http://dev.rhinocarhire.com is a kentico based website.
We are getting an error - "Request timed out” and “Service Unavailable” while trying to access this page - http://dev.rhinocarhire.com/
We are getting this error when we try to upload new files which are related to new development web parts.
We developed the new web part in our local server
And then import the web part to http://dev.rhinocarhire.com .
Upload the files through FTP if we need to change any in the web part.
Please check and let us know more on this problem

Kentico Developer

kentico_ivanat - 5/31/2011 1:47:36 AM

RE:service Unavailable Problem

Hi,

Here is information for readers of this thread:

The web part used a custom method for finding one value. If you need to query database you can use following code for example:



public string GetOneValue(string strQuery)
    {

        GeneralConnection genConn = ConnectionHelper.GetConnection();
        object[,] parameters = null;
        string someColumn = genConn.ExecuteQuery(strQuery, parameters, CMS.IDataConnectionLibrary.QueryTypeEnum.SQLQuery, false).Tables[0].Rows[0]["SomeColumn"].ToString();
       
        return ValidationHelper.GetString(SomeColumn,"empty");

    }

There was another issue in query definition - missing space in the query.

Best regards,
Ivana Tomanickova

Top