You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/09/20 02:36:18 UTC
[Bug 121057] New: Webquery: Insert Link to External Data gives
server Error in ver. 3.4.1, used to work perfectly
https://issues.apache.org/ooo/show_bug.cgi?id=121057
Priority: P3
Bug ID: 121057
Assignee: ooo-issues@incubator.apache.org
Summary: Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Severity: blocker
Issue Type: DEFECT
Classification: Application
OS: Windows XP
Reporter: denver80218us@yahoo.com
Hardware: PC
Status: UNCONFIRMED
Version: AOO 3.4.1
Component: open-import
Product: spreadsheet
Created attachment 79577
--> https://issues.apache.org/ooo/attachment.cgi?id=79577&action=edit
file used to do WebQueery perfectly in earlier version, now NOTHING
WebQuery: Loading table from Internet gets error: URL [see below] works fine in
Firefox, OO file worked perfectly in previous version [3.3??] and File is
attached, now I updated to your latest 3.4.1 and get "server Error" Right after
"Insert Link to External Data", pasted this link to URL box, push Return and
get an error. [I'm after “main_Table” in Available Tables window.]
Document that used to work just fine in previous version has the data, now upon
opening and clicking Update [this file contains link to external data?] it
gives error AND erases everything ["The link could not be updated."]. Also
Refresh every 60 seconds worked, now it stopped.
Here is the link - below. Document enclosed - email me if you have questions -
thanks!! [login email denver80218us@yahoo.com or alexander1us@msn.com] but I
think I covered it all in detail. Worked, now in 3.4.1 does NOT. I tried a
blank New Spreadsheet but no result either. You can test it in your older
version. [How can I get older version to get it working till it's fixed and
resolved??]
File enclosed: webqueryError
[A6 is the cell where i load data] saved as .XLS if that makes any difference?
I tried blank sheet and it still gives same error.
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?SessionID=2F0293B4451B4D12B89D6C5364F67439&Symbol=AAPL&Range=0&lstMarket=3&ChainType=&AdjNonStdOptions=OFF&lstMonths=Nov12&FromVB6=True#
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
jsc@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jsc@apache.org
--- Comment #10 from jsc@apache.org ---
I downloaded the webqueryError.xls and load it. I got asked that the file
contains links to other files and if I want update them. Clicking ok triggered
an update and the document got updated. I can't reproduce the problem withe
this document on MacOS and AOO 3.4.1
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
Bug 121057 depends on bug 121202, which changed state.
Bug 121202 Summary: webdav ucp seems broken
https://issues.apache.org/ooo/show_bug.cgi?id=121202
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |RESOLVED
Resolution|--- |FIXED
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #3 from Alexander <de...@yahoo.com> ---
Even stripped down version of URL gives error [now little progress - it may
work sometimes, but not ALL, mostly NOT: [And my Windows XP is updated to the
latest - ran update last couple weeks or so when provided by MS]
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=AAPL&Range=0&lstMarket=3&lstMonths=Nov12
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=AAPL&Range=0&lstMarket=3&lstMonths=Nov12&FromVB6=True
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #6 from Ariel Constenla-Haile <ar...@apache.org> ---
Created attachment 79729
--> https://issues.apache.org/ooo/attachment.cgi?id=79729&action=edit
First error when Linking to external data in Calc
In Calc, menu Insert - Link to external data...
URL of external data source:
http://twolf.hermitstore.com/wolf.gz/ver001/yield.html
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #13 from jsc@apache.org ---
The second Url in comment 4 works for me as well, the first Url only once and
the Url from comment 6 doesn't work for me.
Seems to be not stable or a general problem. Further investigation necessary.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #17 from Ariel Constenla-Haile <ar...@apache.org> ---
(In reply to comment #0)
> Created attachment 79577 [details]
> file used to do WebQueery perfectly in earlier version, now NOTHING
Works after updating serf to 1.2.0
> https://www.optionsxpress.com/OXNetTools/Chains/index.
> aspx?SessionID=2F0293B4451B4D12B89D6C5364F67439&Symbol=AAPL&Range=0&lstMarket
> =3&ChainType=&AdjNonStdOptions=OFF&lstMonths=Nov12&FromVB6=True#
Works too
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
edoardopanfili <ed...@aspix.it> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |VERIFIED
--- Comment #23 from edoardopanfili <ed...@aspix.it> ---
tested with
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=AAPL&Range=10&lstMonths=1/19/2013
http://twolf.hermitstore.com/wolf.gz/ver001/yield.html
on OS X 10.8.4
AOO400m3(Build:9702) - Rev. 1499347
2013-07-03 14:06:53 (Wed, 03 Jul 2013)
and
Windows 8
AOO400m3(Build:9702) - Rev. 1499347
2013-07-03 15:11:47 (Mi, 03 Jul 2013)
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
Ariel Constenla-Haile <ar...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Depends on| |121202
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #21 from Ariel Constenla-Haile <ar...@apache.org> ---
(In reply to comment #20)
> I'm just a regular user... how do I install this serf thing on my Windows XP
> Home, latest version??? You say "Works after updating serf to 1.2.0"
This was to register that updating our version of serf solves the bug. I didn't
mean you download and install serf (something impossible for a regular user, as
you have to build it from source).
> Thanks guys for fixing it. Just what to do with it??????
Unfortunately, OpenOffice does not provide partial updates for important fixes.
So you have to wait until the next release.
If this issue is a blocker for you, and you are adventurous, you could try a
build from the nightly build bot (if you are interested, I pass you the link).
If that build solves the bug, you could try copying the serf libraries from
this build into the installation folder of OpenOffice 3.4 (if you are
interested, I tell which libraries to copy, and where to copy them).
Disclaimer: I'm not suggesting you to do so ;) (even if you are adventurous,
the build from the build bot will replace previous versions of OO, so this
should be tried in a virtual machine).
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #1 from Alexander <de...@yahoo.com> ---
Want to add that "Insert Link to External Data" worked minutes before OO update
to 3.4.1, file enclosed is from 2 days ago = everything is current, current
data in spreadsheet.
BTW, is there any way to delete my 2 email addresses from my initial
submission? [don't want to get spammed] - thanks!!
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #16 from Ariel Constenla-Haile <ar...@apache.org> ---
(In reply to comment #6)
> Created attachment 79729 [details]
> First error when Linking to external data in Calc
>
> In Calc, menu Insert - Link to external data...
> URL of external data source:
> http://twolf.hermitstore.com/wolf.gz/ver001/yield.html
Works after updating serf to 1.2.0
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #20 from Alexander <de...@yahoo.com> ---
I'm just a regular user... how do I install this serf thing on my Windows XP
Home, latest version??? You say "Works after updating serf to 1.2.0"
I downloaded "serf" and it has a bunch of files, no installer, opened Readme
and have no idea what it is and what to do with it??:
--------
Welcome to serf, a high-performance asynchronous HTTP client library.
The serf library is a C-based HTTP client library built upon the Apache
Portable Runtime (APR) library. It multiplexes connections, running the
read/write communication asynchronously. Memory copies and transformations are
kept to a minimum to provide high performance operation.
* Status: http://code.google.com/p/serf/wiki/
* Site: http://code.google.com/p/serf/
* Code: http://serf.googlecode.com/svn/
* Issues: http://code.google.com/p/serf/issues/list
* Mail: serf-dev@googlegroups.com
* People: Justin Erenkrantz, Greg Stein
----
Quick guide for the impatient
(Unix)
% ./configure
% make
% make install
----
Building serf from a Subversion checkout (non-packaged releases)
We suggest that you try out 'serfmake'.
% ./serfmake --prefix=/usr/local/serf --with-apr=/usr/local/apr install
If you want to use the autoconf build system and are using a Subversion
checkout, you need to run buildconf and have APR and APR-util sources handy.
% ./buildconf --with-apr=/path/to/apr --with-apr-util=/path/to/apr-util
(By default, buildconf will look in . and ../ for apr and apr-util.)
Then, you can use ./configure, make, etc.
-------------------------------
Thanks guys for fixing it. Just what to do with it??????
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #14 from Alexander <de...@yahoo.com> ---
Thanks for testing it guys... [yes sometimes some URLs work] BUT overall most
URL don't work ALL the time, or consistently... pointing to some BUG. Problem
that needs to be resolved so it works 100% - as it used to work in previous
versionS. Noticed a Mac may work "better"? :)
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #19 from Ariel Constenla-Haile <ar...@apache.org> ---
(In reply to comment #15)
> Similar problem has been seen with 3.4.1:
> http://www.oooforum.org/forum/viewtopic.phtml?t=182626
The URL posted by the forum user works fine after updating to serf 1.2.0:
http://shares.telegraph.co.uk/indices/?index=NMX
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #7 from Ariel Constenla-Haile <ar...@apache.org> ---
Created attachment 79730
--> https://issues.apache.org/ooo/attachment.cgi?id=79730&action=edit
Second error in Calc
Despite of the first error, the application allows selecting import options
(like locale).
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
Ariel Constenla-Haile <ar...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |arielch@apache.org
Ever confirmed|0 |1
OS|Windows XP |All
--- Comment #8 from Ariel Constenla-Haile <ar...@apache.org> ---
Confirmed on Linux
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #12 from Ariel Constenla-Haile <ar...@apache.org> ---
(In reply to comment #10)
> I downloaded the webqueryError.xls and load it. I got asked that the file
> contains links to other files and if I want update them. Clicking ok
> triggered an update and the document got updated. I can't reproduce the
> problem withe this document on MacOS and AOO 3.4.1
Attachment 79577 works for me too, but please try with URLs in comment 4 and
comment 6
Both work in OOo 3.4.0 BETA OOO340m0 9583, and don't work with AOO.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
Andreas Säger <vi...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |villeroy@t-online.de
--- Comment #5 from Andreas Säger <vi...@t-online.de> ---
Tools>Options>Internet>Proxies: None
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
kiloran <ki...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kiloran.public+ooforum@gmai
| |l.com
--- Comment #15 from kiloran <ki...@gmail.com> ---
Similar problem has been seen with 3.4.1:
http://www.oooforum.org/forum/viewtopic.phtml?t=182626
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #18 from Ariel Constenla-Haile <ar...@apache.org> ---
(In reply to comment #4)
> this one is the *simplest* of all - *never works*, yet in ANY browser [IE,
> Firefox] works fine [till Jan '13]:
> https://www.optionsxpress.com/OXNetTools/Chains/index.
> aspx?Symbol=AAPL&Range=10&lstMonths=1/19/2013
Works after updating serf to 1.2.0
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #4 from Alexander <de...@yahoo.com> ---
this one is the *simplest* of all - *never works*, yet in ANY browser [IE,
Firefox] works fine [till Jan '13]:
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=AAPL&Range=10&lstMonths=1/19/2013
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
fanyuzhen@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |fanyuzhen@gmail.com
QA Contact| |edoardo@aspix.it
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #11 from jsc@apache.org ---
sorry your email addresses can't be deleted.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
Ariel Constenla-Haile <ar...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |RESOLVED
Resolution|--- |FIXED
Target Milestone|--- |AOO 4.0
--- Comment #22 from Ariel Constenla-Haile <ar...@apache.org> ---
Fixed on trunk.
@Alexander: the next release will be OpenOffice 4.0, there is no final release
date yet; it might be in the middle of 2013
In these times of cloud storage and web connectivity, this bug might be a
blocker for several users; it might make sense to think about a bug fix
release. This kind of discussions happen on the development mailing list,
anyone interested can post a mail bringing this topic.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
Ariel Constenla-Haile <ar...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |regression
--- Comment #9 from Ariel Constenla-Haile <ar...@apache.org> ---
Regression from OOo 3.4 Beta
may be introduced while removing neon, see bug 118569
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121057] Webquery: Insert Link to External Data gives server
Error in ver. 3.4.1, used to work perfectly
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121057
--- Comment #2 from Alexander <de...@yahoo.com> ---
Likewise Edit -> Links... Update nor Modify buttons don't work.
--
You are receiving this mail because:
You are the assignee for the bug.