I have just purchased and installed the directory module. Everything went fine with that.

I have added the search, signup and glossary modules and still everything is OK.

But when I add an Admin Console module the page fails and I get the follwoing error:

A critical error has occurred.
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. Incorrect syntax near the keyword 'where'. SELECT #ListingID#,#ListingNa#e#,#ListingAddress#, #ListingCountry#,#ListingState#, #ListingZip#,#ListingDesc#, #ListingURL#,#ListingCity#,ShowFeedback,#ListingPictureURl#, convert#varchar#50#,DateOfReg,100# DateOfReg,UserNa#e,TabId FROM Smith_DirectoryListing WHERE #tabid='-1' or '-1'=-1# where #DateOfReg# >= '1/01/0001 12:00:00 AM' and order by convert#datetime,convert#varchar#200#, datepart#month,DateOfReg##+'/'+ convert#varchar#200#,datepart#day,DateOfReg##+'/'+ convert#varchar#200#,datepart#year,DateOfReg### Asc ,datepart#hh,DateOfReg# Asc ,datepart#n,DateOfReg# Asc

If I check the actual database there is only one date column for DateOfReg and the date is listed in the format 16/05/2011 12:00:00 AM

Is this occurring because we use Australian language localisation?

Hi,

Can you give us any idea how long before this will be looked at. We have a client keen to start using the directory.

Can you tell me where this file is located? I have looked in DesktopModules > SmithDirectory and there is an AdminConsole.ascx which doesn't contain the code mentioned anyway but no AdminConsole1.ascx that I can see?

As I mentioned in my post there is no AdminConsole1.ascx in the DesktopModules/SmithDirectory/ only a AdminConsole.ascx which does not contain the quoted code.

???????????