Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

help with updating inventory SQL


holmes74

Recommended Posts

Posted

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

Posted

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...