MySQL help!

Shadow

Original Flavor Darkness
  • 2,863
    Posts
    21
    Years
    I'm trying to install a system for webcomics that requires a MySQL database. The system is called CUSP (Comic Update Script for PHP), and when I try to install it, it says there is a MySQL database error. I can't make MySQL database myself, my host does it for me (and he is on vacation or something because he hasn't been on lately). Normally I would join at the product's forum and ask for help there, but they just had a server change and haven't set up the forums yet so this is the only place I can get help. This is the error I get:
    Database error in :

    Invalid SQL: SELECT value FROM setting WHERE name='displayversion'
    mysql error: Table 'sonicpl_shadowinc.setting' doesn't exist

    mysql error number: 1146

    Date: Wednesday 28th of July 2004 06:02:44 PM
    Script: /shadowinc/comicupgrade.php
    Referer:
     
    Try installing the program again and make sure the database name, user, and password is correct. It seems that a table wasn't created. If that doesn't help, then I don't know.
     
    is the database set up? if not you will need to cotact your host :( and get one set up.

    Otherwise:

    did you run any installer scripts or import the .sql database dump provided with your php script?

    is the db name/user/password all correct in your script's config file?
     
    Yeah the db name/username/password are all correct. I think my host may have deleted the db or something. It's been over a month since I asked if he could make one for me and I just now tried installing this thing tonight.

    Should I leave the DB server as 'localhost' or change it to something else?
     
    Most of the time, localhost will work.

    It sounds like the database doesn't exist or the SQL statements weren't completed.
     
    Back
    Top