Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

EP Upload Syntax Errors with Product Description


Recommended Posts

Posted

Hi,

 

I've got EP isntalled and working great. To test I've downloaded a full EP file, made sure that all my model nubmers were different (as some weren't) and then tried to upload it again, unchanged, as suggested in the EP manual.

 

I upload my file (in the correct format), by browsing to it on my PC and then clicking add to DB.

 

It seems to upload the file ok up to a certain point and I then get:

 

File uploaded.

Temporary filename: /tmp/phpvhJYST

User filename: EP2004Feb14-1111-new2.txt

Size: 188490

| 1024MB | Memory.jpg | 1024MB DDR | 1024MB PC2 | | 192.7 | 0.5 | 13/02/2004 | 19/01/2004 | 0 | 1 | Color | 14 | | Black | 15 | | Silver | 2 | Size | 3 | Model | 5 | | Value | 6 | | Premium | 7 | | Deluxe | 8 | | PS/2 | 9 | | USB | 4 | Memory | 1 | | 4 mb | 2 | | 8 mb | 3 | | 16 mb | 4 | | 32 mb | 5 | Version | 10 | | Download: | 13 | | Box: Windo | 6 | Hush Memor | 7 | Hush Optic | 8 | Hush Hard | 16 | | 80GB | 9 | Hush Softw | Other | Components | Memory | | | | | | Taxable Go | Active Updated

| 120GB 3,5? | hushlogo-s | 120GB 3,5? | Hush PC - | | 35.17 | 0 | 13/02/2004 | 22/11/2003 | 0 | 1 | Color | 14 | | Black | 15 | | Silver | 2 | Size | 3 | Model | 5 | | Value | 6 | | Premium | 7 | | Deluxe | 8 | | PS/2 | 9 | | USB | 4 | Memory | 1 | | 4 mb | 2 | | 8 mb | 3 | | 16 mb | 4 | | 32 mb | 5 | Version | 10 | | Download: | 13 | | Box: Windo | 6 | Hush Memor | 7 | Hush Optic | 8 | Hush Hard | 16 | | 80GB | 9 | Hush Softw | Hush Techn | Hush Silen | Hush Hard | | | | | | Taxable Go | Active Updated

| 120GB Barr | Hdd.jpg | 120GB Barr | 120GB Barr | www.seagat | 74.03 | 1 | 13/02/2004 | 18/11/2003 | 0 | 1 | Color | 14 | | Black | 15 | | Silver | 2 | Size | 3 | Model | 5 | | Value | 6 | | Premium | 7 | | Deluxe | 8 | | PS/2 | 9 | | USB | 4 | Memory | 1 | | 4 mb | 2 | | 8 mb | 3 | | 16 mb | 4 | | 32 mb | 5 | Version | 10 | | Download: | 13 | | Box: Windo | 6 | Hush Memor | 7 | Hush Optic | 8 | Hush Hard | 16 | | 80GB | 9 | Hush Softw | Seagate | Components | Hard Drive | | | | | | Taxable Go | Active Updated

 

it lists like the above for a while until it get's to a product with a problem, and then it shows this error:

 

1064 - 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 'unique heat dissipation technology for the CPU, Northbridge

 

it then goes on to show the full description (from the v_products_description_1 column) of the product that has caused this mysterious error.

 

To try and solve it I would remove the offending description from that product (from the v_products_description_1 column) and upload the file again. This time it's get's further down the list but then pops up the same error but for a product further down the list.....

 

I have check and double checked the isntallation and the descriptions in the v_products_description_1 column and can't see any difference from each one and why one causes and error and another doesn't.

 

Oh, before I forget, here's the full desciption from the v_products_description_1 column that seems to be causing the above error:

 

<p><strong>Hush Technologies Hush ATX HTPC</strong></p>  <p><font color="#FF0033">CONFIGURE YOUR OWN HUSH ATX SPECIFICATION</font> <a href="http://www.emvi-htpc.com/store/ccc.php"><font color="#3300FF">HERE</font></a></p>  <p><font color="#FF0033">WITH OUR NEW</font> <a href="http://www.emvi-htpc.com/store/ccc.php"><font color="#3300FF">CUSTOM    COMPUTER CREATOR</font></a></p>  <p> </p>  <p>Swift, sexy and silent, the new Hush ATX proves that silent PCs now mean business.    Providing increased flexibility and greater choice for multimedia, gaming, design,    medical, media, audio, libraries, HTPC, and the home, the Hush ATX benefits    from the advantages of Hush Technologies' unique heat dissipation technology    for the CPU, Northbridge and GPU. At last there is a silent solution for Intel©    Pentium© 4 and Celeron Processors. </p>  <p>All Hush ATX PCs are hand built in Germany, soak tested for 24 hours and despatched    by UPS to your door within approximately 2 to 3 weeks of ordering.</p>  <p>  </p>  <p><strong>Specifications</strong> </p>  <ul>    <li>Hush ATX HTPC-System</li>    <li><font color="#CC0000">Fanless</font></li>    <li>Consisting of: Mainboard FIC P4M-800T, Socket 478VIA PT800 Chipset</li>    <li><font color="#CC0000">2000MHz Intel® Celeron® Processor</font></li>    <li><font color="#CC0000">256MB DDRAM PC400</font></li>    <li><font color="#CC0000">120GB Seagate Barracuda HDD 7200 RPM</font></li>    <li><font color="#CC0000">Teac DVD-Rom</font></li>    <li>Graphic Card-Kit incl. <font color="#CC0000">Radeon 9200V 128MB DDR</font>      SDRAM DVI+CRT+TV out - <font color="#CC0000">Fanless</font></li>    <li>AGP 4X RiserCard</li>    <li> V1020 <font color="#CC0000">SAT Tuner Card</font> PCI without Common Interface      <font color="#CC0000">incl. Remote Control</font></li>    <li>Ports on Board: 4x USB 2.0, 2x IEEE 1394 FireWire</li>    <li><font color="#CC0000">6 channel Audio</font>, SPDIF out (Optisch/RCA) </li>    <li><font color="#CC0000">10/100 Base-T Ethernet</font>, serial parallel, Mouse      and Keyboard Ports</li>    <li>Hush ATX Aluminium Case with 3 Heatpipes</li>    <li> 240Watt Power Supply, Fanless, without USB / FireWire Panel in Front.</li>  </ul>  <p> </p>  <p><strong>Detailed</strong> <strong>Specifications</strong></p>  <p>? Black or Silver Hush ATX PC Enclosure<br>    ? Up to 15mm thick Aluminium Chassis <br>    ? Case dimensions: 440mm x 380mm x 99mm (W X D x H) inc. feet<br>    ? Weight: 15Kg approx. </p>  <p><strong>PT800 Chipset, up to 2.8GHz Passively Cooled Pentium 4 CPU</strong><br>    ? FIC P4M-800T VIA PT800 / 8237 Chipset 800/533Mhz FSB Motherboard<br>    ? Intel Celeron 2.0 / 2.7Ghz or Pentium 4 Hyperthreading 2.6 / 2.8Ghz    CPU </p>  <p><strong>Near Silent Operation</strong><br>    ? Passively cooled, antivibrational design - no noisy fans</p>  <p><strong>Choice of ATI Radeon 9200V/9800SE Graphics</strong><br>    ? 128MB ATI Radeon 9200V Graphics card or<br>    ? 128MB ATI Radeon 9800SE All-in-Wonder Graphics with PVR and Remote </p>  <p><strong>6 Channel Sound with Optical Output</strong><br>    ? 6 channel AC97 v2.2 compliant sound, integrated optical S/PDIF in and    out</p>  <p><strong>Up to 1GB DDR400, 160GB 7200RPM Serial ATA and DVD Rewriter</strong><br>    ? 256MB / 512MB / 1GB PC3200 DDR400 DIMMs (dual channel) <br>    ? 160GB / 160GB IDE or Serial ATA 7200RPM Seagate Barracuda HDD <br>    ? Slimline DVD, CD-RW/DVD Combo or DVD-Rewriter optical drive options  </p>  <p><strong>Front Panel </strong><br>    ? Power Button, HDD LED, Optical Drive Bay<br>    ? Optionally: 2xUSB / 4xUSB / 2xUSB and 2xFirewire, and 2x 3.5mm Audio</p>  <p><strong>Rear Panel </strong><br>    ? ATX Plate Mount, 2 x Riser Card Slots, Power Cord Socket, Additional    Slot for external USB/Firewire connectors</p>  <p><strong>Rear Connectors </strong><br>    ? Keyboard, Mouse, 2 x Serial, Parallel, 4 x USB 2.0, 10/100 RJ45 LAN  </p>  <p><strong>Microsoft Operating System Options</strong><br>    ? Pre-installed Microsoft Windows XP Home / XP Professional Options</p>  <p><strong>Universal Power Supply</strong><br>    ? Fanless 240W PSU (typically 82% efficient), ATX Spec 2.01 Standard.<br>    ? Auto switching 100V - 240V AC operation. Audio optimised.</p>  <p><strong>Maximum Operating Temperature / Warranty </strong><br>    ? Maximum 36° Celsius recommended operating air temperature<br>    ? 1 year return to base manufacturers warranty<br>  </p>  <p> </p>  <p><font color="#FF0000">When comparing prices with other Hush PC suppliers don't    forget to include their VAT and delivery costs.</font></p>  <p><font color="#FF0000">We only charge ?16 for delivery to the UK</font></p>  <p><br>  </p>

 

this seems to be my last stumbling block to get EP fully working......Please help!

 

I've also searched all over the forum and can't find the answer...

 

TIA guys.

Steve

Posted

You must escape the apostrophe here:

 

Technologies'

 

like this:

 

Technologies\'

 

Matti

Posted (edited)

As Matti has stated but to help aid location

 

from the advantages of Hush Technologies'

This will have to be done with all instances of the apostrophe ' within your descriptions or the error will reoccur again in a different product

Edited by 241

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Posted
This will have to be done with all instances of the apostrophe ' within your descriptions or the error will reoccur again in a different product

 

Thanks guys - that's sounds like it could be my problem... I will give it a try now

:-)

 

