Mysql error [revcms]

Results 1 to 7 of 7
  1. #1
    Member Janzeer is offline
    MemberRank
    Mar 2012 Join Date
    96Posts

    Mysql error [revcms]

    Hello, i am having this error on the top of my habbo retro, "Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\xampp\htdocs\app\class.engine.php on line 48". Can teach me how to change msql to mysqli as i dont want to hide my errors. Thanks. Not only that but my Password box is small, take a look below. i would be pleased if anyone could help me with either one of this.



    http://prntscr.com/4n1h6b


  2. #2
    Account Upgraded | Title Enabled! asesinato is offline
    MemberRank
    Aug 2014 Join Date
    601Posts

    Re: Mysql error [revcms]

    Don't use XAMPP.

  3. #3
    Hakuna Matata Matata is offline
    MemberRank
    Sep 2012 Join Date
    DenmarkLocation
    807Posts

    Re: Mysql error [revcms]

    Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\xampp\htdocs\app\class.engine.php on line 48

    This is not an error but a warning message. If you want to turn them off, read this:
    http://stackoverflow.com/questions/2...errors-php-5-3

  4. #4
    Member Mink is offline
    MemberRank
    Jun 2011 Join Date
    55Posts

    Re: Mysql error [revcms]

    Quote Originally Posted by Scurry View Post
    Don't use XAMPP.
    This has nothing to do with him using XAMPP.

    The best way to learn how to transition from MySQL to MySQLi would be to teach yourself and do some reading You can compare the current functions to the MySQLi ones here:

    The MySQLi Extension Function Summary

    All of the function calls using "mysql_" can simply be replaced with "mysqli_", although a fair few of the functions (take mysqli_query for example) require different parameters compared to using the old extension. Personally, if you're not going to utilize the MySQLi for it's advantages (such as prepared statements) then I wouldn't bother upgrading, it's not really worth the time that will be invested into doing so (for now, anyway). As Matata said, it's a warning rather than an error so it does not not affect the code being executed. Just replace "error_reporting(E_ALL ^ E_NOTICE);" with "error_reporting(0);" and nothing will go wrong regarding that until the MySQL extension is removed from PHP. Either way, it's up to you.

    As for the password box on the index, I'd say you have some issues in your HTML/CSS. Check out the styling that corresponds them with inspect element or equivalent to see what might be the problem... or just get yourself some updated stylesheets and pages as I've seen the password box look that way on many retros way back when.

  5. #5
    Member Leans is offline
    MemberRank
    Jul 2014 Join Date
    94Posts

    Re: Mysql error [revcms]

    Try putting this in your config page
    Code:
    <?php error_reporting ;0 ?>
    


    If that doesn't work add this to the pages with the error

    Code:
    <?php
    
    error_reporting(0);
    
    ?>
    





  6. #6
    Member Mink is offline
    MemberRank
    Jun 2011 Join Date
    55Posts

    Re: Mysql error [revcms]

    Quote Originally Posted by Leans View Post
    Try putting this in your config page
    Code:
    <?php error_reporting ;0 ?>
    


    If that doesn't work add this to the pages with the error

    Code:
    <?php
    
    error_reporting(0);
    
    ?>
    




    This would not work, as error reporting is already defined in global.php.. he'll need to replace it instead.

    Also, something I forgot to mention before is that you can add an exception to your error reporting so that you can display certain errors and hide others. For example, replacing your current error reporting function with "error_reporting(E_ALL ^ E_DEPRECATED);" will display all errors EXCEPT for the deprecated warnings. If you don't want to make the transition to MySQLi and use RevCMS but still want to display regular errors, this would be your best bet.

  7. #7
    Account Upgraded | Title Enabled! YoWesty is offline
    MemberRank
    Oct 2012 Join Date
    285Posts

    Re: Mysql error [revcms]

    Problem Fixed, I fixed it him earlier. He needed to turn off Error reporting in php.ini. He was also using Xampp soo. Thanks.



Advertisement