Revms MySQL problem

Results 1 to 6 of 6
  1. #1
    Elite Member GrateZ4 is offline
    Member +Rank
    Jul 2014 Join Date
    145Posts

    Revms MySQL problem

    Before everything worked perfect but then the server just lagged it self and when i restarted the server mysql stopped work so i reinstalled mysql 5.1 and then the website worked fine but then i got alot of query errors extradata,room_id etc so i disabled the mysql strict and restart the server again and then the website stopped working again! anyone ever had this problem, i really have no idea what to do or how to fix this, before i was used to have mysql strict mode and everything worked well, now when i disabled mysql strict mode and restarted server i got:

    MySQL Engine - RevCMS:
    MySQL could not connect to host

    But the details are RIGHT!!


  2. #2
    Member Tietoturva is offline
    MemberRank
    Sep 2012 Join Date
    42Posts

    Re: Revms MySQL problem

    Just download the newest MySQL http://dev.mysql.com/downloads/mysql/

    It will work perfectly, also if it will not work, fix your database.

  3. #3
    Elite Member NoOne96 is offline
    Member +Rank
    Jul 2013 Join Date
    173Posts

    Re: Revms MySQL problem

    Quote Originally Posted by GrateZ4 View Post
    Before everything worked perfect but then the server just lagged it self and when i restarted the server mysql stopped work so i reinstalled mysql 5.1 and then the website worked fine but then i got alot of query errors extradata,room_id etc so i disabled the mysql strict and restart the server again and then the website stopped working again! anyone ever had this problem, i really have no idea what to do or how to fix this, before i was used to have mysql strict mode and everything worked well, now when i disabled mysql strict mode and restarted server i got:

    MySQL Engine - RevCMS:
    MySQL could not connect to host

    But the details are RIGHT!!
    I assume you broke your database. You should always turn mysql off before rebooting server :)

  4. #4
    Elite Member GrateZ4 is offline
    Member +Rank
    Jul 2014 Join Date
    145Posts

    Re: Revms MySQL problem

    Quote Originally Posted by NoOne96 View Post
    I assume you broke your database. You should always turn mysql off before rebooting server :)
    How could i fix this?

    i have repaired all tables in my db with navicat

  5. #5
    Newbie Vailyz is offline
    MemberRank
    Jun 2014 Join Date
    6Posts

    Re: Revms MySQL problem

    Try re-installing!
    That would avoid the hassle and make things correct for you.

  6. #6
    Elite Member GrateZ4 is offline
    Member +Rank
    Jul 2014 Join Date
    145Posts

    Re: Revms MySQL problem

    Quote Originally Posted by Vailyz View Post
    Try re-installing!
    That would avoid the hassle and make things correct for you.
    Fixed it myself, turn off mysql strict mode & restarted mysql services.



Advertisement