When site is put into maintenance mode and then admin logs out of the site, unable to login again due to SQL Server conversion error.

Drupal 7.23
Running on IIS8 on Windows Server 2012 Std
SQL Server 2012
PHP 5.3.26

PDOException: SQLSTATE[22018]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the nvarchar value 'login' to data type int.: SELECT revision.[vid] AS [vid], base.[uid] AS [uid], revision.[title] AS [title], revision.[log] AS [log], revision.[status] AS [status], revision.[comment] AS [comment], revision.[promote] AS [promote], revision.[sticky] AS [sticky], base.[nid] AS [nid], base.[type] AS [type], base.[language] AS [language], base.[created] AS [created], base.[changed] AS [changed], base.[tnid] AS [tnid], base.[translate] AS [translate], revision.[timestamp] AS [revision_timestamp], revision.[uid] AS [revision_uid] FROM {node} base INNER JOIN {node_revision} revision ON revision.vid = base.vid WHERE ( ([base].[nid] IN (:db_condition_placeholder_0)) ); Array ( [:db_condition_placeholder_0] => login ) in DrupalDefaultEntityController->load() (line 191 of C:\inetpub\wwwroot\includes\entity.inc).

Comments

babinet’s picture

babinet commented

I got the same problem.
I can't login anymore. Using Postgres 9.2 Mac OS X 10.7

PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "content" LINE 5: WHERE (base.nid IN ('content')) ^: SELECT revision.vid AS vid, base.uid AS uid, revision.title AS title, revision.log AS log, revision.status AS status, revision.comment AS comment, revision.promote AS promote, revision.sticky AS sticky, base.nid AS nid, base.type AS type, base.language AS language, base.created AS created, base.changed AS changed, base.tnid AS tnid, base.translate AS translate, revision.timestamp AS revision_timestamp, revision.uid AS revision_uid FROM {node} base INNER JOIN {node_revision} revision ON revision.vid = base.vid WHERE (base.nid IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => content ) in DrupalDefaultEntityController->load() (line 191 of /drupal/includes/entity.inc).

david_garcia’s picture

david_garcia commented
Issue summary: View changes
Status: Active » Closed (cannot reproduce)

Unable to reproduce. Please check if this happens witht he latest version of Drpual 7 and SQL Server. If so, provide full stack trace.

babinet’s picture

babinet commented

Hi David,
Thank you for your answer.
I'm now running drupal 7.29 version and all is fine!