SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Nov 2000
    Posts
    123
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I uploaded the file called phpshop.sql to database using phpMyAdmin interface, then I got this error:

    MySQL said: You have an error in your SQL syntax near 'P04','Blast away that paint job from the past. Use this power sander to really ' at line 1

    After searching the error, some people advice that I should create each table seperately, rather than import all at once. Any help with my error? Anybody here uses phpshop? And how to create tables one by one? I was using http://www.phpshop.org , that's a PHP e-commerce script. Thanks.

  2. #2
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would run it from the command line if you have access, upload the .sql file to your ftp folder then telnet in and run this line

    $ mysql -u username -p databasename < phpshop.sql
    Please don't PM me with questions.
    Use the forums, that is what they are here for.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •