Error when site has no section pages

[tedwardson]

Has anyone successfully deployed a site that has no sections defined? My client only has a few products and doesn't need to group them into sections. If I try to upload the site I receive the following errror:
"
There was a problem with the database

Operation: Opening the [Product] table where [Catalog reference] = 'A000' AND ([bSuppressHtml] Is NULL OR NOT [bSuppressHtml]) 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 NOT `bSuppressHtml`) AND (NOT `Status` = 'D') AND (`nParentSectionID` IN ())'.

Action: Contact your Actinic reseller or Actinic Support as appropriate
"

[cdicken]

Hi Todd

I just tried this on my copy of v8 and didn't get the error. I would suggest doing a 'Housekeeping | Compact Databases' as this can often fix odd little database problems like this.

If that doesn't yield any joy, I suggest raising an email support query at http://www.actinic.co.uk/support/register.htm and the team there can take a look at the snapshot and figure out what is happening.