Cheers

Steve

Posted

Hi all,

 

Gave it a try and I was able to upload the complete file ok..but then I came across another problem (one which I was lucky to nitice really!)

 

For some reason, when I upload the new file (of which all I did was change the prices, nothing else) it truncates the products description (from the v_products_description_1 column).

 

EG:

 

This would be in the file in the v_products_description_1 column:

 

<p><strong>Dimension </strong>(L)300*(W)200*(H)185 2.85Kg (N.W.) 4.65Kg (G.W.) <br>    <br>    <strong>Front Panel</strong> USB 2.0 6 in 1 card reader, USB * 2, 1394 * 1, MIC * 1, Line in/out  * 1 <br>  <br>  <strong>Back Panel </strong>SPDIF In/Out * 1 Serial Port * 1, LAN Port * 1, VGA Port * 1, USB  * 2, TV-out Port * 1 <br>  <br>  <strong>Extension Bay</strong> 5.25" * 1, 3.5" * 2 <br>  <br>  <strong>Mainboard </strong>Form Factor Shuttle Form Factor <br>  <br>  <strong>CPU </strong>Socket 478 400/533/800MHz FSB <br>  <br>  <strong>Chipsets </strong>North bridge:ATI RS300 South bridge:ATI IXP150 <br>  <br>  <strong>Memory </strong>Dual Channel DDR 200/266/333/400 SDRAM DIMM * 2 <br>  <br>  <strong>VGA </strong>Integrate high performance ATI Radeon 9100 <br>  <br>  <strong>Audio</strong> Realtek 650F 6 channel audio <br>  <br>  <strong>Expansion Slot </strong>PCI * 1, 8XAGP * 1 <br>  <br>  <strong>IDE interface </strong>ATA-100 <br>  <br>  <strong>Power </strong>250W (PFC) <br>  <br>  <strong>Accessory </strong></p>  <p>I.C.E Technology CPU heat-pipe</p>  <p>FDD Cable * 1</p>  <p>HDD Cable * 1</p>  <p>CD-ROM  Cable * 1</p>  <p>SATA Cable</p>  <p>Screws, Twin Adhesive <br>    <br>  <strong>Hot Features </strong></p>  <p>SiliconImage Sil3512 supports RAID 0,1</p>  <p>Auto Fan speed  control makes the lowest noise</p>  <p>Builtin USB 2.0 6 in 1 card reader</p>  <p>Support platform  longevity for the latest ATI</p>  <p>800 MHz FSB delivers greater      system bandwidth. <br>  </p>

 

but it has been truncated to:

 

Dimension (L)300*(W)200*(H)185 2.85Kg (N.W.) 4.65Kg (G.W.)

 

Front Panel USB 2.0 6 in 1 card reader, USB * 2, 1394 * 1, MIC * 1, Line in/out * 1

 

Back Panel SPDIF In/Out * 1 S

 

This has basically happened on all products that have a description longer than about 2 lines. It doesn't truncate at the same point, it seems random??

 

Any suggestions please? The time saved by EP in updated prices quickly has now been lost as I have to manually put in all the descriptions again :-(

 

TIA guys - I need your help...!!

 

Cheers

Steve

Posted

anyone? surely someone must have come across this?? Pleeeease :-)

Steve

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...