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] paj...@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
