search

JimHagan / wwwsqldesigner

Automatically exported from code.google.com/p/wwwsqldesigner
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

Failed to export as sql script #143

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Create a new table
2. Save/Load 
3. Generate SQL ((tested with mysql, sqlite)

What is the expected output? What do you see instead?
Expected output: SQL script generated in Input/Output window.
Received output: XML error: 'undefined' is not an object (evaluating 
'result.documentElement')

What version of the product are you using? On what operating system?
-WWWSQLDesigner 2.6
-Mac OS Lion
-Nginx 1.0.3
-PHP 5

Please provide any additional information below.
The same zip file if run locally (without web server) works fine.
I have added MIMEType to cater for xsl file to be application/xml

Original issue reported on code.google.com by nhis...@gmail.com on 14 Dec 2011 at 6:41

GoogleCodeExporter commented 9 years ago 
Very strange, never seen anything like this. What Web Browser? Can you test 
with latest Firefox? Can you provide a link to your installation?

Original comment by ondrej.zara on 14 Dec 2011 at 8:17

GoogleCodeExporter commented 9 years ago 
I just tested with Firefox 8.0.1 and it works fine.
However I'm still getting the same error with Safari 5.1.2 and Chrome 
16.0.912.63 beta.

Unfortunately, I don't have a public web server for your testing.

Original comment by nhis...@gmail.com on 14 Dec 2011 at 9:30

GoogleCodeExporter commented 9 years ago 
Okay; does the demo installation 
(http://ondras.zarovi.cz/sql/demo/?keyword=default) work in Safari and Chrome?

Original comment by ondrej.zara on 14 Dec 2011 at 1:50

GoogleCodeExporter commented 9 years ago 
Yeah both works fine.

Original comment by nhis...@gmail.com on 15 Dec 2011 at 1:29

GoogleCodeExporter commented 9 years ago 
So the only non-working combo is:

- your webserver (nginx 1.0.3)
- Safari 5 OR Chrome 16

Strange. I will try to reproduce the problematic behavior by creating a similar 
setup, but I cannot guarantee any time estimates...

Original comment by ondrej.zara on 15 Dec 2011 at 6:44

GoogleCodeExporter commented 9 years ago 
No problem as I can use Firefox for now to export to sql.

Thanks. This is one great tool.

Original comment by nhis...@gmail.com on 16 Dec 2011 at 1:17

GoogleCodeExporter commented 9 years ago 
Hello, I am facing the same issue with Google Chrome 25 and NGINX with PHP5, 
PHP5-FPM. The demo above indeed works fine so I can only imagine it is 
something in NGINX, PHP, or FPM.

Original comment by kay...@gmail.com on 30 Mar 2013 at 2:59

GoogleCodeExporter commented 9 years ago 
Are you able to provide a link for your setup, i.e. can your WWWSQLDesigner's 
installation be publicly available?

Original comment by ondrej.zara on 1 Apr 2013 at 12:07

GoogleCodeExporter commented 9 years ago 
Hi Ondřej, I'm having the same issue. Here's a link:

http://dev.michalvondracek.cz/sql

nginx version: nginx/1.1.19
PHP 5.3.10-1ubuntu3.6 with Suhosin-Patch (php5-fpm)

Thx for such a great software. Díky moc.

Original comment by i...@michalvondracek.cz on 1 Jun 2013 at 2:36

GoogleCodeExporter commented 9 years ago 
Your webserver needs to serve XSL files with a correct mime type (such as 
text/xml); the browser needs to recognize them as XML in order to process them. 
They are currently served as "application/octet-stream".

Original comment by ondrej.zara on 3 Jun 2013 at 6:34