• 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

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

M
Question SvelteKit and Plesk Node : TypeError: Cannot read properties of undefined (reading 'on')
Replies
0
Views
198
MarcelP
M
M
Issue Plesk using wrong directory for Apache web server config
Replies
3
Views
310
marcvh
M
J
Issue Permission Denied Error with Auto Login Button Using Plesk API on Debian 10
Replies
1
Views
759
Kaspar
K
O
Issue NodeJS attribute name is invalid: application
Replies
0
Views
1K
ortiz_mario
O
W
Issue PositiveSSL not installed, but payed
Replies
1
Views
682
AYamshanov
AYamshanov
Back
Top