• 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!
  • 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.

Question Installing applications using Plesk is failing for my server

Manuel_mhas01

Manuel_mhas01

New Pleskian
Good morning. I'm getting this error, when I try to install a new application using Plesk.


ODBC error #42S22: [MySQL][ODBC 5.1 Driver][mysqld-5.5.54]Unknown column 'T59892720.uid' in 'field list'


I'm using plesk 17.5.3


Does anyone have an idea of how can I resolve this?

In advance thank you for your help.
 
Hi Manuel_mhas01,

you have a database inconsistency.

Pls. consider to use the "Plesk Repair Utility" => Plesk Repair Utility

Example command:
Code: 
plesk repair db -y -v

... or choose the option to RESTORE your databases from the most recent backup.​
 
I ran the command you recommended @UFHH01 thank you by the way. Here is the result

Run query: CHECK TABLE accounts
Run query: CHECK TABLE actions
Run query: CHECK TABLE admin_aliases
Run query: CHECK TABLE admin_aliases_param
Run query: CHECK TABLE anon_ftp
Run query: CHECK TABLE ApiRpcCallsStat
Run query: CHECK TABLE APSApplicationItems
Run query: CHECK TABLE APSCatalogUpdates
Run query: CHECK TABLE apscategories
Run query: CHECK TABLE APSClientApplicationItems
Run query: CHECK TABLE apsContexts
Run query: CHECK TABLE apsContextsApplications
Run query: CHECK TABLE apsInstancesParameters
Run query: CHECK TABLE APSLicenses
Run query: CHECK TABLE APSLicenseTypes
Run query: CHECK TABLE apsResources
Run query: CHECK TABLE apsResourcesParameters
Run query: CHECK TABLE ApsTokens
Run query: CHECK TABLE avstatistics
Run query: CHECK TABLE BackendCache
Run query: CHECK TABLE BackupExcludeFiles
Run query: CHECK TABLE BackupsScheduled
Run query: CHECK TABLE BackupsSettings
Run query: CHECK TABLE badmailfrom
Run query: CHECK TABLE BlUpgradeActions
Run query: CHECK TABLE BlUpgrades
Run query: CHECK TABLE Cards
Run query: CHECK TABLE certificates
Run query: CHECK TABLE cl_param
Run query: CHECK TABLE CliCallsStat
Run query: CHECK TABLE clients
Run query: CHECK TABLE ClientsTraffic
Run query: CHECK TABLE ComposerInstances
Run query: CHECK TABLE Configurations
Run query: CHECK TABLE cp_access
Run query: CHECK TABLE custom_buttons
Run query: CHECK TABLE data_bases
Run query: CHECK TABLE DatabaseCustomHosts
Run query: CHECK TABLE DatabaseServers
Run query: CHECK TABLE DatabaseUserRemoteAccessRules
Run query: CHECK TABLE db_users
Run query: CHECK TABLE disk_usage
Run query: CHECK TABLE dns_recs
Run query: CHECK TABLE dns_recs_t
Run query: CHECK TABLE dns_refs
Run query: CHECK TABLE dns_zone
Run query: CHECK TABLE dom_level_usrs
Run query: CHECK TABLE dom_param
Run query: CHECK TABLE domain_aliases
Run query: CHECK TABLE DomainOutgoingMessagesPeaks
Run query: CHECK TABLE DomainOutgoingMessagesStats
Run query: CHECK TABLE domains
Run query: CHECK TABLE DomainServices
Run query: CHECK TABLE DomainsTraffic
Run query: CHECK TABLE dsn
Run query: CHECK TABLE DynamicIpSecurity
Run query: CHECK TABLE event_handlers
Run query: CHECK TABLE exp_event
Run query: CHECK TABLE externalWebmails
Run query: CHECK TABLE fileSharingUsers
Run query: CHECK TABLE forwarding
Run query: CHECK TABLE ftp_users
Run query: CHECK TABLE GL_remote_domains
Run query: CHECK TABLE GL_settings
Run query: CHECK TABLE hosting
Run query: CHECK TABLE hotlink_friends
Run query: CHECK TABLE hotlink_prot
Run query: CHECK TABLE IisAppPoolDomains
Run query: CHECK TABLE IisAppPools
Run query: CHECK TABLE IisAppPoolsPolicy
Run query: CHECK TABLE IP_Addresses
Run query: CHECK TABLE ip_pool
Run query: CHECK TABLE IpAddressesCollections
Run query: CHECK TABLE IpCollections
Run query: CHECK TABLE key_history
Run query: CHECK TABLE key_history_params
Run query: CHECK TABLE Limits
Run query: CHECK TABLE LimitsReservation
Run query: CHECK TABLE locales
Run query: CHECK TABLE log_actions
Run query: CHECK TABLE log_components
Run query: CHECK TABLE log_rotation
Run query: CHECK TABLE Logos
Run query: CHECK TABLE longtaskparams
Run query: CHECK TABLE longtasks
Run query: CHECK TABLE mail
Run query: CHECK TABLE mail_aliases
Run query: CHECK TABLE mail_redir
Run query: CHECK TABLE mail_resp
Run query: CHECK TABLE MailLists
Run query: CHECK TABLE MailMessagesStat
Run query: CHECK TABLE MailOutgoingMessagesPeaks
Run query: CHECK TABLE MailOutgoingMessagesStats
Run query: CHECK TABLE mass_mail
Run query: CHECK TABLE mass_mail_clients
Run query: CHECK TABLE mass_mail_domains
Run query: CHECK TABLE misc
Run query: CHECK TABLE mn_param
Run query: CHECK TABLE Modules
Run query: CHECK TABLE ModuleSettings
Run query: CHECK TABLE Notes
Run query: CHECK TABLE Notifications
Run query: CHECK TABLE PackageUpdateLocks
Run query: CHECK TABLE PackageUpdateNotifications
Run query: CHECK TABLE Parameters
Run query: CHECK TABLE password_secrets
Run query: CHECK TABLE pd_users
Run query: CHECK TABLE Permissions
Run query: CHECK TABLE PersistentCache
Run query: CHECK TABLE PhpSettings
Run query: CHECK TABLE PhpSettingsCustom
Run query: CHECK TABLE PhpSettingsParameters
Run query: CHECK TABLE PlanItemProperties
Run query: CHECK TABLE PlanItems
Run query: CHECK TABLE PlanServiceInstallations
Run query: CHECK TABLE PlanServiceProperties
Run query: CHECK TABLE PlansSubscriptions
Run query: CHECK TABLE PleskPagesStat
Run query: CHECK TABLE PleskStats
Run query: CHECK TABLE protected_dirs
Run query: CHECK TABLE report
Run query: CHECK TABLE report_auto
Run query: CHECK TABLE report_section
Run query: CHECK TABLE Repository
Run query: CHECK TABLE resp_attach
Run query: CHECK TABLE resp_forward
Run query: CHECK TABLE resp_freq
Run query: CHECK TABLE RestrictedDomains
Run query: CHECK TABLE SBConfig
Run query: CHECK TABLE SBResellers
Run query: CHECK TABLE ScheduledTasks
Run query: CHECK TABLE SchemaVersions
Run query: CHECK TABLE secret_keys
Run query: CHECK TABLE ServiceInstallationProperties
Run query: CHECK TABLE ServiceInstallations
Run query: CHECK TABLE ServiceInstanceDepends
Run query: CHECK TABLE ServiceInstanceProperties
Run query: CHECK TABLE ServiceInstanceResources
Run query: CHECK TABLE ServiceInstances
Run query: CHECK TABLE ServiceLimits
Run query: CHECK TABLE ServiceNodeCache
Run query: CHECK TABLE ServiceNodeCertificates
Run query: CHECK TABLE ServiceNodeConfiguration
Run query: CHECK TABLE ServiceNodeEnvironment
Run query: CHECK TABLE ServiceNodes
Run query: CHECK TABLE ServicePermissions
Run query: CHECK TABLE SessionContexts
Run query: CHECK TABLE sessions
Run query: CHECK TABLE SiteAppsHitsStat
Run query: CHECK TABLE SitePagesStat
Run query: CHECK TABLE Skins
Run query: CHECK TABLE smb_apsBundleFilterItems
Run query: CHECK TABLE smb_apsBundleFilters
Run query: CHECK TABLE smb_apsCategories
Run query: CHECK TABLE smb_apsContexts
Run query: CHECK TABLE smb_apsInstanceErrors
Run query: CHECK TABLE smb_apsInstances
Run query: CHECK TABLE smb_apsMetas
Run query: CHECK TABLE smb_apsPackages
Run query: CHECK TABLE smb_apsPackagesCategories
Run query: CHECK TABLE smb_apsPackageUpdates
Run query: CHECK TABLE smb_apsProvisionEnvironments
Run query: CHECK TABLE smb_apsProvisions
Run query: CHECK TABLE smb_apsResourceParameters
Run query: CHECK TABLE smb_apsResources
Run query: CHECK TABLE smb_apsSettings
Run query: CHECK TABLE smb_componentUpdates
Run query: CHECK TABLE smb_fileSharingUnlistedFiles
Run query: CHECK TABLE smb_generalPermissions
Run query: CHECK TABLE smb_locales
Run query: CHECK TABLE smb_productUpgrades
Run query: CHECK TABLE smb_roleGeneralPermissions
Run query: CHECK TABLE smb_roles
Run query: CHECK TABLE smb_roleServicePermissions
Run query: CHECK TABLE smb_serviceEntryPoints
Run query: CHECK TABLE smb_serviceInstances
Run query: CHECK TABLE smb_servicePermissionAccounts
Run query: CHECK TABLE smb_servicePermissions
Run query: CHECK TABLE smb_serviceProviders
Run query: CHECK TABLE smb_settings
Run query: CHECK TABLE smb_users
Run query: CHECK TABLE smb_userServicePermissions
Run query: CHECK TABLE smtp_poplocks
Run query: CHECK TABLE spamfilter
Run query: CHECK TABLE spamfilter_preferences
Run query: CHECK TABLE SSOBranding
Run query: CHECK TABLE stat
Run query: CHECK TABLE subdomains
Run query: CHECK TABLE SubscriptionOutgoingMessagesPeaks
Run query: CHECK TABLE SubscriptionOutgoingMessagesStats
Run query: CHECK TABLE SubscriptionProperties
Run query: CHECK TABLE Subscriptions
Run query: CHECK TABLE suspend_handler_history
Run query: CHECK TABLE sys_users
Run query: CHECK TABLE Templates
Run query: CHECK TABLE TmplData
Run query: CHECK TABLE TraceFailedRequestsProviderAreas
Run query: CHECK TABLE TraceFailedRequestsProviders
Run query: CHECK TABLE TraceFailedRequestsRules
Run query: CHECK TABLE upgrade_history
Run query: CHECK TABLE web_users
Run query: CHECK TABLE webalizer_group_referrer
Run query: CHECK TABLE webalizer_hidden_referrer
Run query: CHECK TABLE WebApps
Run query: CHECK TABLE Webmails
Run query: CHECK TABLE WebServerSettings
Run query: CHECK TABLE WebServerSettingsParameters

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

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

Error messages: 0; Warnings: 0; Errors resolved: 0

And I still get the issue on my other end. I really wouldn´t mind starting from scratch, is there any way that I can get plesk essential tables even empty ones?
 
It is inconsistency of 'apsc' database but not 'psa'.
I would suggest you contact Plesk Support Team for repairing this broken 'apsc' database directly on your server.
 
You must log in or register to reply here.

Similar threads

q-quan
Resolved Windows Server 2025 - Plesk Obsidian 18.0.69 - msodbcsql17 dependency
Replies
11
Views
614
iForced
I
S
Resolved Backup Fails on Plesk Obsidian for Windows — Error (0x80004005) Unspecified error
Replies
2
Views
1K
s.buscemi
S
M
Issue Database Connection Refused 10 mins after Deploy
Replies
1
Views
436
scsa20
scsa20
C
Question Server Error 500 Plesk\Exception\Database
Replies
3
Views
713
Raul A.
R
R
Issue Update fails
Replies
0
Views
785
richardproctor
R
Back
Top