HomeHome Product Discus... Product Discus...Business Direct...Business Direct...Admin Console ErrorAdmin Console Error
Previous
 
Next
New Post
5/17/2011 1:31 AM
 

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?

 
New Post
5/18/2011 2:34 AM
 
Its possible that their is a localization issue with one of the date fields in the admin console. Programming will look into it and we will post back to this thread with a status update.

Thanks for reporting the issue!

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
5/22/2011 4:52 PM
 

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.

 
New Post
5/31/2011 12:10 PM
 

Hi Marcus,

I took a look at the issue you reported and thinnk I found the problem.  If you open up the "AdminConsole1.ascx" page and remove the date formatting as highlighted below it should fix the issue.  The line you want to change is at about line 130.

 

Old Line:

<asp:Label ID="lblDateOfReg" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "dateofreg", "{0:M/dd/yyyy}")%>' Width="100px"></asp:Label>

 

Change to the following:

 <asp:Label ID="lblDateOfReg" runat="server" Text='<%# (DataBinder.Eval(Container.DataItem, "dateofreg"))%>' Width="100px"></asp:Label>


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
5/31/2011 4:26 PM
 

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?

 
New Post
5/31/2011 9:48 PM
 
DesktopModules/SmithDirectory/AdminConsole1.ascx

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
5/31/2011 10:08 PM
 

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.

???????????

 
New Post
5/31/2011 10:12 PM
 
What version of the module do you have installed? Are there any other folders in your \desktopmodules folder that start with "Smith"?

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
5/31/2011 10:19 PM
 
Version is 1.30 and there are no other folders in the DesktopModules directory that even start with an "s" let alone "smith"
 
New Post
5/31/2011 10:52 PM
 
If you send an email to support@smith-consulting.com I will send you v1.31 that has the AdminConsole1.ascx page.

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
2/7/2013 6:59 PM
 
I have also started to install the directory module, this information will help me to get installation easily.
 
Previous
 
Next
HomeHome Product Discus... Product Discus...Business Direct...Business Direct...Admin Console ErrorAdmin Console Error