StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
15350955
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-03-12T00:05:05.273
FavoriteCount
0
LastActivityDate
2013-03-12T00:05:05.273
LastEditDate
LastEditorUserId
0
OwnerUserId
1357192
ParentId
15203864
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Yesterday morning, I finally managed to get this JSON script working; however, it was by working around the problem. That said, I feel sure that I have at last managed to identify the root cause too - I just cannot rectify it. Below I have documented how I got the code to run and at the end is a list of areas that I researched. For those who can’t wait though, I just changed my JSON file names to .JS and changed my file paths to .JS too. <hr> My research has been extensive and if documented may help someone else facing the same or similar situation. I have also detailed my approach too; although the approach will be common sense to most it may help someone get to the root of a problem. By the way: Thanks to Juan from the YUI forum who to use his words provided a ‘second pair of eyes’ which confirmed up front that the problem was related to the JSON file not loading correctly. He also gave me some of his time – appreciated. By running the page in Firefox I was able to use the error console. This helped only at first though as after I had deleted any excess code other than that specifically related to the example the Firefox console did not give any errors even though the site script was not working? The Firefox error console did give two telling errors early on however: One related to the server not responding to the call and another outlining that there was a JSON MIME type issue again pointing to the server (IIS 7.0). I then changed the try/ catch error messages in the script to make them all different. Then I was able to see at which point in the script the application was failing according to which alert was showing. Before reaching this point I had got a bit side tracked searching Google for answers – it is easy to do. Working methodically with what I had in front of me enabled me to focus on more directly on specific issues though. I knew that I had issues with JSON files not running; I also knew that the server was not responding and that the server was not recognising the MIME type. Therefore, it seemed probable that if I sorted the MIME type issue on the server the server would recognise and run the JSON file. To add a new JSON MIME type I went to the Microsoft IIS knowledge base at the following link and read the instructions on how to set up IIS 7.0 to manage JSON files – sure enough JSON files were not listed in my IIS Manager as known file types. New MIME type = JSON Filename extension - .json MIME type description = application/json <a href="http://technet.microsoft.com/en-us/library/cc725608%28v=ws.10%29.aspx" rel="nofollow">http://technet.microsoft.com/en-us/library/cc725608%28v=ws.10%29.aspx</a> As the site would still not work I looked deeper. More research told me that I needed to configure a handler mapping for my new JSON MIME type. Again I used the Microsoft IIS site: (Links removed due to insufficient reputation points) You may need to change your web.config in some cases so here’s another MS link: (Links removed due to insufficient reputation points) Again I ran into trouble as the ASP.DLL from C/ Windows/ system32/ inetsrv/ asp.dll was missing. To overcome this I found another copy from somewhere else on my system and copied the file into the inetsrv folder. The site was still not working though, so I carried on to discover that there should be at least one 32bit asp.dll file and one 64bit asp.dll file on the system. I presume that I had copied the incorrect bit asp.dll into the inetsrv folder and I could not identify which was which; so, that is where I got to. I then went back to basics trying to learn more about opening JSON files when I ran into a post on yahoo answers from a guy called Colanth who stated “JSON is a technique, not a format’. Thinking more about this statement I found another JSON tutorial that just focused on creating a simple JSON call function here: (Links removed due to insufficient reputation points) Noting that the tutorial also outlined that ‘JSON was a technique’ I read on. The tutorial detailed that JSON is JavaScript. Then, it occurred to me that if JSON is not the format but JavaScript is I should change the file name of my JSON files to .js and then change my JSON file paths to .js as my system recognises JavaScript to see what happens. So I did, and Blam! (To quote Dog the Bounty Hunter) Everything works! Granted I need to sort the MIME type and missing asp.dll issues. I think that the asp.dll might be missing because I uninstalled Visual Studio 2010 for VS2012 and the removal of VS2010 may have removed the asp.dll file. I understand that VS2012 builds on installed versions of VS2010 so VS2012 may have expected the asp.dll to already be installed. Saying that VS2010 should not have removed it if that is the case; who knows? Also, JSON files are JSON files for a reason so I need to get to the bottom of that issue to. But, after a lot of hard work I have a work around for the minute. Here are some other things that I checked that may give you some ideas too: URL’S, file paths and file names Localhost – which port the site and response files are running on JSON script using the validator for ideas: <a href="http://jsonlint.com/" rel="nofollow">http://jsonlint.com/</a> Check he code for errors and typos Try running IIS on in 2.0 and 4.0 modes Check web.config script for JSON Tried running the code in html, aspx, cshtml and php websites Tried moving the JSON file to different locations; check JSON file paths Tried different YUI configurations both local and external using the Configurator Looked at different browser security settings Changed Firefox about:config: for security.fileuri.strict_origin_policy Increased timeout settings in the code Check yur system handles JSON MIME types Is the version of IIS correct 5.0, 6.0, 7.0 , 7.5 etc Check the server WCF settings Change code Change global settings
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POYUI JSON - How do I Add New Object Members During Parsing?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USDaniB
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.