Forums (Obsolete)

Old Forums

Portal Engine Questions on portal engine and web parts.

Version 5.x > Portal Engine > Products are getting SQL error

View modes:

Certified Developer v7

Gitesh - 2/13/2011 2:55:24 PM

Products are getting SQL error

Hi,

I have created some products and I don't want it any more.
But when I click on a product it gives me this error:

"[DataConnection.ExecuteQuery]: Query: SELECT TOP 1 * FROM View_NewtonSeed_Product_Joined WHERE (((SiteName = N'newtonseed') AND (DocumentCulture = N'en-us')) AND (NodeAliasPath = N'/Products/Vegetable-Seeds/Tomatoes/Tomato--Currant-Sweet-Pea-(Organic)')) : caused exception: Invalid object name 'NewtonSeed_Product'.
Could not use view or function 'View_NewtonSeed_Product_Joined' because of binding errors."

Ans also I can't delete the product because of it.

Can someone help me please?

Thanks
Gitesh Shah


Kentico Consulting	kentico_borisp - 2/14/2011 3:15:39 AM RE:Products are getting SQL error Hello, Could you please try to refresh the mentioned view in the database? The syntax below should work: sp_refreshview 'View_NewtonSeed_Product_Joined' For more information please check the following article. Best regards, Boris Pocatko

Certified Developer v7

Gitesh - 2/14/2011 2:39:41 PM

RE:Products are getting SQL error

Hi Boris,

Thanks for your help.

I tried doing that but it didn't help.

Then I also tried adding a simple SQL Select statement"
SELECT * FROM View_NewtonSeed_Product_Joined"

and it gave me the following error:
"Msg 208, Level 16, State 1, Line 1
Invalid object name 'NewtonSeed_Product'.
Msg 4413, Level 16, State 1, Line 1
Could not use view or function 'View_NewtonSeed_Product_Joined' because of binding errors.
"

May be if this is helpful to you in answering.

Cheers
Gitesh Shah


Kentico Consulting	kentico_borisp - 2/23/2011 10:38:50 AM RE:Products are getting SQL error Hello, Could you please check if the mentioned table is in the database present? Could you please let me know what database schema are you using? Is it the same on every table? Best regards, Boris Pocatko

Top