Articles in this section

See more

Plesk fails with: 1054 Unknown column 'rnameType' in 'field list'

Avatar
Marc Vidal
Updated
Follow

Applicable to:

  • Plesk Onyx 17.8 for Linux
  • Plesk Onyx 17.8 for Windows

Symptoms

  • When clicking Domains or logging in to Plesk, the following error message appears:

    PLESK_ERROR: DB query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rnameType' in 'field list', query was: select id, name, displayName, email, status, syncRecords, syncSoa, type, ttl, ttl_unit, refresh, refresh_unit, retry, retry_unit, expire, expire_unit, minimum, minimum_unit, serial, serial_format, external_id, rnameType from dns_zone where id=47

  • The following error occurs when restoring a backup on Plesk Onyx 17.8:

    PLESK_ERROR: Element 'dns-zone', attribute 'rnameType': The attribute 'rnameType' is not allowed.

  • The following error occurs when migrating to Plesk Onyx 17.8:

    CONFIG_TEXT: Unable to create subscription 'example.com'.
    Command execution failed on the local server with non-zero exit code.
    command: /opt/psa/bin/subscription --create example.com -hosting true -hst_type phys -login jdoe -passwd '' -ip 203.0.113.2 -do-not-apply-skeleton -notify false -service_plan Unlimited -force -guid d91b323a-8838-4b96-b1c7-be9d4e97f938 -creation-date 2019-05-10 -ignore-nonexistent-options
    exit code: 1
    stdout:
    stderr: [2019-05-16 15:42:36.266] ERR [panel] Domain update failed: Unable to update domain data: DB query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rnameType' in 'field list', query was: ...
    An error occurred during domain creation: Unable to load object of type PhDomain with id=1: Unable to update domain data: DB query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rnameType' in 'field list', query was: ...

  • When running plesk repair db, the utility shows the error:

    # plesk repair db -n
    ...
    Checking the structure of the Plesk database
    Column rnameType is absent in the table dns_zone .................. [ERROR]
    ...

  • Unable to retrieve DNS records of a domain via a command-line interface:

    # plesk bin dns --info example.com
    DB query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rnameType' in 'field list', query was: select `id`, `name`, `displayName`, `email`, `status`, `syncRecords`, `syncSoa`, `type`, `ttl`, `ttl_unit`, `refresh`, `refresh_unit`, `retry`, `retry_unit`, `expire`, `expire_unit`, `minimum`, `minimum_unit`, `serial`, `serial_format`, `external_id`, `rnameType` from `dns_zone` where `id`=1 exit status 1

Cause

The column rnameType is missing from dns_zone table because the database scheme migration was not performed correctly by a Micro-Update.

This is a Plesk bug with ID PPPM-9351, which is planned to be fixed in Plesk updates.

Resolution

 

For Plesk on Linux

 

  1. Connect to the Plesk server via SSH

  2. Reinstall Plesk updates:

    # plesk installer update

  3. Repair the Plesk database:

    # plesk repair db
    ...
    Checking the structure of the Plesk database
    Column rnameType is absent in the table dns_zone .................. [ERROR]
    Repair table 'dns_zone'? [Y/n] y
    Creating a database dump ........................................ [OK]
    A dump of the database was created before an attempt to repair the database: /var/lib/psa/dumps/mysql.preresolve.20180924-110248.dump.gz
    Repairing table 'dns_zone' ...................................... [FIXED]

  4. If the steps above didn't help, repair the Plesk installation:

    # plesk repair all -y

 

For Plesk on Windows Server

 

  1. Connect to the Plesk server via RDP

  2. Start a command prompt as an Administrator and run the 'repair' utility to fix the Plesk database:

    C:\> plesk repair db
    ...
    Checking the structure of the Plesk database

    Column rnameType is absent in the table dns_zone .................. [ERROR]
    Repair table 'dns_zone'? [Y/n] y
    Creating a database dump ........................................ [OK]
    Repairing table 'dns_zone' ...................................... [FIXED]

  3. If the steps above didn't help, repair the Plesk installation:

    C:\> plesk repair all -y

 

Comments

4 comments

Sort by Date Votes

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles