1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

phpweby.com directory script installation error

Discussion in 'Databases' started by emega, Mar 23, 2024.

0
  1. #1
    When going to mywebsite.com/install.php I get the following error

    Error could not create tables. MySQL returned this:
    All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

    Please help.
     
    emega, Mar 23, 2024 IP
  2. sarahk

    sarahk iTamer Staff

    Messages:
    28,501
    Likes Received:
    4,460
    Best Answers:
    123
    Trophy Points:
    665
    #2
    I'm guessing that theres a config.php file somewhere and it doesn't have the right database information in it. Double-check what you've entered. You should be able to copy a basic MySQLi connection script from php.net, put in your credentials and access the database.

    If that doesn't work, talk to your hosting provider.
    If it does work, and the install script still fails you'll need to go to phpweby.com and ask on their support platforms.
     
    sarahk, Mar 24, 2024 IP
  3. GreenHost.Cloud

    GreenHost.Cloud Member

    Messages:
    118
    Likes Received:
    8
    Best Answers:
    3
    Trophy Points:
    33
    #3
    This error is likely occurring because the script is attempting to create a PRIMARY KEY on a column that allows NULL values.
    You can try modifying the script to use a UNIQUE key instead of a PRIMARY KEY for the column in question.
    Also, you can manually create the tables in the database with the appropriate keys and then update the script to skip the table creation step during installation.
    If you are not comfortable modifying the script or creating the tables manually, you may want to reach out to the support team for the script for further assistance.
     
    GreenHost.Cloud, Apr 3, 2024 IP