Just started getting a strange error while building out new menus. A little hard to reproduce but it seems to mostly happen if I try to move a new menu to the top of the list on the 'Power Edit' tab. It will save/create the new item but throw the following error and not save the new order. If I repeat the same reorder action in the 'List Links' tab it works.

We are on:
Drupal 7.72
MSSQL: 11.00.300
PHP 5.5.11
IIS 8.5

PDOException: SQLSTATE[22018]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting the nvarchar value 'structure' 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], revision.[ds_switch] AS [ds_switch], 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] => structure ) in DrupalDefaultEntityController->load() (line 191 of E:\Websites\Isenberg\wwwroot\includes\entity.inc).

Comments

donquixote’s picture

Thanks for reporting!
I am quite busy atm.. could you do some debugging yourself?
Maybe you could try to get a backtrace and see where the 'structure' value comes from.

dreg’s picture

Status: Active » Closed (fixed)
donquixote’s picture

dreg’s picture

Yes, that's the correct thread/patch/issue that fixed my problem. I had only bookmarked the patch and couldn't find the original thread immediately. Thanks!

donquixote’s picture

Status: Closed (fixed) » Needs review
Related issues: +#1171428: D7+Postgres: enabling module breaks nodes due to [#1003788]

I don't agree with the "Fixed" status.
It could be "Postponed" or "Duplicate", but I am not really happy with that either. Don't know the ideal status here, so I am setting it to "Needs review".

Also the linked issue is about PostgreSQL, and you have MSSQL - that seems weird.
If we can confirm that it does the job then we can set to "Duplicate".

donquixote’s picture

Status: Needs review » Closed (duplicate)

Hmm.. since you are the only one who could confirm anything, "Duplicate" seems the correct choice. If someone else has the same problem and the patch does not help, this person may reopen.