Plesk Admin - 404 - Not Found

[Steve Tozer]

Hello,

Seem to have an issue trying to log into Plesk admin getting 404 - Not Found. Tried running the

pp10.8.0-bootstrapper/bootstrapper.sh repair

But getting

ERROR while trying to upgrade SQL database from 1070
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 7
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'innodb status' at line 1

Any help would be great.

Thanks

 

[IgorG]

What is version of Plesk and mysql do you have?

 

[Steve Tozer]

Hello,

Version 9.5.4

mysql Ver 14.14 Distrib 5.5.41

Thanks

 

[IgorG]

In this case this article will help http://kb.odin.com/en/120238

 

[Steve Tozer]

Thanks, would you suggest running the upgrade rather than downgrading MySQL

 

[Steve Tozer]

I have upgraded Plesk to 10.4, The upgrade has brought the plesk panel back up and I can login, but when going to "Domains" Im getting the error

Internal error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.custom' in 'where clause'
Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.custom' in 'where clause'
File Pdo.php
Line 234
Type Zend_Db_Statement_Exception

Also none of the domains load on the server, just getting a default plesk page for any website we try and access

Thanks

 

[UFHH01]

Hi Steve Tozer,

you can always try to use the bootstrapper repair utility, which corrects quite a lot of issues and mis-configurations:
The bootstrapper utility can be found at the directory "/usr/local/psa/bootstrapper/" and the command over the command line would be:

/usr/local/psa/bootstrapper/pp10.9.0-bootstrapper/bootstrapper.sh repair

If the command doesn't work for you, try "ls /usr/local/psa/bootstrapper/" to list your own most recent version and correct the suggestion with your very own bootstrapper version.​

 

[Steve Tozer]

Hello,

Thanks for the suggestion. I have tried the bootstrapper repair but still getting the same