In Need Of help. Urgently. Regarding MySQL

Discussion in 'PHP' started by jijigren, Sep 4, 2007.

  1. #1
    When I try to install a script, this is what appear:

    MySQL Error: 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 'ENGINE=MyISAM' at line 4 - Query Attempted: CREATE TABLE `mmh_admin_sessions` ( `admin_id` text NOT NULL, `session` text NOT NULL ) ENGINE=MyISAM;

    (And the end of the error is like below....)

    MySQL Error: Table 'hisdirco_imagehosting.mmh_user_data' doesn't exist - Query Attempted: INSERT INTO `mmh_user_data` VALUES ('', 'jijigren', 'df10a5222bd8e7056e71f00b94425aff', '', '60.49.67.55', 'hisdir@hisdir.com', '0', '1188899849', 'ROOT_ADMIN', 'us', 0, 'm');


    Can anyone tell me what is this..? I try to figure it out but cannot find any solution. Please really need help in this.:( Anyone?
     
    jijigren, Sep 4, 2007 IP
  2. Brewster

    Brewster Active Member

    Messages:
    489
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    60
    #2
    Not sure - I would guess that the database doesnt exist. Have you created a database for the script and given it a username and password with appropriate permissions ?

    What script are you using ?

    Brew
     
    Brewster, Sep 4, 2007 IP
  3. undir

    undir Peon

    Messages:
    696
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Is that solved or do you still need help?
     
    undir, Sep 4, 2007 IP