• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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
Resolved Can't login at Plesk admin panel (Plesk Onyx 17.0.17)
Replies
6
Views
10K
JVG
J
R
Issue Joomla Toolkit is not listed
Replies
0
Views
773
Ronny Burström
R
W
Resolved Several errors after failed update 17.8.11 Update #94
Replies
2
Views
1K
webwolf
W
P
Forwarded to devs Advisor extension Synchronize Server Time 'Open' button broken
Replies
3
Views
1K
NITROFOX
N
P
Issue cause to 18.0.30 Obsidian fails with DB failure
Replies
7
Views
2K
pipeman1981
P
Back
Top