holmes74 Posted July 10, 2010 Posted July 10, 2010 im am have a problem with uploanding my product i use EZDROPSHIP as my supplier and only getting 49 out of 304 on my website when i upload from them i get this Warning: fopen(http://www.ppiimages.com/pics/(S)VCD) [function.fopen]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home3/adkshopn/public_html/admin/hotbuy4u_cli.php on line 101 Warning: fopen(http://www.ppiimages.com/pics/CD-R/RW & Windows Media Audio for maximum disc compatibility and listening pleasure.</div> </li> <li> <div class="""MsoNormal""">Picture CD enables you to view MP3 audio and digital pictures using CD-R or CD-RW.</div> </li> <li> <div class="""MsoNormal""">When inserting a Picture CD in the DVD player) [function.fopen]: failed to open stream: HTTP request failed! HTTP/1.1 400 Bad Request in /home3/adkshopn/public_html/admin/hotbuy4u_cli.php on line 105 110 i:(S)VCDj:CD-R/RW & Windows Media Audio for maximum disc compatibility and listening pleasure. Picture CD enables you to view MP3 audio and digital pictures using CD-R or CD-RW. When inserting a Picture CD in the DVD playerf: -------------------------------------------------------------------------------- REPLACE INTO products ( products_id, products_quantity, products_weight, products_model, products_image, products_price, products_date_added, products_status, manufacturers_id) VALUES ( 'DVD+R/RW', 'more information is captured from the original analogue sound wave form', 'showing your JPEG's and/or MP3 files on the disc. Just select the music and pictures files you wish to enjoy and press play or OK. You can watch your pictures on TV with your music playing simultaneously. The versatile multi region DVP5140 plays any region PAL or NTSC DVD from any country on a normal NTSC TV. Features: Region 1 DVD Player with integral PAL to NTSC Converter Progressive Scan component video for optimized image quality 192kHz 24 bit audio DAC delivers high quality audio Progressive Scan for razor sharp and flicker free images Plays CD', 'DVD-R/RW', '', 'DivX for maximum disc compatibility and viewing pleasure. DivX Ultra combines DivX playback with great features like integrated subtitles', '2010-07-10 14-14-03' , '1' , '686' ):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's and/or MP3 files on the disc. Just select the music and pictures files you wis' at line 1 dont know how to fix does anyone else know about this MYSQL on last line
MrPhil Posted July 10, 2010 Posted July 10, 2010 Hoo boy, what a mess! I'm not familiar with this particular add-on, but I can see some problems that you might be able to deal with. 1) Warning: fopen(http://www.ppiimages.com/pics/CD-R/RW & Windows Media Audio for maximum disc compatibility and listening pleasure.</div> </li> <li> <div class=""... Are you sure that you are supposed to give the whole product description, including HTML markup, as something to be "opened" and read by PHP? The fopen() function is supposed to receive either a page URL or a file path -- I suspect it's not going to be happy being fed HTML markup, as well has having / in it (CD-R/RW) that looks like a path. Perhaps the system is asking for a URL giving the content to use, and you misunderstood it to be the content itself, starting with a product image URL? 2) captured from the original analogue sound wave form', 'showing your JPEG's and/or MP3 files on the disc... JPEG's would have to be escaped to JPEG\'s, as you have an apostrophe ' within a '-delimited string. Not to mention that JPEGs would be more grammatically correct in this case... Anyway, whatever you're receiving from the source (CSV?) may have to be cleaned up manually or with a utility, to escape ' within strings. 3) REPLACE INTO products ( products_id, products_quantity, products_weight, products_model, products_image, products_price, products_date_added, products_status, manufacturers_id) VALUES ( 'DVD+R/RW',... The list of fields and VALUES don't seem to match up. Specifically, the first 6 fields you give don't seem to match what the product field names suggest that the data should be.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.