Friday, March 16, 2012

SQL errors

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)

Note: Enabling the database statistics here might cause heavy traffic between the web server and the MySQL server.

$ validationenginelanguage is null or not an object
object expected

SQL query failed. Check your query.

Error Returned: Column 'CreatedOn' in field list is ambiguous

Houston, there's a problem...!

SQL Error (select)
SELECT frk_member.*, as country_name, author.username as author_username, author.password as author_password, author.salt as author_salt, author.autoLogin as author_autoLogin, author.timeZone as author_timeZone, author.creationDate as author_creationDate, author.expirationDate as author_expirationDate, author.lastLoginDate as author_lastLoginDate, author.lastLoginAddress as author_lastLoginAddress, author.lastChangeDate as author_lastChangeDate, author.visits as author_visits, author.badAccess as author_badAccess, author.level as author_level, author.enabled as author_enabled, as author_email, author.title as author_title, author.firstName as author_firstName, author.middleName as author_middleName, author.lastName as author_lastName, as author_city, author.zipCode as author_zipCode, author.stateCode as author_stateCode, author.countryId as author_countryId, as author_phone, as author_mobile, author.fax as author_fax, author.memberId as author_memberId FROM frk_member LEFT JOIN frk_country as country ON country.countryId=frk_member.countryId LEFT JOIN frk_member as author ON author.memberId=frk_member.authorId WHERE frk_member.username = 'admin'
Error SQL #1146: Table 'pmtask.frk_member' doesn't exist

My Famous Blog List