1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.2 The Following server error has occured..

Discussion in 'Installation, Upgrade, and Import Support' started by Richie, Sep 29, 2013.

  1. Richie

    Richie New Member

    Hey Guys, Just just after importing all VB data and just trying to to house keeping.

    I am getting the following error every so often, any thoughts?

     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    The text at the top hints as to what the issue might be:

    You may need to update your server.
     
  3. Digital Doctor

    Digital Doctor Well-Known Member

  4. Richie

    Richie New Member

    Update my server, yet the the test script told me that everything was ok and ready to tun XenForo?
     
  5. Digital Doctor

    Digital Doctor Well-Known Member

    Are you on php 5.2 ?
     
  6. Richie

    Richie New Member

    I'm on a managed server. I set up a new mysql5 database in the control panel. I have just gone into php myadmin to see what they had set up. Here is a screen shot, is this wrong?

    Thanks
     

    Attached Files:

  7. Digital Doctor

    Digital Doctor Well-Known Member

    @Richie - what version of php are you using ?
     
  8. Digital Doctor

    Digital Doctor Well-Known Member

  9. Richie

    Richie New Member

  10. Mike

    Mike XenForo Developer Staff Member

    You're running MySQL 5.0, but your PHP MySQLi extension is compiled against MySQL 4.1. You'd need to update the MySQLi bindings to fit with your MySQL version. This is something your host should be able to do. This generally shouldn't happen unless the server has been updated piecemeal over time.

    (This isn't something we can detect and it's possible that this error is simply masking another error.)
     
    Richie likes this.
  11. Richie

    Richie New Member

    Thanks Mike. Did I perhaps select the wrong database to create (see screenshot) in the first place?
     
  12. Mike

    Mike XenForo Developer Staff Member

    I just realized that your MySQL server is separate from your PHP server. That's how that could happen. Strictly speaking you could create a MySQL 4 DB but that's below our minimum requirements. Your host really needs to update their MySQL bindings in PHP. (AFAIK, newer ones should generally work with older servers but not necessarily vice version.

    (It's worth noting that the last update to MySQL 4.1 was 2008 and MySQL 5.0 has been considered production ready since 2005...)
     
  13. Richie

    Richie New Member

    So I got this back from my host:

    Any suggestions as what to do next?
     
  14. Amaury

    Amaury Well-Known Member

    Switch hosting providers. Use Mike Edge's hosting services.
     
    The Forum Heroes likes this.
  15. Richie

    Richie New Member

    Its not that simple as I have a few websites email accounts with this host. When I ran the test script with Xenforo and it gave the all clear... I would have thought that I would not have needed to move host for it to work without errors.
     
  16. Mike

    Mike XenForo Developer Staff Member

    I wasn't really suggesting that YOU compile it (unless you had root access). It's something they should be doing for you because they've set themselves up with incompatible libraries. There are more details of what's happening here: http://stackoverflow.com/questions/1786654/mysqli-server-returned-unknown-type-246

    Unfortunately, as I noted, it's not something that's easy to detect as in the vast majority of cases things like this will never come up -- this is definitely the first time I've ever seen it in terms of XF -- and accessing new servers with old clients is bound to potentially create problems like this. The issue isn't one that we can do anything to workaround; it's simply down to the library mismatch. All they need to do is make sure that PHP is actually using the libraries that correspond to the MySQL server version that they're connecting to.
     
    Richie likes this.
  17. Richie

    Richie New Member

    Thanks @Mike , would it be an option to set up a database using on of the other options as per screenshot below. These were my options when creating a new database for xenforo and I selected the second option.

    [​IMG]
     
  18. Mike

    Mike XenForo Developer Staff Member

    No, that's the only option that meets our requirements for MySQL versions.
     
  19. Richie

    Richie New Member

    Hmm, right so I am up ssss*it creek without a paddle.

    I will mention all of the above to my hosting company and see what they say.
     
  20. Mike

    Mike XenForo Developer Staff Member

    If you can't reach a resolution with them (and unfortunately, I don't think it's likely), submit a ticket with us and we can look at the options.
     

Share This Page