Doesn’t work with few people

  • Hello Everybody!

    First thanks for the plugin!

    I have a little issue here… Some people works when i added the pages but others never… I mean, when i click on the link of the people this one never show up, appear a 504 error.

    I already change the php server settings for the plugin. Any idea? this only happen with the 10% of the people but it’s annoying and i can’t see the problem.

    Many Thanks,
    Alberto

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author ed4becky

    (@ed4becky)

    CAn you try upgrading and let me know how it works?

    Thread Starter tiptopit

    (@tiptopit)

    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

    Plugin Author ed4becky

    (@ed4becky)

    Did you update anything else at the same time? The plugin does not define the MySQL connection, just uses wordpress’

    Thread Starter tiptopit

    (@tiptopit)

    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 7 years, 10 months ago by tiptopit.
    Thread Starter tiptopit

    (@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: https://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.

    Plugin Author ed4becky

    (@ed4becky)

    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.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Doesn’t work with few people’ is closed to new replies.

Tags