• 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 error Table psa.certificaterepositories

hardsoft

New Pleskian
Buenas tardes, tengo plesk Obsidian y en la ultima actualizacion, la v 18.0.35, la base de datos psa tiene una tabla corrupta o mala y no me deja pedir certificados Let's Encrypt. he probado "plesk repair all" y da este problema
"Checking the structure of the Plesk database
DB query failed: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'psa.certificaterepositories' doesn't exist in engine, query was: DESC certificaterepositories
The database structure is corrupted. You can try to repair it with "repair.exe --db"."
Tambien he probado "plesk repair --db -y" y da este otro error
"La operación no pudo llevarse a cabo debido al siguiente error: {"id":1,"cmd":"plesk repair.exe db -y","type":"progress","message":"Checking the Plesk database using the native database server tools","level":0} {"id":1,"cmd":"plesk repair.exe db -y","type":"success","message":"Checking the Plesk database using the native database server tools","level":0} {"id":2,"cmd":"plesk repair.exe db -y","type":"progress","message":"Checking the structure of the Plesk database","level":0} {"id":3,"cmd":"plesk repair.exe db -y","type":"info","message":"DB query failed: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'psa.certificaterepositories' doesn't exist in engine, query was: DESC certificaterepositories","level":1} {"id":4,"cmd":"plesk repair.exe db -y","type":"info","message":"The database structure is corrupted. You can try to repair it with \"repair.exe --db\".","level":1}"
Parece ser que el problema esta en la tabla "psa.certificaterepositories", pero no se como solucionarlo.
Podeis ayudarme?
Muchas gracias

*********************************************

Good afternoon, I have plesk Obsidian and in the last update, v 18.0.35, the psa database has a corrupt or bad table and it does not allow me to ask for Let's Encrypt certificates. I have tried "plesk repair all" and it gives this problem "Checking the structure of the Plesk database DB query failed: SQLSTATE [42S02]: Base table or view not found: 1932 Table 'psa.certificaterepositories' doesn't exist in engine, query was: DESC certificaterepositories The database structure is corrupted. You can try to repair it with "repair.exe --db". " I have also tried "plesk repair --db -y" and it gives this other error "The operation failed due to the following error: {" id ": 1," cmd ":" plesk repair.exe db -y "," type ":" progress "," message ":" Checking the Plesk database using the native database server tools "," level ": 0} {" id ": 1," cmd ":" plesk repair.exe db -y "," type ":" success "," message ":" Checking the Plesk database using the native database server tools "," level ": 0} {" id ": 2," cmd ":" plesk repair.exe db -y "," type ":" progress "," message ": "Checking the structure of the Plesk database", "level": 0} {"id": 3, "cmd": "plesk repair.exe db -y", "type": "info", "message": " DB query failed: SQLSTATE [42S02]: Base table or view not found: 1932 Table 'psa.certificaterepositories' doesn't exist in engine, query was: DESC certificaterepositories "," level ": 1} {" id ": 4, "cmd": "plesk repair.exe db -y", "type": "info", "message": "The database structure is corrupted. You can try to repair it with \ "repair.exe --db \". "," Level ": 1}" It seems that the problem is in the table "psa.certificaterepositories", but I don't know how to solve it. Can you help me? Thank you
 
Can you help me?
Looks like Plesk database is seriously corrupted. Therefore I'd suggest you contact Plesk Support Team. They will check and fix the issue directly on your Plesk server.
 
Back
Top