Database error

[richard2005]

Tried to upload my new site in V9 business plus but got the following error message.

Operation: Opening the [Product] table where [Catalog reference] = 'A000' AND ([bSuppressHtml] Is NULL OR [bSuppressHtml] = false) AND (NOT [Status] = 'D') AND ([nParentSectionID] IN ()) sorted by [Price]

Syntax error (missing operator) in query expression '`Catalog reference` = 'A000' AND (`bSuppressHtml` Is NULL OR `bSuppressHtml` = false) AND (NOT `Status` = 'D') AND (`nParentSectionID` IN ())'.


I have used Housekeeping/Compact Database, and the Network test passed ok but with no effect.

Any one got any ideas or found a thread on this subject.

Thank you

Richard

[TraceyG]

Hi Richard,

Are all of your sections hidden? If so then try un-hiding at least one of them and then do the upload.

[richard2005]

Thank you for the advice. Yes I did have all the sections hidden. Now working fine.