Jump to content


Photo

Little help with SQL file


  • Please log in to reply
1 reply to this topic

#1 JamesyBHOY

JamesyBHOY
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 24 May 2006 - 06:02 PM

Hi, I purchased a php shopping cart software a few months ago. However I was always planning to use it with my new hosting provider, so was waiting until my old hosting account expired before using it. So last week, I just signed up with a new provider. Created a DB & tried to import the SQL file that contained all the tables etc.

Unfortunately I actually don't know any coding, only enough to do what I need. So I was hoping someone here could help me with the error.

Here is the SQL file that I'm importing using phpmyadmin.

[a href=\"http://www.cheekstorage.net/store.sql\" target=\"_blank\"]SQL file[/a]

I opened up the config file, added in the dbhost, name, user & password. Then uploaded all the files to the server using FTP Voyager. Then I went into phpmyadmin & imported the SQL file in.

This error message keeps coming up:

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Error
SQL query:
INSERT INTO items
VALUES ( 95084681, 5, '1', 0, '0000-00-00', 'Matrox G400', '', '', 'Dramatically Different High Performance Graphics. Introducing the Millennium G400 Series - a dramatically different, high performance graphics experience.', '', '', '<b>Dramatically Different High Performance Graphics</b>\r\n\r\nIntroducing the Millennium G400 Series - a dramatically different, high performance graphics experience. Armed with the industry\'s fastest graphics chip, the Millennium G400 Series takes explosive acceleration two steps further by adding unprecedented image quality, along with the most versatile display options for all your 3D, 2D and DVD applications. As the most powerful and innovative tools in your PC\'s arsenal, the Millennium G400 Series will not only change the way you see graphics, but will revolutionize the way you use your computer.\r\n\r\n<!-- Section: Features -->\r\n<b>Key features:</b>\r\n\r\n- New Matrox G400 256-bit DualBus graphics chip\r\n- Explosive 3D, 2D and DVD performance\r\n- DualHead Display\r\n- Superior DVD and TV output\r\n- 3D Environment-Mapped Bump Mapping\r\n- Vibrant Color Quality rendering \r\n- UltraSharp DAC of up to 360 MHz\r\n- 3D Rendering Array Processor\r\n- Support for 16 or 32 MB of memory\r\n', '', '', 1, '0.000', '', '0.00', '0.00', '0.00', 'matrox_G400.gif', 'matrox_G400.gif', 'matrox g400 dramatically different high performance graphics. introducing the millennium g400 series - a dramatically different, high performance graphics experience. dramatically different high performance graphics introducing the millennium g400 series - a dramatically different, high performance graphics experience. armed with the industry\'s fastest graphics chip, the millennium g400 series takes explosive acceleration two steps further by adding unprecedented image quality, along with the most versatile display options for all your 3d, 2d and dvd applications. as the most powerful and innovative tools in your pc\'s arsenal, the millennium g400 series will not only change the way you see graphics, but will revolutionize the way you use your computer. key features: - new matrox g400 256-bit dualbus graphics chip - explosive 3d, 2d and dvd performance - dualhead display - superior dvd and tv output - 3d environment-mapped bump mapping - vibrant color quality rendering - ultrasharp dac of up to 360 mhz - 3d rendering array processor - support for 16 or 32 mb of memory matrox g400 neu! matrox g400 "all inclusive" und vieles mehr... die neue millennium g400-serie - hochleistungsgrafik mit dem sensationellen unterschied. neu! matrox g400 "all inclusive" und vieles mehr... die neue millennium g400-serie - hochleistungsgrafik mit dem sensationellen unterschied. ausgestattet mit dem neu eingeführten matrox g400 grafikchip, bietet die millennium g400-serie eine überragende beschleunigung inklusive bisher nie dagewesener bildqualitat und enorm flexibler darstellungsoptionen bei allen ihren 3d-, 2d- und dvd-anwendungen. dualhead display und tv-ausgang environment mapped bump mapping matrox g400 256-bit dualbus 3d rendering array prozessor vibrant color quality² (vcq²) ultrasharp dac "bleibt abschließend festzustellen, daß die matrox millennium g400 max als allroundkarte für den highend-pc derzeit unerreicht ist. das ergibt den testsieg u INSERT INTO items VALUES (41728395, 14, '1 ', 0, '0000 -00 -00 ', 'ASUS V8460Ultra GeForce4Ti4600 ', '', '', ' & nbsp;



MySQL said:

#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 '1', 0, '0000-00-00', 'ASUS V8460Ultra GeForce 4 Ti 4600', '', '', ' ' at line 1 [/quote]


Anybody have any ideas at what this means & how do I fix it? Thanks James..

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 24 May 2006 - 06:49 PM

First, where is your column list, and what is your table spec?
Second, where are the semi-colons between subsequent INSERT statements?
Third, what's with the strange date?
Fourth, where's the end of the final values() clause?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users