• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

Issue Can't List Extentions

M

mendip_discovery

New Pleskian
Recently upgraded from 17.5 to 17.8.

Home > Extentions > My Extentions = No rendered content, i get a Plesk page but nothing about the extentions.
So I tried a Plesk repair and it ran, has some errors...not looked at them yet.

But I thought I was try listing my current extentions...and got this error.
Code: 
 plesk bin extension -l
DB query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hidden'                   in 'where clause', query was: SELECT `Modules`.* FROM `Modules` WHERE (hidden =                   '') ORDER BY `name` ASC

exit status 1

Other things are broken, I suspect I have a defuncked extention so now Plesk doesn't know how to deal with it.
 
Have you tried repair Plesk database with

# plesk repair db

?
 
IgorG said:
plesk repair db
Click to expand...

Not sure if I should say yes or not to these.

Code: 
Checking the Plesk database using the native database server tools .. [OK]

Checking the structure of the Plesk database

  Extra table: PlanServiceInstallations ............................. [WARNING]
  Delete table 'PlanServiceInstallations'? [Y/n]     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.20181211-172523.dump.gz
    Deleting table 'PlanServiceInstallations' ....................... [FIXED]

  Extra table: PlanServiceProperties ................................ [WARNING]
  Delete table 'PlanServiceProperties'? [Y/n] n

  Extra table: ServiceInstallationProperties ........................ [WARNING]
  Delete table 'ServiceInstallationProperties'? [Y/n] n

  Extra table: ServiceInstallations ................................. [WARNING]
  Delete table 'ServiceInstallations'? [Y/n] n

  Extra table: ServiceInstanceDepends ............................... [WARNING]
  Delete table 'ServiceInstanceDepends'? [Y/n] n

  Extra table: ServiceInstanceProperties ............................ [WARNING]
  Delete table 'ServiceInstanceProperties'? [Y/n] n

  Extra table: ServiceInstanceResources ............................. [WARNING]
  Delete table 'ServiceInstanceResources'? [Y/n] n

  Extra table: ServiceInstances ..................................... [WARNING]
  Delete table 'ServiceInstances'? [Y/n] n

  Extra table: ServiceLimits ........................................ [WARNING]
  Delete table 'ServiceLimits'? [Y/n] n

  Extra table: ServicePermissions ................................... [WARNING]
  Delete table 'ServicePermissions'? [Y/n] n

  Extra table: SSOBranding .......................................... [WARNING]
  Delete table 'SSOBranding'? [Y/n] n

  Extra table: WebApps .............................................. [WARNING]
  Delete table 'WebApps'? [Y/n] n

  Extra columns in the table actions: ............................... [WARNING]
    - id
    - descr
  Repair table 'actions'? [Y/n] n

  Extra unique key in the table actions: ............................ [ERROR]
    - name (name)
  Repair table 'actions'? [Y/n] n

  Unique key values mismatch in the table 'actions': name in the
  original schema and id in the Plesk database ...................... [ERROR]
  Repair table 'actions'? [Y/n] n

  Wrong attributes for the column 'repository' in the table
  'BackupsScheduled': ............................................... [ERROR]
    - The attribute 'type' value mismatch:
      enum('local','ftp','ext','local-and-ext') in the original
      schema and enum('local','ftp') in the Plesk database.
  Repair table 'BackupsScheduled'? [Y/n] n

  Column remoteStorage is absent in the table BackupsScheduled ...... [ERROR]
  Repair table 'BackupsScheduled'? [Y/n] n

  Wrong attributes for the column 'val' in the table 'cl_param': .... [ERROR]
    - The attribute 'type' value mismatch: varchar(5000) in the
      original schema and varchar(255) in the Plesk database.
  Repair table 'cl_param'? [Y/n] n

  Extra columns in the table disk_usage: ............................ [WARNING]
    - webapps
  Repair table 'disk_usage'? [Y/n] n

  Wrong attributes for the column 'type' in the table 'dns_recs': ... [ERROR]
    - The attribute 'type' value mismatch:
      enum('NS','A','AAAA','CNAME','MX','PTR','TXT','AXFR','SRV','DS','CAA','master','none')
      in the original schema and
      enum('NS','A','AAAA','CNAME','MX','PTR','TXT','SRV','DS','master','none')
      in the Plesk database.
  Repair table 'dns_recs'? [Y/n] n

  Wrong attributes for the column 'type' in the table 'dns_recs_t': . [ERROR]
    - The attribute 'type' value mismatch:
      enum('NS','A','AAAA','CNAME','MX','PTR','SOA','TXT','AXFR','SRV','CAA','none')
      in the original schema and
      enum('NS','A','AAAA','CNAME','MX','PTR','TXT','SRV') in the
      Plesk database.
  Repair table 'dns_recs_t'? [Y/n] n

  Wrong attributes for the column 'val' in the table 'dns_recs_t': .. [ERROR]
    - The attribute 'type' value mismatch: varchar(512) in the
      original schema and varchar(255) in the Plesk database.
  Repair table 'dns_recs_t'? [Y/n] n

  Wrong attributes for the column 'displayVal' in the table
  'dns_recs_t': ..................................................... [ERROR]
    - The attribute 'type' value mismatch: varchar(512) in the
      original schema and varchar(255) in the Plesk database.
  Repair table 'dns_recs_t'? [Y/n] n

  Wrong attributes for the column 'val' in the table 'dom_param': ... [ERROR]
    - The attribute 'type' value mismatch: varchar(5000) in the
      original schema and varchar(255) in the Plesk database.
  Repair table 'dom_param'? [Y/n] n

  Extra columns in the table event_handlers: ........................ [WARNING]
    - action_id
  Repair table 'event_handlers'? [Y/n] n

  Column action_name is absent in the table event_handlers .......... [ERROR]
  Repair table 'event_handlers'? [Y/n] n

  Extra index in the table event_handlers: .......................... [WARNING]
    - action_id (action_id)
  Repair table 'event_handlers'? [Y/n] n

  Missing index in the table event_handlers: ........................ [WARNING]
    - action_name (action_name)
  Repair table 'event_handlers'? [Y/n] n

  Extra columns in the table log_actions: ........................... [WARNING]
    - action_id
  Repair table 'log_actions'? [Y/n] n

  Column action_name is absent in the table log_actions ............. [ERROR]
  Repair table 'log_actions'? [Y/n] n

  Extra index in the table log_actions: ............................. [WARNING]
    - action_id (action_id)
  Repair table 'log_actions'? [Y/n] n

  Missing index in the table log_actions: ........................... [WARNING]
    - action_name (action_name)
  Repair table 'log_actions'? [Y/n] n

  Column hidden is absent in the table Modules ...................... [ERROR]
  Repair table 'Modules'? [Y/n] n

  Wrong attributes for the column 'value' in the table
  'ModuleSettings': ................................................. [ERROR]
    - The attribute 'type' value mismatch: varchar(5000) in the
      original schema and varchar(2000) in the Plesk database.
    - Extra attribute: notNull.
  Repair table 'ModuleSettings'? [Y/n] n

Checking the consistency of the Plesk database ...................... [OK]

Error messages: 14; Warnings: 20; Errors resolved: 1


exit status 1
 
Looks like your upgrade was not completed successfully and Plesk database was not updated correctly.
Try to fix upgrade with the command:

# plesk installer --select-release-current --reinstall-patch --upgrade-installed-components
# plesk repair db
Then run Plesk upgrade again.
Contact Plesk Support Team if these steps not help.
 
You must log in or register to reply here.

Similar threads

J
Issue Can't login at Plesk admin panel (Plesk Onyx 17.0.17)
Replies
1
Views
119
JVG
J
W
Resolved Several errors after failed update 17.8.11 Update #94
Replies
2
Views
854
webwolf
W
P
Issue cause to 18.0.30 Obsidian fails with DB failure
Replies
7
Views
2K
pipeman1981
P
Rot
Resolved Plesk Onyx 17.8.11 Update #22 with Error 500 Plesk Exception Database
Replies
3
Views
4K
Rot
Rot
G
Resolved Help! mail not working after failed update to Plesk Obsidian
Replies
3
Views
2K
gregconway
G
Back
Top