Developer forum

Forum » Development » 8.4.1.16 System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ProductUserDefined'.

8.4.1.16 System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ProductUserDefined'.

E-mail notifications
Remi Muller
Reply
Posted on 12/09/2014 15:55:36

8.4.1.16 System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ProductUserDefined'.

This error occurs when i load a catalog with a groupid which has subgroups (containing products).
It only seems to occur when the groupid has no products but only subgroups.

I can work around it by:
1. Enable Use Lucene to retrieve products regardless of presence of filters
2. Or change the default sort from userdefined to something else.

I guess it has something to do with bugfix nr 15089

We upgraded from version 8.4.1.12

 

Can you please investigate?

 

And what is the effect when i enable "Use Lucene to retrieve products regardless of presence of filters"?


Replies

 
Remi Muller
Posted on 12/09/2014 16:04:46
Reply

When i enable "Use Lucene to retrieve products regardless of presence of filters" i get another problem:
LoopStart(NextLevelGroups) is not working anymore :(
 

 

 
Remi Muller
Posted on 12/09/2014 16:30:47
Reply

Downgraded to 8.4.1.15 and this seems to work better.

"Use Lucene to retrieve products regardless of presence of filters" is disabled and the sql error "Invalid column name 'ProductUserDefined'." is gone.

As soon as i enable "Use Lucene..." then it still breaks the LoopStart(NextLevelGroups) on the catalog grouplist template.

 
Nicolai Høeg Pedersen
Posted on 16/09/2014 17:46:36
Reply

Hi Remi

Will have someone look into these 2 errors. The SQL exception and the missing loop when running on the index...

BR Nicolai

 
Remi Muller
Posted on 18/09/2014 08:57:45
Reply

Oke thanks. Let me know if there is any progress or trouble reproducing.

 

You must be logged in to post in the forum