Troubles installing php/mysql script

Discussion in 'Programming' started by jkoll, Sep 18, 2008.

  1. #1
    I purchased this cc web script http://creditcardscript.com/ and it says its MySQL4+ compatible yet when I try to run the php install file on my webspace (hostgator; MySql5) I am getting this:

    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 '; INSERT INTO `article` VALUES (1, 1, 'Learning More about Visa Credit Card', '' at line 9Invalid query: select * from issuer order by issuer_name

    I tried to look for a fix and contact the seller on their Contact Us email but to no avail. Can you guys help? How can I get this updated / install running on my webspace?

    Appreciate your help

    jkoll
     
    jkoll, Sep 18, 2008 IP
  2. chmdznr

    chmdznr Active Member

    Messages:
    417
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    78
    #2
    It's definitely some typos on your script. Possibly on the SQL dump. I can help you fixing this kind of problem if you wish.
     
    chmdznr, Sep 19, 2008 IP
  3. jkoll

    jkoll Active Member

    Messages:
    521
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    58
    #3
    My web hosting's support worked this out - I am not sure what exactly was behind this problem but they got it working by manually performing some of the mysql steps the install should have been done automatically.
     
    jkoll, Sep 20, 2008 IP
  4. manjothi

    manjothi Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Well it looks like problem in installation file. PM me if you want get this fixed
     
    manjothi, Sep 20, 2008 IP
  5. javaongsan

    javaongsan Well-Known Member

    Messages:
    1,054
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    128
    #5
    Are using phpmyadmin? to avoid this problem, if you have shell access you can try this
    mysql mydatabase < sql.dump
     
    javaongsan, Sep 25, 2008 IP