Edit report at https://bugs.php.net/bug.php?id=61957&edit=1
ID: 61957
User updated by: dean dot sanderson at 3dgroupuk dot com
Reported by: dean dot sanderson at 3dgroupuk dot com
Summary: XMLReader::open(): Unable to open source data i
-Status: Feedback
+Status: Open
Type: Bug
Package: XML Reader
Operating System: Windows
PHP Version: 5.3.12
Block user comment: N
Private report: N
New Comment:
Sorry i did try this before. But to double check i did it again using urlencode. Still the same
error.
Url give was:
http://images.gwales.com/cgi-bin/xmlif?userid=1&password=canolfan&sql=SELECT%20*%20FROM%20(SELECT%20isbn,%20price_vat,pub_code,available,title,author,publication_date,link_to_marketing,medium,prod_lang_code,c1.CATEGORY_DESCRIPTION%20text_category,c2.CATEGORY_DESCRIPTION%20text_sub_category,DESC1,DESC2,PROD_SIZE,PAGES,%20row_number()%20OVER%20(ORDER%20BY%20ISBN)%20rn%20FROM%20PRODUCTS,%20CATEGORIES%20c1,%20CATEGORIES%20c2%20WHERE%20INVALID='N'%20AND%20ORDER_ALLOWED_OME='Y'%20AND%20c1.CATEGORY=PRODUCTS.CATEGORY%20AND%20c2.CATEGORY=PRODUCTS.SUB_CATEGORY)%20WHERE%20rn%20BETWEEN%201%20and%2050000%20ORDER%20BY%20rn
Previous Comments:
------------------------------------------------------------------------
[2012-05-06 10:44:37] pajoye@php.net
Encode the URI correctly and it should work fine.
------------------------------------------------------------------------
[2012-05-06 01:15:04] dean dot sanderson at 3dgroupuk dot com
Description:
------------
It seems this function doesn't like long url's
$z = new XMLReader;
$z->open("http://images.gwales.com/cgi-bin/xmlif?userid=1&password=canolfan&sql=SELECT
* FROM (SELECT isbn,
price_vat,pub_code,available,title,author,publication_date,link_to_marketing,medium,prod_lang_code,c1.CATEGORY_DESCRIPTION
text_category,c2.CATEGORY_DESCRIPTION text_sub_category,DESC1,DESC2,PROD_SIZE,PAGES, row_number()
OVER (ORDER BY ISBN) rn FROM PRODUCTS, CATEGORIES c1, CATEGORIES c2 WHERE INVALID='N' AND
ORDER_ALLOWED_OME='Y' AND c1.CATEGORY=PRODUCTS.CATEGORY AND
c2.CATEGORY=PRODUCTS.SUB_CATEGORY) WHERE rn BETWEEN 1 and 10 ORDER BY rn");
returns
XMLReader::open(): Unable to open source data
this error has started to apear since upgrading from php 5.2 to 5.3
Test script:
---------------
Tried
$z = new XMLReader;
$z->open("http://www.w3schools.com/xml/cd_catalog.xml");
works fine.
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=61957&edit=1