Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsMapMapConversion from string "0500-01" to type Conversion from string "0500-01" to type 'Integer' is not valid.
Previous
 
Next
New Post
4/17/2009 1:30 PM
 

I've noticed another post in this thread recently commenting on the same error  I'm getting when trying to add a Marker to the map.

Conversion from string "0500-01" to type 'Integer' is not valid."

The interesting thing is that there are no fields to input the data points such as x, y, icon, etc.      I've tried to reinstall the map model, but the result is the same -I can't add any markers. As soon as the "add marker" is selected the browser goes to a new page with the above mentioned error message.

Thoughts on what could be happening?

Markers
      Size   Size Anchor Info
Index Task Icon Width Height Shadow Width Height X Y X Y

 

 
New Post
4/19/2009 8:29 AM
 

Hi ataheri,

I would suggest first that you check that you have entered the required information in all of the other Panels of the Map Setup screens, including the API Key in the Geo Locator panel if you haven't done that already. Adding markers is probably the last step in the whole Map Setup process.

Can you confirm that your map is set up to use Standard Map Points?

Finally, the problem looks like there is data on your database which contains 0500-01 in one of the fields and without looking at the source code I couldn't really guess which tables it's pulling this data from. It could depend on a few things.

One way you can find out which table and column the data is in would be to search all tables for any occurrence of the string. Fortunately, I found a thread which contains some SQL for you to do just that! The thread can be found here. Post number 2 in the thread is what you need, although I think someone else posts a slightly fuller version of the code later in the thread as well.

I would suggest trying to use this, and then let us know if your "0500-01" value is found in the database and if so, where. I'm guessing tt'll help us to find the cause of the problem.


Regards,
Sean

www.puffettfoto.com
 
New Post
4/20/2009 11:37 AM
 

Hi together,

i've just installed the newest release of the map-module, set the google-api-key and switched to standard mode and: same result as ataheri... I have an idea: could it be that this '0500-01' could be the dnmn-version number ? >> i'm using 5.0.1 !!

Urs Waldispühl
Switzerland

 
New Post
4/20/2009 4:13 PM
 

Well, I ran the recommended SP, and it resulted in the following error message showing up over and over again.

I am running Standard Data Points, the Geolocator does have the Google provided API. I am able to set my Lat/Long on the same page as the "Add markers". Also the default "dotnetnuke.com" marker does load and can be modified.....just can't add any additional markers.

 

SP results:

en-US) AppleWebKit/525.19 (KHTML, like Gecko) Chrome/1.0.154.53 Safari/525.19</PropertyValue></LogProperty><LogProperty><PropertyName>DefaultDataProvider</PropertyName><PropertyValue>DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider</PropertyValue></LogProperty><LogProperty><PropertyName>ExceptionGUID</PropertyName><PropertyValue>ff771981-ef46-46c7-ba61-1cbde512507f</PropertyValue></LogProperty><LogProperty><PropertyName>InnerException</PropertyName><PropertyValue>Conversion from string "0500-01" to type 'Integer' is not valid.</PropertyValue></LogProperty><LogProperty><PropertyName>FileName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>FileLineNumber</PropertyName><PropertyValue>0</PropertyValue></LogProperty><LogProperty><PropertyName>FileColumnNumber</PropertyName><PropertyValue>0</PropertyValue></LogProperty><LogProperty><PropertyName>Method</PropertyName><PropertyValue>Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble</PropertyValue></LogProperty><LogProperty><PropertyName>StackTrace</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>Message</PropertyName><PropertyValue>DotNetNuke.Services.Exceptions.PageLoadException: Conversion from string "0500-01" to type 'Integer' is not valid. ---&gt
 
New Post
4/21/2009 1:12 PM
 

Hi ataheri

I'm a little confused with your output. When I run the query from the thread I mentioned searching for the string "Järpen" I get output like this:

ColumnName ColumnValue
[dbo].[aspnet_Users].[LoweredUserName] järpenbio
[dbo].[aspnet_Users].[UserName] JärpenBio
[dbo].[EventLog].[LogPortalName] Järpens Förening
[dbo].[Events].[EventName] Järpen Kulturförening Årsmöte
[dbo].[EventsCategory].[CategoryName] Järpens Evenemang
[dbo].[Files].[FileName] JärpensTräbroHöst.jpg
[dbo].[Files].[FileName] JärpenströmmenVinter.jpg
[dbo].[Map_Maps].[Description] Overview of Järpen Locale in Jämtland, Sweden
[dbo].[Map_Maps].[Name] Järpen
[dbo].[Map_Sources].[Name] Järpen

Can you please just confirm that what you're getting as a result to running the SQL is what is posted above in your previous post? If so, did you run this code in SQL Enterprise Manager, or from the Host -> SQL page on your website?

Urs, is there any chance that you could run this code as well so that we can see an alternative set of results.

Finally, ataheri, can you please confirm you're running DNN 5.01 as well? Personally, I'm running 4.9.3 and I haven't seen this behaviour. Is there anyone out there using 5.0.1 who *has* got the Map Module working successfully? Any positive replies would help us.

Thanks all,


Regards,
Sean

www.puffettfoto.com
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsMapMapConversion from string "0500-01" to type Conversion from string "0500-01" to type 'Integer' is not valid.


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out