MySQL PHP Errors.

Discussion in 'Free Hosting' started by christian.v.t.shadd14, Jun 18, 2014.

Thread Status:
Not open for further replies.
  1. forumall

    forumall Member

    Messages:
    39
    Likes Received:
    2
    Trophy Points:
    8
    Not fixed for me..
     
  2. mbillsx1

    mbillsx1 New Member

    Messages:
    7
    Likes Received:
    1
    Trophy Points:
    1
    Still not working for me. I believe all they need to do is revert the MYSQL to the older version or use a different PHP. But I'll sit and wait.. nothing else I can do at this point. :D Good luck to the admins.
     
  3. leafypiggy

    leafypiggy Manager of Pens and Office Supplies Staff Member

    Messages:
    3,819
    Likes Received:
    163
    Trophy Points:
    63
    It has nothing to do with mismatched versions, as we've not changed versions. This appears to be a problem with CageFS. We are working on it.
     
  4. mt4indic

    mt4indic New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    x02 has the same problem and BTW I love the free service and at the beginning of the month when I get my paycheck i'm upgrading :)
    I tried to login to my ocart admin and it gives me invalid login
    this is the message:
    Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50173 Library:50531 in /home/mt4indic/public_html/ocart/system/database/mysqli.php on line 6

    then it takes me back to the login page saying:
    invalid token
     
    Last edited: Jun 23, 2014
  5. bdistler

    bdistler Well-Known Member Prime Account

    Messages:
    3,534
    Likes Received:
    196
    Trophy Points:
    63
    This Warning - is now thrown by all three (3) x10hosting's free-hosting servers
    you can also receive one or more like "Warning: session_start(): Cannot send session cookie - headers already sent by..." after the above Warning
    which will stop (kill) some CMS
     
  6. mt4indic

    mt4indic New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    I assume this issue is being worked on all 3 servers
     
  7. nemesis0one

    nemesis0one Member

    Messages:
    34
    Likes Received:
    2
    Trophy Points:
    8
    As a quick fix you can do the following to hide the error untill the server admin figure out whats going on.
    Open the complaining file in a good editor like Notepad++ & navigate to the line number stated in the error, if theres more than 1 file in the errors above the header then you will have to find the 1 that has the details to connect to the database, as an example, your looking for something like this on that line
    $con = mysql_connect("$server","$username","$password"); or $this->pdo = new PDO("mysql:host=" . Config::read('hostname') . ";dbname=" . Config::read('database') so on, so on.
    If you add a @ at the beginning of the line the error will be removed, so its like this @$con = mysql_connect("$server","$username","$password"); or @$this->pdo = new PDO("mysql:host=" . Config::read('hostname') . ";dbname=" . Config::read('database') and so on, so on.

    If more than 1 error is showing,dont worry theres only 1 file that needs the alteration
    Refresh you page & the error should be gone.
    Please dont forget to remove the @ after the issue has been resolved.
     
    Last edited: Jun 23, 2014
    • Like Like x 1
  8. mt4indic

    mt4indic New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Wooo Hoooo.... Worked like a charm thanks man
     
  9. mbillsx1

    mbillsx1 New Member

    Messages:
    7
    Likes Received:
    1
    Trophy Points:
    1
    Hey guys I turned off my monitor now I can't see any errors. Thanks! Works great!
     
    • Like Like x 1
  10. forumall

    forumall Member

    Messages:
    39
    Likes Received:
    2
    Trophy Points:
    8
    How can I disable it for vBulletin 4?

    PLEASE HELP!
     
  11. pablo14

    pablo14 New Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
  12. forumall

    forumall Member

    Messages:
    39
    Likes Received:
    2
    Trophy Points:
    8
    Can we please have an update? The status page hasn't been updated for this issue in ages. My forum cannot run because of this error.

    Please help!
     
  13. leafypiggy

    leafypiggy Manager of Pens and Office Supplies Staff Member

    Messages:
    3,819
    Likes Received:
    163
    Trophy Points:
    63
    Hi.

    We're working on a fix for this, however we need to test it before we can deploy it to the servers.
     
  14. forumall

    forumall Member

    Messages:
    39
    Likes Received:
    2
    Trophy Points:
    8
    Help! That error is gone but now I get this!

    mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

    Please get these errors fixed! This is a great host but the downtimes suck :(
     
  15. mt4indic

    mt4indic New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    try using:
    $conn = new mysqli($db_server,$db_user,$db_pass,$db_name);
    further information available via the online mysqli help file.
    Additional commands that may be needed
    mysqli_connect_error()
    mysqli_error()
    cose()
     
  16. forumall

    forumall Member

    Messages:
    39
    Likes Received:
    2
    Trophy Points:
    8
    If you want to bypass this add this to your htacess:
    Code:
    AddType application/x-httpd-php53 .php .php5 .phtml
    
    It will put your php version to 5.3 which supports mysql.
     
    • Like Like x 1
  17. bdistler

    bdistler Well-Known Member Prime Account

    Messages:
    3,534
    Likes Received:
    196
    Trophy Points:
    63
    while PHP [ mysql_connect ] extension is deprecated as of PHP 5.5.0, and will be removed in the future
    it is supported up through version 5.5.X
    the issue is - starting with PHP version 5.5.0 this function will generate (throw) an [ E_DEPRECATED ] error
    ###

    as I type this - my x10hosting's free-hosting server [ xo3 = (old Level) - IP: 198.91.81.3 ] shows PHP version ==> 5.4.29 <== and I do not receive that [ E_DEPRECATED ] error
    the other two (2) x10hosting's free-hosting servers show PHP version ==> 5.5.13 <== and they do throw that [ E_DEPRECATED ] error
    ###

    AFTER you receive that [ E_DEPRECATED ] error
    you might receive one or more like "Warning: session_start(): Cannot send session cookie - headers already sent by..."
    which will stop (kill) some CMS

    To receive only those errors that cause applications to stop working put this line at the top of your PHP script file
    PHP:
    error_reporting(E_ALL ^ (E_NOTICE E_WARNING E_DEPRECATED));
    This will stop PHP from throwing notice, warning and deprecated errors.

    if you use WordPress put that code after [ require_once( ABSPATH .'wp-settings.php' ); ] in the wp-config.php file
     
    Last edited: Jun 24, 2014
  18. spbcx10m

    spbcx10m New Member

    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Where do I put 'error_reporting(E_ALL & ~E_WARNING);' ?
    Do you mean I should create a php.ini file in the public_html folder, or within the body of the page code, or somewhere else? I'm using webcal as part of my site, and get the message from so many different pages I think it would be impossible to find them all, even if I knew exactly what I was doing!. The error does seem to affect the operation of Webcal, since somehow it is stopping me logging in as admin user to make updates to my calendar.
     
  19. leafypiggy

    leafypiggy Manager of Pens and Office Supplies Staff Member

    Messages:
    3,819
    Likes Received:
    163
    Trophy Points:
    63
    We've tested a solution to this that seems to work. We will be implementing it today.
     
  20. wtfmusic

    wtfmusic New Member

    Messages:
    7
    Likes Received:
    1
    Trophy Points:
    3
    I've had some success on this one; 'they/thePHP Man' have basically deprecated the mysql extension. What they seem to be 'encouraging' is a shift to PDO. msqli extension still works, but throws errors. PDO works (using the sqlite or msql drivers available on x10's servers), and no errors thrown. So learn and use PDO; it's more portable, anyway. And not a steep learning curve if you already know the ins and outs of PHP and mysql. Good starter tut here: http://code.tutsplus.com/tutorials/why-you-should-be-using-phps-pdo-for-database-access--net-12059
     
    • Like Like x 1
Thread Status:
Not open for further replies.

Share This Page