Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Bug: Query on Google Spreadsheet blocked by IE10 due to MIME type mismatch #1281

Open
orwant opened this issue May 9, 2015 · 11 comments
Open

Bug: Query on Google Spreadsheet blocked by IE10 due to MIME type mismatch #1281

orwant opened this issue May 9, 2015 · 11 comments
Assignees
@orwant
Labels
Priority-Medium Type-Defect

Comments

@orwant
Copy link
Collaborator

orwant commented May 9, 2015 

What steps will reproduce the problem? Please provide a link to a
demonstration page if at all possible, or attach code.
1. Have IE10 (build 10.0.9200.16635)
2. View the charts on http://sgratrace.appspot.com/
3. Charts timed out because of MIME type mismatch

My charts work perfectly on Chrome and Firefox but breaks on IE10. The IE10 console
reports the following error:


SEC7112: Script from https://accounts.google.com/ServiceLogin?service=wise&passive=1209600&continue=https://docs.google.com/spreadsheet/tq?key%3D0ArgBv2Jut0VxdERtWEU4UE5BbFd2TnZzVW8yTlB5eFE%26headers%3D1%26gid%3D0%26pub%3D1%26tq%3Dselect%2BL,%2BA,%2BH,%2BB,%2BI,%2BC,%2BF,%2BE,%2BG%2Bwhere%2BJ%2B%253D%2B...
DreqId:0 was blocked due to mime type mismatch sgratrace.appspot.com


Question posted on Stackoverflow

http://stackoverflow.com/questions/17905682/are-google-chart-tools-able-to-query-google-spreadsheet-on-ie10

Is issue related to #356?

https://code.google.com/p/google-visualization-api-issues/issues/detail?id=356

What component is this issue related to (PieChart, LineChart, DataTable,
Query, etc)?

At least the following charts are affected, though I suspect this problem extends to
all charts.

Combo and Table charts: http://sgratrace.appspot.com/

Bubble chart: http://sgratrace.appspot.com/diploma.html

Line chart: http://sgratrace.appspot.com/household.html



Are you using the test environment (version 1.1)?
(If you are not sure, answer NO)
NO

What operating system and browser are you using?
Win7, IE10


*********************************************************
For developers viewing this issue: please click the 'star' icon to be
notified of future changes, and to let us know how many of you are
interested in seeing it resolved.
*********************************************************

Original issue reported on code.google.com by seahrh on 2013-08-08 02:48:36
@orwant
Copy link
Collaborator Author

orwant commented May 9, 2015 

I have the same issue regardless of visualization. I am trying to retreive data from
a google drive spreadsheet.

Original issue reported on code.google.com by ilana.hakim on 2013-09-27 19:12:37

@orwant orwant self-assigned this May 9, 2015
@orwant
Copy link
Collaborator Author

orwant commented May 9, 2015 

could it be related to the windows version as well (I have win8) ?

one more observation - running the same web page on my localhost works just fine with
IE10, but when deploying to a remote server (even the jsfiddle example) it is blocked
like described.

Original issue reported on code.google.com by ilana.hakim on 2013-09-27 19:18:33

@orwant
Copy link
Collaborator Author

orwant commented May 9, 2015 

I'm having similar issues in the Web browser on Android when loading a DataTable with
a query from a Google Drive spreadsheet.  I'm getting the error "Uncaught SyntaxError:
Unexpected token <" in the Android Javascript console (about:debug).  I get this same
error with the original poster's example as well.  My situation is not the same but
could be related.

Original issue reported on code.google.com by aaron.s.hawley on 2013-09-27 19:39:01

@orwant
Copy link
Collaborator Author

orwant commented May 9, 2015 

Hi Aaron, I've seen that error occur when you are not signed into your Google account
(or the account that you are signed into does not have permission to read from the
spreadsheet). You probably want to make your spreadsheet publicly readable. Let me
know whether that fixes your issue.

Original issue reported on code.google.com by grabks@google.com on 2013-09-27 19:41:55

@orwant
Copy link
Collaborator Author

orwant commented May 9, 2015 

Yes, that seemed to be the issue.  Thank you.

Original issue reported on code.google.com by aaron.s.hawley on 2013-10-16 14:10:19

@orwant
Copy link
Collaborator Author

orwant commented May 9, 2015 

Hi, I am the OP. I set my spreadsheet publicly readable (Anyone who has the link can
access. No sign-in required) but I still encounter the issue on both IE and Chrome
mobile. Please help as I'm at a loss of what to do.

Chart - http://sgratrace.appspot.com/

Google Spreadsheet  - https://docs.google.com/spreadsheet/ccc?key=0ArgBv2Jut0VxdERtWEU4UE5BbFd2TnZzVW8yTlB5eFE&usp=sharing

Code - https://github.com/seahrh/sgratrace/blob/master/war/js/rats.js

The relevant functions are 
Rats.Viz.GraduateEmploymentSurvey.Qualification.query
Rats.Viz.GraduateEmploymentSurvey.Qualification.dashboard


RH

Original issue reported on code.google.com by seahrh on 2013-12-18 23:16:39

@orwant
Copy link
Collaborator Author

orwant commented May 9, 2015 

I think that's because you link to the spreadsheet with

 https://docs.google.com/spreadsheet/pub?key=0ArgBv2Jut0VxdERtWEU4UE5BbFd2TnZzVW8yTlB5eFE

and it should be

 https://docs.google.com/spreadsheet/tq?key=0ArgBv2Jut0VxdERtWEU4UE5BbFd2TnZzVW8yTlB5eFE

Original issue reported on code.google.com by aaron.s.hawley on 2013-12-19 00:16:17

@orwant
Copy link
Collaborator Author

orwant commented May 9, 2015 

Thanks Aaron for pointing that out. I updated the dataSourceUrl in my other site to
tq?key=... but the same error remains. 

Found the issue in a forum thread. The error seems to arise from Google Drive instead
of Visualization API. IE and Chrome force user to login before Google spreadsheet returns
data to chart. Would the Google Viz team follow up on this issue with the Drive team
please?

  https://groups.google.com/d/msg/google-visualization-api/o2Okyr5vK3E/Vj0oeX7--ZAJ

RH

Original issue reported on code.google.com by seahrh on 2013-12-26 19:23:04

@orwant
Copy link
Collaborator Author

orwant commented May 9, 2015 

You're welcome. The login issue with Google spreadsheet happens for me as well.  If
you are logged in to Google Drive or signed-out of Google Drive the charts will load.
 If you haven't been in Google Drive for a while, then the response from Google spreadsheet
is a login request rather than the requested data.  This results in the charts failing
with "Request timed out".  Hopefully, this will be resolved.

Original issue reported on code.google.com by aaron.s.hawley on 2013-12-26 20:17:02

@orwant
Copy link
Collaborator Author

orwant commented May 9, 2015 

This continues to be a problem.  I see a newer post over on docs for this.

http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/report-an-issue/desktop/mXanabWbSAs

Seems this issue should have a high priority.

Original issue reported on code.google.com by luke_adams@vaeb.uscourts.gov on 2014-01-03 15:47:09

@orwant
Copy link
Collaborator Author

orwant commented May 9, 2015 

As I can see, it doesn't depend on browser and breaks all charts.
The problem is you have to be logged in to Google services in order to get data.
If you try in incognito mode on any browser, it will fail.

Original issue reported on code.google.com by I.Grechuhin on 2014-09-14 08:08:40

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@orwant orwant

Labels
Priority-Medium Type-Defect
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@orwant