Server Code – 200 = Install Error

  • Resolved sideswipev2

    (@sideswipev2)


    7 years, 5 months ago

    I’ve Been trying to install my site on a new server, but running into issues. Used Duplicator without issues before, but now causing all sorts of problems.

    Getting this:

    WEB SERVER CONFIGURATION FILE RESET:
    – Backup of .htaccess/web.config made to .orig
    – Reset of .htaccess/web.config files
    ERROR: Unable to read from the extracted database.sql file .
    Validate the permissions and/or group-owner rights on directory ‘/home/theunsig/public_html/mannacards.co.uk’

    ERROR: Unable to create new sql file installer-data.sql.
    Validate the permissions and/or group-owner rights on directory ‘/home/theunsig/public_html/mannacards.co.uk’ and file ‘installer-data.sql’

    UPDATED FILES:
    – SQL FILE: ‘/home/theunsig/public_html/mannacards.co.uk/installer-data.sql’
    – WP-CONFIG: ‘/home/theunsig/public_html/mannacards.co.uk/wp-config.php’

    ARCHIVE RUNTIME: 0.0007 sec.

    I’ve tried creating new databases, connecting to old ones, from the zip file, manual extraction, changing file permissions to 755, database users all privileges.

    I know this seems to be quite a popular topic, but can’t see any solution that matches what I haven’t tried.

    “No tables where created during step 1 of the install. Please review the installer-log.txt file for sql error messages. You may have to manually run the installer-data.sql with a tool like phpmyadmin to validate the data input. If you have enabled compatibility mode during the package creation process then the database server version your using may not be compatible with this script.”

    The installer-data.sql is blank (seems to be a common question), but I thought this was a permission issue, and as the file permissions are all access is this relevant? I’ve tried importing the database.sql file into phpmyadmin and it’s created all the tables, but made no difference in the install.

    Any direction would be super!

Viewing 5 replies - 1 through 5 (of 5 total)

  • Hey @sideswipev2,

    How large is the database.sql file inside of the archive file? If that file is really large and you don’t have enough memory on the server then it won’t be able to copy it over to the installer-data.sql file.

    If the database.sql is small in size like 10-20MB or less this it may be an issue with PHP not having enough permissions to copy the data. Those typically tend to be the main issues around that particular error…

    Thread Starter sideswipev2

    (@sideswipev2)

    Hey @corylamleorg ! Cheers for getting back to me.

    The database.sql file is just about 10mb. I’ll see if I can get on to my hosting company about PHP permissions. I assume that’s something they can sort rather than something I can do?!

    Thanks again!

    They should be able to help if its a permissions issue, unless you know how to adjust the permissions on their servers, which most hosts have some level of being able to update/change permissions…

    Thread Starter sideswipev2

    (@sideswipev2)

    Managed to get it sorted. Thanks for all your help!

    Excellent! This for the update!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Server Code – 200 = Install Error’ is closed to new replies.