CAn you try upgrading and let me know how it works?
Hello ed4becky,
I just came back from Christmas. I updated the plugin through WordPress back-end and now i see this message in Ancestor Index.
ERROR: SQLSTATE[HY000] [2005] Unknown MySQL server host ‘localhost:3306’ (0)
Any idea?
Many Thanks,
Alberto
Did you update anything else at the same time? The plugin does not define the MySQL connection, just uses wordpress’
No, i didn’t update anything else at the same time. I deleted and try to install again. Now this error when i try to activate it:
Plugin could not be activated because it triggered a fatal error.
ERROR: SQLSTATE[HY000] [2005] Unknown MySQL server host ‘localhost:3306’ (2)
Fatal error: Call to a member function prepare() on a non-object in /var/www/vhosts/web009.co.uk/httpdocs/wp-content/plugins/rootspersona/php/dao/sql/class-RP-Connection.php on line 48
Many Thanks,
Alberto
-
This reply was modified 9 years, 4 months ago by
tiptopit.
Hello Again,
I rebuild the website from scratch and now no error appears. But the is the same problem with some people.
Just in case you need visit the website
URL: http://web009.co.uk/
guest username: test
Password: rootpersona
Is maybe something i can do from my site?
Many Thanks,
Alberto
I believe I have found the problem to the “Unknown MySQL server host” issue.
Looking through the code, there is no part that grabs the port number. It seems that one way of setting the db server location is to append the port to the server url using a colon, which the php connect function balks at.
if you set ‘localhost’ as you db server address, it will connect fine, if you set it as ‘localhost:3306’ (default port?) then it will fail.
I found this out since my host uses port 3309 for their port and assign the url as above, with a colon. hand editing the dsn connection string with the url bare, and a “port=”parameter made everything work.
Rootspersona looks for:
DB_HOST
DB_USER
DB_PASSWORD
DB_NAME
define(‘DB_HOST’, ‘localhost:3306’);
Rootspersona creates it own connection to the DB so as not to intefer with the one WP uses for itself.
