Guest Posted February 14, 2004 Posted February 14, 2004 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 Quote
Guest Posted February 14, 2004 Posted February 14, 2004 You must escape the apostrophe here: Technologies' like this: Technologies\' Matti Quote
241 Posted February 14, 2004 Posted February 14, 2004 (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 February 14, 2004 by 241 Quote 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! Is your Osc dated try Phoenix raising oscommerce from the ashes.
Guest Posted February 14, 2004 Posted February 14, 2004 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 Quote
Guest Posted February 15, 2004 Posted February 15, 2004 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 Quote
Guest Posted February 16, 2004 Posted February 16, 2004 anyone? surely someone must have come across this?? Pleeeease :-) Steve Quote
Recommended Posts
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.