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
"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